2024 MSCPA Annual Convention: Details

Advanced Excel: Hidden Secrets and Gems

← Return to The CPE Catalog
Monday, July 22, 2024 @ 8:30am 10:30am
Add to Calendar

Description

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.

Prerequisites

A high level of proficiency with Microsoft Excel.

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

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

Credits

Category Amount
General 2.00