Microsoft Excel: VLOOKUP and other Excel Formulas
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
- Relative Formulas
- Absolute Formulas
- Sum if
- Count if
- Average if
*** This event is promoted by the largest and the one and only event promotional portal of Bangladesh. ***
Now discover upcoming events happening in your city. Find out where your friends are going. Get event recommendations based on events you have attended is just a click away!
www.HelloEventz.com (EVERYTHING IS EVENT)