Excel 2010 Fundamentals - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Get started with Microsoft Office Excel 2010
  • Perform calculations 
  • Modify a worksheet
  • Format a worksheet
  • Print workbooks
  • Manage workbooks

Course Content

Lesson 1: Getting Started with Microsoft Office Excel 2010

  1. Navigate the Excel User Interface
  2. Use Excel Commands
  3. Create and Save a Basic Workbook
  4. Enter Cell Data
  5. Use Excel Help

Lesson 2: Performing Calculations 

  1. Create Worksheet Formulas
  2. Insert Functions 
  3. Reuse Formulas

Lesson 3: Modifying a Worksheet

  1. Insert, Delete, and Adjust Cells, Columns, and Rows
  2. Search for and Replace Data
  3. Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet 

  1. Modify Fonts
  2. Add Borders and Colors to Worksheets
  3. Apply Number Formats
  4. Align Cell Contents
  5. Apply Styles and Themes
  6. Apply Basic Conditional Formatting
  7. Create and Use Templates

Lesson 5: Printing Workbooks

  1. Preview and Print a Workbook
  2. Define the Page Layout

Lesson 6: Managing Workbooks

  1. Manage Worksheets
  2. Manage Workbook and Worksheet Views
  3. Manage Workbook Properties

Appendix A: Microsoft Office Excel 2010 Exam 77–882
Appendix B: Microsoft Office Excel 2010 Expert Exam 77–888
Appendix C: Microsoft Excel 2010 Common Keyboard Shortcuts 

 
 If you would like to customize this class please call us at (888) 572-1200

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!