Excel Masterclass Microsoft excel data analytics by real world project

Описание

? Subscribe to my Channel: https://www.youtube.com/channel/UCWuy8qSsYBh0mjZab-7Z4CA


About This Class
Project-based learning is the most effective type of learning

Whether you're learning to advance your analytics skill, or just looking to build an analytics visualization application, we believe working on projects is the most effective way to learn. Instead of being taught theory, you’ll learn by building working excel applications.

Most people feel overwhelmed with excel formulas and functions, but with this course, you’ll make rapid progress on your projects so you always stay engaged while mastering the most frequently used advanced functions in a simple and practical method.

This course will provide you the most advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Most excel formulas and functions are complicated Mathematics and algorithms. This tailored course will breakdown it in a short and simple way so that you can apply it in your everyday professional job.

The real-world project will be presented from start to finish, complex topics are taught in a simple way by an instructor with 16 years of experience in data management and analysis area. The contents have been carefully crafted and clearly organized. The videos are high quality with easy to grasp examples. Most importantly you will master the most used excel formulas by doing the provided project examples. Each formula or function video is accompanied by the project exercise files so that you can do it by yourself at your own pace.

By the end of the course, you'll master the most used Excel formulas and Functions, Data analytics from basic to advanced, Insightful data visualization, and creative dashboard reporting and start writing your own formulas and functions from scratch for any demand you may think of.



Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
Go rogue and design your own formula-based formatting rules
Join data sets from multiple sources in seconds with lookup, index & match functions
Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)
Manipulate dates, times, text, and arrays
Automate tedious and time-consuming analytics tasks using cell formulas and functions in Excel.

You will master a broad range of Excel formulas & functions, including:

Date & Time functions and Categorization
Advanced Text functions
Powerful Statistical Functions
Calculation and Mathematics Functions
Counting and Summing Functions
Lookup/Reference functions
Formula based formatting
Logical and Errors operators
Conditional Formatting