Excel Functions Guide
72 function guides with examples, explanations, and interactive practice.
SQL Practice Exercises with Solutions: A Complete Guide
Master SQL quickly with structured practice exercises with solutions. Improve your skills from beginner to advanced, step by step.
How to Build Dashboards in Excel: A Complete Guide
Discover how to create effective dashboards en excel. This complete guide shows you how to visualize and manage your data effortlessly.
Excel Assessment Test Practice: Your 2026 Prep Guide
Boost your skills with our excel assessment test practice guide. Achieve 80%+ and shine in interviews and certifications!
Best Free Online Excel Sheet Tools for 2026
Discover the best free online Excel sheet tools for 2026. Access, edit, and collaborate on spreadsheets from any device with zero installation.
Best Excel Sample Data for Practice: Free Datasets by Domain
Unlock your Excel potential with the best excel sample data for practice. Discover free datasets across various industries to enhance your skills.
Best Sites to Learn Excel in 2026: Top Picks Compared
Discover the best site to learn Excel in 2026. Compare top platforms like Coursera and Udemy to find the perfect fit for your needs!
Excel Functions Cheat Sheet: Quick Reference for 2026
Unlock Excel's potential with our ultimate excel functions cheat sheet. Master essential formulas for quick, efficient spreadsheet management!
Excel Exercises for Beginners: Build Real Skills Fast
Master essential skills with these hands-on Excel exercises for beginners. Jump in and start building your expertise today!
Studying Excel Online: Your 2026 Complete Skills Guide
Master studying Excel online in 2026 with structured courses, real exercises, and certified credentials. Start building your skills today!
Excel Percentage Formulas: A Practical Step-by-Step Guide
Master formulas de porcentaje en excel with this step-by-step guide. Simplify calculations and boost your efficiency. Start learning today!
Excel Absolute Reference ($A$1): How to Lock a Cell
An Excel absolute reference like $A$1 stays locked when you copy a formula. Learn $A$1 vs A1, when to lock a row or column, and practice it live.
How to Calculate Average in Excel (AVERAGE)
How to calculate average in Excel with the AVERAGE function. Syntax, a worked column example, AVERAGE vs AVERAGEA, and a free interactive practice lesson.
Change Case of Text to Upper, Lower, & Proper
Learn how to change the case of text in Excel to uppercase, lowercase, and proper case.
How to Combine Two Cells in Excel (CONCAT)
How to combine two cells in Excel with CONCAT or &. Join first and last names, add a space or comma, and practice the formula in a live spreadsheet.
Conditional Formatting Based on Another Cell
Format a cell or whole row in Excel based on the value in a different cell. Learn the formula rule, absolute vs relative references, and how to highlight entire rows.
COUNT Function Examples and Practice
Learn how to use the COUNT function in Excel with real example formulas and practice exercises.
Count Unique Values in Excel
Count how many distinct values are in an Excel range. Learn the modern UNIQUE and COUNTA method and the classic SUMPRODUCT/COUNTIF formula for older Excel.
Excel COUNTIF: Count Cells That Meet a Condition
Excel COUNTIF counts cells that match a condition: text, a number, or a wildcard. See the syntax, worked examples, and practice COUNTIF online for free.
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.
DATEDIF Function
The Excel DATEDIF function returns the difference between two dates in years, months, or days. Learn the unit codes, see examples like age and tenure, and avoid its traps.
Excel Ninja Skills: The 2026 Professional's Guide
Become an excel ninja with our 2026 guide. Master advanced skills, save time, and enhance your data analysis for professional success.
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!
Excel FILTER Function: Extract Matching Rows
The Excel FILTER function returns only the rows that meet a condition and spills the result. Syntax, AND/OR examples, and a free interactive FILTER lesson.
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.
OFFSET Function
The Excel OFFSET function returns a cell or range a set number of rows and columns from a starting point. Learn the syntax, dynamic range use, and its performance trade-off.
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.
How to Calculate Standard Deviation in Excel
How to calculate standard deviation in Excel with STDEV.S and STDEV.P. Sample vs population, a worked scores example, and a free interactive practice lesson.
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.
SUBTOTAL Function
The Excel SUBTOTAL function sums, counts, or averages a range while ignoring hidden and filtered rows. Learn the function numbers and why it beats plain SUM on filtered data.
How to Add Up a Column in Excel (SUM)
How to add up a column in Excel with SUM or AutoSum. Add a whole column, skip headers, and practice the SUM formula in a live spreadsheet — no signup.
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.
Excel Time Functions: NOW, TIME, HOUR, MINUTE
Excel time functions: NOW, TIME, HOUR, MINUTE, and SECOND. Build a clock value, split it into parts, and practise the formulas in a live grid.
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
Discover 4 tools to learn excel online free. Choose the best option that fits your skill level and enhance your Excel expertise.
Excel TRIM Function: Remove Extra Spaces
The Excel TRIM function removes extra spaces from text so Lee and Lee with trailing spaces match. Syntax, a cleanup example, and a free interactive TRIM lesson.
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.