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