
©bongkarn thanyakij via Canva.com
Microsoft Excel: VLOOKUP and other Excel Formulas

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:
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.
Turn your passion into a business.