| SETTING UP A WORKSHEET
Overview of Excel
Screen Layout
Selecting areas of a worksheet
Moving around worksheets
Text and numbers
Saving workbooks
Opening and closing workbooks
Autorecovery
Creating a new workbook
Inserting, deleting and moving worksheets
CALCULATIONS & FORMULAS
Creating Calculations
Using Functions
Sum, Average, Max, Min, Count, Counta
Paste function
Conditional Sum Wizard
Lookup Wizard
FORMATTING WORKSHEETS
Using fonts and colours
Bold, italic and underline
Formatting numbers
Clearing cell formats
Inserting and deleting columns and rows
Resizing columns and rows
Task Pane
|
COPY AND MOVE
Day and date sequences
Number sequences
Cut, copy and paste
Office Clipboard
Smart Tags
NAMING RANGES
Creating, using and pasting
Protecting Ranges
PRINTING
Preview and print worksheets
Print ranges
Print headers, footers and titles
3D WORKSHEETS
Selecting more than one worksheet
Formatting and data entry
Creating 3D formula
Copying 3D formula
Follow on courses:
Tailored Excel Training, details available on request. |
 
4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
enquiries@premiercs.co.uk |
