Excel Level 2

Formatting and Advanced Functions

Pré-requis :
Excel Level 1
Durée :
1 Day

Ordre du jour

1  Cell and Range Names

Name a Cell

Name Manager

Edit a Cell Name

Apply a Cell Name to an existing formulas

Name a Range

2  Conditional Formatting(Introduction)

Pre-set Criteria (colors/Icons)

Edit

3  Data Validation (Introduction)

Numbers

List

Error Message Styles

4  Functions (Intermediate)

IF

SUMIF

Nested Functions

Exercises

5  Print (Multipage)

Freeze Table Header

Repeat Header when you print

Page Break Preview

Insert/Delete Page Breaks

Headers and Footers settings

Custom Views

Exercises