Home ∙ Training

Spreadsheet Training

You can either choose the contents of your spreadsheet training course by Pic'n'Mix from any of the topics below, or you can tell us what spreadsheet you want to design and we will base your course on the requirements of this spreadsheet.

We normally provide training at your premises for up to four delegates.  Training at your premises means the delegates are more refreshed than having to travel to our location.

Training can also be carried out at some training rooms we can rent near our offices in Basingstoke.
 

Pic'n'Mix Topics

Training Costs

  [Top of page] 

Pic'n'Mix Spreadsheet Training Topics

The following topics applies to Microsoft Excel 2007 and may not apply to Microsoft Excel 2003.  We would recommend upgrading to Microsoft Excel 2007 for the increased functionality.

If you are not sure what you require training on, JUST ASK on 0845 226 0696.

Basics User Interface Managing Larger Data Collections File Formats Formatting Cells and Worksheets Managing Data Tables Creating Formulas Summarising Data Creating Powerful Conditional Formats Creating Charts Controlling Printouts Setting Up a Workbook Creating Workbooks Modifying Workbooks Modifying Worksheets Working with Data and Data Tables Entering and Revising Data Moving Data Within a Workbook Finding and Replacing Data Correcting and Expanding Upon Worksheet Data Defining a Table Performing Calculations on Data Naming Groups of Data Creating Formulas to Calculate Values Summarising Data That Meets Specific Conditions Finding and Correcting Errors in Calculations Changing Document Appearance Formatting Cells Defining Styles Applying Workbook Themes and Table Styles Making Numbers Easier to Read Changing the Appearance of Data Based on Its Value Adding Images to a Document Focusing on Specific Data Using Filters Limiting Data That Appears on Your Screen Manipulating List Data Defining Valid Sets of Values for Ranges of Cells Re-ordering and Summarising Data Sorting Data Lists Organising Data into Levels Looking Up Information in a Data List

Combining Data from Multiple Sources Using Data Lists as Templates for Other Lists Linking to Data in Other Workbooks and Worksheets Consolidating Multiple Sets of Data into a Single Workbook Grouping Multiple Sets of Data Analysing Alternative Data Sets Defining and Editing Alternative Data Sets Defining Multiple Alternative Data Sets Varying Your Data to Get a Desired Result Using Goal Seek Finding Optimal Solutions with Solver Analysing Data with Descriptive Statistics Creating Dynamics Lists with PivotTables Analysing Data Dynamically with PivotTable Filtering, Showing, and Hiding PivotTable Data Editing PivotTables Formatting PivotTables Creating PivotTables from external Data Creating Charts and Graphs Creating Charts Customising the Appearance of Charts Finding Trends in Your Data Creating Dynamic Charts Using PivotTables Creating Diagrams by Using SmartArt Printing Adding Headers and Footers to Printed Pages Preparing Worksheets for Printing Printing Data Lists Printing Parts of Data Lists Printing Charts Automating Repetitive Tasks With Macros Introducing Macros Creating and Modifying Macros Running Macros When a Button is Clicked Running Macros When a Workbook is Opened Spreadsheet Security Protecting Worksheets Protecting Workbooks

 [Top of page] 

Spreadsheet Training Costs

The following charges apply to our Spreadsheet Training for up to 4 Delegates:

	Your Premises (within 100 miles of our offices, excluding within the M25)	Your Premises (over 100 miles of our offices, including within the M25)	Our Rented Training Rooms
Half Day (4 hours)1
Trainer	£240.00	£320.00	£240.00
Accommodation and Subsistence2	@ Cost	@ Cost	N/A
Mileage	N/A	@ Cost	N/A
Training Room Cost	N/A	N/A	£120.00
Lunch	See Note1&3	See Note1&3	£6.00 per delegate1
Full Day (7 Hours Training plus 1 Hour Lunch Break)
Trainer	£420.00	£500.00	£420.00
Accommodation and Subsistence2	@ Cost	@ Cost	N/A
Mileage	N/A	20p per mile	N/A
Training Room Cost	N/A	N/A	£220.00
Lunch	See Note3	See Note3	£6.00 per delegate

Notes:

All above prices exclude VAT
1.  A half day could be two hours prior to lunch and two hours after lunch, using lunch as a natural break.
2.  Accommodation and Subsistence Costs by prior agreement.
3.  We often find it's a good idea for the trainer to spend lunch with the delegates, helps for both to get to know each other, not just for the remainder of the training session, but for any remote support incidents after the training session.

 [Top of page]