K2's Excel Conference - VIRTUAL

Overview

Virtually all accounting and financial professionals use Excel but, unfortunately, most don't use it as efficiently and effectively as they could or should. If you're ready to elevate your Excel skills, plan today to participate in this special 8-hour conference designed to help you work better with Excel.

In this event, you will go well beyond simple functions such as SUM to learn how you can take full advantage of many key features in Excel. Included in the discussion are newer functions and features such as LAMBDA, PIVOTBY, and XLOOKUP. You will also learn various tips for improving productivity and security when working with Excel. And you will learn best practices for working with PivotTables. 

You don't want to miss this special opportunity to learn better ways for working with Excel!

Prerequisites

Fundamental understanding of Microsoft Office Excel

Objectives

•  Identify the benefits associated with newer functions and features in Excel and utilize these newer tools
• Create advanced formulas using Excel functions and utilize formula "best practices"
• List various ways you can improve your efficiency and effectiveness in Excel by utilizing tips and tricks discussed in this session
• Construct PivotTables –  including those with user-defined calculations – and list examples of advantages of PivotTables compared to formula-based summaries and calculations 
  

Highlights

• Why and how to use new functions and features in Excel
• Advanced formulas and best practices for constructing them
• Excel productivity tips and tricks
• The power of the PivotTable