Microsoft Excel Course (Level 2)
- 8 Hours
The Microsoft Excel course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications.
About the course
The Microsoft Excel course (Level 2) is designed to help you take your Excel skills to the next level. While you already know how to use Excel for basic calculations and formatting, this program has the capability to do much more. To gain a competitive advantage, it is essential to be able to extract valuable insights from your data. This course builds on the foundations covered in the Microsoft Excel course (Level 1), and will guide you in creating advanced workbooks and sheets that can provide a deeper understanding of organizational intelligence. The ability to analyze large amounts of data, extract actionable information, and present it to decision-makers is crucial for a successful organization that can compete effectively.
Course Objectives
- Work with functions.
- Work with lists.
- Analyze data.
- Visualize data with charts.
- Use PivotTables and PivotCharts.
Course Outline
- Working with Functions
- Working with Lists
- Analyzing Data
- Visualizing Data with Charts
- Using PivotTables and PivotCharts