• Live Instruction

• Hands-on, Guided Activities

• LIVE Remote or Classroom Delivery

What’s Included

  • Small class sizes
  • A digital Excel training manual
  • Certificate of course completion
  • FREE retake valid for 12 months
  • Virtual Lab (LIVE Remote)

Onsite Excel training available countrywide.

MICROSOFT EXCEL COURSE OUTLINES

Excel Level 1 - Introduction

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.

1 Day $264 2 Tickets

Detailed Course Outline

Getting Started with Excel
  • Navigate the Excel user interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
Modifying a Worksheet
  • Insert, Delete and Adjust Cells, Columns Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
Managing Workbooks
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
Printing Workbooks
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

"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."

Excel Level 2 - Introduction

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

1 Day $264 2 Tickets

Detailed Course Outline

Working with Functions
  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date and Time Functions
  • Work with Text Functions
Working with Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
Using PivotTables and PivotCharts
  • 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."

Excel Level 3 - Introduction

Become a high-level user of Excel with our Excel 3 course, utilizing the most advanced features of the application. Work in collaboration with others to deliver actionable organizational intelligence while keeping and maintaining workbooks for multiple purposes with efficiency in mind.

Recommended Preparation: Excel 1 & 2

1 Day $264 2 Tickets

Detailed Course Outline

Working with Multiple Worksheets and Workbooks
  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
Using Lookup Functions and Formula Auditing
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
Sharing and Protecting Workbooks
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
Automatic Workbook Functionality
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
Creating Sparklines and Mapping Data
  • Create Sparklines
  • Map Data
Forecasting Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Using the Goal Seek Feature
  • Forecasting Data Trends

"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."

Excel Level 1 - Introduction

Our Excel Dashboard’s class covers similar concepts to that of Excel 2, with a particular focus on how data is displayed. Learn skills to extract actionable, organizational intelligence from your raw data and present it in various visual formats – enabling significant trends to be identified and conclusions made at a glance.

Recommended Preparation: Excel 1

1 Day $264 2 Tickets

Detailed Course Outline

Using Names in Formulas and Functions
  • Examine Dashboards
  • Use Range Names in Formulas
  • Use Specialized Functions
Automating Workbook Functionality
  • Apply Data Validation
  • Work with Forms and Controls
Applying Conditional Logic
  • Use Lookup Functions
  • Combine Functions
Visualizing Data with Basic Charts
  • Create Charts
  • Modify and Format Charts
Using Advanced Charting Techniques
  • Create Dual-Axis Charts and Trendlines
  • Create Sparklines
Analyzing Data with PivotTables, PivotCharts, and Slicers
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using 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."

Detailed Course Outline

Preparing Data and Creating PivotTables
  • Prepare Data
  • Create a PivotTable form a Local Data Source
  • Create a PivotTable from Multiple Data Sources
  • Create a PivotTable from an External Data Source
Analyzing Data by Using PivotTables
  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data
Working with PivotCharts
  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart

"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."

Detailed Course Outline

Gettings Started with Power Pivot
  • Enable and Navigate Power Pivot
  • Manage Data Relationships
Visualizing Power Pivot Data
  • Create a Power Pivot Report
  • Create Calculations in Power Pivot
Working with Advanced Functionality in Power Pivot
  • Create a Key Performance Indicator
  • Work with Dates and Time in Power Pivot

"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."

Three Class Discount

Buy any three classes and receive 20% off.

The Training to YOU Three Class Discount is a terrific way for an individual to purchase multiple classes for a discount. Whether you are looking for a series of classes like Excel 1, 2 & 3 or a variety of classes such as Google Sheets, Docs and Slides the Three Class Discount is the way to go!

State of Arizona employees are eligible for an additional discount.

Training to YOU Tickets

Tickets are a great way to reduce the cost of training your team. Save up to 45% by purchasing your training in bulk.

We are now providing a custom-made registration portal for each organization that purchases 50+ training tickets. These portals allow supervisors and employees to schedule training easily and information workflows keep everyone in the loop.

Give us a call

We are happy to answer any questions you may have.

Call us

(602) 266-1500

TRAINING TO YOU


Class Ratings
4.9 stars from 1984 reviewers:

“I learned so much in this Excel 1 course. My Instructor paced the class just right so you felt challenged but not overwhelmed (even with 264 pages). He ensured we were all engaged in the material and always allowed us an opportunity to ask any questions. He is patient and eager to help. I’m thrilled to have found this class and leaving with so much useful information. Overall one of the best instructors I’ve had! He did an amazing job!! ”

— S.G. took Excel 1

“I really enjoyed this class. My instructor has a very unique ability to convert technical terminology into plain English and makes the material so much easier to understand. My instructor was very attentive and ensured everyone was on the same page before moving on and provided assistance if we were having any difficulties.”

— A.G. took Excel 2

“Alexandre is very easy to learn from. His thorough teaching technique helps you understand the material and hold that info in your brain. I can’t wait to start applying this to my forms I use everyday! Thank you so much!”

— S.P. took Excel 1

EXCEL TRAINING FAQ

Training to YOU is dedicated to providing the best online and in-person Excel training classes. Find answers to some of our most frequently questions related to Excel training below, or contact us should you require further assistance.

Our Excel training classes are all face-to-face, whether you come to our facility or take the class remotely through our virtual meeting and lab.  Our trainers are subject matter experts and passionate about teaching, ensuring that you will have a great learning experience. 

LIVE Remote classes start the set-up process at 8:00 a.m. 

In-person classroom participants should arrive no by 8:15 a.m. 

Students that arrive late will be asked to reschedule. 

Instruction begins at 8:30 a.m. for both classroom and LIVE Remote delivery. 

Classes are scheduled to end at 4:30 p.m. but this may vary depending on class size and student skill level.  

All times are in MST for Phoenix, AZ where Daylight Savings Time is not observed. 

See the local time in Phoenix here for clarification. 

You will need: 

  • A stable, high-speed internet connection (wired is recommended over Wi-Fi whenever available) 
  • A PC or laptop with mouse and keyboard 
  • A second monitor (preferred) or device (screen size should be large enough to view instructor’s share) 
  • Speakers or headphones are a must and a microphone is recommended.  

Click here for full setup instructions, including links to test your system and network.  

If you do not have the resources above, consider taking your class in-person at our training center and we will provide everything you need. 

This depends on your current level of experience. Reference our Excel Tracks document here to determine the path that best suits your training needs. Most will benefit from starting at the beginning with Excel 1 which is the perfect introduction to the core concepts, terminology and navigation of the application. Before you decide to start with a course later in the series, we recommend reviewing the full list of topics covered by downloading the PDF outline for that course below the course description. 

Our instructors can travel anywhere in the United States to deliver training. Contact registration for a quote at registration@trainingtoyou.com