Course Information
Course Overview
Start your spreadsheet journey with this Excel 2021 training course for beginners!
Microsoft has released its latest stand-alone Excel version, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.
If you are an absolute beginner who has never used Excel before, this course can give you a great foundation. Maybe you have some very basic Excel skills and want to improve your proficiency, or you are using an older version of Excel and want to check out what’s new. Well, this course can help you get the ball rolling.
This is an 11-hour course, with 100 bite-sized video lessons and exercises. You will also get course demo files and exercise files to download so you can follow along with the lessons and practice what you’ve learned at the end of each section.
In this course, you can learn how to:
Become familiar with what’s new in Excel 2021
Navigate the Excel 2021 interface
Utilize useful keyboard shortcuts to increase productivity
Create your first Excel spreadsheet
Use basic and intermediate Excel formulas and functions
Effectively apply formatting to cells and use conditional formatting
Use Excel lists and master sorting and filtering
Work efficiently by using the cut, copy, and paste options
Link to other worksheets and workbooks
Analyze data using charts
Insert pictures in a spreadsheet
Work with views, zooms, and freezing panes
Set page layout and print options
Protect and share workbooks
Save your workbook in different file formats
This course includes:
11 hours of video tutorials
100 individual video lectures
Course and Exercise Files to follow along
Certificate of completion
Here's what our students are saying...
★★★★★ "It was very thorough. As a beginner, I had a lot to learn and it was very beneficial." -Karen Bruton
★★★★★ "I love everything about the Microsoft Excel 2021/365 for Absolute Beginners course. Definitely a great refresher for those who don't use Excel as much as they want." -Kristen Smith
★★★★★ "Very good beginning Course." -Marcello Dioguardi
Course Content
- 10 section(s)
- 110 lecture(s)
- Section 1 Introduction
- Section 2 Getting Started in Excel 2021
- Section 3 Creating You First Excel Spreadsheet
- Section 4 Introduction to Excel Formulas and Functions
- Section 5 Using Named Ranges
- Section 6 Formatting Numbers and Cells
- Section 7 Formatting Worksheets
- Section 8 Working with Excel Lists
- Section 9 Moving and Linking to Data
- Section 10 An Introduction to Intermediate Formulas
What You’ll Learn
- Become familiar with what’s new in Excel 2021
- Navigate the Excel 2021 interface
- Utilize useful keyboard shortcuts to increase productivity
- Create your first Excel spreadsheet
- Use basic and intermediate Excel formulas and functions
- Effectively apply formatting to cells and use conditional formatting
- Use Excel lists and master sorting and filtering
- Work efficiently by using the cut, copy, and paste options
- Link to other worksheets and workbooks
- Analyze data using charts
- Insert pictures in a spreadsheet
- Work with views, zooms, and freezing panes
- Set page layout and print options
- Protect and share workbooks
- Save your workbook in different file formats
Skills covered in this course
Reviews
-
MManodjkumar Boedhoe
yes I have learn a lot
-
LLesleyan Laing
Ofcourse it was a good expierence cause a learn much more about excel. I have not seeing this coming how much I can do with excel.
-
JJeff Matthews
I am taking the excel class to improve my skills and help me with my current role at work.
-
MMo Mojadedi
It was a well-presented crash course.