Excel Level 4


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
Site Loader