Create linked spreadsheets with greater functionality, named cell ranges and charts using the features and functions available in Microsoft Excel.
Who should attend?
Anyone with basic Excel knowledge needing to create more complex spreadsheets quickly and with greater functionality and efficiency. As well as be able to use graphs and charts for visualimpact using graphical representation of data and information.
Course overview
• Name cells and cell ranges for use in calculations
• Freeze columns & rows for effective scrolling without losing column and row headings
• Split worksheets to work in two parts of a worksheet at the same time
• Group worksheets together and work on them simultaneously
• Create summary worksheets quickly by calculating through worksheets in 3D
• Printing large worksheets effectively
• Need to update cells in one workbook by working in another? Create links between worksheets and workbooks
• Use the chart wizard to create graphical displays of your data
• Create quick charts with one press of a button
• Change the shape, design and colours of your charts
• Add pictures and text boxes to your charts
• Work with 2D and 3D charts
• Print charts effectively
Pre-requisites
An understanding of basic Excel, including basic formula and functions, and basic PC keyboard and mouse knowledge required.
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
