Course content

Course contents: Core

  • The Basics • Getting Started • Signing In • Creating a New Workbook • Parts of a Workbook • Saving a Workbook • Opening a Workbook • Review Questions
  • Your First Workbook • Selecting Data • Entering and Deleting Data • Using Undo and Redo • Using Cut, Copy, and Paste • Review Questions
  • Working with Data • Inserting Rows and Columns • Merging and Splitting Cells • Moving Cells • Using Paste Special • Using Find and Replace • Hiding and Unhiding Cells • Review Questions
  • Using Basic Excel Tools • Understanding Cell References and Formulas • Using Basic Formulas • Using Basic Functions • Using Advanced Functions • Using Spell Check • Using Sort and Filter • Review Questions
  • Using Timesaving Tools • Using AutoFill • Using Flash Fill • Using AutoSum • Using AutoComplete • Using AutoCalculate • Review Questions
  • Formatting Text • Changing the Font Face, Size, and Color • Applying Text Effects • Applying Borders and Fill • Using the Font Tab of the Format Cells Dialog • Clearing Formatting • Review Questions
  • Formatting Data • Wrapping Text • Changing the Size of Rows and Columns • Adjusting Cell Alignment • Changing Text Direction • Changing Number Format • Review Questions
  • Formatting the Workbook • Using Cell Styles • Formatting Data as a Table • Changing the Theme • Inserting Page Breaks • Adding a Background • Review Questions
  • Inserting Art and Objects • Inserting SmartArt • Inserting Text Boxes • Inserting Pictures • Inserting Equations • Drawing Shapes • Review Questions
  • Charting Data • Creating Sparklines • Inserting Charts • Inserting PivotTables • Inserting PivotCharts • Using Slicers • Creating Timelines • Review Questions
  • Viewing, Printing, and Sharing Your Workbook • Using Views • Saving a Workbook as PDF or XPS • Printing a Workbook • E-Mailing a Workbook • Sharing Your Workbook on SkyDrive • Review Questions
  • Customizing the Interface • Changing Ribbon Display Options • Customizing the Quick Access Toolbar • Hiding and Showing Ribbon Tabs • Creating Custom Ribbon Tabs • Resetting Interface Changes • Review Questions

Course contents: Advanced

  • Advanced Formula Tasks • Understanding Relative and Absolute Cell References • Using Multiple Cell References • Using 3D References • Using Array Formulas • Review Questions
  • Working with Named Ranges • Understanding Named Ranges • Defining Named Ranges • Editing Named Ranges • Deleting Named Ranges • Using Named Ranges in Formulas • Review Questions
  • Using Advanced Functions • Using the PMT Function • Using the FV Function • Using VLOOKUP and HLOOKUP Functions • Using IF, AND, OR Functions • Review Questions
  • Resolving Formula Errors • Tracing Formula Precedents and Dependents • Showing Formulas • Evaluating Formulas • Setting Error Checking Options • Using Error Option Buttons • Running an Error Check • Review Questions
  • Managing Data • Consolidating Information • Removing Duplicates • Configuring Data Validation • Transposing Data • Converting Text to Columns • Review Questions
  • Outlining and Grouping Data • Outlining Data • Showing and Hiding Outline Details • Grouping Data • Creating Subtotals • Removing Outlining and Grouping • Review Questions
  • Working with Scenarios • Creating Scenarios • Loading Scenarios • Merging Scenarios • Editing Scenarios • Creating a Scenario Summary Report • Deleting Scenarios • Review Questions
  • Using Solver • Setting up the Worksheet • Running Solver • Generating Reports and Scenarios with Solver • Modifying Constraints • Setting Solver Options • Review Questions
  • Analyzing Data • Enabling the Analysis ToolPak • Using Data Analysis Tools • Using Goal Seek • Using Data Tables • Review Questions
  • Advanced PivotTable Features • Creating a Basic PivotTable • Creating a Basic PivotChart • Using the PivotTable Fields Pane • Adding Calculated Fields • Sorting Pivoted Data • Filtering Pivoted Data • Review Questions
  • Using PowerPivot • Enabling PowerPivot • Importing Access Data • Importing Excel Data • Integrating Data with Relationships • Creating a PivotTable with PowerPivot Data • Review Questions
  • Using Macros • Recording a Macro • Writing a Macro using the Visual Basic Editor • Editing a Macro • Running a Macro • Review Questions

Course contents: Expert

  • Using Conditional Formatting — Applying Conditional Formatting — Applying Multiple Rule Sets — Creating Custom Rule Sets — Viewing and Managing Rules — Clearing Custom Rules — Review Questions
  • Working with Slicers — Inserting and Using a Slicer — Renaming the Slicer — Changing Slicer Settings — Formatting a Slicer — Clearing the Slicer — Review Questions
  • Using Power View, Part One — Enabling Power View — Creating a Power View — Adding and Removing Fields — Arranging Fields — Filtering Data — Sorting Data — Review Questions
  • Using Power View, Part Two — Refreshing Data — Choosing a Visualization — Changing Tile Display — Setting Display Options — Review Questions
  • Using the Inquire Add-In — Installing Inquire — Generating a Workbook Analysis Report — Viewing Workbook and Worksheet Relationships — Viewing Cell Relationships — Comparing Two Workbooks — Review Questions
  • Working with Tables — What is a Table? — Creating Tables — Resizing the Table — Choosing a Table Style — Clearing the Table — Review Questions
  • Working with Records and Fields — What are Records and Fields? — Adding Fields by Inserting Columns — Adding Records by Inserting Rows — Deleting Records or Fields — Review Questions
  • Using Excel as a Database — Filtering with Wildcard Characters — Validating Your Data — Data Validation Using Lists — Data Validation Using Formulas — Using Database Functions — Review Questions
  • Using Custom AutoFill Lists — Creating a Custom AutoFill List — Using a Custom AutoFill List — Modifying a Custom AutoFill List — Deleting a Custom AutoFill List — Review Questions
  • Using Comments — Inserting Comments — Editing Comments — Navigating Through Comments — Deleting Comments — Review Questions
  • Tracking Changes — Tracking Changes — Reviewing Changes — Setting Options for Tracking Changes — Stopping Tracking Changes — Review Questions
  • Linking, Consolidating, and Combining Data — Linking Workbooks — Consolidating Workbooks — Consolidating Worksheets — Pivoting Consolidated Data — Review Questions