| HOT TOPICS: | |
|---|---|
| Shortcuts | Formulas |
| FAQ | Excel Hacks |
| Downloads | Troubleshooting |
| Testimonials | More Courses.. |
Formulas and Functions in excel like:
Basic arithmetic operations
Text functions (e.g. LEN, LOWER, UPPER),
Date and time functions (e.g., TODAY, NOW),
Logical functions (e.g. IF, IFERROR),
Lookup and reference functions (e.g. VLOOKUP, INDEX/MATCH)
Excel VBA Errors: Troubleshooting and Fixing Common VBA Errors Are you tired of dealing with frustrating VBA errors in Excel? Do you find yourself scratching your head, wondering why your VBA code isn’t working correctly?...
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!) Hey there, Excel newbie Are you tired of spending hours analyzing data in Excel? Do you want to learn a powerful tool that can help...
Excel Formula Tutorial: A Step-by-Step Guide to Writing Formulas Are you new to Excel and struggling to write formulas? Do you want to learn how to create powerful formulas that can help you analyze and...
Array Formulas in Excel: Advanced Data Analysis and Manipulation Unlocking the Power of Array Formulas As an Excel user, you’re likely familiar with the basics of formulas and functions, but you may not be aware...
Excel Formula Examples: Real-World Applications and Scenarios Are you tired of learning Excel formulas in a vacuum? Do you want to see how they’re used in real-world scenarios? You’re in luck In this comprehensive guide,...
Excel Formulas: Understanding Absolute and Relative References Are you new to Excel and struggling to understand how formulas work? Do you want to learn how to create powerful formulas that can help you analyze and...
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...
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...
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...
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...
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?...
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...
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...
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.
Here we learn that what is formulas in Excel and how to Create and Editing these formulas for different operations in Excels.
| Beginners: | |
|---|---|
| Introduction | Basic Excel |
| Excel interface | Data entry |
| cells & Rows | More... |
| Intermediate: | |
|---|---|
| Worksheets & Workbooks | Array |
| Ranges & References | Index-Match |
| Built-in Functions | More... |
| Advanced: | |
|---|---|
| Macros | VBA |
| Pivot tables | Data Mining |
| Forecasting & prediction | More... |
| Data Analytics: | |
|---|---|
| Power Query | Charts & graphs |
| Data validation | Conditional formatting |
| Data Visualization | More... |
| Formulas: | |
|---|---|
| V/H/X-Lookup | Index/Match |
| Operators | Date & time |
| IF/IFS/IFERROR | More... |
More
