Microsoft Excel - Advanced Excel Formulas & Functions

Microsoft Excel - Advanced Excel Formulas & Functions

Microsoft Excel - Advanced Excel Formulas & Functions
English | Size: 1.20 GB
Category: CBTs

This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.

By the end of the course you'll be writing robust, elegant formulas and functions from scratch, allowing you to:

Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
Go rogue and design your own formula-based formatting rules
Join datasets 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 (no VBA required!)

We'll dive into a broad range of Excel formulas & functions, including:

Lookup/Reference functions
Statistical functions
Formula based formatting
Date & Time functions
Logical operators
Array formulas
Text functions
Powerful analytics tools and formulas like INDIRECT, HYPERLINK, WEBSERVICE & FILTERXML

Buy Long-term Premium Accounts To Support Me & Max Speed


If any links die or problem unrar, send request to

Related News

Comments (0)


You can support by buying a Linkifier account. %70 of your payment goes to

linkifier allows you to download as a premium user at fast speeds from all major filehosters!
Latest Mini Game Releases
Recommended Filehosts