Course 50546A: Learn Microsoft Office Excel 2010 Step by Step, Level 3

Duration   :  1 day

Analyzing Alternative Data Sets

  • Defining an Alternative Data Set
  • Defining Multiple Alternative Data Sets
  • Varying Your Data to Get a Desired Result by Using Goal Seek
  • Finding Optimal Solutions by Using Solver
  • Analyzing Data by Using Descriptive Statistics
  • Key Points

Creating Dynamic Worksheets by Using PivotTables

  • Analyzing Data Dynamically by Using PivotTables
  • Filtering, Showing, and Hiding PivotTable Data
  • Editing PivotTables
  • Formatting PivotTables
  • Creating PivotTables from External Data
  • Key Points

Creating Charts and Graphics

  • Creating Charts
  • Customizing the Appearance of Charts
  • Finding Trends in Your Data
  • Summarizing Your Data by Using Sparklines
  • Creating Dynamic Charts by Using PivotCharts
  • Creating Diagrams by Using SmartArt
  • Creating Shapes and Mathematical Equations
  • Key Points

Automating Repetitive Tasks by Using Macros

  • Enabling and Examining Macros
  • Macro Security in Excel 2010
  • Examining Macros
  • Creating and Modifying Macros
  • Running Macros When a Button Is Clicked
  • Running Macros When a Workbook Is Opened
  • Key Points

Working with Other Microsoft Office Programs

  • Including Office Documents in Workbooks
  • Storing Workbooks as Parts of Other Office Documents
  • Creating Hyperlinks
  • Pasting Charts into Other Documents
  • Key Points

Collaborating with Colleagues

  • Sharing Workbooks
  • Sidebar: Saving a Workbook for Secure Electronic Distribution
  • Managing Comments
  • Tracking and Managing Colleagues’ Changes
  • Protecting Workbooks and Worksheets
  • Sidebar: Finalizing a Workbook
  • Authenticating Workbooks
  • Saving Workbooks for the Web
  • Key Points