Microsoft Excel - Overview
6 modules, 27 lessons, 10 quizzes
1h 00min video duration
Learning Outcomes
- Describe the difference between a worksheet and a workbook
- Differentiate between the ribbon, the quick access toolbar & the status bar
- Define different data types within Microsoft Excel
- Perform data manipulation techniques through copying and pasting data
- Create your first workbook with meaningful data
Course Content
Course Introduction
Set expectations for the course & provide an overview of topics covered.
Learning Outcomes
Cover all learning outcomes for the course and how they’ll be achieved.
Exercise File
Download the master Excel file used throughout the course.
The Excel Interface
Look at the 5 main aspects of the Excel front-end interface.
The Quick Access Toolbar
Learn what it is and how to customize it.
The Ribbon
Understand the difference between tabs and tab groups.
The Formula Bar
Learn about the name box, the formula bar buttons and the cell contents section.
The Work Surface
Understand the grid system, made up of rows and columns.
The Status Bar
Learn about Excel calculation states, different visual settings & auto-calculate.
Creating a Workbook
Create your first workbook from scratch.
Saving a Workbook
Learn the difference between using Save and Save As.
Opening a Workbook
Learn about the different options available to open files.
Worksheet vs. Workbook
Understand the difference between a worksheet and a workbook.
Adding & Deleting Worksheets
Learn how to add new worksheets to your workbook or delete worksheets.
Copying & Moving Worksheets
Learn how to make copies of your worksheets or move worksheets.
Renaming Worksheets
Understand why you should rename worksheets.
Selecting Cells in Excel
Learn how to select individual or multiple cells in Excel.
Selecting Rows & Columns
Quickly select data in your worksheet to be able to copy and/or format it.
Navigation Tips
Understand how to navigate in Excel and how to not get lost in the application.
Data Types
Learn about the 6 types of data in Excel.
Entering Data
Understand how you can enter data into Excel and how Excel processes data.
Editing Data
Edit existing data that you’ve already entered into Excel.
Removing Data
Learn different methods of removing data from cells.
Copying, Cutting & Pasting Data
Understand the difference between copying & cutting data and learn how to paste the data.
Overview Project
Understand the project requirements and download the project file.
Overview Project Solution
View the solution to the project, step-by-step.
Closing Comments
Course conclusion and final thoughts.
Includes
- 1 hour of on-demand video
- 1-on-1 instructor support
- Mobile learning supported
- Frequently updated content
- Learn at your own pace
- Unlimited tests & quizzes
- Certificate of completion
Overview
Are you new to Excel? Just getting started? This online course is designed to introduce you to all of the fundamental aspects of Microsoft Excel without diving deep into any technical details.
This course will lay the ground-work for the Beginner, Intermediate and Advanced courses offered on My Excel Academy so that you are able to follow the terminology used. This course will ensure every user has the same baseline knowledge of Microsoft Excel.
In the 6 modules included in this course, you will learn about the Excel application, the Excel interface, the difference between a worksheet and a workbook, how to enter & manipulate date and much more.
This course was recorded using Microsoft 365 and is compliant with Excel 2010, 2013, 2016, 2019 and Microsoft 365.
Once enrolled, you will gain access to one-on-one support during your Microsoft Excel learning journey. You will also gain access to instructional videos on how to navigate the learning management software, to maximize your experience.
Prerequisites
- No prior knowledge of Microsoft Excel
- Students will need a computer & Microsoft Excel to complete assigned exercises
Summary
MODULES
6
LESSONS
27
VIDEO DURATION
1h 00min
ESTIMATED STUDY TIME
2h 30min
CERTIFICATE
Yes
SKILL LEVEL
Beginner
Instructor
Kyle Stott
Microsoft Excel Consultant
Kyle has worked professionally with Microsoft Excel for almost a decade and has been consulting on best practices in Microsoft Excel for several years.
Reviews
My experience with My Excel Academy was excellent! The instructor was knowledgeable, engaging and provided plenty of hands-on practice. The course was perfect for beginners as it clearly outlined the workspace as well as some basic features that excel has to offer. I highly recommend this course for anyone looking to improve their excel skills or to begin their journey of learning excel.
Really enjoyed this course! Packed full of useful insights. Even though I consider myself somewhat experience with Excel, I still took away new learnings.
I really appreciate the refresher of key basics. I use Excel daily and learned new tools, lingo and strategies. It’s tempting to skip past these foundational elements to tackle the sticky and more complex problems. With these basics in hand I’ll have a much easier time navigating the system and bringing efficiency to my work! Time to customize my Quick Access Toolbar!
Microsoft Excel – Overview
30-Day Money-Back Guarantee
This course includes:
- 1 hour of on-demand video
- 1-on-1 instructor support
- Mobile learning supported
- Frequently updated content
- Learn at your own pace
- Unlimited tests & quizzes
- Certificate of completion
Training multiple people?
