K2's Excel Conference

Overview

You could pay $0 for this course!

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!

This course qualifies for reimbursement through the state’s Workforce Training Express Fund. Firms/companies with fewer than 50 staff can be reimbursed up to 100% of the cost of training and firms/companies with 50-100 employees can be reimbursed up to 50% of the cost of training. You must register for the course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks prior to the start of the course. The course code for this program is C-12846. To learn more, click here or contact Julia Ekelund at jekelund@masscpas.org.

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

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