2024 Advanced Excel: Hidden Secrets and Gems

Overview

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

Highlights

• Awareness of advanced functions
• Creative methods for data manipulation
• Real-life examples of innovative ways to analyze and report data with Excel
• Using Excel to perform e-mail merges
• Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox 

Prerequisites

A high level of proficiency with Microsoft Excel

Designed For

Practitioners, members in industry and other accounting professionals seeking an advanced understanding of Microsoft Excel

Objectives

• Evaluate lesser-known but powerful Excel functions
• Categorize your level of intellectual curiosity as you unearth ways to utilize Excel in manners you may not have previously considered
• Assess your mindset of professional skepticism that helps you explore the edges of Excel’s capabilities

Preparation

None

Notice

This course is provided by a third-party vendor. Please note that login instructions will not be available in the ‘My Upcoming CPE’ section of the NESCPA website. Instead, the login instructions will be sent directly to you via email by ACPEN. Upon completing the course, your hours will be recorded in the ‘My CPE Tracker’ section of the NESCPA website.