Microsoft Excel ā€“ Advanced Excel Formulas & Functions

Join SuperDataScience

Start Your Free Trial Today >>

It's time to show Excel who's boss. Whether you're starting from square one or aspiring to become an absolute Excel badass, you've come to the right place.


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

Featured
Standard Subscription - Monthly

$35

/ Month
14-day free trial ā€¢ then $35 USD monthly

Accelerate your Career and boost your Earning Potential with our Expert Instructors & Community! What Youā€™ll Unlock: - šŸŽ“ 40+ Courses (over 200 hours!) - šŸš€ 17 Specialized Career Paths - šŸ“ Quizzes and Practice Activities - šŸ“œ Certificates for Courses & Career Paths - šŸ† Prizes for Learning - šŸ§Ŗ Weekly Live Labs (plus recordings!) - šŸŽÆ Monthly Missions to practice even more - šŸ’¼ Monthly Career Booster Events - šŸ’¬ Full access to the SDS Community - āš” Monthly Speed Networking - šŸ„ Monthly Resume Clinics - šŸ‘„ Group Mentorship Program "In just a few months of learning at SDS, I landed a Data Analyst job!" ā€” Sanaz Afshar, California

Pro Subscription - Monthly

$157

/ Month

Accelerate your Career and boost your Earning Potential with our Expert Instructors & Community! What Youā€™ll Unlock: - šŸŽ“ 40+ Courses (over 200 hours!) - šŸš€ 17 Specialized Career Paths - šŸ“ Quizzes and Practice Activities - šŸ“œ Certificates for Courses & Career Paths - šŸ† Prizes for Learning - šŸ§Ŗ Weekly Live Labs (plus recordings!) - šŸŽÆ Monthly Missions to practice even more - šŸ’¼ Monthly Career Booster Events - šŸ’¬ Full access to the SDS Community - āš” Monthly Speed Networking - šŸ„ Monthly Resume Clinics - šŸ‘„ Group Mentorship Program Plus, Pro Plan perks just for you: - šŸŒŸ A Personalized Career Path built around your goals - šŸ§‘ā€šŸ« 1-on-1 Mentoring Sessions every month - āœļø Personalized Resume Reviews "In just a few months of learning at SDS, I landed a Data Analyst job!" ā€” Sanaz Afshar, California

Course content

12 sectionsā€¢96 lessonsā€¢6 hr 2 min