Excel 2 – Supported – Full Day

$ 350.00

Class Duration: 7.5 Hours

Class Agenda

Resource Setup 30 Minutes
Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Other Breaks Prescribed by Instructor

Building upon knowledge gained from Excel 1, our intermediate-level Excel class teaches you to control data – a skill that is a significant benefit to your organization. You will learn to analyze massive amounts of data, extract actionable information from it, and present the information clearly using more advanced features than previously covered.

Recommended Preparation: Excel 1

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date and Time Functions
  • Work with Text Functions
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Other options for this content:

Scroll to Top