Excel 2010-Advanced

About the Class:

This course is for anyone wanting to expand proficiency skills with spreadsheets.  In-class activities will require you to use the latest version of Microsoft Excel to create and edit a spreadsheet document according to specific requirements provided.

What You’ll Learn:

Upon completion of this class, participants will:

  • Add header / footer.
  • Add graphics.
  • Insert hyperlinks.
  • Insert comments.
  • Copy / Move worksheet.
  • Insert / Delete worksheet.
  • Rename worksheet.
  • Track workbook/worksheet changes.
  • Share workbooks.
  • Add password protection.
  • Work with formulas, financial, date/time, 3-D, logical and statistical.
  • Manipulate data with sorting and filtering.
  • Use templates and styles.
  • Use conditional formatting.
  • Saving as a Web page.
  • Customize charts.

What You Need to Know:

  • TECH 101 – Excel Basics or equivalent skills, keyboarding and mouse skills.

Resources

Excel 2010(PC) Excel 2011(Mac)
 Microsoft Office: Descriptions of SmartArt Graphics  Microsoft Office: Add or Remove a Header or Footer
 Microsoft Office: Password Protect Worksheet or Workbook Elements  Microsoft Office: Require a Password to Open or Modify a Workbook
 Microsoft Office: Save a Workbook as a Web Page