Tollfree - +1-888-222-5917

Microsoft Excel: VLOOKUP and other Excel Formulas

Faculty :

Industry :

Live On :

Duration :

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

Who will benefit?

This webcast will be of a valuable assistance to the below audience.

  • Business Owners
  • CEO's / CFO's / CTO's
  • Managers
  • Accountants
  • CPA's
  • Controllers
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
  • Anybody with large amounts of Data
  • Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive

Registration Options



Max 5 participants from a single location with 1 Dial-in.


Max 10 participants from a single location with 2 Dial-in.


Avail 12 months unlimited access for a single user.


Material shipped within 15 days post webinar completion & get life time access for unlimited participants.



Avail recording + Attend live session for a single participant.


Unlimited participants for max 5 locations.


Tags


Microsoft Excel, VLOOKUP Functions, Manage Database in Excel, Data, Excel Functions, Macros, Pivot Tables

Speaker Details

Tom Fragale

Tom Fragale

Microsoft Excel Coach

Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training.

Refund Policy



Participants/Registrants for our live events, may cancel up to 72 hours prior to the start of the live session and ComplyArena will issue a letter of credit to be used towards any of ComplyArena's future events. The letter of credit will be valid for 12 months.

ComplyArena will process refund in cases where the event has been cancelled and is not rescheduled within 90 days from the original scheduled date of the webinar. In case if a live webinar is cancelled, participants/registrants may choose between recorded version of the course or a refund. Refunds will not be processed to participants who do not show up for the webinar. A webinar may be cancelled due to unavoidable circumstances, participants will be notified 24 hours before the scheduled start of the event. Contact us via email: admin@complyarena.com or call +1-888-222-5917 (Toll Free).