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