Microsoft Excel - Advanced Excel Formulas & Functions

Microsoft Excel - Advanced Excel Formulas & Functions

Courses Select



Ce que vous apprendrez

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