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

Course Content

Lesson 1: Getting Started with Microsoft Excel 2016

  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 and Functions

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

Lesson 5: Printing Workbook 

  1. Preview and Print a Workbook
  2. Set Up the Page Layout
  3. Configure Headers and Footers

Lesson 6: Managing Workbooks

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

Appendix A:  Microsoft Office Excel 2016 Exam 77-727
Appendix B:  Microsoft Office Excel 2016 Expert Exams 77-728
Appendix C:  Microsoft Office Excel 2016 Common Keyboard Shortcuts
Appendix D:  Adding Borders and Colors to Worksheets
Appendix E:  Basic Excel Customization 

 

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!