Loading...

Course Description

In this workshop, you will gain a foundational understanding of the basic functionality in Excel 2016. You will begin by navigating the Excel 2016 environment. From there, you will perform the basic tasks associated with creating and saving Excel worksheets and exploring the Help system. You will use formulas and functions to perform calculations in your worksheets, and you will modify worksheets by manipulating cells and data, by searching for and replacing data, and by checking for spelling errors. You will format worksheets and prepare them for printing. You will also begin working with larger workbooks that contain multiple worksheets. You can also use this workshop to prepare for the Microsoft Office Specialist (MOS) certification exams for Microsoft Excel 2016.

Course Outline

1: Getting Started with Microsoft Office Excel 2016 
Topic A: Navigate the Excel User Interface 
Topic B: Use Excel Commands 
Topic C: Create and Save a Basic Workbook 
Topic D: Enter Cell Data 
Topic E: Use Excel Help 
2: Performing Calculations 
Topic A: Create Worksheet Formulas 
Topic B: Insert Functions 
Topic C: Reuse Formulas and Functions 
3: Modifying a Worksheet 
Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows 
Topic B: Search for and Replace Data 
Topic C: Use Proofing and Research Tools 
4: Formatting a Worksheet 
Topic A: Apply Text Formats 
Topic B: Apply Number Formats 
Topic C: Align Cell Contents 
Topic D: Apply Styles and Themes 
Topic E: Apply Basic Conditional Formatting 
Topic F: Create and Use Templates 
5: Printing Workbooks 
Topic A: Preview and Print a Workbook 
Topic B: Set Up the Page Layout 
Topic C: Configure Headers and Footers 
6: Managing Workbooks 
Topic A: Manage Worksheets 
Topic B: Manage Workbook and Worksheet Views 
Topic C: Manage Workbook Properties 
 

Learner Outcomes

Upon completion of this workshop students will know how to:
  • Get started with Excel 2016.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbook contents.
  • Manage large workbooks.

Notes

Materials Required:
Handouts will be provided by the instructor.

Prerequisites

None
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .