Course Description
Short Course | 6 hours | 0.6 CEUs | $345
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 Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel: 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 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
*Academic Unit eligibility to be determined by college/university in which you are enrolled in a degree seeking program.