Create simple and effective spreadsheets using the tools and functions available in Microsoft Excel.
Who should attend?
Anyone new to Excel or those who are self taught and want to learn more effective ways of using Microsoft Excel.
Course overview
• Create new workbooks and worksheets
• Enter, modify and organise data in spreadsheet
• Add and remove columns and rows
• Improve the look of your work with fill colours, borders and shading
• Add currency, percentage style and comma style formatting to cells
• Learn how to use merge and centre
• Automatically total columns and rows using AutoSum
• Speed up repetitive calculations using AutoFill
• Move, copy sort and search data
• Add information to cells using comments
• Perfect printing using headers and footers, page set-up and page break preview
• Calculate using basic formulas, functions and dates
• Improve the functionality of your calculations by understanding absolute and relative addressing
Pre-requisites
Basic PC skills required. This includes basic keyboard and mouse skills, and a basic understanding of how to locate and open files.
Duration
1 full or 2 half days
Price
Onsite: £595 + VAT per day
Offsite: £745 + VAT per day
Options
Microsoft Office 2000, XP, 2003 and 2007 MS Office for Mac
