Topic: Become a Microsoft Excel Formulas Pro (2-Part Series)
Presenter: Donna Gilliland, award-winning technology instructor, certified technology trainer, and president of MOSTraining
Date: Part 1: Thursday, July 16, 2015, Part 2: Thursday, July 30, 2015
Time: 12 p.m. CDT, 1 p.m. EDT, 10 a.m. PDT
To find the time in your time zone, click here.
Price: $37 or $57 for both sessions (Single User License)
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 AdminTech Crash Course!
Part 2: Beyond Excel Formula Basics: Names, 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 session, 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! Join us for this AdminTech Crash Course!