Education

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!

Get to know how to navigate through the Excel interface by taking this lesson.

Disclaimer


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.


HELLO THERE!


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


The Excel Environment

This lesson will walk you through creating and editing worksheets.

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.


WELCOME BACK!


Creating a Workbook

This lesson is designed to guide you with some basic Excel functions such as random number generator, count, and getting the sum and average.

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.


New

free course

Getting Started with Microsoft Excel

Getting Started with Microsoft Excel Lessons

Course overview

The full course includes

Explore more

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