Boost your career with a strong foundation in Microsoft Excel and accounting. This course covers essential functions, formulas, and financial concepts to help you manage data, analyse trends, and support sound business decisions.
Course Curriculum: Microsoft Excel Training Modules
- Module 01: Getting Started with Microsoft Office Excel 2016
- Module 02: Performing Calculations
- Module 03: Modifying a Worksheet
- Module 04: Formatting a Worksheet
- Module 05: Printing Workbooks
- Module 06: Preview and Print a Workbook
- Module 07: Set Up the Page Layout
- Module 08: Configure Headers and Footers
- Module 09: Managing Workbooks
- Module 10: Working with Functions
- Module 11: Working with Lists
- Module 12: Analyzing Data
- Module 13: Visualizing Data with Charts
- Module 14: Using PivotTables and PivotCharts
- Module 15: Working with Multiple Worksheets and Workbooks
- Module 16: Using Lookup Functions and Formula Auditing
- Module 17: Sharing and Protecting Workbooks
- Module 18: Automating Workbook Functionality
- Module 19: Creating Sparklines and Mapping Data
- Module 20: Forecasting Data Accounting Training Modules
- Module 21: Professional Bookkeeper Introduction
- Module 22: Introduction to Accounting and Business
- Module 23: The Accounting Equation
- Module 24: Analyzing Transactions
- Module 25: Entering Information – Posting Entries
- Module 26: Adjusting Process
- Module 27: Adjusting Entries
- Module 28: Adjustment Summary
- Module 29: Preparing a Worksheet
- Module 30: Financial Statements
- Module 31: Completing the Accounting Cycle
(See curriculum)
What's included:
- CPD Certification
- Fully online, interactive course.
- Free PDF certificate on course completion.
- 24/7 access to the course for a lifetime.
- Online support