Mastering Microsoft Excel Formulas and Functions
$0.99
Welcome to ” Master Microsoft Excel Formulas and Functions “, covering 80+ built-in Excel designed functions , a comprehensive online course to elevate your proficiency in one of the world’s most widely used spreadsheet applications. Whether you’re a professional looking to streamline your workflow, a student aiming to enhance your analytical skills, or a freelancer seeking to expand your toolset, this course offers an in-depth exploration of Excel’s powerful formula features.
What you’ll learn
- Master Excel’s Formula Syntax: Gain proficiency in creating and applying a range of Excel formulas.
- Excel in Basic to Advanced Functions: Master basic and advanced functions, including VLOOKUP and INDEX-MATCH.
- Error Detection and Troubleshooting: Acquire skills to identify and fix common errors in Excel formulas.
- Manipulate Text, Date, and Time: Become adept at using Excel’s text, date, and time functions.
- Expertise in Nested Functions: Develop the ability to create complex, nested formulas for advanced analysis.
- Logical Function Application: Master logical functions like IF, AND, OR for dynamic data evaluation.
- Streamline Excel Calculations Using Excel Array Functions like SUMPRODUCT, FILTER, SORT, GROUPBY and more
- How to User ChatGPT and Microsoft Excel together
Course content
1515 sections • 150 lectures • Total duration 8 hours 17 minutes
Excel Formulas and Functions Course Introduction
Introduction to Excel Formulas and Functions
Microsoft Excel Mathematical Functions
Nesting Microsoft Excel Functions
Microsoft Excel Text Functions
Microsoft Excel Date and Time Functions
Microsoft Excel Logical Functions
Microsoft Excel Lookup and Reference Functions
Microsoft Excel Statistical Functions
Microsoft Excel Database Functions
Microsoft Excel Financial Functions
Microsoft Excel Array Formulas
Introduction to Custom Functions with Microsoft Excel VBA
Introduction to Using ChatGPT with Microsoft Excel
Microsoft Excel Formulas and Functions Course Conclusion