Excel 2007 / 2010 Level 3

     

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Organising Data Using Tables

Creating tables
Modifying tables
Formatting tables

Outlining

Creating an Outline automatically
Creating an outline manually
Ungrouping an outline manually
Removing the Outline from a Worksheet
The outline symbol

Custom views

Creating a View of a Worksheet
Deleting a view of a worksheet
Displaying a different view

Scenario

Set up a scenario
View a scenario
Edit a Scenario
Delete a Scenario

Using tracers to help audit a worksheet

Display the Auditing Toolbar
Description of tracer arrows
Tracing Precedents and Dependents
Remove all tracer arrows
Adding a Comment to a cell
Read a comment attached to a cell
Print the comments with a Worksheet
Edit a Comment on a cell
Viewing comments all the time

Calculating Data with Advanced Formulas

Format Text Using Formulas
Perform Numeric Calculations
Calculate Data with Lookup & Reference Functions
Perform Logical Analysis
Print Formulas
Functions, including Nested IF, SUMIF, COUNTIF and COUNTBLANK function
Round: round a number to decimal places
Enter the Workbooks name, Path and worksheet name into a cell
Using VLOOKUP
Tips using VLOOKUP
HLOOKUP

Getting Started with Pivot Tables

Creating your first Pivot Table
Fields to create Row headings
Fields to create Column headings
Data in the Summary area
Dynamically building a Pivot Table
Rearranging Fields in a Pivot Table
Number formatting of the Data Area
Creating a second (or more) Pivot Table on the same data
Moving the Pivot Table from one sheet to another or around the same sheet
Deleting a Pivot Table

Formatting the Pivot Table

Autoformat
Removing AutoFormat
Grouping and Hiding of multiple row/column groupings

Pivot Table Options

Dealing with empty cells
Refreshing the Pivot Table
Activating automatic refresh options
Turning off the Summary Rows and Columns

Goal seek

Using Goal Seek to find a required result
Setting values based on a target cell

Macros

Record a Macro
Use Relative References when recording a macro
Run a Macro
Delete a Macro
Assign a Macro to a Toolbar Button
Remove a Button from a Toolbar
Assign a Macro to a Button on a Worksheet
Edit a Button on a Worksheet
Viewing the code behind a macro stored in the current workbook
Viewing the code behind a macro stored in the Personal workbook
Creating your own toolbar
Setting a security option for your macros

Training Options

What's Included