SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Microsoft Excel Training

Liked the interactive working with other students in the class. This allowed practice of not only the exercise, but what it would be like in a work environment.
Comment from HRSDC

1. Title

  • Microsoft Excel Level 1: Mastering Cells, Workbooks and Graphs (EXCBAS, 2 days)
    View PDF

2. Course Pre-requisites

  • Previous experience with Microsoft Office products

3. Target Audience

  • Business professionals who want to learn how to use Microsoft Excel

4. Dates and Pricing

2 People for Guaranteed Live or Virtual Delivery $1,150.00 per person

5. Outline

Module 1: Introduction to Microsoft Excel

Topic 1: The Major Elements of Excel: Workbooks, Worksheets and Cells

Topic 2: Identifying and Referencing Cells

Topic 3: Working with Cells, Rows and Columns

Topic 4: Working with Multiple Cells

Topic 5: Adding and Removing Cells, Rows and Columns

Topic 6: Naming Cells and Cell Ranges

Topic 7: Naming Worksheets

Topic 8: Adding and Removing Worksheets

Topic 9: Setting Project Information

Topic 10: Saving and Opening Workbooks

Topic 11: Exercise: Working with Cells and Workbooks

Module 2: Working with Cell Contents

Topic 1: Entering Numeric Cell Data

Topic 2: Modifying Cell Data

Topic 3: Formatting Numbers: Integers, Decimals, Currency and Percentages

Topic 4: Entering Textual Cell Data

Topic 5: Formatting Textual Data: Font, Size, Weight and Presentation

Topic 6: Working with Dates

Topic 7: Working with Currencies

Topic 8: Creating Custom Formats

Topic 9: Working with Auto-Fill

Topic 10: Creating Custom Auto-Fill Data Sets

Topic 11: Exercise: Adding Content to a Excel Worksheet

Module 3: Formatting Cells

Topic 1: General Principles of Cell Formatting

Topic 2: Formatting Cells for Vertical and Horizontal Alignment

Topic 3: Formatting Cells for Fill Pattern and Colour

Topic 4: Formatting Cells for Border Style and Thickness

Topic 5: Formatting Cells for Text Behaviour: Wrap and Continue

Topic 6: Working with Multiple Workbooks

Topic 7: Enabling and Disabling Cell Protection

Topic 8: Exercise: Formatting Data for Presentation Purposes

Module 4: Working with Formulas

Topic 1: The Anatomy of an Excel Function: Parameters and Return Values

Topic 2: Referencing Cells: The Magic of Relative References

Topic 3: Using Absolute References to Pin Down Cell References

Topic 4: Using Named Cells to Pin Down Cell References

Topic 5: Using Arithmetic Operators: Addition, Subtraction, Multiplication and Division

Topic 6: Introduction to Statistical Functions: Count, Average and Median (And maybe variance)

Topic 7: Introduction to Financial Functions: Payments and their Characteristics

Topic 8: Exercise: Creating a Data Summary Sheet with Excel Functions

Module 5: Business Graphics

Topic 1: Setting Up the Worksheet

Topic 2: Choosing the Right Type of Graph

Topic 3: Creating the Graph

Topic 4: Modifying the Axis Labels

Topic 5: Modifying the Title

Topic 6: Modifying the Legend

Topic 7: Changing the Graph Type

Topic 8: Exercise: Creating a Presentation Graphic with Impact

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette