Excel 2013 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 2013
  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbooks 
  • Manage workbooks

Course Content

Lesson 1: Getting Started with Microsoft Excel 2013

  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. Add Number Formats
  4. Align Cell Contents
  5. Apply Styles and Themes
  6. Apply Basic Conditional Formatting
  7. Create and Use Templates

Lesson 5: Printing Workbook 

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

Lesson 6: Managing Workbooks

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

Appendix A:  Microsoft Office Excel 2013 Exam 77-420
Appendix B:  Microsoft Office Excel 2013 Expert Exams 77-427 and 77-428
Appendix C:  Microsoft Office Excel 2013 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!