Skip to content
UdemyExcelPaid courseAll LevelsCertificate

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

icon
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

icon
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!

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More courses by Tamas Benko

$59.99

$74.99

$44.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.4

3,272 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 3,272 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100