Name: Excel for Bookkeeping
Rating: 4.7 (8 reviews)

Home
Course
Office Productivity
Excel for Bookkeeping

Educational accomplishments and income are closely correlated. Education and skill with endorsed certificates from credible and renowned authorities typically lead to better jobs with attractive salaries. Educated and skilled workers also have lower rates of unemployment. Therefore, skills and endorsed certificates to showcase are essential for people early in their careers.

Imperial Academy offers this premium Excel for Bookkeeping course to ensure security in your career. In addition, this comprehensive Excel for Bookkeeping course will assist you in building relevant skills that will help you find a job in the related sectors. Also, the Certificate you’ll get after completing the Excel for Bookkeeping will put your head and shoulder above others in front of potential employers.

Become the person who would attract the results you seek. What you plant now, you will harvest later. So, grab this opportunity and start learning Excel for Bookkeeping !

QLS/ CPD/ CIQ Accredited
24/7 Assistance from our Support Team
100% Online
Self-paced course
Bite-sized Audio-visual Modules
Rich Learning Materials
Developed by Industry Specialists
Career Guidance

Learn at your own pace from the comfort of your home, as the rich learning materials of this premium course is accessible from any place at any time. The advanced course curriculums are divided into tiny bite-sized audio-visual modules by industry specialists with years of experience behind them.

Course Curriculum

Getting Started with Microsoft Office Excel 2016
	Navigate the Excel User Interface	00:28:00
	Use Excel Commands	00:10:00
	Create and Save a Basic Workbook	00:19:00
	Enter Cell Data	00:12:00
	Use Excel Help	00:05:00
Performing Calculations
	Create Worksheet Formulas	00:15:00
	Insert Functions	00:17:00
	Reuse Formulas and Functions	00:17:00
Modifying a Worksheet
	Insert, Delete, and Adjust Cells, Columns, and Rows	00:10:00
	Search for and Replace Data	00:09:00
	Use Proofing and Research Tools	00:07:00
Formatting a Worksheet
	Apply Text Formats	00:16:00
	Apply Number Format	00:08:00
	Align Cell Contents	00:09:00
	Apply Styles and Themes	00:12:00
	Apply Basic Conditional Formatting	00:11:00
	Create and Use Templates	00:08:00
Printing Workbooks
	Preview and Print a Workbook	00:10:00
	Set Up the Page Layout	00:09:00
	Configure Headers and Footers	00:07:00
Managing Workbooks
	Manage Worksheets	00:05:00
	Manage Workbook and Worksheet Views	00:07:00
	Manage Workbook Properties	00:06:00
Working with Functions
	Work with Ranges	00:18:00
	Use Specialized Functions	00:11:00
	Work with Logical Functions	00:23:00
	Work with Date & Time Functions	00:08:00
	Work with Text Functions	00:11:00
Working with Lists
	Sort Data	00:10:00
	Filter Data	00:10:00
	Query Data with Database Functions	00:09:00
	Outline and Subtotal Data	00:09:00
Analyzing Data
	Create and Modify Tables	00:16:00
	Apply Intermediate Conditional Formatting	00:07:00
	Apply Advanced Conditional Formatting	00:05:00
Visualizing Data with Charts
	Create Charts	00:13:00
	Modify and Format Charts	00:12:00
	Use Advanced Chart Features	00:12:00
Using PivotTables and PivotCharts
	Create a PivotTable	00:13:00
	Analyze PivotTable Data	00:12:00
	Present Data with PivotCharts	00:07:00
	Filter Data by Using Timelines and Slicers	00:11:00
Working with Multiple Worksheets and Workbooks
	Use Links and External References	00:12:00
	Use 3-D References	00:06:00
	Consolidate Data	00:05:00
Using Lookup Functions and Formula Auditing
	Use Lookup Functions	00:12:00
	Trace Cells	00:09:00
	Watch and Evaluate Formulas	00:08:00
Sharing and Protecting Workbooks
	Collaborate on a Workbook	00:19:00
	Protect Worksheets and Workbooks	00:08:00
Automating Workbook Functionality
	Apply Data Validation	00:13:00
	Search for Invalid Data and Formulas with Errors	00:04:00
	Work with Macros	00:18:00