Quick Source Learning | Quick Source Learning | Excel 2013 Advanced Course

Excel 2013 Advanced Course

excel 2013

 

"


 

E13A

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
  • Customizing How Workbooks are Saved
  • Sharing a Workbook
  • Editing a Shared Workbook

Cells, Rows, and Columns

  • Introduction
  • 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

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

Formulas

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

Managing Data

  • Introduction
  • 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

Revision and Security

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

Macros

  • Introduction
  • Displaying the Developer Tab
  • Recording a Macro
  • Running a Macro
  • Deleting a Macro
  • Changing the Macro Security Level

Customization

  • Introduction
  • Customizing New Workbook Options
  • Customizing Formula and Error Checking Options
  • Customizing Proofing Options
  • Customizing Advanced Excel Options