Microsoft Excel 2010: Intermediate

Pre-Requisites: Basic Microsoft Excel ® 2010 skills.

5-stars

Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

This intermediate course teaches spreadsheet users about additional features available in Microsoft® Office Excel® 2010. Key topics include naming ranges, protecting worksheets, linking between worksheets, and charting.

This course is intended for students learning Microsoft Excel® 2010 Intermediate skills.

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: Lists and tables

  • Topic A: Examining lists
  • Topic B: Sorting and filtering lists
  • Topic C: Advanced filtering
  • Topic D: Working with tables

Unit 6: Web and Internet features

  • Topic A: Saving workbooks as Web pages
  • Topic B: Using hyperlinks
  • Topic C: Distributing workbooks

Unit 7: Advanced charting

  • Topic A: Chart formatting options
  • Topic B: Combination charts
  • Topic C: Graphic 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: Application settings
  • Topic B: Built-in templates
  • Topic C: Creating and managing templates

Course Number : MOUS-7-0201

Duration : 8 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder