Microsoft Excel - Tips & Tricks

Half day (3 hours)  course

Stumped by SPREADSHEETS?

Much of Microsoft Excel's power is often unknown & unused!

We’ll show you some of our favourite tips and tricks for making Excel easier to use.

We will  demonstrate some of the hidden options, unknown features, and shortcuts, which go unused and undiscovered by the majority of people. 

 TO ENABLE INDIVIDUALS TO:

• Use Excel to it’s full potential.

• Understand many handy features, which go unused.

• Customize Excel to work the way you want.

• Make Excel more powerful, more productive and even easier to use.

Course Outline
Download Course Details

FORMULAE

AutoSum

Create formulas

Auto Fill

Custom Auto Fill.

Auto-calculation.

How To Use Named Ranges.

Quick Range Names.

Figuring out formulas.

Create subtotals.

PRINTING.

Print One Page Wide.

Print Column Titles on Each Page.

Do Not Print - Hide.

 FORMATTING.

Keep Headings Visible.

Delete vs clear.

Remove zeros.

The Current Date or Time

Getting columns in shape.

AutoFit Columns.

Cell Comments.

To wrap text.

To manually wrap text.

Add a Drop-Down List.

OTHERS.

Easy Worksheet Linking.

Quick charts.

Using Goal Seek.

Excel shortcut keys.