Loading...

Course Description

This seminar will give you techniques that are guaranteed to increase your productivity with Microsoft Excel. Participants will cover Excel's formulas and functions with advanced instruction on the most useful methods for automating reports. The seminar will impart shortcuts and tips for preparing outstanding presentations using Excel charts. And, participants will be able to see how to use Excel macros to automate spreadsheet work. The best thing about this seminar is that it's taught in layman’s terms – not “geek-speak!” 

Related Courses

Other Courses

Who Should Attend

This class is for Excel users who are interested in learning shortcuts, tips, and techniques for increasing productivity.

Prerequisites

A solid understanding of basic and intermediate Microsoft Excel is needed.

Attend and You Will Learn / Expected Outcome

Attend And You Will Learn

Timesaving Methods for Building a Worksheet

  • Personalizing the Excel environment with the QAT and ribbon
  • Using Excel options to customize your work environment
  • Seven steps to spreadsheet success 
  • Basic list rules to keep you sane 
  • Paste with live preview
  • Data validation as a self-defense move 

Creating Attention Grabbing Excel Reports

  • Sorting to bring order to madness 
  • Custom lists for greater flexibility 
  • Conditional formatting
  • Filtering to get immediate answers
  • Subtotals – done automatically for you 
  • Using the auditing tools to track problems 
  • The IFERROR function for better error handling 
  • Using goal seek to find desired solutions 

 Combining Data with Ease and Accuracy

  • Shortcuts for working with worksheets and workbooks 
  • Linking data across workbooks effortlessly 
  • Consolidating data across workbooks with active links 

Functions that Save Time and Add Pizzazz

  • VLOOKUP for expert search capabilities
  • The IF function for basic decision making 
  • The SUMIF function for one criterion math decisions 
  • The SUMIFS function for multiple criteria math decisions 
  • The LEFT, RIGHT and MID functions for data display 
  • Extremely useful date and time functions 
  • Using macros to expedite analysis 

 Amazing Chart Ideas that will Get You Noticed

  • The fastest way to create a chart 
  • Positioning multiple charts
  • Linking chart titles to worksheet cells 
  • Sparklines
  • PivotTables for easier analysis
  • Slicers
  • PivotCharts for better visuals 
  • Wrap up 

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel Tips and Tricks
Type
In-Class
Days
W
Time
9:00AM to 4:30PM
Dates
Mar 25, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors