# Intermediate Excel Training

Our intermediate Excel training courses cover more complex Excel functions, charting, and data tools. Go beyond the basics to learn more formatting, more formulas, and more functionality. The intermediate Excel training starts working with functions such as IF, Proper, Roundup and Date and Time functions. It also looks at how to create formulas across multiple spreadsheets in the same document.

### Training Class Goal

In the Intermediate Excel training, we will begin to explore how to utilize more complex functions, including date & time functions and IF statements. We will also look at organizing data, working with multiple worksheets and basic charting. The Intermediate Excel training courses builds on things learned in the basic class. Students learn how to do more with copying and pasting such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.

### PreRequisites

Before taking this class, students should have an understanding of basic Excel formulas and functions, experience entering data into Microsoft Excel, familiarity with Windows, and basic computer skills.

### Formulas & Functions

• Typing formulas and functions
• Cell references and reference formulas
• AutoSum
• The Functions Library
• Average, date, and time functions
• IF statements
• Nested IF Statements
• Other classes covering Formulas & Functions

### Moving and Copying Data in Excel

• Cut, copy, and paste data
• The Fill Handle
• Absolute and relative references
• AutoFill and custom Lists

### Working with More Functions

• Date and Time Functions
• Calculating dates in years
• IF Statements in Date Functions
• The Proper Function
• The Roundup Function

### Working with Multiple Worksheets

• Renaming worksheets
• Color coding tabs
• Moving and copying worksheets
• 3D reference formulas
• ScreenTips

### Formatting Cells and Appearance

• Formatting text and numbers in cells
• Merging cells
• Wrapping text within a cell
• Custom number formats
• Conditional formatting
• Copying formatting
• Other classes covering Excel formatting

### Viewing Worksheets

• Showing formulas and references
• Tracing precedents and dependents
• Grouping rows and columns
• Other classes covering Navigation and Views

### Introduction to Basic Charts

• Creating and defining a chart
• Positioning, rotating, and resizing charts
• WordArt in charts
• Editing charts in Excel
• Changing types
• Formatting a data series
• Multiple series charts
• Sparkline charts
• Other classes covering Excel charts

The Intermediate Excel training covers things beyond the basics, to give you more confidence in building your spreadsheets and creating formulas to automate them.

### Upcoming Classes

Oct 2 8:00 am - 12:00 pm Excel Intermediate Tech Center
Oct 10 8:00 am - 12:00 pm Excel Intermediate Phoenix
Oct 18 8:00 am - 12:00 pm Excel Intermediate Westminster
Oct 30 8:00 am - 12:00 pm Excel Intermediate Westminster
Nov 7 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Nov 8 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Nov 19 1:00 pm - 5:00 pm Excel Intermediate Westminster
Dec 4 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Dec 12 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Dec 19 1:00 pm - 5:00 pm Excel Intermediate Westminster
Jan 7 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Jan 8 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Jan 23 1:00 pm - 5:00 pm Excel Intermediate Westminster
Feb 6 8:00 am - 12:00 pm Excel Intermediate Tech Center
Feb 12 8:00 am - 12:00 pm Excel Intermediate Phoenix
Feb 20 8:00 am - 12:00 pm Excel Intermediate Westminster
Mar 6 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Mar 18 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Mar 18 1:00 pm - 5:00 pm Excel Intermediate Westminster
Apr 1 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Apr 17 8:00 am - 12:00 pm Excel Intermediate Westminster
Apr 17 1:00 pm - 5:00 pm Excel Intermediate Phoenix
May 1 8:00 am - 12:00 pm Excel Intermediate Tech Center
May 14 8:00 am - 12:00 pm Excel Intermediate Westminster
May 20 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Jun 3 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Jun 17 8:00 am - 12:00 pm Excel Intermediate Westminster
Jun 24 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Jul 1 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Jul 16 1:00 pm - 5:00 pm Excel Intermediate Westminster
Jul 22 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Jul 30 8:00 am - 12:00 pm Excel Intermediate Tech Center
Aug 13 8:00 am - 12:00 pm Excel Intermediate Westminster
Aug 20 8:00 am - 12:00 pm Excel Intermediate Phoenix
Aug 27 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Sep 9 1:00 pm - 5:00 pm Excel Intermediate Westminster
Sep 26 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Sep 27 8:00 am - 12:00 pm Excel Intermediate Tech Center
Oct 7 1:00 pm - 5:00 pm Excel Intermediate Westminster
Oct 21 1:00 pm - 5:00 pm Excel Intermediate Phoenix
Oct 23 8:00 am - 12:00 pm Excel Intermediate Tech Center
Nov 6 1:00 pm - 5:00 pm Excel Intermediate Westminster
Nov 14 8:00 am - 12:00 pm Excel Intermediate Phoenix
Nov 18 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Dec 4 1:00 pm - 5:00 pm Excel Intermediate Westminster
Dec 16 1:00 pm - 5:00 pm Excel Intermediate Tech Center
Dec 16 1:00 pm - 5:00 pm Excel Intermediate Phoenix

### Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.

• ### Class Retakes

Retake any public class up to 6 months after original class date....Read more

• ### Hands-on Learning

Interactive classes allow you to immediately try out new skills....Read more

• ### Live Training

Live instructors deliver our classes in an engaging and interactive way....Read more

• ### Small Class Sizes

Classes limited to 12 students for more individual attention....Read more