Tollfree - +1-888-222-5917

Mastering Excel: Rising Above the VLOOKUP Function

Faculty :

Industry :

Duration :

Course Description:

         Microsoft Excel has become the de facto spreadsheet application for business. But do you sometimes feel like you have rows and rows of data and it's hard to make heads or tails of it? This class will help you learn how to manage databases in Excel, and get the most out of them.

Why should you Attend?

        Learn how to manage databases in Excel with this webinar. Learn the tools that will help large amounts of data seem more manageable, and easier to sort through and analyze. Understand what functions work best with large tables, and how you can automate repetitive steps with simple macros. Become a master of working with databases in Excel.

        For 60-minutes, our Excel expert Tom Fragale will lead you through a full array of powerful and easy-to-use database commands and methods critical to effectively working with Excel databases. In this webinar, you will learn how to improve your Excel database skills so that you can better summarize info-making better, more-informed business decisions.

        You'll learn how to cleverly use standard Excel functions that could save you hours through to days of manual work.

  • Easy-to-use methods to build and manage your database
  • Specialized database functions that simplify your job
  • Techniques to sort and filter data in order to identify business trends
  • Tips and tricks to validate your data and guarantee accuracy

Areas Covered:

  • Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form
  • Use VLOOKUP and HLOOKUP to aggregate data from multiple tables
  • Sort records in a data list using a variety of methods
  • Filter data in a list using a variety of methods, as well as work with filtered data
  • Create and work with subtotaled lists
  • Use various database functions to summarize data
  • Create, modify, and work with PivotTables, PivotCharts, and Slicers
  • Import external data from a variety of sources into Excel

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


Avail 12 months unlimited access for a single user.


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



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).