Excel Level 2

Learning Method: Instructor-led Classroom Learning Duration: 1.00 Day


*Click here to view upcoming Excel Level 2 classes


Overview:

In this course, students use Excel to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Who Should Attend:

This course is for those who have a basic understanding of Excel.  Students will learn how to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.

At Course Completion:

Upon successful completion of this course, students will be able to: Calculate with advanced formulas. Organize worksheet and table data using various techniques. Create and modify charts. Analyze data using PivotTables and PivotCharts. Insert graphic objects. Customize and enhance workbooks and the Microsoft Office Excel environment.


Prerequisite(s) or equivalent knowledge: Excel Level 1


Course Outline:

Lesson 1: Working with Functions

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

Lesson 2: Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Lesson 3: Analyzing Data

  • Create a and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers
Site Loader