Course ID: EXCELINT

Excel Intermediate Productivity Features

About & Customize

Popular Options

  • In-Person
  • Live Webcast

  • Utilize best practices and time-saving business tips for working with data
  • Perform data analysis and reporting in Excel
  • Upon completion of this course, participants will be able to:
  • Control and troubleshoot accuracy of calculations
  • Apply business formatting and structure to worksheets
  • Protect your work from errors and changes

  • Applying and reviewing formula calculations
  • Applying business formatting and design to worksheets
  • Identifying trends in data and finding duplicates using Excel’s conditional formatting features
  • Tracking key performance indicators with new business dashboard graphics
  • Performing quick data analysis using Excel’s Table and Pivot Table features
  • Pivot Table reporting of unique values, codes or categories from data
  • Enhancing Pivot Table results with slicers to filter data
  • Creating dynamic Excel business charts in seconds and incorporate new graphics
  • Exploring interactivity between Excel and Word with linking data
  • Exploring interactivity with linking formulas between Excel files
  • Controlling calculation of external links with user prompt controls
  • Applying multiple worksheet features and 3D functions
  • Incorporating Excel data ranges into Word documents with updating links
  • Applying security settings to Excel sheets and files
Designed For

CPAs and professionals at all levels of an organization using Excel who desire to learn timesaving tips to improve productivity

Field of Study
Computer Software & Applications
Prerequisites

Familiarity with Excel features

Course Producer
Business Learning Institute
Level
Intermediate
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