Excel Intermediate Course Overview
The Excel Intermediate Course Overview by Microsoft equips professionals with essential skills to analyze data efficiently and streamline workflows. Designed for analysts, managers, and business professionals, this course enhances data manipulation techniques, advanced formulas, and visualization tools, empowering participants to make informed decisions and boost productivity in their organizations.
Course outline & what you'll learn
- Course objectives and outcomes
Overview of Excel interface and basic features
- Nested functions
- Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Logical functions (IF, AND, OR)
- Sorting and filtering data
- Using advanced filter options
- Data validation techniques
- Creating and formatting tables
- Table styles and features
- Creating various chart types (bar, line, pie)
- Creating PivotTables for data analysis
- Customizing PivotTable layouts
- Using PivotCharts for visual representation of data
- Using Goal Seek and Scenario Manager
- Data analysis with What-If analysis
- Introduction to Power Query
- Recording and running macros
- Editing macros in the Visual Basic Editor
- Assigning macros to buttons
- Protecting and sharing workbooks
- Using comments and notes for collaboration
- Version control and tracking changes
- Review of key concepts
- Final project or assessment
- Feedback and next steps for further learning
Why train with Traincrest
This Microsoft course is delivered by Traincrest's certified instructors, live online or in the classroom, with hands-on labs and a 98% exam success rate. Trusted by 500+ companies and 50,000+ students worldwide.