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

 Topic A: Work with Ranges

 Topic B: Work with Logical Functions

 Topic C: Work with Date & Time Functions

 Topic D: Work with Text Functions

Lesson 2: Analyzing Data

 Topic A: Create and Modify Tables

 Topic B: Apply Conditional Formatting

 Topic C: Outline and Subtotal Data

Lesson 3: Visualizing Data with Charts

 Topic A: Create Charts

 Topic B: Modify and Format Charts

 Topic C: Use Advanced Chart Features

Topic D: Create Sparklines

Lesson 4: Using Pivot Tables

 Topic A: Create a Pivot Table

 Topic B: Analyze Pivot Table Data

Site Loader