HOT TOPICS:
Shortcuts	Formulas
FAQ	Excel Hacks
Downloads	Troubleshooting
Testimonials	More Courses..

Category: Formulas and Functions

Expert Lookup and Reference Functions

Lookup and Reference Functions in Excel: VLOOKUP, INDEX/MATCH, and HLOOKUP Are you tired of searching for data in your Excel spreadsheets? Do you want to learn how to quickly and easily find the data you...

Powerful Pivot Tables in Excel

Pivot Tables in Excel: A Beginner’s Guide to Data Analysis Are you tired of sifting through rows and rows of data, trying to make sense of it all? Do you want to unlock the secrets...

Powerful Date and Time Functions

Date and Time Functions in Excel: TODAY, NOW, EOMONTH, and WORKDAY Are you tired of manually entering dates and times in your Excel spreadsheets? Do you struggle to calculate dates and times accurately? Well, you’re...

Powerful Conditional Formatting in Excel

Conditional Formatting in Excel: Basic and Advanced Techniques Are you tired of sifting through rows and rows of data, trying to make sense of it all? Do you want to highlight important trends and insights...

Powerful Logical Functions

Logical Functions in Excel: IF, IFERROR, IFBLANK, and IFS Are you tired of dealing with errors and blank cells in your Excel spreadsheets? Do you want to take your Excel skills to the next level?...

Master Formulas and Functions in Excel

Introduction to Formulas and Functions in Excel Welcome to the world of Formulas and Functions in Excel. In this comprehensive guide, we’ll take you on a journey to master the basics of formulas and functions...

XLOOKUP function with 5 Examples

NEW & IMPROVED XLOOKUP (with 5 Examples) Are you tired of using the old VLOOKUP function in Excel? Well, you’re in luck the new and improved XLOOKUP function is here, and it’s a game-changer. In...

Overview of functions in Excel

Here we will learn about Function and its uses. We will also learn types of function and their syntax to write. Also learn function library and how to use it.