Excel Formulas & Functions Basic to Advanced

Name: Excel Formulas & Functions Basic to Advanced
Rating: 4.2 (381 reviews)

Advanced Microsoft Excel Formulas And Functions , Logical, Index, Match, Vlookup, Hlookup and More

Created byClick Learning

Last updated 7/2025

English

English [Auto],

What you'll learn

Understand the basics of formulas, cell references, arithmetic operators, and common functions.
Dive into logical functions (IF, AND, OR) and text functions (CONCATENATE, LEFT, RIGHT) for data manipulation.
Master lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH) to find and retrieve data efficiently.
Explore mathematical and statistical functions for data analysis.
Delve into advanced functions like nested functions, array formulas, and financial functions for complex calculations.
Understand error handling techniques and troubleshooting common formula errors.

Course content

7 sections • 20 lectures • 2h 47m total length

Tabs and Ribbon12:01
Explore how to use and customize Excel's tabs and ribbon, add a new tab with grouped commands, and access tools like auto filter and autosum for your worksheets.
Adding Zero in MS Excel4:11
Learn to add a leading zero in Excel with custom format codes and the Format Cells dialog. Apply the Text function to preserve the zero and ensure consistent serial numbers.
Absolute & Relative REF7:12
Explore how absolute references lock cells with the dollar sign while relative references adjust when copying formulas, enabling accurate discounts and totals.
Mixed REF6:04
Master mixed cell references in Excel by using the dollar sign to fix either the column or the row, enabling flexible formulas that copy correctly when dragged.
Slicers and Timeline8:20
Learn to use slicers and timelines in pivot tables to filter sales data by date and salesperson, and view sums for sales one and sales two by month or year.

Automatic Generate Serial Number3:51
Automate serial numbers in Excel using table formatting, the fill handle, and a simple formula to ensure accuracy and time savings, with options for a leading zero and custom formats.
Convert Function11:58
Explore how to use the Excel convert function to convert between units like centimeters to millimeters, feet to inches, kilograms to grams, and hours to minutes, demonstrating practical examples.
CONVERT FROM NUMBERS TO WORDS5:49
Learn to convert numbers to words in Excel using a custom VBA function, built via the developer tab and Visual Basic, to generate invoices and financial documents.

WORKDAY & WORKDAYINTL FUNCTIONS10:38
Learn to use workday and workdayintl functions in Excel to calculate work dates while excluding weekends and holidays. Explore syntax, arguments, and practical examples with start dates and holidays.
RAND FUNCTION5:07
Generate random numbers with the rand function in Excel, from 0 to 1 and in ranges like 1 to 100, then use round and index or counter functions for simulations.
RANDBETWEEN FUNCTION5:01
Using the randbetween function in Excel, generate random whole numbers within a specified minimum and maximum. Learn to refresh results and paste as a value for simulation and data analysis.
AUTOSUM FUNCTION3:32
Explore the autosum function in Excel, which automatically detects a range and quickly sums a column or row. Use the autosum button or keyboard shortcut to apply the calculation.

INDEX & MATCH FUNCTIONS7:48
Explore how index and match work together to retrieve data from a table using exact lookups. Use a product dropdown and fetch its code and rate with index and match.
VLOOKUP FUNCTION8:41
Explore the vlookup function in Excel to search the first column and return a value from a table array by column index, using exact or approximate matches.
HLOOKUP FUNCTION8:08
Explore the HLOOKUP function to perform horizontal lookups, searching the top row and returning a value from a related row using exact or approximate matches.
XLOOKUP FUNCTION10:52
Explore the XLOOKUP function in Excel, combining lookup, index, and match into one formula, with syntax, exact and wildcard match options, and comparisons to VLOOKUP.

Requirements

No Prior Excel Knowledge is Needed.
Beginners and Experts Will Learn a Lot From The Course.

Description

Excel Formulas & Functions Basic to Advanced

Ready to truly leverage Microsoft Excel's power? The "Excel Formulas & Functions: Basic to Advanced" course is your comprehensive guide to mastering everything from fundamental to advanced Excel formulas and functions.

Whether you're a complete beginner or an intermediate user looking to deepen your understanding, this course is tailored to help you master Excel’s most powerful features—its formulas and functions.

Why Formulas and Functions Are Key

Excel is much more than just a spreadsheet; it's a robust tool for data analysis, manipulation, and visualization. At the core of its capabilities are its powerful formulas and functions. This course is designed for everyone, whether you're a beginner wanting to grasp the basics or an intermediate user looking to elevate your skills.

What You'll Learn

The course covers a wide array of essential topics:

Fundamentals of Excel Formulas: Understand the basics of formulas, cell references, arithmetic operators, and common functions.
Logical and Text Functions: Dive into essential logical functions (like IF, AND, OR) and text functions (such as CONCATENATE, LEFT, RIGHT) for effective data manipulation.
Lookup and Reference Functions: Master crucial lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH) to efficiently find and retrieve data.
Mathematical and Statistical Functions: Explore commonly used mathematical (SUM, AVERAGE, COUNT) and statistical functions for data analysis.
Date and Time Functions: Learn practical date and time functions (TODAY, NOW, DATE, TIME) to manage and manipulate date-related data.
Advanced Functions: Delve into more complex functions, including nested functions, array formulas, and financial functions for intricate calculations.
Error Handling and Troubleshooting: Understand techniques for handling errors and troubleshooting common formula issues.

Why This Course Stands Out

Complete Curriculum: Covers all levels—basic, intermediate, and advanced—making it suitable for all learners
Hands-On Practice: Apply your knowledge through real-world examples, exercises, and guided tutorials
Expert Instruction: Learn from experienced Excel professionals who simplify complex concepts and focus on practical use
Career Boosting Skills: Excel proficiency is a key asset in nearly every industry—this course helps you stand out

Who Should Enroll?

Office professionals looking to become more efficient in their roles
Students and researchers working with data and statistics
Business analysts, accountants, and data managers
Anyone seeking to improve their Excel skills and career opportunities

Become an Excel formulas and functions maestro! Enroll now in "Excel Formulas & Functions: Basic to Advanced" and gain the confidence to handle complex calculations, data analysis, and manipulation.

Don't miss this opportunity to become a proficient Excel user and add immense value to your professional toolkit!

Who this course is for:

Anyone Who Work with Excel for Formulas and Functions.
Anyone Interested in Becoming a Proficient Excel User.
Anyone Curious to Master Excel in Short Span of Time.
Professionals using Excel everyday at work

Excel Formulas & Functions Basic to Advanced

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 38min

Logical Functions1 lecture • 16min

Convert Text and Numbers3 lectures • 22min

Workday, Rand, Rand Between, AutoSum Functions4 lectures • 24min

Transpose and Count Blank Functions2 lectures • 11min

LOOKUP Functions4 lectures • 35min

Create Data Entry Form in Excel1 lecture • 20min

Requirements

Description

Who this course is for: