Excel Course 1: Introduction to Spreadsheets
Requirements
Additional Course Information
This foundational training session is ideal for individuals new to Microsoft Excel or those looking to refresh their basic skills. It begins with an introduction to key spreadsheet terminology and a walkthrough of the Excel interface, helping users become comfortable navigating the program. Participants will learn how to perform essential tasks such as data entry, formatting, inserting and deleting rows or columns, and using basic formulas for simple calculations. By the end of the session, learners will have a solid understanding of Excel fundamentals.
Syllabus
Learning Objectives:
- Identify and use appropriate terminology when working with spreadsheets.
- Enter data into cells, and perform basic tasks such as selecting cell ranges, copying and pasting data, and inserting or deleting rows and columns.
- Recognize and describe the key components of the Excel interface.
- Apply correct cell referencing techniques when working with data.
Course Outline:
Welcome and Course Overview- Introduction to spreadsheet goals and structure
- Explanation of course materials and sample files
Reviewing the Excel Interface
- Using the correct terminology
- Knowing where to find the right buttons
Spreadsheet Basics/Terminology
- What is a spreadsheet, a row, a column, a cell, and a range?
- Understanding workbooks vs. worksheets
- Navigating and selecting cells
Data Entry and Formatting
- Inputting text and numbers
- Inserting rows and columns values
- Raw data vs calculations
- Writing basic formulas
- Order of operations
Note: Our course modules work best on the latest version of Google Chrome. If your course is not loading, update your browser and/or check your internet connectivity as a first step.