Complete Microsoft Excel Basics: Beginner to Confident User
Taught by Gary Newport
Master Microsoft Excel from scratch with formulas, functions, charts, lookups, data analysis, and real-world projects
Included with all-access
Get this course and every other Skillademia course with one membership.
Start 7-day free trialthen $59/year (or $14.95/mo) · cancel anytime
See all plans & lifetime →What you'll learn
- Navigate Microsoft Excel confidently
- Understand workbooks, worksheets, rows, columns, and cells
- Format spreadsheets professionally
- Create formulas using relative and absolute references
- Build calculations using essential Excel functions
- Use IF, COUNTIF, SUMIF, SUMIFS, INDEX, MATCH, VLOOKUP, and XLOOKUP
- Work with dates, text, logical functions, and mathematical functions
- Import and export CSV files
- Apply conditional formatting
- Create professional charts and graphs
- Organize and filter data efficiently
- Build practical spreadsheets including budgets and gradebooks
- Use modern Excel 365 functions such as FILTER, SORT, UNIQUE, LET, XMATCH, and SEQUENCE
- Develop confidence working with real-world Excel projects
Included with all-access
Unlock all 64 courses
This course and every other Skillademia course, with one membership.
Start 7-day free trialthen $59/year (or $14.95/mo) · cancel anytime
See all plans & lifetime →30-day money-back guarantee
30-Day Money-Back Guarantee
100% refund, no questions asked.
Lifetime Access
Access your content on any device, at any time.
Friendly Support
Got a question? Ask in the course Q&A and our team is happy to help.
About The Course
Learn Microsoft Excel from the ground up with one comprehensive beginner course.
Whether you're a student, office worker, business owner, freelancer, or simply want to become more productive, Excel is one of the most valuable skills you can learn. From organizing information and performing calculations to creating charts and analyzing data, Excel is used in virtually every industry.
This course is designed specifically for complete beginners and gradually builds your skills through practical lessons and hands-on projects. Instead of memorizing features, you'll learn by creating real spreadsheets and solving realistic problems.
You'll begin by learning how Excel works, becoming comfortable with the interface, worksheets, cells, rows, columns, formatting, and navigation. Once you've mastered the basics, you'll start building formulas, using autofill, understanding relative and absolute references, and protecting your worksheets.
From there, you'll explore Excel's most useful functions, including IF statements, COUNTIF, SUM, AVERAGE, VLOOKUP, XLOOKUP, INDEX, MATCH, FILTER, SORT, and many more. You'll also learn how to work with dates, text, CSV files, web data, conditional formatting, named ranges, and logical functions.
Throughout the course you'll reinforce your knowledge by completing practical projects including times tables, Battleships, gradebooks, budgeting systems, and data modeling exercises. These projects help transform theory into practical Excel skills you can immediately apply in your own work.
You'll also learn how to visualize data using charts and graphs, organize information efficiently, generate sample datasets, and take advantage of many of the powerful new dynamic array functions introduced in Excel 365.
By the end of the course, you'll have a strong understanding of Excel's core tools and functions, allowing you to confidently build spreadsheets, analyze data, automate calculations, and continue into more advanced Excel topics.
Curriculum
20 sections · 14 hours of content
1 Introduction to Excel 3 lessons
- What Is Microsoft Excel
- How Do I Get Microsoft Excel
- How Do I Open Microsoft Excel
2 Getting to Know the Interface 6 lessons
- Cells, Worksheets And Workbooks
- The Ribbon Toolbar
- Selecting Cells And The Name Box
- Altering Rows And Columns
- Borders
- Revision 1 - Times Table Square
3 Using Formulae in Excel 8 lessons
- Exploring Data Types
- Formatting Data
- Creating A Series (Autofill)
- Creating Formulae
- Formulae And Autofill (Relative Addressing)
- Resolving Relative Addressing Issues (Absolute Addressing)
- Formatting Cells
- Revision 2 - Times Table Square
4 Protecting Cells and Worksheets 2 lessons
- Protecting Worksheets
- Restricting Data In Cells
5 Data Formatting and the First Function 5 lessons
- Creating Lists
- Adding And Deleting Rows And Columns
- Conditional Formatting
- Introducing Functions - Mod
- Revision 3 - Times Table Square
6 Basic Functions in Excel 8 lessons
- Introducing Battleships
- The If Function
- The Countif Function
- The Counta Function
- Nested Ifs
- The Sum Function
- Named Ranges
- Revision 4 – Battleships
7 Shapes and Images 5 lessons
- 3d Formulae
- Shapes
- Images
- Revision 5 - Battleships
- Revision 6 - Battleships
8 Importing Data Into Excel 4 lessons
- Using Csv Files
- Exporting Data Into A Csv File
- Issues With Csv Files
- Importing Csv Files Using The Legacy Wizard
9 Averages in Excel 6 lessons
- The Average Function
- The Median Function
- The Mode Function
- The Mode.Sngl Function
- The Mode.Mult Function
- Revision 7 – Gradebook
10 Using Lookups in Excel 2 lessons
- The Vlookup Function
- The Hlookup Function
11 More Functions in Excel 6 lessons
- The Max And Min Functions
- The Rand And Randbetween Functions
- The Index Function
- The Match Function
- Filters
- Revision 8 – Gradebook
12 Functions and Conditions 2 lessons
- The Sumif Function
- The Sumifs Function
13 Working with Dates and Text 2 lessons
- Working With Dates
- Working With Text
14 Simple Graphs and Charts 4 lessons
- Simple Bar Graphs
- Pie Charts
- Scattergraphs
- Scattergraphs 2
15 Handling Text and Importing Www Data 3 lessons
- Manipulating Text
- More Manipulating Text
- Importing Data From The Web
16 Generating Test Data 2 lessons
- Creating Test Data
- Creating Test Data 2
17 Creating a Budgetary System 2 lessons
- Developing A Budget Spreadsheet
- Continuing The Budget Spreadsheet
18 Revision Exercise Astronomical Modelling 4 lessons
- Revision 9 - Astronomical Modelling
- Revision 10 - Astronomical Modelling
- Revision 11 - Astronomical Modelling
- Revision 12 - Astronomical Modelling
19 New Functions in Excel 365 13 lessons
- Unique And Spills
- The Ifs Function
- The Maxifs Function
- The Minifs Function
- The Switch Function
- The Sort Function
- The Xmatch Function
- The Let Function
- The Xlookup Function
- The Filter Function
- The Sortby Function
- The Sequence Function
- Revision 13 - Combining Functions
20 More Basic Features of Excel 8 lessons
- The Randarray Function
- Text To Columns
- Zooms And Sheet Selections
- Logical Functions
- Odds And Evens
- Trigonometry
- Ceilings And Floors
- Reviewing All Our Learning
What students are saying
Real reviews from students taking this course.
“Well out of all those excel online i finally found out the best excel learning video and this course.”
“Very detailed course! This course teaches you so many things about excel.”
“Comprehensive guidance highlighting the essential need to know tools. Great learning platform for people who wants to learn excel but never has gotten any exposure before.”
“So far, it's interesting and the teacher explains it very well. It is what I needed.”
“Great course which really helped to advance my skills in Excel.”
“The Excel course was very well organized and easy to follow. The instructor explained each topic clearly and provided practical examples that made the lessons engaging and easy to understand.”
Save more with a bundle
Get this course in a bundle
This course is included in a bundle - get it plus more courses for one low price.
Free Excel tutorials
Quick, step-by-step how-to guides. A taste of what you'll master in the full course.
Free reference guides
Handy free references to speed up your work while you learn.
Related courses
Keep building momentum with these picks.
Ready to start learning?
Get this course and every other Skillademia course with all-access. Start with a 7-day free trial, then just $59 a year.
Start 7-day free trialComplete Microsoft Excel Basics: Beginner to Confident User
$59/yr · all 64 courses · 7-day free trial