Course ID: EXCELINT

Excel Intermediate Productivity Features

Improve your personal productivity in Excel by learning quicker techniques to get your work done. The focus of this fast-paced course is on important business productivity features in Excel including managing data, business formatting, troubleshooting worksheet errors, and using complex functions.


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

MAJOR TOPICS
  • 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

CPE CREDITS
4.0

LEVEL
Intermediate

This course is currently available for registration

DateHost OrgCPEFormat
05/16/18 Marriott International, Inc 4.0 Group Live --

This course is available for your group as:

Group Live
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org