Microsoft Excel Expert Level
Course Code: MSO.EXL2
Duration:14 hours
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
The course introduces various financial analysis tools such as goal seek, scenario manager and data tables. Finally the course presents ways to protect the spreadsheets and formulae and to create templates.
The participants will be able to use advanced features of Excel in order to:
- Filter and analyze data
- Analyze data with Pivot Tables
- Group and create subtotals
- Use popular Functions such as IF function, VLOOKUP, PMT etc
- Create nested functions for automation and analysis of calculations
- Track formulae and function errors
- Protect Workbooks, files, sheets and cells
- Use Analysis tools for financial analysis
Participants may come from various departments and are dealing or wish to create complex spreadsheets. Participants who seek for ways to utilize all the excel features in order to create “smart sheets” or analyze data will find this course very useful.
Unit1: Databases
Unit2: Naming Ranges
Unit3: Using Functions And Nested Functions
Unit 4: Collaborating
Unit 5: Templates
Unit6: Advanced Number Formatting
Unit7: Analysis Tools
Unit8: Use data analysis and PivotTables
Unit9: Auditing
Unit10: Printing