Microsoft Excel Training Course 2003 Advanced

Overview and objectives of the Microsoft Excel Training Course

On the Advanced  Excel Training Course you will learn to assign descriptive labels to a range of cells, use a range of analytical tools, use advanced list management tools. You will learn to import and export data from Excel and to create piviot tables to summarise data. You will also learn to add automation to your workbooks by recording

 

 

Who is this Microsoft Excel Training Course for?

If you want to develop your skills to use more complex analytical tools in Excel.

Microsoft Excel Training Course prerequisites

It is recommended that you attend the Introduction & Intermediate Excel training courses prior to attending this course

Microsoft Excel Training Course Contents

Using Named Ranges

Apply a name to a range of cells, Apply a name to a constant value, Modify and delete range names, Print a list of range names, Use a range names and labels in formulas, Define and modify a list range

Custom Number and Conditional Formatting

Use formatting options with Paste Special, Create a custom number or date form at, U se scientific and fractional number formats, Use conditional formatting

Linking Worksheets and Workbooks

Create a formula to link worksheets and workbooks, Consolidate data using 3D references in com m on functions, Use Paste Special to link worksheets and workbooks, Use Paste Special to manipulate data, Manage and update linked workbooks

Consolidating Data

Use Consolidate to summarise data in multiple lists

Summarising a List

Extract data using advanced filters, Group and subtotal data using the outlining tools, U se Dfunctions to perform calculations on a data list

PivotTable and PivotChart Reports

Create a Pivot table Report, Modify Pivot Table field layout, Modify field settings and grouping intervals, U se Pivot Table AutoFormat, Create a PivotChart Report

Lookup Functions

Use VLOOKUP  to get values from multi-column tables, Sort values in rows or from left-to-right, U se other lookup functions (LOOKUP, MATCH , INDEX, OFFSET), Prevent lookup errors

Customising a Chart

Change the source data for a chart and modify data series, Explode segments of a pie chart, Insert an image into a chart, Add a text box to a chart, S ore a custom chart as a chart tem plate

Importing Text Data

Import data from a text file

Inserting Spreadsheets and Charts

Insert a worksheet from Microsoft Excel, Insert a chart from Microsoft Excel

Analytical Options

Goal Seek And Solver, Scenarios , Views , Reports

Publishing to a Web Page

Save a worksheet or chart as a web page, U se Web P age Preview

Macros

Recording And Running A Macro , Editing VBA Code , Function Procedures