0Microsoft Excel Beginner, Intermediate and Advanced course will provide a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level to learners. Microsoft Excel Advanced course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices.
Basic Level:
- Introduction to Spreadsheets
- Understanding Microsoft Excel
- Excel Workbook Windows
- Basic Spreadsheet Skills
- Excel Help System
- Opening and Closing Workbooks
- Understanding Workbook File Formats
- Creating New Workbooks
Advanced Level:
- Introduction to Excel Advanced
- Using Text to Columns
- The Paste Special Function
- Data Validation
- Subtotals and Grouping
- Consolidating Data
- Scenario Analysis
- Data Tables in Scenario Analysis
- What-if Analysis
- Mats and Trig Functions
- Text Functions in Excel
- Using Lookup Functions
- Vlookups
- HLookups
- Using Statistical Functions
MS Excel is a useful tool for every business organisation. That helps to manage data and information inside the organisation.
