Become a Microsoft Excel Formulas Pro (2-Part Series)

Webinar Presented by: Donna Gilliland, award-winning technology instructor, certified technology trainer, president of MOSTraining

Part 1: Leverage Basic Excel Formula Functionality to Save Time & Effort

Want to power up your Excel formula knowledge and go beyond the double-click of the AutoSum? Fasten your seat belts and get ready for a power hour of super useful Excel formulas!

Microsoft Excel contains hundreds of time-saving functions you can use to perform specific calculations. For example, you can use the financial function, PMT to calculate a mortgage payment. Use the text function UPPER to convert text to all capitals.

During this webinar, you’ll learn how to create a variety of time-saving function formulas:

IF (logical function)
COUNTIF (statistical function)
PROPER (text function)
CONCATENATE (text function)
PMT (financial function)
TODAY (date and time function)
Bonus: You’ll also get a glimpse into how to nest functions!

If you’ve ever been perplexed about how to create or edit a formula, or just want to learn more about Excel, join us for this webinar!

Part 2: Beyond Excel Formula Basics: Name Ranges, Drop Down Lists & Data Validation

Are you ready to dive deeper into the world of Excel formulas? Go beyond the basics and learn how to use name ranges, drop-down lists and validate data with a few clicks of your mouse!

Did you know that you can use the range name feature to name a cell or range of cells? You can, and once cells are given names, they can be referenced from any spreadsheet within your workbook. Plus, a range name becomes an absolute reference and will refer to the same location no matter where you copy the formula. It’s such a power tool when writing formulas!

During this webinar, you’ll learn how to:

Create a range name using the name box.
Create and edit range names using the name manager dialog box.
Use range names in a formula.
Quickly create range names from column and row headings.
Use to use a range name to populate a data validated list.
Use range names to navigate spreadsheets in a workbook.

Take your Excel formula skills to the next level and put the name range, drop-down list, and data validation features to work for you with this webinar!

Learn to maximize the benefits of Excel for your professional and personal use with this 2-part webinar series!

Watch a preview:

Part 1: Leverage Basic Excel Formula Functionality to Save Time & Effort

Price: $67

(Single User License)

Part 2: Beyond Excel Formula Basics: Name Ranges, Drop Down Lists & Data Validation

Price: $67

(Single User License)