- What’s included: Microsoft Excel complete online course – beginner, intermediate, and advanced
The course syllabus:
- Introduction to Microsoft Excel 2019 new features:
- CONCAT
- IFS
- MAXIFS
- MINIFS
- SWITCH
- TEXTJOIN
- Map chart
- Funnel chart
- Pivot table enhancements
- Power pivot updates
- Beginner level:
- Navigate the Excel user interface
- Use Excel commands
- Create and save a basic workbook
- Enter cell data
- Use Excel help
- Create worksheet formulas
- Insert functions
- Reuse formulas and functions
- Use proofing and research tools
- Preview and print a workbook
- Intermediate level:
- Work with ranges
- Use specialized functions
- Work with logical functions
- Sort data
- Outline and subtotal data
- Filter data by using timelines and slicers
- Advanced level:
- Use links and external references
- Use 3-D references
- Consolidate data
- Use lookup functions
- Trace cells
- Watch and evaluate formulas
- Collaborate on a workbook
- Protect worksheets and workbooks
- Determine potential outcomes using scenarios
- Use the Goal Seek feature
- Forecasting data trends
Features of the Course:
- E-learning course with an interactive learning portal
- Tutor support from industry experts
- Accredited PDF Certificate upon successful completion at a free of cost
- Exam system with instant results track progress within own personal learning portal
- Lifetime access to material
- 24/7 customer support