Quick Source Learning | Quick Source Learning | Excel 2007 Advanced Course

Excel 2007 Advanced Course

Microsoft Excel

 

"


 

 

E07A

The Quick Source eLearning Series combines three levels of training: Learn It, Try It, and Evaluation. The Learn It section includes high quality video that shows you everything the instructor is teaching. The Try It section allows you to practice what you have learned right in our course. There is no need to switch between the course, and the software that you are learning. The Evaluation section gives you the ability to test your knowledge and receive immediate feedback.


Topics covered in this course:

Workbooks and Worksheets

  • Introduction
  • Hiding or Displaying Workbooks
  • Hiding or Displaying Worksheets
  • Hiding or Displaying Worksheet Tabs
  • Adding a Background to a Worksheet
  • Working with Custom Views
  • Sharing a Workbook
  • Editing a Shared Workbook

Cells, Rows, and Columns

  • Introduction
  • Hiding or Displaying Rows and Columns
  • Moving or Copying Rows and Columns
  • Splitting Cell Contents Across Multiple Cells
  • Formatting Cells
  • Adding Conditional Formatting
  • Creating a New Conditional Formatting Rule
  • Finding Cells with Conditional Formatting
  • Creating Cell Styles
  • Creating a 3-D Reference

Data

  • Introduction
  • Performing a Custom Sort
  • Filtering Data Using Advanced Filter Criteria
  • Importing Data
  • Importing Data from a Web Page
  • Importing a Text File
  • Inserting Symbols and Unicode Characters
  • Creating a Custom Fill Series
  • Copying and Pasting Data
  • Inserting Subtotals in a List
  • Grouping and Outlining Data
  • Inserting a Hyperlink

Formulas

  • Introduction
  • Creating Array Formulas
  • Creating Conditional Formulas
  • Using the Lookup Wizard
  • Creating Lookup Formulas
  • Using Dates as Values
  • Creating Links
  • Tracing Formula Relationships
  • Correcting Formula Errors
  • Customizing How Formulas are Calculated

Illustrations and Charts

  • Introduction
  • Inserting a Picture or Clip Art
  • Inserting a Shape
  • Inserting a SmartArt Graphic
  • Working with Text
  • Grouping Objects
  • Creating a Table
  • Creating a Chart
  • Working with Chart Design Tools
  • Working with Chart Layout Tools
  • Working with Chart Format Tools
  • Adding Trendlines and Error Bars to a Chart

Managing Data

  • Introduction
  • Consolidating Data on Multiple Worksheets
  • Creating a PivotTable Report
  • Using PivotTable Tools
  • Creating a PivotChart Report
  • Using PivotChart Tools
  • Designating Valid Cell Entries
  • Creating a Drop-Down List
  • Creating Data Tables
  • Using Goal Seek
  • Using Solver
  • Creating Scenarios

Revision and Security

  • Introduction
  • Using a Custom Filter
  • Protecting a Worksheet
  • Protecting a Workbook
  • Protecting and Sharing a Workbook
  • Adding a Comment
  • Tracking Changes in Shared Workbooks
  • Merging Workbooks
  • Using the Trust Center

Macros and Customization

  • Introduction
  • Displaying the Developer Tab
  • Recording a Macro
  • Running a Macro
  • Deleting a Macro
  • Changing the Macro Security Level
  • Customizing New Workbook Options
  • Customizing Formula and Error Checking Options
  • Customizing Proofing Options
  • Customizing How Workbooks are Saved
  • Customizing Advanced Excel Options