| Getting More from Excel 2007 |
- Gain knowledge of Excel features such as functions, auditing and charts
- Save time by using efficient Excel spreadsheets in a work based situation
- Derive information from Excel rather than simply creating it.
The Getting More from Excel 2007 training course focuses on the practical application of intermediate program features. Training Course OutlineUsing Multiple Worksheets and Workbooks | Using Charts | - Inserting, renaming and deleting worksheets
- Creating multiple views and freezing panes
- Viewing and arranging multiple worksheet windows
- Viewing, selecting and navigating in multiple workbooks
- Creating and opening a workspace
- Managing multiple worksheets and workbooks
- Selecting multiple worksheets
- Moving, copying and linking data between worksheets
- Creating a 3-D formula.
| - Using and creating charts
- Changing chart type, style and chart sub-type
- Changing chart source data
- Adding and changing data in an existing chart
- Removing data from a chart
- Managing, moving, resizing and deleting chart objects
- Adding data series and objects to a chart
- Changing the chart type
- Formatting chart objects
- Printing charts.
| Advanced Functions | Advanced Formatting | - Creating and using functions
- Using built-in functions
- Using dates and times
- Using dates in calculations
- Using nested functions
- Auditing worksheets
- Identifying the auditing commands
- Understanding the watch window and the formula evaluator.
| - Using comments in a worksheet
- Reviewing, showing and hiding comments
- Deleting a comment
- Applying, modifying and working with style
- Using format painter
- Creating custom number formats
- Applying an AutoFormat (table format)
- Understanding conditional formatting
- Clearing conditional formats.
|
Bespoke Excel training can be delivered at your premises, for a minimum of six delegates, and will cover specific program features most relevant to your organisation. For more information on bespoke courses please call 01923 698498 or This e-mail address is being protected from spambots. You need JavaScript enabled to view it us. Entry Requirements: Delegates should have an understanding of any of the following operating systems: Windows 2000 or above
Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Excel 2007 Building Blocks course. Duration: Full day Cost per delegate (including refreshments): £195.00 excl VAT
.png)
|
