Microsoft Excel - Ms Excel from Beginner to Advanced Course (Udemy.com)
Excel Beginner Course: Ms Excel Basics, Formulas & Charts in Excel 2010, 2013, 2016, 2019, 2021 & Microsoft Office 365
Created by: Tamas Benko
Last updated February 2023
What you will learn
- Microsoft Excel - Excel From Beginner to Advanced 5.5-hour course
- Excel basics & advanced features
- Focusing on Data Visualization techniques you can stand out with
- Over 100 Keyboard Shortcuts To Speed Up Your Work
- Most Frequently Used Excel Functions With Examples
- PivotTable Made Easy
- Database Design Principles
- PivotTable Advanced (Using Multiple Tables)
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.4 out of 5higher than 25% of them
- Reviews3,272#83 of 356 by number of reviews
- Length5.6 hoursshorter than 49% of them
- Last updatedFebruary 2023earlier than 57% of them
Course Description
In this special Microsoft Excel - Ms Excel from Beginner to Advanced course you can learn the most important features of Excel focusing on data visualization and productivity. I'm using the version Microsoft Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with Ms Excel 2010, 2013, 2016, 2019, 2021, 2022 versions.
If you're a beginner, in the first section you can learn Excel basics from scratch in 30 minutes.
Topics covered in the 30-min Getting Started With Excel lecture:
quick overview of the user interface
how to save your excel worksheet
drag & drop gesture
excel rows, columns, cells
how to move between cells quickly
excel data entry
excel data types
excel formulas & references
excel operators
how to select cells, ranges, columns, rows in excel
copy & paste data
AutoComplete feature
AutoFill feature
what is function
define Name
how to sort & filter your data in excel
how to create a simple chart with a few clicks
multiple worksheets
zoom function
Then we're going to go through several data visualization techniques which you can use to create Excel charts that will impress your audience.
Projects covered:
highlight max value dynamically on an Excel chart
discover Excel's conditional formatting feature to highlight key data in your table
how to create a map chart that reads well by the viewer
how to use icons in your bar charts to make it exciting
how to create a progress chart in infographic style
I dedicated an entire section to Excel shortcut keys showing you over 100 Excel shortcuts. The more keyboard shortcuts you know the faster you can work in Excel and more productive you can be.
Shortcuts covered in seven categories:
general shortcuts
shortcuts for navigation
shortcuts for data entry
Excel formatting shortcuts
selection shortcuts
shortcuts for formulas
miscellaneous shortcut keys
I created a section for the most frequently used Excel formulas/functions. You will find lots of real-world examples in these topics:
Relative vs Absolute cell references explained
working with date functions
SUM(), SUMIF(), SUMIFS() functions
MIN(), MAX(), AVERAGE(), COUNT() functions
VLOOKUP(), HLOOKUP() functions examples
INDEX(), MATCH(), XLOOKUP() functions to search data
In the last section we're getting into an advanced Excel topic. I explain how one of the most valuable Excel features works, the PivotTable. Many people are afraid to use it, but I'll make it simple for you. We're going to build several reports, and create a PivotChart too. I will also talk about database design principles. We will create a Data Model, and I will show you how to use PivotTable with multiple tables. So, you'll be able to use Excel as a real database.
By taking this course you can really take your Excel skills to way above the average.
Don't worry if you're an absolute beginner. I'll explain everything step by step.
If you're already familiar with Excel, this course is a great refreshing session, and I'm pretty sure I will be able to show you new, interesting things.
Please watch the Intro video to see what you can expect from this course. Enjoy learning!
Instructor Details
- 4.4 Rating
3,272 Reviews
Tamas Benko
When I was a kid I liked to draw, but unfortunately there was no good art teacher around me at that time, so my life took another direction - I graduated as an IT engineer. But in my 30’s my attention turned to art again. Science is a great thing to get to know the world, but art is another wonderful aspect of life. So I started to learn drawing on my own finding the best teachers and resources. Through creation you can make connection to something greater than us as I realized later in the learning process. I've decided to share these skills with people who'd like to learn. I'd like you to believe that you don't need to be born for creating great artworks. Anyone can learn to draw. Have some fun with me, and become a more creative person.
More courses by Tamas Benko
How to Draw Ep.1 - BASIC DRAWING SKILLS & Sketching Course (2023)
4.7 (1,142 Reviews)
Provider: Udemy
Time: 3.5h
$59.99
Portrait Drawing 101 - Pencil Drawing Course for Beginners (2023)
4.3 (668 Reviews)
Provider: Udemy
Time: 5.4h
$74.99
Procreate: Getting Started With Procreate on the iPad (2023)
4.5 (296 Reviews)
Provider: Udemy
Time: 3.2h
$44.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Fani Zolota on 6/8/2022
the course was decent but i felt like i was jumping from the very basic which i knew into excel programming which was not explained enough and some things were going very fast without any details , the instructor was telling us about simple things he was doing like i hit ok or i close the video but on the more difficult things he didnt get into deeper explenation i many times had to stop the video and go back to understand what just happened in the last 5 seconds
By Andre du Plessis on 9/10/2021
Although a seasoned Excel user, I know one thing; nobody will ever know everything about Excel. I make a point of looking at how other people work with the software and there is always something new to learn. This course is full of detail, clearly explained and yes, there is a ton of valuable information for beginners through to advanced users. Thank you Tamas Benko.
By Claudia Longo on 9/2/2021
This was an awesome course! I learned a lot of functions that I had no idea how to use them or why they were even there! I definitely need to practice a lot! But the fact that I can go back and refer to the lecture and review the video anytime I need to gives me confidence! I have been using excel since 15 years and I always had problems and had to avoid them in doing things differently, while I knew that there was an actual way to do so, like to block a formula or creating tables! The best part are the formulas, pivot tables and the charts! just great! Thanks a lot
By Kumaresan R on 7/14/2021
Udemy has lot of best courses and this course is one of them. I am very satisfied with this course and learned lot of things. And the support from the Instructor "Tamas" is amazing, He is always there to clear your doubts. Resources for every lectures helped me to practice everything I learned in this course. Enroll in this course and learn new things and get satisfied.
By Zeeshan Shahid Ansari on 6/26/2021
I am really thankful for this course that helped me a lot from scratch. After completing this course, now I am feeling pretty confident using Excel. The best part of the course are the challenging topics that have been made very simple by the instructor. I am RECOMMENDING this course (with 5 STARS) to everyone who are a college student, fresher or any working professional who wants to start their career in Excel. A Heartfelt Thanks again to the instructor of this course. God Bless You! :-)
By Laura Satin on 5/25/2021
I found the course to be a bit slow in areas but thought that it finished strong with pivot tables. I didn't care for the heat maps section or the amount of time spent on customization of colors and working to get titles perfect inside of a bubble. I was able to immediately begin making practice spreadsheets of revenues and expenses of our firm and use charts to organize the data in different ways.
By ㅤㅤ on 3/26/2021
The course instructor is amazing! Explains ever step and I would highly recommend to those wanting to learn Excel for Beginners. My only caveat has been that I am a Mac user and some of the commands are slightly different. However, that hasn't changed the concept and understanding of the course as a whole. The commands are highly useful and most of these skills are highly sought after. I would recommend that once you watch the videos, go and practice them and practice using your own examples. Rewatch the videos as well.
By Neo Chi Fang on 3/4/2021
Instructor can be more efficient in describing what he wants to do / objective of his actions. Some parts were lengthy and does not require elaboration (changing fill colours in the chart, styles e.g). I lost focus and fast forwarded because instructor keeps talking about changing fill colours. This course is good if u have EXCEL2019 because instructor touches on some functions not available in earlier versions. Instructor also gives interesting tricks to create useful visualising charts that are not covered by other instructors.
By Sarah Maadh Khaleel on 1/24/2021
Frist of all, thanks you a lots for this impressive and comprehensive Excel course. I really appreciated your effort. For person who started Excel from scratch , I enjoyed diving and learned valuable knowledge from A to Z. I usually downloads files from resources and follow you step by step. Highly recommended this course.
By Md Razaul Karim on 9/28/2020
Hello, Dear Sir, nice to meet you. First of all, you are being thanked for making like this video courses. your effort was to be made clear about the tutorials but it was not done properly because your computer screen was not clear. On the other hand, the translation was not accurate with your speech. Best and Regards Md Razaul Karim.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 88 / 100









