Loading...

Course Description

Microsoft Excel is the leading spreadsheet program in the world. It is commonly used for both numerical and data analysis including calculations, graphs, statistical and database analysis. Excel 2019 Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel 2019: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. 

Course Outline

Chapter 1: Fundamentals

   Module A: Getting around

   Module B: Workbook basics

Chapter 2: Creating worksheets

   Module A: Entering data

   Module B: Formulas

   Module C: Functions

   Module D: Moving and copying data

   Module E: Reference types

Chapter 3: Formatting

   Module A: Text formatting

   Module B: Number formatting

   Module C: Alignment

   Module D: Borders and highlighting

   Module E: Styles and themes

Chapter 4: Manipulating data

   Module A: Data entry shortcuts

   Module B: Paste options

   Module C: Inserting, deleting, and hiding

Chapter 5: Charts

   Module A: Creating charts

   Module B: Chart types and elements

Chapter 6: Output

   Module A: Managing worksheet windows

   Module B: Printing worksheets

   Module C: Sharing workbooks

Chapter 7: Settings and templates

   Module A: Workbook options and properties

   Module B: Templates

Additional Information

This course is delivered in Excel 2019 but is relevant for Excel 2010 and Excel 2016 users also.

Prerequisites

There are no prerequisites for this course but students should be comfortable with Windows and standard Windows applications.

Duration

6 Hours | 1 Day or 2 Nights

Applies Towards the Following Certificates

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 or call 314-977-3226 so that we may promptly notify you when enrollment opens.

Required fields are indicated by .
*Academic Unit eligibility to be determined by college/university in which you are enrolled in a degree seeking program.