Getting Started with Microsoft Excel

This course is free and editable. Yours to re-brand and tailor to your needs!

Getting Started with Microsoft Excel Free

By EdApp
3 Lessons
4.5
(6 reviews)

Microsoft Excel is a spreadsheet tool for storing, organising, and analysing data. From tracking your expenses to preparing an invoice, Microsoft Excel has made it simple to work with various types of information. Help yourself excel with Excel by taking this course!

Getting Started with Microsoft Excel Lessons

Click through the microlessons below to preview this course. Each lesson is designed to deliver engaging and effective learning to your team in only minutes.

  1. The Excel Environment
  2. Creating a Workbook
  3. Basic Excel Functions

Like what you see?

This course is free and completely editable. Update the text, add your own slides or re-brand the entire course — with our no-code authoring tool, the sky’s the limit!

Follow the interactions on each screen or click the arrows to navigate between lesson slides.

Getting Started with Microsoft Excel course excerpts

The Excel Environment

Get to know how to navigate through the Excel interface by taking this lesson.
Getting Started with Microsoft Excel Course - Lesson Excerpt

LESSON 1 THE EXCEL ENVIRONMENT

Disclaimer

HELLO THERE! Welcome to the first part of Getting Started with Microsoft Excel. For Lesson 1: The Excel Environment, we will cover the Excel interface to prepare you for the workbook editing in Lesson 2 and basic computations in Lesson 3. After taking this lesson, you should be able to: enumerate the uses of Excel spreadsheet; differentiate the Excel spreadsheet and the Word table; and identify the key components of the Excel interface. While taking this lesson, we encourage you to use the software on your personal computer to implement what you have learned. --- Are you ready? Tap the button below to get started.

Data Input and Storage

Analysing and Interpreting Data

Reporting and Visualisations

Budgeting and Accounting

Schedules and Calendars

RECALL Which of the following should you click to create a new Excel file? Select an icon below By selecting one of these buttons, you will be able to view the Excel interface. We will discuss the Excel interface next. To start with a clean slate, access the interface by selecting Blank workbook.

RECALL Which of the following should you click to create a new Excel file? Select an icon below By selecting one of these buttons, you will be able to view the Excel interface. We will discuss the Excel interface next. To start with a clean slate, access the interface by selecting Blank workbook.

RECALL Which of the following should you click to create a new Excel file? Select an icon below By selecting one of these buttons, you will be able to view the Excel interface. We will discuss the Excel interface next. To start with a clean slate, access the interface by selecting Blank workbook.

Creating a Workbook

This lesson will walk you through creating and editing worksheets.
Getting Started with Microsoft Excel Course - Lesson Excerpt

LESSON 2 CREATING A WORKBOOK

Disclaimer

WELCOME BACK! You are now on the second part of Getting Started with Microsoft Excel. With your knowledge of the Excel interface from Lesson 1, you are now ready to interact with the workbook here in Lesson 2: Creating a Workbook. After taking this lesson, you should be able to: create and edit a worksheet; sort data values in a worksheet; and save your workbook to a new file. While taking this lesson, we encourage you to use the software on your personal computer to implement what you have learned. --- Are you ready? Tap the button below to get started.

Basic Excel Functions

This lesson is designed to guide you with some basic Excel functions such as random number generator, count, and getting the sum and average.
Getting Started with Microsoft Excel Course - Lesson Excerpt

LESSON 3 BASIC EXCEL FUNCTIONS

Disclaimer

WELCOME BACK! You are now on the last part of Getting Started with Microsoft Excel. You have learned how to create, edit, and input data in a worksheet from Lesson 2. Now, let us perform basic operations in Excel! After taking this lesson, you should be able to: understand how to write an Excel syntax properly; and use the COUNT, SUM, and AVERAGE functions to get information from a given data set. While taking this lesson, we encourage you to use the software on your personal computer to implement what you have learned. --- Are you ready? Tap the button below to get started.

EXCEL FUNCTIONS

EQUAL SIGN The basic syntax of a function starts with an equal sign.

FUNCTION NAME Functions are predefined formulas that perform calculations in your data. Some examples are the SUM, COUNT, and AVERAGE functions.

ARGUMENT The last part of the syntax is one or more arguments, which indicates the information you want to calculate. Arguments must be enclosed in parentheses and can refer to either individual cells or cell ranges. Depending on the syntax required for the function, you can include: One argument: =SUM(A1:A30) Multiple arguments: =SUM(A1:A3, C1:C2)

In the example above, the function would calculate the sum from cells A1 through A10.

RECALL Which of the functions below has the correct syntax?

CHALLENGE Supposed you used the formula =AVERAGE(B2:B7), what would be the expected result?

Getting Started with Microsoft Excel Course Author

EdAppEdApp is an award winning, mobile first microlearning platform with integrated authoring and delivery. EdApp contributes training courses that have been created by the in house instructional design specialists.

Good

It was simple and easy to understand for a beginner.

EdApp is easy to use and free for you and your team. No credit card required.

or book a demo with us today!