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
• 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.