100+ Microsoft Excel Formulas & Functions with ChatGPT
$0.99
Ready to take control of Excel and make it work for you? Whether you’re just starting or aiming to become an Excel expert, this course is designed to help you master the formulas and functions that transform Excel from a simple spreadsheet into a powerful tool for data analysis.
We focus on more than just showing you what each formula does. We dive deep into why these formulas are so valuable and how you can apply them in real-life situations. You’ll learn through hands-on examples and practical exercises that bring Excel’s power to life.
What you’ll learn
- Master Excel’s lookup functions to seamlessly combine data from different sources, making your work faster and smarter.
- Transform messy data into insights by learning powerful cleaning and analysis tools that simplify even the most complex datasets.
- Create custom, formula-driven formats that make your data pop, turning dull sheets into dynamic, readable visuals.
- Automate everyday tasks in Excel so you can spend less time on repetitive work and more time on what really matters—no coding required!
Course content
1212 sections • 79 lectures • Total duration 4 hours 6 minutes
Introduction
Fundamentals of Excel Functions and Formulas
Basic Aggregation formulas
Office 365 Functions
Advanced Logical Aggregations with IF, IFS and IFS family of formulas
Basic DATE and TIME Functions
Lookup functions
Advanced TEXT functions
Rounding Functions
Nested formulas
Doing analysis of orders table with Excel functions and formulas + GenAI
Conclusion