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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Highlights

The major topics covered in this class include:

• Awareness of advanced functions
• Creative methods for data manipulation
• Using intellectual curiosity and professional skepticism to develop a problem-solving mentality
• 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
• Enhance creativity in your approach to developing Excel models

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

After attending this presentation you will be able to...

• 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 CPA Crossings. Upon completing the course, your hours will be recorded in the ‘My CPE Tracker’ section of the NESCPA website.