Quick Source Learning | Quick Source Learning | Excel 2010 Advanced Course

Excel 2010 Advanced Course

Microsoft Excel

 

"


 

E10A

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

  • Hiding or Displaying Workbooks
  • Hiding or Displaying Worksheets
  • Hiding or Displaying Worksheet Tabs
  • Adding a Background to a Worksheet
  • Customizing How Workbooks are Saved
  • Sharing a Workbook
  • Editing a Shared Workbook

Cells, Rows, and Columns

  • Splitting Cell Contents Across Multiple Cells
  • Adding Conditional Formatting
  • Clearing Conditional Formatting
  • Creating a New Conditional Formatting Rule
  • Managing Conditional Formatting Rules
  • Finding Cells with Conditional Formatting
  • Creating Cell Styles

Data

  • Performing a Custom Sort
  • Filtering Data Using Advanced Filter Criteria
  • Importing Data
  • Importing a Text File
  • Importing Data from a Web Page
  • Creating a Custom Fill Series
  • Inserting Subtotals in a List
  • Grouping and Outlining Data

Formulas

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

Illustrations and Charts

  • 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 Layout Tools
  • Working with Chart Format Tools
  • Adding Trendlines and Error Bars to a Chart

Managing Data

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

Revision and Security

  • 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

  • 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 Advanced Excel Options