
Microsoft Excel - Advanced Excel Formulas & Functions
Courses Select
$16
Taxes included
What you will learn
Master 75+ Excel formulas with hands-on demos from a best-selling Microsoft Excel instructor (Excel '07 - Excel 2019)
Whether you're starting from square one or aspiring to become an absolute Excel power user, you've come to the right place.
This course will give you a deep understanding of the advanced Excel 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 Excel formatting rules
-Join datasets from multiple sources with Excel's 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 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
-INDIRECT & HYPERLINK
-Web scraping with WEBSERVICE & FILTERXML
Who this course is for:
-Excel users who have basic skills but want to get really, REALLY good
-Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
-Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
-Excel users looking to build strong analytical thinking and business intelligence skills
-Anyone looking to pursue a career in data analysis or business intelligence