Course ID: EXCELADV

Excel Advanced Productivity Features

This fast-paced program covers: range naming, decision-making IF and VLOOKUP functions, advanced Pivot Table reporting, controlling calculation inputs, formula auditing, and time-saving usage of the macro recorder. New features in Excel 2013/2016 will be covered.


LEARNING OBJECTIVES
  • Upon completion of this course, participants will be able to:
  • Use a variety of nested functions and variations for IF testing and Vlookup
  • Suppress the display of error messages with IFERROR
  • Understand how to use custom calculations in the Excel Pivot Table feature
  • Build digital dashboards with data and the Pivot Table
  • Incorporate a variety of multiple worksheet tips including range
    consolidations
  • Understand range naming, formula auditing, data validation, and
    conditional formatting to control results and find patterns in data
  • Automate using the macro recorder for repetitive tasks

MAJOR TOPICS
  • Range naming input values
  • Name Manager dialog box for quick range identification and formulas
  • IF testing, nested function rules, decision making functions and Vlookup
  • Date functions, text functions, and FlashFill
  • Multiple criteria functions of SUMIFS, COUNTIFS, AVERAGEIFS
  • Conditional Formatting to identify data patterns and duplicates with color
  • Suppression of Excel error messages in cells
  • Formula auditing tools to trace formula dependencies across sheets
  • Watch window to track calculations on a sheet
  • Data Validation to control user input
  • Grouping and outlining according to formula structure
  • List design rules and the new Table feature
  • Advanced Pivot Table custom calculations with dates and percentages
  • Pivot Table tips for recalculation and duplicating
  • Pivot Table reporting of multiple consolidated ranges
  • Macro recorder examples for printing, formatting, and data cleanup

DESIGNED FOR
CPAs and Professionals at all levels of an organization who desire to learn advanced automation features within Excel

FIELD OF STUDY
Computer Software & Applications

PREREQUISITES
Strong familiarity with Excel features

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
4.0

LEVEL
Advanced

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