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