Excel Training - instructor led beginners to advanced

MS Excel 2010 Training to study full time or part time. 

Complete this form for the Latest Pricing Information and Dates!

Available Study Methods:

1. Classroom Instructor Led training that will benefit your CV and give you the skills

2. Online Courses

3. Onsite Training for 5-15 people attending

Classroom training Location: Cape Town CBD

 

Overview:
This course will teach you basic to advanced features. Microsoft Excel is the standard spreadsheet application for both the business world and personal use.


Whether you are a new or an advanced user, Our training will cover what you need to know to become an power user.

Cape Town Instructor led training Contact us for the latest schedule and pricing.

View Course Details below!

 

 2010 - Level 1 - Class Outline

 2010 - Level 2 - Class Outline

 2010 - Level 3 - Class Outline


Excel 2010 - Level 1 - Class Outline

Duration -Traditional Instructor Led Learning - 1 Day

 

  Lesson 1: Creating a Basic Worksheet
  • Identify the  User Interface
  • Customize the  Interface
  • Work with Cells
  • Enter Data in an  Workbook
  • Obtain Help
   Lesson 2: Performing Calculations in an Excel Worksheet
  • Create Basic Formulas
  • Calculate Using Functions
  • Copy Formulas and Functions
   Lesson 3: Modifying an Excel Worksheet
  • Manipulate Worksheet Data
  • Modify Worksheet Elements
  • Search Worksheet Data
  • Modify Rows and Columns
 

   Lesson 4: Formatting an Worksheet                                 

  • Modify Fonts
  • Spell Check a Worksheet
  • Apply Number Formats
  • Add Borders and Color to Cells
  • Align Cell Contents
  • Apply Cell Styles

  Lesson 5: Printing Workbooks

  • Set Page Breaks
  • Set Page Layout Options
  • Print a Workbook
   Lesson 6: Managing an Workbook
  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage Workbook Views

 

Excel 2010 - Level 2 - Class Outline

Duration: Traditional Instructor Led Learning - 1 Day

 

Prerequisite(s) or equivalent knowledge: 
Excel 2010 - Level 1

 

  Lesson 1: Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions
  Lesson 2: Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Use Functions to Calculate Data in a Table or Worksheet
  Lesson 3: Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts

  Lesson 4: Pivot Tables, Slicers, and Pivot Charts

  • Create a Pivot Table Report
  • Filter Data Using Slicers
  • Analyze Data Using Pivot Charts

   Lesson 5: Inserting Graphic Objects

  • Insert and Modify Pictures and Clip Art
  • Draw and Modify Shapes
  • Illustrate Workflow Using Smart Art Graphics
  • Layer and Group Graphic Objects

 

  Lesson 6: Customizing and Enhancing Environment     

  • Customize the  Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

 

Excel 2010 - Level 3 - Class Outline

Duration: Traditional Instructor Led Learning - 1 Day

 

Prerequisite(s) or equivalent knowledge:
Excel 2010 - Level 1
Excel 2010 - Level 2

 

  Lesson 1: Streamlining Workflow                               
  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  Lesson 2: Collaborating with Others
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access
  Lesson 3: Auditing Worksheets
  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Watch and Evaluate Formulas
  • Create a Data List Outline

 

  Lesson 4: Analyzing Data
  • Create a Trend line
  • Create Sparklines
  • Create Scenarios
  • Perform What-If Analysis
  • Perform Statistical Analysis with the Analysis ToolPak
  Lesson 5: Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
  Lesson 6: Importing and Exporting Data
  • Export  Data
  • Import a Delimited Text File
  Lesson 7: Using Excel with the Web
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query
  Lesson 8: Structuring Workbooks with XML
  • Develop XML Maps
  • Import and Export XML Data


 

Next Course: Excel 2010 Power Programming with VBA

IT courses Cape Town to study full time or part time. Office administration jobs will always require the skillls gained in this course. Consider adding this to your CV.

You may have found this page by searching for: Excel CoursesCape Town