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

Jun 30, 2015 | Career Development, Technology

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!


Learn to maximize the benefits of Excel for your professional and personal use! Join us for this two-part AdminTech Crash Course!

NEW TRAINING! Elevate Your Career With a Powerful Professional Portfolio. Register and Get Started Now!

New Monthly and Quarterly Membership Options Now Available

Check Out Julie’s Books!