This course is free and editable. Yours to re-brand and tailor to your needs!
Getting Started with Microsoft Excel Free
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.
- The Excel Environment
- Creating a Workbook
- 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.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.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.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.some guidance was confusing but otherwise good
NA
The first lesson was great. I enjoyed the way the lesson was presented, in a slide format, with the a good summary at the end. This makes learning easier.
Great work
EdApp is easy to use and free for you and your team. No credit card required.
or book a demo with us today!
