Excel - Microsoft Excel Beginner to Advanced
Excel Course Online: Microsoft Excel From Beginner to Advanced, Ms Excel Formulas & Charts in Excel 2019/2021/Office 365
Updated on Sep, 2023
Language - English
In this special Microsoft Excel - 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, 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
how to select cells, ranges, columns, rows in excel
copy & paste data
what is function
how to sort & filter your data in excel
how to create a simple chart with a few clicks
Then we're going to go through several data visualization techniques which you can use to create Excel charts that will impress your audience.
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:
shortcuts for navigation
shortcuts for data entry
Excel formatting 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!
What will you learn in this course:
- 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)
What are the prerequisites for this course?
- The course was recorded with Microsoft Excel 2019 which is similar to Office 365 Excel version
- Most features work in Excel 2010/2013/2016 or I show you alternative
- no previous Excel knowledge is necessary - you can even be an absolute beginner in Excel
Check out the detailed breakdown of what’s inside the course
- Preview Video 02:53 02:53
- Get the Most Out of This Course 02:45 02:45
- How To Set The English Display Language 02:48 02:48
- Getting Started With Excel 30:22 30:22
Data Visualizations - Out of the Ordinary
Over 100 Keyboard Shortcuts for Fast Productivity
Most Frequently Used Excel Functions With Examples
Understanstand the PivotTable
I love to teach new skills to students.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now