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)
Become a Microsoft Excel Formulas Pro (2-Part Series)
Price: $97
(Single User License)
When you finish the registration and payment process, you will receive a registration confirmation email with the webinar link. Please make sure orders [at] allthingsadmin.com and adminsuccess [at] allthingsadmin.com are on your safe/white list so your junk or spam filters allow us through.