Desktop Applications > Microsoft Excel

Microsoft Excel

Microsoft Excel Essentials

Who is the course for?

This practical hands-on course is designed for spreadsheet users who need to acquire Excel skills quickly and effectively. Practice tasks and case studies ensure that fundamental techniques can be applied quickly in a demanding financial and business environment

Is this course suitable for me?

Take the Skills quiz

Pre-requisites

You need to have basic Windows skills, including opening and saving, copying and moving information, and working with a keyboard and mouse

What are the objective of the course?

By the end of the course, you will be able to:

  • Build effective spreadsheets using a range of efficiency features

  • Perform calculations using formulas and functions

  • Use a range of auditing techniques to verify accuracy

  • Format and print different areas of workbook

  • Create and print a range of different charts

What does the course cover?

Getting started:

Elements of the Excel workspace; quick ways to select and navigate; different ways to get help; workbook design - tips and best practice

Building workbooks:

Entering data; quick ways to enter data; managing worksheet; copying and moving data; editing and making changes; calculating with formulas; saving and opening/ closing workbooks

Calculating with formulas and function:

Creating a formula; relative and absolute references; precedence/ order of calculation; overview of functions; statistical and mathematical functions; creating and using range names; using data validation

Presentation techniques:

Formatting shortcuts; using Format Cells; changing column widths and row heights; inserting extra rows and columns; hiding rows and columns; freezing panes; conditional formatting; custom number formats

Printing:

Deciding what to print; checking output with page break preview; checking print preview; changing page setup (including headers and footers); printing

Charting:

Creating a chart quickly with the chart wizard; using the chart toolbar; range finder in charts; fine tuning your chart; adding and removing data; changing the scale; setting fill effects and special effects; printing a chart with the data; creating your own custom chart, troubleshooting charts

How long does this course last?

1 day

Forthcoming courses

VBA for Excel Part One

14 September 2010

£250.00

Places available: 8

Microsoft Excel Intermediate

16 September 2010

£220.00

Places available: 8

Microsoft Excel Advanced

24 September 2010

£250.00

Places available: 8

VBA for Excel Part Two

27 September 2010

£250.00

Places available: 8

Microsoft Excel Essentials

5 October 2010

£220.00

Places available: 5

VBA for Excel Part One

8 October 2010

£250.00

Places available: 8

Microsoft Excel Intermediate

14 October 2010

£220.00

Places available: 8

Microsoft Excel Advanced

21 October 2010

£250.00

Places available: 8

VBA for Excel Part Two

27 October 2010

£250.00

Places available: 8

VBA for Excel Part One

10 November 2010

£250.00

Places available: 8

Microsoft Excel Intermediate

18 November 2010

£220.00

Places available: 8

Microsoft Excel Advanced

25 November 2010

£250.00

Places available: 8

VBA for Excel Part Two

26 November 2010

£250.00

Places available: 8

Microsoft Excel Essentials

6 December 2010

£220.00

Places available: 5

VBA for Excel Part One

9 December 2010

£250.00

Places available: 8

Microsoft Excel Intermediate

13 December 2010

£220.00

Places available: 8

Tips and tricks...
Excel – keyboard shortcuts (1)
[Alt] + =         AutoSum [Ctrl] + ;         Insert current date [Ctrl] +...
Excel VBA – tracking who has opened a workbook
Problem: How can I keep a record of who has opened my workbook? Solution: Create a tracking...
Excel – Count how many cells contain a date greater than today
You would think this would be quite simple, but you can't specify >TODAY() as criteria. Try this...
Delegate comments

"Excellent value, especially data consolidation. everyone should have to do excel courses."

The content is good - a good range of topics. More time for pivot tables as there is so much functionality behind these. I would happily take this course twice because it is so useful.

The VBA 1 course was very useful and accessible to anyone. The module can be used for anyone and for any role. Gihan, JP Morgan