Course DescriptionIn 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 Outline1: 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 OutcomesUpon 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.
Handouts will be provided by the instructor.