Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 400766
 
Credit & Course Provided by:

Utilizing Formulas in Microsoft® Excel®

Live Webinar
August 9, 2017
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$149Register Now
Can't Attend?   Audio & Reference Manual$149Add to Cart

Learn how to unlock the powerful formulas and features in Excel®.

Anyone using Excel® invariably needs to create and understand how to use formulas and functions. For some Excel® users, it is the centerpiece of what they do on a daily basis. Many Excel® formulas involve simple mathematical constructions using addition, subtraction, multiplication and division, but sometimes you need more complex formulas to reach an answer. Excel® has more than 300 built-in functions that simplify what could be more cumbersome and lengthy formulas. Whether it's calculating the monthly payment on a car loan or quickly tabulating a total or average for a column of numbers, Excel®'s functions give you a tremendous capability to tackle a myriad of statistical, mathematical and financial challenges, not to mention functions that extract valuable date information and let you manipulate text at the character level. This topic will give you a ton of valuable tools to make you a master at creating formulas, auditing worksheet formulas, mastering the way to understanding many of those 300+ functions, and some real insight and depth into highlighted functions, such as IF, VLOOKUP, COUNTIF (and its related functions), ROUND (and its companions), powerful array formulas and the potent (but overlooked) text functions.

Learning Objectives

  • You will be able to explain how to use text functions to extract data from long entries.
  • You will be able to describe and guarantee that all entries within a list are unique.
  • You will be able to discuss how to get rid of problematic extra spaces that prevent efficient data-matching.
  • You will be able to review how to manage leading zeroes in zip, numerical, and text codes.

Registration

Live Webinar$149Register Now
Can't Attend?   Audio & Reference Manual$149Add to Cart