Microsoft Excel

We are very excited to add Excel training to our website. If used correctly, Excel can be a very powerful tool for the business owner.  Our Microsoft Office training is provided by CDS Training Resourses.  CDS Training has over 20 years experience in the training and development of training materials for a variety of office software. 

In addition to video based and live webinar training provided by CDS Training Resources, they also provide complete reference material and practice exercises for each Module. We suggest that you print the reference material ahead of time and follow along for the most effective training experience. 

ExcelExcel Introducton Module 1

  • Getting Started
  • Entering and Editing Text
  • Values and Dates
  • Working with Files

Excel Introducton Module 2

  • Creating Formulas
  • Statistical Formulas (Sum, Average, Min, Max, Count)

Excel Introducton Module 3

  • Enhancing text and numbers
  • Adding color
  • Adding borders

Excel Introduction Module 4

  • Learn to work more efficiently
    • Insert and remove rows and columns
    • Use the fill handle
    • Use copy and paste
  • Get a glimpse into working with larger worksheets
    • Inserting worksheets
    • Naming worksheet tabs
    • Moving between worksheets

Excel Introduction Module 5

  • Control Print Layout
  • Work with Page Setup
  • Change Margins
  • Create Heaters and Footers

Excel Intermediate - Download Page  

Excel Intermediate Module 1 - Building Flexible Formulas – 26 minutes  

  • Understanding Relative, Absolute and Mixed Cell Adressing
  • Using Input Variables

Excel Intermediate Module 2 – Working More With Formals – 42 minutes  

  • Working with Named Ranges
  • Using Auditing Tools
  • Formulas that Link
  • Functions
  • Protecting Cell Contents
  • Password Protecting a Worksheet

 Excel Intermediate Module 3 – Working With Large Spreadsheets- 25 minutes 

  • Moving around quickly
  • Locking in Column Headings
  • Controlling the View
  • Splitting a Window
  • Using Find and Replace
  • Spell Check
  • Comments

Excel Intermediate Module 4 – Printing Large Spreadsheets – 26 Minutes  

  • Controlling Page Breaks
  • Changing Defaults
  • Hiding
  • Controlling Margins

Excel Intermediate Module 5 - Working with Multiple Worksheets – 46 minutes

  • Managing Worksheets
  • Working with Groups of Worksheets
  • Sum values across Worksheets
  • Paste Special
  • Consolidating Worksheets
  • Using Outlines

Excel Intermediate Module 6 – Wrapup – 19 Minutes

  • Working with Multiple Files
  • Creating a link when coping
  • Pros and Cons of Link Methods

Excel Database – 44 minutes

Excel Q & A

Excel Charts  Coming soon 

  •  Module 1 – Creating a Basic Column Chart
  • Module 2 – Enhancing Charts with Text Objects and Shapes
  • Module 3 – Changing the Chart Type and Customizing

Excel