Description

What you will cover – Lesson Outline Intermediate

Lesson 01 – What is Microsoft Excel

• Components of the Microsoft Excel screen and the ribbon

Lesson 02 – File Formats and Columns and Rows

• Selection Techniques and Entering in Data
• Page Setup and Page Breaks

Lesson 03 – Working with Formulae

• Creating, copying and using formulae
• Formulae with Absolute References and 3-D Formulae

Lesson 04 – Creating Multiple Views

• Freezing and Hiding Columns and Rows
• Split panes to see multiple worksheet areas

Lesson 05 – Formatting and Editing Worksheets

• Editing, Formatting, Moving and Copying Data
• Conditional Formatting

Lesson 06 – Printing and Page Setup

• Print Preview, Printing Options and Headers and Footers
• Setting Print Titles

Lesson 07 – Using Functions

• Sum, AutoSum, Average, Max, Text
• Conditional Formatting

[/dt_sc_fullwidth_section]