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

Microsoft Excel Training

I am enjoying the opportunity to learn additional functionality of the product. I am also enjoying the opportunity to understand how other government colleagues are utilizing this product.
Comment from PWSGC

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