OUTLINE

DURATION:  2 DAYS (16 HOURS)

DIFFICULTY LEVEL: INTERMEDIATE

1.  Main Excel objects

What are worksheets & workbooks?

Columns, row, cells & ranges

Navigating, important shortcut keys

The Backstage

The Ribbon

2.       Worksheets & workbooks

Creating a worksheet

Creating a workbook

Save & save as

3.       Formulas

What are excel formulas

The formula bar

Common mathematical operators

The order of operations

4.       Insert functions

The Excel function

The function library

Important excel functions

5.       The new Array formula platform

Evaluating array formulas v normal formulas

Spilled array behavior of formulas

6.       Formula references

Absolute & relative references

References when copying formulas in an array

7.       Important Excel functions

IF, VLOOKUP, SUMIF, COUNT

8.       Important excel aspects

Undo & redo

Autofill feature

Autofill options

Dragging & dropping cells

Cut, copy, & paste cells

How to cut, copy, & paste multiple cells

Using the clipboard

Paste special

The transpose option

Live preview

The Clear button

Excel spellchecking

9.       Rows & columns

Inserting & deleting

Important shortcut keys

Adjusting width of rows & columns

Hiding & unhiding rows & columns

10.   Finding & replacing data

The Find command

The Replace command

The Go to command

11.   Excel fonts

Fonts & font type

The font group

The format cells dialog box

The format painter

Live preview & formatting

The mini toolbar

12.   Drawing borders & coloring cells

Border options

Fill options

Sheet backgrounds

13.   Apply number formats

Number formats

Excel number formats

Customizing number formats

14.   Cell alignment & cell styles

Alignment options

The indent command

Orientation options

The merge & center options

Cell styles

The style dialog box

15.   Printing excel worksheets

Print options in backstage view

Page setup dialog box

Print preview options

Inserting headers & footers

Header & footer settings

Page margins

Margins tab options

Setting page orientation

16.   Page layout & other print options

Zoom options

Page breaks

Page break options

Setting the print area

Print titles

Scaling options

17.   Worksheet tabs

Renaming worksheet tabs

Changing tab color

Hiding & unhiding worksheets

Deleting worksheets

Copying tabs

Moving tabs

18.   Worksheet views

Split command

Freeze panes options

Arrange all command

Arrange windows dialog box

View side by side command

Switch windows command

New window command

19.   Formula Auditing

Tracking Dependents and Precedents

Showing formulas

Error checking and tracing errors

20.   Sorting & Filtering

Working with lists

Applying Sorting and Filtering to a list

Simple sorting

Sorting by multiple columns

Using AutoFilter

Using custom filter

Using Advanced Filter

Removing duplicates from data

21.   Data Tools

Text to Columns

Flash Fill

Remove Duplicates

Data Validation

Consolidate

22.   Introduction to Excel charts

Types of Excel charts

Data ranges and selecting data

The bar graph

The pie chart

Advanced chart formatting