Microsoft Excel: VLOOKUP and other Excel Formulas

MessageThis Webinar is over
Date Jun 8, 2018
Time 01:00 PM EDT
Cost $139.00
View All Dates
Online
Course Description:
         In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be.
         Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization.
         If you handle large amounts of data in Excel, this webinar will help you tremendously.
Why should you Attend?
        Utilize Excel lookup functions to become more efficient in Excel and use the IFERROR function to display something other than an N/A error value when VLOOKUP can't find a match. You need to perform dual lookups, allowing you to look across columns and down rows to cross-reference data you need. Use the MATCH function to find the position of an item on a list, view two worksheets from within the same workbook at the same time.
        Use Excel's OFFSET function to dynamically reference data from one or more accounting periods and Future-proof VLOOKUP by using Excel's Table feature versus referencing static ranges

Areas Covered:
  •  Relative Formulas
  •  Absolute Formulas
  •  Vlookup
  •  Sum if
  •  Count if
  •  Average if
  •  Networkdays

 


Create your own event
Turn your passion into a business.
Join our mailing list