Sage | Excel Essentials

What you will cover – Lesson Outline Essentials

• Components of the Microsoft Excel screen and the ribbon

Lesson 02 – Working with workbooks and worksheets

• Selection Techniques and Entering in Data

Lesson 03 – Working with formulae and functions

• Creating, copying and using formulae

Lesson 04 – Creating Multiple Views

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

Lesson 05 – Managing your worksheet

• Moving and Copying Data
• Freezing and unfreezing columns and rows

Lesson 06 – Formatting and editing worksheets

• Formatting and editing data

Lesson 07 – Page setup and printing

• Page orientation and printing options