Microsoft Excel Worksheets, Workbooks and Charts

1/2 Day Course

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

In this course, you will learn how to create and design multiple Excel Worksheets and how to work efficiently within Workbooks. You will learn how to create macros to automate some steps and save you time! You will also learn how to create visually appealing charts that will display the spreadsheet data in a graphical format.

COURSE CONTENT

USING MULTIPLE WORKBOOKS AND WORKSHEETS

• Setting Up Multiple Worksheets

• Working with Multiple Worksheets within a Workbook

• 3 Dimensional References

• Multiple Arguments with the Sum Function (comma vs. Control key) Consolidating Data

• Basic Macros

• Recording a Macro

• Linking

• Edit links

WORKING WITH CHARTS

• Creating Charts

• Changing Chart Data

• Modifying Chart Elements

• Creating Custom Charts

• Using Sparklines

Register
Prix
Qté
Total
  • 2 to 5 Course Participants
    $175
    +$22.75 HST
    $175
    +$22.75 HST
    0
    $0
  • 1 on 1 Training
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 6 to 10 Course Participants
    $995
    +$129.35 HST
    $995
    +$129.35 HST
    0
    $0
  • 10 - 20 Course Participants
    $1,495
    +$194.35 HST
    $1,495
    +$194.35 HST
    0
    $0
Total$0

Share This Event