Excel Intermediate

Excel Intermediate

Course Description

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.

Topics Covered

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

Hyperlinks

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

Cell comments

Headers and footers

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.