Excel Hints and Tips
Microsoft Excel 2003, 2007 or 2010
This one day course is intended for delegates already using Excel but who would like to consolidate their knowledge and make the most of using Excel.
Aims and Objectives
By the end of the course participants will be able to:
- Use Quick ways to select data using the keyboard and mouse
- Create and use formula
- Change the order of calculation (BODMAS)
- Use Autocalculate
- Show and hide formulae
- Replicate formula
- Use Autosum effectively
- Create a series and custom series
- Work with multiple worksheets
- Work with relative and absolute cell address
- Best fit columns and rows
- Wrapping text and changing text orientation within a cell
- Headers and footers
- Printing
- Printing titles on each page
