Learning Method: Instructor-led Classroom Duration: .5 Day
*Click here to view upcoming Excel Level 4 classes
Overview:
Excel has many tools and functions that help you analyze data to make decisions having large scale implications on profitability, sales, operations, project management, credit, and so on. In this course, you will use the advanced features of Microsoft Office Excel to attain a high degree of proficiency as an Excel power user.
Who Should Attend:
This course is designed for advanced Microsoft Office Excel professionals.
At Course Completion:
Upon successful completion of this course, students will be able to:
- forecast data using functions
- analyze data using the data analysis tools in Excel
- make decisions using the financial functions in Excel
- examine data using math functions in Microsoft Office Excel
- manipulate data using text and information functions in Excel
Prerequisite(s) or equivalent knowledge: Excel Level 1, Excel Level 2, Excel Level 3
Course Outline:
Lesson 1: Manipulating Data Using Statistical and Lookup Functions
- Forecast Using Statistical Functions
- Evaluate Sales Data Using Statistical Functions
Lesson 2: Working with Data Using Financial Functions
- Using Financial Functions
Lesson 3: Examining Data Using Math Functions
- Analyze Sales Data Using Math Functions
- Aggregate Data Using Math Functions
Lesson 4: Manipulating Data Using Text and Information Functions
- Manipulate Data Using Text Functions
- Validate Data Using Information Functions
Lesson 5: Managing Data in Workbooks
- Retrieve and Paste Data
- Clean Data in Workbooks
