Udemy - Microsoft Excel - Excel From Beginner to Advanced [2021]

Microsoft Excel - Excel From Beginner to Advanced Course: Excel Basics, Examples, Tips & Tricks in Excel 2019/Office 365
What you'll 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)
Requirements
The course was recorded with Microsoft Excel 2019 which is similar to Office 365 Excel versionMost features work in Excel 2010/2013/2016 or I show you alternative
Description
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 versions.
If you're a beginner, in the first section you can learn Excel basics 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
https://www.udemy.com/course/microsoft-excel-2013-from-beginner-to-advanced-and-beyond/