Microsoft Excel - Let`s Look Beyond the Look-Up 2018

Topics

• Future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges
• Avoiding the complexity of nested IF statements with Excel’s CHOOSE function
• Learning how to arrange two worksheets from the same workbook on-screen and at the same time
• Performing dual lookups, which allow you to look across columns and down rows to cross-reference the data you need
• Understanding why the Protected View prompt should be turned off in Excel 2010 and later
• Discovering the array of functionality the SUMPRODUCT function offers
• Using the SUMIF function to summarize data based on a single criterion and the SUMIFS function to sum values based on multiple criteria

Who should Attend

• CPAs
• Accountants
• Controllers
• CFOs
• Income Tax Preparers
• Excel User
• Financial Consultants
• Enrolled Agents
• Auditors
• IT Professionals
• Bookkeepers
• Human Resource Personnel
• Government Personnel
• Marketers