A Course for for Technicians, Engineers and Scientists

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.

What you’ll learn

• Powerful and Useful Functions Explained Part 1.
• Powerful and Useful Functions Explained Part 2.
• Working With Tabs to Simplify Your Work.
• Optimize Your Analysis with Goal Seek.

Course Content

• Some snippets of the Course –> 1 lecture • 9min.
• More snippets of the Course –> 1 lecture • 1min.
• The Top, Most Powerful Functions Explained: Part 1 –> 1 lecture • 48min.
• The Top, Most Powerful Functions Explained: Part 2 –> 1 lecture • 36min.
• Working with Tabs to Simplify Your Work –> 1 lecture • 9min.
• Using Date and Time Parameters in Your Spreadsheets –> 1 lecture • 16min.
• Optimize Your Analysis with Goal Seek –> 1 lecture • 28min.

Requirements

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

•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