 |  |  |  |  |  |
| Course | Microsoft Excel Advanced - all versions up to 2007 | |
| Duration | 1 Day | |
| Overview |
There is something for everyone is this one day advanced course. Most users keeping lists in Excel will benefit from Pivot Tables, and Goal Seek, Scenario Manager and Solver will find answers to complex problems. Students attending this course should be comfortable with the majority of the features on the introductory and intermediate courses. |
|
| Content | Data Analysis with PivotTables | Getting your data ready for a Pivot Table Creating & Editing a Pivot Table using: Drag and Drop and the Layout dialog box Using the Column, Row, Data and Page positions Formatting a Pivot Table Adding a Pivot Table Chart and editing the chart Working with and grouping dates in a Pivot Table Producing multiple sheets using the page position Changing the function used for the Data Changing the calculation of the Data Using multiple fields in a position Updating the Pivot Table Adding a calculated field Using Microsoft's free on-line learning Time is given to practice during this session |
| Data Validation | Setting up Data Validation to enable: Pick from List Specific numbers to be typed in cells Controlling the error messages and input alerts |
|
| Sharing Workbooks |
Setting User Information |
|
| Macros | Recording and running a Macro Macro storage Absolute and Relative referencing Assigning a Macro to a button, keystroke and menu The Personal Macro Workbook |
|
| Advanced Functions (if required) | Financial/Statistical Functions Information Functions Cell Test Functions |
|
| What IF Analysis with: | GOAL SEEK
SCENARIO MANAGER SOLVER (if required) |
|
| Protecting Worksheets & Cells | Sheet Protection Unlocking a Range of cells Hiding Formulae in cells Workbook Protection Windows & Structure Protection Saving a file with a Password |
|
| Outline and the View Manager (if required) | Using Manual & Automatic Outlining Creating, Displaying and Deleting a View |
|
| Worksheet Auditing | The Audit Toolbar Tracing Precedents and Dependents Navigating and Removing Tracer Arrows Tracing Arrows Adding/Deleting/Printing Comments |
|
| Using Styles and Templates | Creating a template and template
storage What are Styles in Excel? Adding and Editing Styles Changing the default Book.xlt workbook |
|
| Please note: | The above list of features is for
a standard course. These features can be customised to suit the client with
any mix of features taken from the introductory, intermediate or advanced
courses.
Clients are encouraged to choose and prioritize the features they wish to cover during the day. It may not be possible to cover all the above content during one day. Macro training on this course is aimed at writing and running macros from the Excel interface and VBA programming and building custom dialog boxes are not covered. Courses are available in Excel VBA and please contact us for details. |
|