Class Outline

This one-day, instructor-led course builds on the foundational skills covered in our Level 1 course providing a better understanding of advanced features and shortcuts to organize and analyze complex data using Microsoft® Excel. By the end of this course, you will be able to confidently manage more advanced workbooks, customize Excel, use named ranges in functions and utilize data analysis features with appealing. You will learn how to create Excel tables, sort data, filter data, and structured references. The class also gives a brief introduction to PivotTables and PivotCharts. You will be well on your way of becoming a data pro after this highly sought-after course.

The training covers these topics:

Customizing Excel

  • Adding Buttons to the Quick Access Toolbar
  • Customizing the Quick Access Toolbar
  • Customizing the Ribbon

Managing Worksheets

  • Formatting Worksheet Tabs
  • Coloring Sheet Tabs
  • Inserting and Deleting Worksheets
  • Moving and Copying Worksheets
  • Hiding and Unhiding a Worksheet
  • Inserting Hyperlinks

Named Ranges

  • Naming a Cell Range
  • Naming Multiple Cell Ranges
  • Editing Named Ranges
  • Functions on Multiple Ranges

Creating Excel Tables

  • Creating a Table and Using Styles
  • Filtering Tables
  • Sorting Tables
  • Inserting and Deleting Rows/Columns in Tables

Conditional Formatting

  • Conditional Formatting
  • Modifying Conditional Formatting
  • Customizing Data Bars

Graphics in Excel

  • Adding Shapes in Excel Files
  • Adding SmartArt

Creating and Modifying Charts

  • Creating a Column Chart
  • Creating a Line Chart
  • Creating a Pie Chart
  • Recommended Carts
  • Working with Chart Layouts
  • Working with Chart Elements
  • Adding Sparklines

Creating PivotTables and Pivot Charts

  • Creating a PivotTable
  • Pivoting Data in a PivotTable
  • Creating a Pivot Chart
  • Changing the Look of a Pivot Chart