Cancellation Policy
Cancellation Policy
Cancellation Policy
Cancellation Policy
FREE Course Guide Download
Microsoft Excel Beginner
Course Overview
FREE Course Guide Download
Overview
​
Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks.
Target Student
This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.
Prerequisites
​
Basic Windows, keyboarding and mouse skills.
Duration
​
1 day
​
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