Excel Training

Improve Your Skills

Introduction to Excel

View ...OR...view by topic below:

Blank Workbook听

Opens up Ribbons听听听听听听听听

Ribbons divided into groups听听听

Launch Button听听听

Columns and Rows听听听听听听听

Cell听听听听听听听听听听听听听听

Range听听听听听听听听听听听

Multiple Sheets听听

Workbook听听听听听

Stretching a column听听听听听

Tips听听听听听听听听听听听听听听

fixing misspell on a cell (To get in a cell you听have to听double click on it)听听听听听听听听

Merge & Center听

Click and Drag听听听

Click and Drag SHORTCUT听听听

Trick听听听听听听听听听听听听

Trick to resize columns听

听

Intermediate Excel

View听...OR view by topic below:

Format painter

Conditional formatting

Specific formatting

Formulas

=Sum( & (auto sum)

Reformat conditional formatting

=average(

=max( (highest value)

=min( (lowest value)

Formula bar

Auto fill

Pattern auto fill

Dates/time auto fill

Sort

Filter

Freeze pane

听

Advanced Excel

View ...OR...view by topic below:

Start

Introduction

Overview of List Design

Formatting Lists as Tables

Filtering Records from Lists or Tables

Removing Duplicates from Lists or Tables

Flash Fill

Single & Multi-Level Sorting

Inserting Automatic Subtotals in Lists

Inserting Data Charts Using Recommended Charts

Formatting & Editing Chart Elements

Creating & Applying Custom Chart Templates

Adding & Removing Data from Charts

Inserting Sparklines

Printing Charts

Inserting Pivot Tables

Filtering Pivot Tables

Using Report Layouts in Pivot Tables

Refreshing & Changing Source Data in Pivot Tables

Inserting Pivot Charts

Data Validation

Applying Built-In Conditional Formatting

Creating Custom Conditional Formats

Linking Data

Comments

Protection

听

Multiple Topics in Excel

听

听

听