K2's Excel Conference

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!

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

Prerequisites

Fundamental understanding of Microsoft Office Excel

Designed For

Business professionals who want to increase their proficiency when working with 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

Notice

All materials will be available to download in advance and participants will receive an email two days prior to the course date. Materials will also be posted in the “My CPE” section of the NESCPA website.