Advanced Excel: Make your Spreadsheets Dynamically Reactive

As a an Engineer with over 35 years of experience, I will show you how to harness the most powerful features of Excel. I’ll guide you to a strong understanding of Excel’s most powerful features and functions, so your spreadsheets will dynamically react to changes in any input parameter.

The course will teach you how to make use of the most powerful Excel functions, optimize your work through file linking techniques and tabs. You will learn how to best incorporate Date and Time functions into your projects, understand graphing techniques and conditionally format your spreadsheets. Your will learn how to perform powerful What-If analysis using Goal Seek.

Functions presented include:

•Rand: Generate random numbers for statistical analysis or testing

•Int: Strip out the integer component of any number

•Round: Round any number to any number of decimal places

•Max: Identify the maximum value in of any range of numbers

•Min: Identify the minimum value in of any range of numbers

•Count: Easily count the number of items in any range

•Sum: Easily sum up the values in any range

•Intercept: Determine the best fit intercept of any linear dataset

•Slope: Determine the best fit slope of any linear dataset

•Linest: Determine the best fir polynomial parameters for a non-linear dataset

•Vlookup: Lookup an associated value related to to a chosen parameter (sorted column)

•Xlookup Lookup an associated value related to to a chosen parameter (unsorted column)

•Sumif: Dynamically sum all terms related to a chosen parameter

•Averageif: Dynamically average all terms related to a chosen parameter

•If: Make your spreadsheet dynamically react to changes in input parameters

•And: Force two of more constraints in an If function

•Or: Program a requirement for one of multiple options be true within an If function

•Iferror: Easily handle errors that may occur in your spreadsheets

•Choose: Have your spreadsheets automatically react to a range of possible parameters.

•Transpose: Quickly and easily flip rows to columns for a given dataset.

Who this course is for:

• Technicians
• Engineers
• Scientists
• Curious People