Microsoft Excel & Accounting Training Class

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