EVENT DESCRIPTION
SCHEDULE
This course has shifted online into two, half-day sessions.
Monday, August 8, 2022, 8:30am - 12:30pm
Tuesday, August 9, 2022, 8:30am - 12:30pm
Ready to take your Excel skills to the next level?
This seminar starts by clarifying some key Excel misunderstandings that affect typical Excel workbooks and shows you how advanced Excel functions will improve your calculating skills. Need to bring data into Excel from an outside source? The seminar will cover this in depth. You will learn how to use Excel’s data analysis tools, including advanced lookups. Then the course dives into array formulas, a powerful tool that very few Excel users understand. Finally, you will be exposed to the Excel Data Model and PowerPivot, a tool first introduced in Excel 2010 that enables you to work with large amounts of data from multiple data sources.
LEARNING OBJECTIVES:
- Understand how Excel calculates; creating custom formats; and date arithmetic
- Learn how to use Excel functions such as AND, OR; CHOOSE, INDEX, MATCH and INDIRECT
- Learn the key skills you need to access external data such as importing from ACCESS, importing from other file types, using Microsoft Query
- Discover data analysis tools such as Goal Seek, Data Tables, Scenario Manager and Solver
- Understand the power of lookups, VLOOKUPS with IFERROR, VLOOKUPS with wild cards, combining VLOOKUPS and doing a VLOOKUP across multiple sheets
- Discover array formulas to simplify complex calculations, including single arrays, multi-cell arrays, comparative arrays, conditional formatting with arrays and more
- Discover the power of Excel PowerPivot, Power View, Data Models, DAX calculations and Power Map that is available in Excel Professional Plus 2013 and 2016
WHO WILL BENEFIT:
The seminar is designed for intermediate users who want to further their Excel skills to the next level. You will leave the seminar with a clear understanding of how to use the many advanced tools in Excel that few users take advantage of.