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!

register-now

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!

register-now

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

AdminPro Training VIP Pass

 

Procedures Pro book

 

Check Out Julie’s Books!