Microsoft Excel Fundamentals - SCORM

Course Description

This course is taught in online mode and consists of 10 units.

The duration of the course is 40 hours that is distributes between content and collaboration tools. Upon completion, students will receive a certificate of completion.

About this course

In the first block of the course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to acquire the skills necessary to create, edit, format, and print basic Microsoft Excel 365 worksheets.

In the second block, students will learn to work with advanced formulas, lists, and illustrations. Students will also work with graphics and advanced formatting including styles.

Goals

• Create basic spreadsheets with Microsoft Excel 365.
• Perform calculations in an Excel spreadsheet.
• Modify an Excel spreadsheet.
• Modify the appearance of data within a spreadsheet.
• Manage Excel workbooks.
• Print the contents of an Excel spreadsheet.
• Learn to use formulas and functions.
• Create and modify charts.
• Convert, sort, filter and manage lists.
• Insert and modify illustrations in a spreadsheet.
• Learning to work with tables.
• Learn how to use conditional formatting and styles.

Course contents

Unit 1: Excel

1. Desktop vs. Web versions
2. What version do you have?
3. Permanent updates

Unit 2: Files

1. New
2. Save and Save As
3. Saving formats
4. Open files and recent list
5. Sharing and co-authorship
6. Publish a workbook in Power Bi
7. Explorer view

Unit 3: Formats

1. Source format
2. Lineups format
3. Borders and shading
4. Number format
5. Row and column formats

Unit 4: Working with sheets and books

1. Moving and copying sheets
2. Insert sheets
3. Hide and show sheets
4. Delete leaves
5. Eyelash color
6. Select multiple sheets
7. Reference a cell from another workbook
8. View multiple sheets at once

Unit 5: Copy and paste

1. Copy and paste
2. Special glue options
3. Operations in gluing
4. Copy format
5. Office Clipboard

Unit 6: Printing

1. Page Setup
2. Headers and footers
3. Excel Views

Unit 7: Data protection

1. File level protection
2. Book level protection
3. Leaf level protection

Unit 8 Formulas

1. What are rank names?
2. Formula audit
3. Errors
4. Calculation options

Unit 9: Insert

1. Insert object
2. Links
3. Add-ons
4. Images
5. Insert 3D models
6. Screenshots
7. SmartArts
8. Shapes

Unit 10: Other options

1. Quotes and information
2. New comments
3. Quick fill
4. Quick navigation
5. Custom number formats
6. Custom date formats
7. Customize toolbar
8. Freeze panes and split windows
9. Automate tasks
10. Leaf view

Prerequisites

No previous knowledge is required to take this course.