Members

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. 

Excel Introducton Module 1 - 34 minutes 

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

Excel Introducton Module 2 - 25 Minutes 

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

Excel Introducton Module 3 -Control Worksheet Appearance – 28 Minutes 

 Excel Introduction Module 4 - 23 Minutes

  •  Learn to work more efficiently
  • Get a glimpse into working with larger worksheets

Excel Introduction Module 5 – 20 Minutes

  • 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

  • Sort and filter data
  • Create Pivot Tables
  • Work with text formulas

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

Comments are closed.