This course is designed for current users of Microsoft Office Excel who have already mastered the fundamentals covered in our Excel: Essential Skills course.

Our aim is to provide you with the necessary skills to produce well-designed spreadsheets. We will introduce many timesaving features using quick keys and short cuts.

In this course we cover features such as:

• Reducing the amount of typing by grouping worksheets together.
• Using formula that evaluate a condition and perform the appropriate calculation.
• Naming cells to minimize errors in formulae and to remove the need to redo these formulae when you add or remove rows or columns of data.
• Creating customised number and date formats.
• Database utilities to quickly generate sub totals, filter lists, and create reports for subtotalling categories from a list.
• File and data protection to avoid accidental corruption.

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes, and to review this Course Guide once you are back at your workplace.

This course in conjunction with Excel Essential Skills covers the material examined in the MOS Excel Core Examination.

ALL Excel users. Anyone who uses Excel regularly will benefit from these Excel hacks that can save countless hours of unnecessary time and effort. Be prepared for many ‘light bulb’ and ‘aha’ moments in this course which will revolutionise the way you work in Excel.

Have a thorough understanding of the different shapes of the mouse pointer in Excel.

Have a thorough understanding of formulae including AutoSum, absolutes references, and creating percentages for categories, all of which are covered in our Excel Essential Skills course.

Are able to AutoFill and use the mouse to drag and drop, copy and move.

This course concentrates on introducing attendees to some of the more productive tools and time saving features of the program. It focuses on how to build accurate spreadsheets that survive changes without errors.

Arranging Windows: No matter if you use a single monitor or multiple ones, find out how to effortlessly view your information at a glance. Includes splitting panes and hiding workbooks.

Best Use of Multiple Worksheets: Fed up with updating each sheet individually? Discover how to make changes across your whole workbook and create simple formulas to summarize figures from various worksheets.

Linking Spreadsheets: Enter values or formulas once and link them to save time.

Conditional Functions: Show Excel how to test your data and decide on what actions to take if it passes or fails the test.

Conditional Formatting: Create rules that determine the format of cells based on their values or how they compare with other values on your sheet.

Creating Customised Formats: Customise your dates and numbers to display exactly as you want them.

Validating Data in a Worksheet: Learn how to add a dropdown list in a cell. Stop text being entered when it should be a number or a date.

Protecting Workbooks and Worksheets: Stop accidental edits or deletions to your spreadsheets and workbooks.

Creating Templates: Save time by creating templates with all your formulas and worksheets fresh, clean and ready to go.

Subtotalling Data: Quickly tally up groups of items in your lists, all with the click of a button.

Formula Auditing: Discover how to easily trace a formula throughout your worksheet.