Training M S B Lane Office Automation Tools Designs
Training and Learning Consulting | Learning Consulting | Customised Training Solutions | Writing and Editing Services
Full Course List | Business Writing | Presentation Skills | Facilitation Skills | Business Etiquette | MS Excel | MS Access | MS Word | Toolbook | Adobe Captivate

MS Office Skills: MS Excel 2007/2010

Workshop

Is it for you?

What will it cover?

What will it cost?

Pivot Tables and Pivot Table Charts

½ day

Prerequisite: Basic MS Excel skills
Ask yourself:
  • Do you want to present your data in an easy-to-understand and flexible summarised format?
  • Do you find the thought of using pivot tables and/or pivot table charts intimidating?
  • Do you want to know how to design an effective pivot table?
  • Do you want to know what kind of pivot table chart to use to present different types of data?
  • Do you want to know how to create custom fields and calculations to make sense of your data?
  • Do you want to know how to use your pivot table to see the changes in data over time?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wants to use MS Excel’s pivot tables and pivot charts to analyse and present data.

The workshop will enable you to:

  • Build a 2-dimensional pivot table
  • Build a 3-dimensional pivot table
  • Group values in a pivot table
  • Add different summary functions (e.g., Count, Average)
  • Use report layouts and formats to present the data most effectively
  • Add and suppress summary values
  • Set pivot table options
  • Sort and filter data in a pivot table
  • Add custom sort orders to a pivot table
  • Add calculated fields to pivot tables
  • Create separate data sheets for individual groups
R750 per person (min 2 participants)

R7,500 per group (up to 12 participants)
Use Lookups and Lists

½ day

Prerequisite: Basic MS Excel skills
Ask yourself:
  • Do you want to know how to view specific data in a list?
  • Do you want to know how to use conditional formatting to highlight specific data in a list?
  • Do you want to display your information in a specific order that is not alphabetic, numeric or date?
  • Do you work with lists of data that include repetitive values?
  • Do you want to be able to have Excel automatically look up values in another spreadsheet?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wishes to use MS Excel’s lists and lookups to analyse and present data.

The workshop will enable you to:

  • Sort and filter lists
  • Validate data entry
  • Conditional formatting
  • Create custom sort orders
  • Use VLOOKUP and HLOOKUP
  • Use MATCH and INDEX
R750 per person (min 2 participants)

R7,500 per group (up to 12 participants)
Use Excel Functions and Formulas

1 day

Prerequisite: Basic MS Excel skills
Ask yourself:
  • Do you need to create averages, count values or find the highest or lowest value?
  • Do you want to summarise data in cells that are not next to each other?
  • Do you want to be able to combine last names and first names from different columns into a single column?
  • Do you want to show the first or last 8 letters from a text value in one column in a separate column?
  • Do you want to be able to show a certain value in one column based on whether a cell in another column meets a specific criteria?
  • Do you know how to create reliable conditions by using “AND” and “OR” statements?
  • Do you want to summarise data that meets certain conditions in a list or database?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wants to use MS Excel’s functions and formulas to calculate and manipulate data.

The workshop will enable you to:

  • Use basic summary functions
  • Use functions that summarise non-contiguous cells
  • Use Text functions (concatenation, Left(), Right() and Mid())
  • Use Date functions
  • Copy formulas
  • Use IIF Statements
  • Understand Boolean logic
  • Use SUMIF, COUNTIF and AVERAGEIF statements
  • Use the DSUM function
R1,500 per person (min 2 participants)

R15,000 per group (up to 12 participants)
Use Macros and VBA to extend the power of MS Excel

1 day

Prerequisite: Intermediate MS Excel skills
Ask yourself:
  • Do you want to automate repetitive data-entry or formatting tasks in MS Excel?
  • Do you want to be able view, understand, and edit a recorded macro in MS Excel?
  • Do you want to use IF statements to add conditions to your macros?
  • Do you want to use VBA to navigate in a spreadsheet?
  • Do you want to carry out a task for a certain number of rows or all the completed rows in a spreadsheet?
  • Do you want to know how to create code from scratch to complete basic tasks?
  • Do you want to perform complex calculations and pass values from one macro to another?
If you can answer “yes” to any of these questions, this workshop is for you!
Designed for anyone who wants to record, customise and create basic macros to use the power of MS Excel to its fullest.

The workshop will enable you to:

  • Record and run macros
  • Add buttons to run macros
  • Understand the basic structure of VBA
  • Edit a macro in VBA
  • Use IF statements in VBA
  • Use ActiveCell.Offset
  • Use For…Next loops
  • Understand and use variables
  • Use the InputBox function
  • Use Select Case loops
  • Create a user-defined function
  • Use Do…While and Do…Until loops
  • Add comments
  • Use debugging tools
R1,500 per person (min 2 participants)

R15,000 per group (up to 12 participants)
Customised MS Excel Workshop

Prerequisite: Depends on training needs
Ask yourself:
  • Are you upgrading from MS Excel 2003 to 2007 or 2010?
  • Do you have specific Excel skills that you want to improve?
  • Do you need targeted MS Excel training?
  • Do you have specific types of data that you need to work with?
  • Do you need to combine some basic and intermediate skills training?
  • Do you have specific time-frames within which you would like training (e.g., 1 hour/day or 2 hours/week)?
If you can answer “yes” to any of these questions, this option is for you!
Designed for anyone with specific needs around improving MS Excel skills.

Customise an MS Excel workshop to meet your specific needs.

Choose from the topics in any of the MS Excel workshops or specify your own.
R250 per person/training hour (min 2 participants)

R300 per person/training hour (1 participant)


Other MS Office Training: MS Access | MS Word

For more in-depth training and consulting around building tools in MS Excel to automate business processes, see Office Automation Tools.

+27 (0)72 614 6010 M S B LANE msblane@yahoo.com, PO Box 354, Derdepark 0035, South Africa