Microsoft Excel 2010: Intermediate

This instructor-led course builds on the skills and concepts taught in Excel 2010: Basic. Course covers how to use multiple worksheets and workbooks efficiently, and will work with more advanced formatting options including styles, themes, and backgrounds. Course will also cover how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Will also be taught to save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts. 

Margaret Saunders

msaunders 214x160Margaret received an Associate Degree from Howard College and a BBA from Texas Tech University.  She worked part-time throughout college and full-time as secretary to the Chief Accountant of the City of Lubbock for one year.  She then taught  business classes at Estacado High School in Lubbock and at Sam Houston High School in Arlington.  While living in California, she taught business classes at Heald Business College and then at Odessa College upon returning to Texas.  She got her Master's Degree from UTPB in Counseling. She finished her teaching career at Robert E. Lee High School in Midland--retiring from there in 2004.  She began teaching Microsoft Office classes for the Continuing Ed and Workforce Training Departments at Midland College in the Fall of 2004. In addition to teaching at Midland College, she also works part-time as a Data Specialist at the ATC.

  • Unit 1: Using multiple worksheets and workbooks
    • Topic A: Using multiple workbooks
    • Topic B: Linking worksheets with 3-D formulas
    • Topic C: Linking workbooks
    • Topic D: Managing workbooks
  • Unit 2: Advanced formatting
    • Topic A: Using special number formats
    • Topic B: Using functions to format text
    • Topic C: Working with styles
    • Topic D: Working with themes
    • Topic E: Other advanced formatting
  • Unit 3: Outlining and subtotals
    • Topic A: Outlining and consolidating data
    • Topic B: Creating subtotals
  • Unit 4: Cell and range names
    • Topic A: Creating and using names
    • Topic B: Managing names
  • Unit 5: Tables
    • Topic A: Sorting and filtering data
    • Topic B: Advanced filtering
    • Topic C: Working with tables
  • Unit 6: Web and sharing features
    • Topic A: Saving workbooks as Web pages
    • Topic B: Using hyperlinks
    • Topic C: Sharing workbooks
  • Unit 7: Advanced charting
    • Topic A: Chart formatting options
    • Topic B: Combination charts
    • Topic C: Graphical elements
  • Unit 8: Documenting and auditing
    • Topic A: Auditing features
    • Topic B: Comments in cells and workbooks
    • Topic C: Protection
    • Topic D: Workgroup collaboration
  • Unit 9: Templates and settings
    • Topic A: Changing application settings
    • Topic B: Using built-in templates
    • Topic C: Creating and managing templates
  • Unit 10: PivotTables and PivotCharts 
    • Topic A: Working with PivotTables
    • Topic B: Rearranging PivotTables
    • Topic C: Formatting PivotTables
    • Topic D: Using PivotCharts
XE03132Q Dec 3 - 5 8:00 am - 12:00 pm
Tue,Thu  $149.00
($154.00 out-of-state)
8.0 Hours