Microsoft Excel Automating Worksheet Functionality

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 some practical and efficient Excel automating worksheet functions. One of the powerful functions of Excel is the ability to easily create automated tasks and custom logic within macros. Macros provide a great way to save time on predictable and repetitive tasks, without having to write a single line of code.

COURSE CONTENT

UPDATE WORKBOOK PROPERTIES

CREATE AND EDIT A MACRO

• What are Macros?

• The Record Macro Dialog Box

• Naming Macros

• Visual Basic for Applications

• Copying Macros Between Workbooks

• Macro Security Settings

APPLY CONDITIONAL FORMATTING

• What is Conditional Formatting?

• Conditional Formats

• The Conditional Formatting Rules Manager Dialog Box

• The New Formatting Rule Dialog Box

• Clear Rules

ADD DATA VALIDATION CRITERIA

• What is Data Validation?

• The Data Validation Dialog Box

Register
Price
Quantity
Total
  • 2 - 6 Course Participants
    $175
    +$22.75 HST
    $175
    +$22.75 HST
    0
    $0
  • 6 - 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
  • 1 on 1 Training
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
Total$0

Share This Event