Free ebooks
Our free ebooks might help too
If you are looking for a longer read, our free ebooks cover formulas, beginner skills, intermediate techniques, and lookup functions — read online with no sign-up.
Browse free ebooksSearch everything Excel
Find topics, subtopics, functions, courses, articles, video resources, and directory links from one practical search page.
Showing 36 of 1912 results
Automation, Macros & VBA
Automate repetitive Excel work when formulas are not enough.
Charts & Visualization
Make numbers understandable at a glance.
Dashboards & Reporting
Build reports people can scan, trust, and reuse.
Data Analysis
Ask better questions of your data and test the answers.
Data Cleaning
Fix messy data before it breaks formulas, pivots, and reports.
Excel Basics
Start here if Excel still feels like a maze of rows, columns, and menus.
Formulas & Functions
Build formulas that answer real questions instead of fighting with syntax.
Pivot Tables
Summarize thousands of rows without writing a formula.
Power Query
Automate the cleanup and reshaping work you keep repeating.
ABS()
Returns the absolute value of a number — the number without its sign.
ADDRESS()
Builds a cell reference as text from a row and column number.
AND()
Returns TRUE only if every argument is true.
AREAS()
Returns the number of separate ranges (areas) contained in a reference.
AVERAGE()
Calculates the arithmetic mean of a set of numbers.
AVERAGEIF()
Averages the cells in a range that meet a single condition.
CEILING()
Rounds a number up to the nearest multiple of a specified significance.
CHAR()
Returns the character that corresponds to a given character code.
CHOOSE()
Returns a value from a list based on an index number.
CLEAN()
Strips the 32 non-printable control characters that often arrive with imported or pasted text.
CODE()
Returns the numeric character code for the first character of a text string.
COLUMN()
Returns the column number of a reference, or the current column when used without one.
CONCAT()
Joins text from multiple cells or strings together, with no delimiter.
CONCATENATE()
Joins two or more text strings into a single string, with no separator added automatically.
COUNT()
Counts how many cells or arguments contain numbers.
COUNTA()
Counts the number of non-empty cells in a range.
COUNTBLANK()
Counts the number of empty cells in a range.
COUNTIF()
Counts the cells in a range that meet a single condition.
COUNTIFS()
Counts cells that meet multiple conditions at once.
DATE()
Builds a date from separate year, month, and day numbers.
DATEDIF()
Calculates the difference between two dates expressed in complete years, months, or days.
DATEVALUE()
Converts a date stored as text into a true Excel date serial number.
DAY()
Returns the day of the month from a date as a number between 1 and 31.
DAYS()
Returns the number of days between two dates.
DOLLAR()
Rounds a number and converts it to text formatted as currency.
DROP()
Removes a specified number of rows or columns from the start or end of an array.
EDATE()
Returns the date a specified number of months before or after a start date.
Sources we reference — not partners
26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
- Chandoo (opens in a new tab)
ExcelJet (opens in a new tab)- MrExcel (opens in a new tab)
- Contextures (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)- Simon Sez IT (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)- Edureka (opens in a new tab)
Course platforms
