Excel Functions Guide
55 function guides with examples, explanations, and interactive practice.
Absolute Reference
An absolute reference, such as $A$1 is a reference to a cell that does not change no matter where the formula is pasted.
AVERAGE Function Examples and Practice
Learn how to use the AVERAGE function in Excel with real example formulas and practice exercises.
Change Case of Text to Upper, Lower, & Proper
Learn how to change the case of text in Excel to uppercase, lowercase, and proper case.
CONCAT Function
The CONCAT function in Excel joins separate values together into a single text string. Learn about this formula and practice some exercises.
COUNT Function Examples and Practice
Learn how to use the COUNT function in Excel with real example formulas and practice exercises.
COUNTIF Function
The COUNTIF function in Excel counts the number of cells that meet a certain criteria. Learn about this function and practice some exercises.
COUNTIFS Function
The COUNTIFS function in Excel counts the number of cells that meet multiple criteria. Learn about this function and practice some exercises.
Create a Drop Down List in Excel
Learn how to create a drop down list in Excel for data entry.
Excel Date Functions: TODAY, NOW, DATE, DATEDIF, DAYS, EOMONTH and More
Master Excel date functions: TODAY, NOW, DATE, DATEDIF, DAYS, EOMONTH, EDATE, WEEKDAY, WORKDAY, and TEXT for date formatting with examples.
Endpoint Check
Excel Functions Cheat Sheet: The 2026 Quick Reference Guide
Master the Excel functions cheat sheet: 30 essential formulas with syntax and examples. XLOOKUP, IF, SUMIFS and more, with free interactive practice.
Excel Ninja Skills: The 2026 Professional's Guide
How to Extract the First Word From Text in Excel
Learn how to extract the first word from text in Excel, including examples and a simple formula you can copy and paste!
How to Extract the Last Word From Text in Excel
Learn how to extract the last word from text in Excel, including examples and a simple formula you can copy and paste!
FIND Function
The FIND function in Excel returns a number corresponding to the position of a substring of text within a larger string of text.
Format Painter to Copy Formats
Learn how to use the Format Painter and copy formats from one cell to another.
HLOOKUP Function
The HLOOKUP function in Excel stands for horizontal lookup. The function HLOOKUP searches for a value you specify in the top row of a table and returns a value from the same column.
How can I use excel to automate data analysis tasks? : 2026 Guide
Master How can I use excel to automate data analysis tasks?: syntax, examples, and step-by-step guidance with free interactive practice from LogicExcel.
How Excel Works: 2026 Guide
How excel works: A clear 2026 guide with steps, examples, and expert tips from LogicExcel. Everything you need to know, explained simply with practical exampl
How to Create an Excel Dropdown: 2026 Guide
Excel dropdown: A clear 2026 guide with steps, examples, and expert tips from LogicExcel. Everything you need to know, explained simply with practical example
Excel Exercises: IF Function Examples and Practice Exercises
The IF function in Excel returns one value if a condition is true, and another if the condition is false. Learn about this formula and practice some exercises.
IFS Function Examples and Practice
Learn how to use the IFS function in Excel with real example formulas and practice exercises.
Indeed Excel Assessment Practice
Learn how to ace Indeed's Excel Assessment to increase your chances of finding a job!
INDEX Function Examples and Practice
Learn how to use the INDEX function in Excel with real example formulas and practice exercises.
INDEX MATCH: The Most Powerful Lookup in Excel
Learn INDEX MATCH step by step — the most powerful Excel lookup. Covers left lookup, two-criteria, INDEX MATCH MATCH, and why it beats VLOOKUP.
LARGE and SMALL Function
The LARGE and SMALL functions in Excel help you quickly find the 2nd largest or 3rd smallest numbers in a list. Learn about these functions and practice some exercises.
LEFT Function
The LEFT function in Excel returns a number of the leftmost characters from a larger string of text. Learn and try some Excel Exercises with this function.
LEN Function
The LEN function in Excel returns the length of a string of text. Learn and try some Excel Exercises with this function.
Len, Left, Right, Mid Functions
The LEN, LEFT, RIGHT, and MID functions in Excel let you work with strings of text. Learn and try some Excel Exercises with these functions.
Logical Functions: AND, OR, XOR, NOT
Logical functions in Excel let you add logic to your spreadsheet. Learn about these formulas and try some Excel Exercises.
Excel Logical Operators: Greater Than or Equal, Not Equal, etc.
Logical operators in Excel (<, >, =, <>, <=, >=) compare values. Greater than, greater than or equal, not equal, less than, less than or equal.
Excel Lookup Functions: LOOKUP, INDIRECT, OFFSET Explained
Learn Excel's LOOKUP, INDIRECT, and OFFSET functions with clear examples. Know when to use each versus VLOOKUP or XLOOKUP for dynamic references.
MATCH Function
The MATCH function in Excel provides the position of a cell with specified contents. Learn about this function and practice some exercises.
MID Function
The MID function in Excel returns a section of text from within a larger string of text. Learn and try some Excel Exercises with this function.
MIN and MAX Function
The MIN and MAX function in Excel help you quickly find the minimum and maximum. Learn about these functions and practice some exercises.
MO-200 Excel Exam Practice
Learn how to prepare for and pass Microsoft's MO-200 Excel certification exam.
MO-201 Excel Exam Practice
Learn how to prepare for Microsoft's MO-201 Excel certification exam.
Excel Math Functions: MIN, MAX, ROUND, MOD, ABS, LARGE, SMALL
Learn Excel math functions: MIN, MAX, ROUND, ROUNDUP, ROUNDDOWN, INT, MOD, ABS, LARGE, SMALL, RANK, CEILING, and FLOOR with examples.
SUBSTITUTE Function
The SUBSTITUTE function in Excel replaces a set of characters for a set of new characters within a string of text. Learn about this function and practice some exercises.
SUM Function Examples and Practice
Learn how to use the SUM function in Excel with real example formulas and practice exercises.
SUMIF Function
The SUMIF function in Excel sums the contents of cells that meet a certain criteria. Learn about this function and practice some exercises.
SUMIFS Function
The SUMIFS function in Excel finds the sum of cells that meet multiple criteria. Learn about this function and practice some exercises.
SWITCH Function Examples and Practice
Learn how to use the SWITCH function in Excel with real example formulas and practice exercises.
Excel Text Functions: Complete Guide to LEFT, MID, RIGHT, LEN, TRIM, SUBSTITUTE and More
Master Excel text functions: LEFT, MID, RIGHT, LEN, TRIM, UPPER, LOWER, SUBSTITUTE, REPLACE, FIND, SEARCH, CONCAT, TEXTJOIN, and TEXT with examples.
TEXTJOIN Function
The TEXTJOIN function in Excel joins separate values together separated by a common delimiter. Learn about this formula and practice some exercises.
TODAY Function
The TODAY function in Excel returns the current date. Learn and try some Excel Exercises with this function.
Top 4 Tools to Learn Excel Online Free in 2026
VLOOKUP Function Examples and Practice
Learn how to use the VLOOKUP function in Excel with real example formulas and practice exercises.
VLOOKUP in Excel Step by Step Tutorial: 2026 Guide
Master vlookup in excel step by step tutorial: syntax, examples, and step-by-step guidance with free interactive practice from LogicExcel.
What are the best online courses to learn advanced excel techniques? : 2026 Guide
What are the best online courses to learn advanced excel techniques?: A clear 2026 guide with steps, examples, and expert tips from LogicExcel.
What Excel Is Used For: 2026 Guide
Master what excel is used for: syntax, examples, and step-by-step guidance with free interactive practice from LogicExcel.
What Excel Version Do I Have: 2026 Guide
Master what excel version do i have: syntax, examples, and step-by-step guidance with free interactive practice from LogicExcel.
Where can I find templates for budgeting and financial modeling in excel? : 2026 Guide
Where can I find templates for budgeting and financial modeling in excel?: A clear 2026 guide with steps, examples, and expert tips from LogicExcel.
Wildcard Examples and Practice
Learn how to use the wildcard characters in Excel with real example formulas and practice exercises.
XLOOKUP Function
Learn how to use the XLOOKUP Function in Excel.