Microsoft Excel: VLOOKUP and other Excel Formulas
Details
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
Schedules
No. of Days: | 1 |
Total Hours: | 1 |
No. of Participants: | 30 |
ComplyArena is the leading online compliance provider, delivering high quality & diverse Compliance training across all domains. We have the best and the most experienced speakers in the Industries who are happy to share their knowledge with the world. We focus on connecting people with high quality webinars and seminars for professional development.
Analyzing the number of compliance requirements we had to comply to just to get us started, gave us an accelerated meaning to what we are doing and why. As a company our main aim is to ensure that our clients have an all-embracing exhaustive ability to act according to all the external and internal systems orders/rules. All our webinars and seminars are targeted towards helping our clients empower their compliance officers fulfill their duties of identifying and managing regulatory risk. All our training/consultation are targeted towards effectively supporting business in their duty to comply with relevant laws and regulations and internal procedures.