Introduction to Microsoft Excel
Overview
Learn the necessary skills and discover the best practices required to create, edit, format, and print basic Microsoft Excel worksheets. Our instructor-led online classes are conducted in the 2016 version of the software. Your instructor will point out the minor differences with earlier versions, where they exist. For our custom instructor-led online and onsite classes, we use the version of the software you use in your office. No prior product knowledge needed.
Course length: 3 days, Delivery: Online or in-person.
Call us at (475) 328-2227 with questions.
Course Objectives
-
Create basic worksheets using Microsoft Excel 2016.
-
Perform calculations in an Excel worksheet.
-
Modify an Excel worksheet.
-
Modify the appearance of data within a worksheet.
-
Manage Excel workbooks.
-
Print the content of an Excel worksheet.
-
Learn how to use handy features new in 2016.
Create and manage worksheets and workbooks
-
Create worksheets and workbooks
-
Format worksheets and workbooks
-
Customize options for worksheets and workbooks
-
Customize views for worksheets and workbooks
-
Modify Document Properties
Manage data cells and ranges
-
Insert data in cells and ranges
-
Manage data by using AutoFill
-
Move data within a workbook
Create Excel tables
-
Create and manage tables
-
Manage table styles and options
Perform operations with formulas and functions
-
Define named ranges
-
Navigate in worksheets and workbooks
-
Summarize data by using functions
-
Perform conditional operations by using functions
-
Format and modify text by using functions
-
Create a simple array formula
Present worksheet data
-
Format cells and ranges
-
Define Styles
-
Apply conditional formatting and filtering