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
• Identifying business patterns to make better industry
• 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?
spreadsheet data that is difficult to work with because it’s not formatted
• 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
• Learn the difference between relative and absolute reference
• 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
• Use filter lists to evaluate a table’s content
Reference tables in formulas
• Understand limitations and restrictions
within functions and how to