SP901 - Introduction to Excel

Course Description

Use Excel to create spreadsheets for accounting, budgeting, expense tracking, and other applications. Learn to set up and format worksheets and enter labels, values, and formulas. Discover how to select data, restrict data entry, adjust column widths, and move around the worksheet. Other topics include using simple statistical functions, editing and deleting data, moving and copying cell contents, understanding absolute and relative references, setting up worksheet pages, and printing.

In this course, you will learn to: 

• Learn how to navigate through Excel, including using the Ribbon to find the commands you need 

• Discover how to use the Backstage View to manage files 

• Understand the purpose of a spreadsheet and common spreadsheet terminology 

• Learn to select cells and enter text and numbers 

• Edit and delete contents of your spreadsheets 

• Create calculations using arithmetic operators and Excel’s built-in functions 

• Move and copy cell contents 

• Understand absolute, relative, and mixed references 

• Use effective formatting 

• Set up and print a spreadsheet 

Applies Towards the Following Certificates

• Business Applications Certificate : Foundational Skills Using Excel
• Excel Certificate : Foundational Skills Using Excel 
• Foundational Skills Using Excel : Required Courses