Date(s):

05/13/2020

Registration Open:

8:30 AM - 9:00 AM

Time:

9:00 AM - 4:30 PM

Meeting Type:

Courses

CPE Credit:

7.50

Field(s) Of Study:

Computer Software and Applications (7.50)

Level of Knowledge:

Intermediate

Price:

Member: $245.00
Nonmember: $275.00

Discounts available:

Not Available

Overview

Have you ever struggled with:
• Accessing all the valuable information in your spreadsheets?
• Making smart business decisions based on your Excel data?
• Providing vital information in order to meet financial goals?
• Identifying business patterns to make better industry forecasts?
• Spotting trends within your data?
• Presenting your information in “layman’s terms”?
• Imported excel spreadsheet data that doesn’t come in the way you expected?
• Trying to calculate numbers that won’t calculate due to numbers in the wrong format?
• Summarizing spreadsheet data that is difficult to work with because it’s not formatted properly?
• Trying to get your data to come out the way you want it to?

Stop struggling with these kinds of questions and come to learn the answers!  This 1 day in-depth, focused training session can take your Excel knowledge to the next level.   Join the elite few who have mastered some of Excel’s most powerful functions and formulas. 

Understand Names, Ranges and Formulas
• Apply simple to complex formulas to draw out hidden information
• Add function formulas to understand what’s really going on with your numbers
• Logical functions, Date type functions, VLookup and HLookup Functions.
• Learn how named cells and ranges can make your formulas more understandable
• Easily move through worksheets using the Name box
• Save time by using names in your formulas and functions
• Learn the difference between relative and absolute reference formats
• Discover the power behind Excel’s data validation formulas
• Learn how to debug errors using Excel’s auditing tools

Analyze Data Using Tables
• Create criteria ranges using database functions
• Use filter lists to evaluate a table’s content
• Reference tables in formulas
• Understand limitations and restrictions within functions and how to

Speaker(s)