The Marquee Group - Data Manipulation with Excel – Part 1
Event DescriptionThis hands-on course is an intensive program that will transform participants into Excel “Power Users”. The course is focused on the pertinent Excel tools that are required in a business environment to efficiently analyze and manipulate data and to create compelling financial analyses.
Topics IncludeData Analysis
Use numerous built-in Excel functions to interpret and manipulate data
Use Excel’s filters in conjunction with specific arithmetic functions to summarize large volumes of data
Learn to use many features of the Advanced Filter, one of the most helpful and least utilized tools in Excel
Incorporate widely used financial and arithmetic functions
Use a variety of intermediate and advanced Lookup functions to efficiently extract specific information
Learn multiple uses of the Vlookup and Offset functions, including ways to automate these functions
Create nested formulas to expand the flexibility of various functions
Use powerful Text functions to manipulate non-numeric variables
Convert non-recognizable values into useable numbers with the use of Text functions
Become proficient with Pivot Tables, one of the most powerful tools in Excel, to quickly analyze large quantities of data
Learn to use some the most effective and lesser known Pivot Table features
Who Will BenefitThis seminar is designed for anyone who wants to use Excel to manipulate data to create compelling financial analyses. Date & TimeWednesday, February 6, 20198:30 am to 5:00 pmLunch is provided Special Instructions
Attendees must bring their own laptop with access to Excel.
This course assumes the participant has a good working knowledge of Excel.
Early Payment Pricing: $525 + tax (if registration paid by January 23, 2019)
Regular Pricing: $600 + tax (registration closes on February 1, 2019)
Liked this event? Spread the word :