Course ID: EXCELHOT

Excel Hot Topics and Best Practices for CPAs

About & Customize

Popular Options

  • In-Person
  • Live Webcast

  • Use Microsoft Excel features for a variety of calculations
  • Compare and contrast the Excel Pivot Table for analyzing one set of data vs the Multiple Consolidated Ranges feature for analyzing multiple sets of data that are dissimilar in structure
  • Explore Pivot Table analysis in date ranges
  • Use new Conditional Formatting and Sparkline presentation graphics to show patterns and trends in data and build a digital dashboard
  • Incorporate new data visualization reporting features
  • Use the data linking features between Excel and Word that automatically expand and contract the linked picture as the Excel data range expands and contracts
  • Use many of the best Excel productivity tips for accountants

  • *Analyze one set of data with a Pivot Table and multiple sets of data with PowerPivot
    *Incorporate the benefits of the Multiple Consolidated Ranges feature for analyzing multiple sets of spreadsheet data
    *Explore the pros and cons of using each feature
  • Use date grouping within a Pivot Table
  • Filter a Pivot Table using the Report Filter and the new Slicer and Timeline
  • Explore the pros and cons of using each feature
  • Communicate patterns and trends in data visually with interactive color and icon based conditional formatting rules and also the new Sparkline graphic
  • Explore how to choose the best graphic feature for your analysis
  • Explore and compare the use of paste Excel range as picture, paste Excel range as linked picture, paste interactive named Excel range as linked picture, update the link, and fix a broken link
  • Demonstrate the best Excel productivity tips for accountants
  • AutoFill vs FlashFill
  • Convert dates and use text to columns for parsing data
  • Troubleshoot formula errors quickly
  • Automate repetitive tasks with the macro recorder
  • Use new criteria based functions
  • Explore graph types including: pie, bar, sideways bar,100% stacked bars, and waterfall chart
  • Use multiple worksheet tips
  • Protect Excel data from changes
  • Compare two Excel files to determine what has changed
  • Cleanup data with the new Get and Transform Power Query tips and connect to Power BI data
Designed For

Business Leaders, Corporate Finance Teams, CPA Practitioner, CPAs, Financial Professionals needing to stay current with the new features added to and trends in best practices with Microsoft Excel

Field of Study
Computer Software & Applications
Prerequisites

Working knowledge of Microsoft Excel

Course Producer
Business Learning Institute
CPE Credits
4
Level
Update
Available Formats
In-Person, Live Webcast

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org