Overview

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

After completing this online training course, students will be able to:

  • Getting Started with Excel
  • Creating Workbooks and Using Templates
  • Entering Data
  • Excel Formula Basics
  • Adjusting a Worksheet
  • Formatting and Aligning Data
  • Using Cell Styles and Themes
  • Inserting Objects and Graphics
  • Proofing a Workbook
  • Printing an Excel File
  • Managing Worksheets
  • Navigating and Viewing Excel Files

Students who are new to Excel 365 and would like to learn how to utilize it.

The recommended prerequisite for this course is basic computer Skills.

01. Excel 365 Beginner
02. Getting Started with Excel
03. Creating Workbooks and Using Templates
04. Entering Data
05. Excel Formula Basics
06. Adjusting a Worksheet
07. Formatting and Aligning Data
08. Using Cell Styles and Themes
09. Inserting Objects and Graphics
10. Proofing a Workbook
11. Printing an Excel File
12. Managing Worksheets
13. Navigating and Viewing Excel Files