New Logo
White mail

Microsoft Excel

Intermediate

This course is for existing users of Excel who wish to improve competence working with calculations, large spreadsheets and lists.

Objectives

Formulas and Functions

Revision of basic formulas & AutoSum

Creating statistical functions

Using absolute & mixed cell addresses

Using the Insert Function button

Testing data using the If function

Calculating percentages

Using the NEW Quick Analysis tool

 

Multiple Worksheets

Inserting & deleting worksheets

Colour-coding worksheet tabs

Moving and copying worksheets

Grouping worksheets for formatting and printing

Linking cells between worksheets

Creating calculations across worksheets

 

Multiple Workbooks

Arranging multiple workbooks on one screen

Linking cells between workbooks

Creating calculations across workbooks

 

Lists

Sorting lists

Filtering lists using AutoFilter

AutoSum with lists

Formatting a list as a table

 

Viewing Large Worksheets

Freezing columns and rows

Splitting the screen

Hiding & unhiding columns and rows

Custom Views

 

Printing

Printing a selection

Setting & clearing print areas

Scaling a sheet to fit

Centring horizontally & vertically

Inserting & removing page breaks

Headers & footers revision

Repeating titles on each page

 

Formula Auditing

Tracing precedents and dependents

Tracing errors

Showing formulas

Using the watch window

 

 

 

Previous knowledge of Excel is required including the ability to construct basic formulas.

Prerequisities

Content

© PrimeraTraining 2020

aIkYTrpHRRG58ENlqEQrRF0h5WI
Green_PolicyBee_Badge

Professionally insured through PolicyBee

We are GDPR compliant. For information on how we handle personal data, and your associated rights, please view our Privacy & Data Protection Notice.