Quick Source Learning | Quick Source Learning | Excel 2003 Advanced Course

Excel 2003 Advanced Course

Microsoft Excel

 


"


 

 

E03A

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
  • Creating a Custom View
  • Displaying and Printing a Custom View
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Displaying or Hiding Scroll Bars or the Status Bar
  • Creating Custom Headers and Footers

Rows, Columns, and Cells

  • Hiding or Displaying Rows or Columns
  • Moving Rows or Columns
  • Using Row and Column Labels in Formulas
  • Creating a 3-D Reference
  • Formatting Cells
  • Merging Cells
  • Adding Conditional Formatting
  • Finding Cells with Conditional Formatting
  • Creating Styles

Data

  • Importing Data
  • Importing Data from a Web Page
  • Importing a Text File
  • Inserting Symbols and Unicode Characters
  • Creating a Custom Fill Series
  • Using a Data Entry Form to Edit a List
  • Copying and Pasting Data
  • Grouping and Outlining Data

Formulas

  • Working with Formulas
  • Creating Array Formulas
  • Creating Conditional Formulas
  • Creating Lookup Formulas
  • Using Dates as Values
  • Creating Links
  • Auditing Formulas
  • Correcting Formula Errors
  • Customizing How Formulas are Calculated

Managing Data

  • Consolidating Data on Multiple Worksheets
  • Creating PivotTable Reports
  • Creating PivotChart Reports
  • Formatting PivotTable Reports
  • Formatting PivotChart Reports
  • Designating Valid Cell Entries
  • Creating Data Tables
  • Working with Data Tables
  • Using Goal Seek
  • Using Solver
  • Creating Scenarios

Pictures, Diagrams, and Charts

  • Inserting a Shape
  • Inserting Pictures or Clip Art
  • Working with Text
  • Grouping Objects
  • Creating a Diagram or Organization Chart
  • Creating a Chart
  • Formatting a Chart
  • Editing Chart Data
  • Adding Trendlines or Error Bars to Charts

Revision and Security

  • Filtering a Range
  • Adding a Comment
  • Merging Workbooks
  • Tracking Changes in Shared Workbooks
  • Protecting a Worksheet
  • Protecting a Workbook
  • Adding Digital Signatures

Macros and Customization

  • Changing the Macro Security Level
  • Creating a Macro
  • Assigning a Macro to a Button or Menu Item
  • Running a Macro
  • Deleting a Macro
  • Customizing Toolbars and Menus
  • Creating a Custom Toolbar
  • Customizing Excel Options