Deletion tools
- Delete cells by condition in Excel
- Delete multiple phrases from text in Excel
- Delete words in Excel
- How to remove formulas from Excel cells
- Remove characters from cells in Excel
- How to delete text up to a certain character in Excel
- Remove extra spaces from cells (trim column) in Excel
- Remove first N characters (from left) in Excel cells
- Remove last N characters (from right) in Excel
- Remove Latin characters from text in Excel
- Remove numbers from text in Excel cells
- Remove Punctuation in Excel — Keep Only Letters and Numbers
- Remove unnecessary columns and rows by condition
Finding tools
- Find phrases in Excel
- Find specific cells in Excel
- Find specific characters in Excel
- Find words in Excel
- How to create a table of contents in Excel
- Techniques and instruments to find duplicate values in Excel
Data extraction tools in Excel
- Count characters inside cells
- Count words in Excel cells
- Extract characters by condition in Excel
- Extract phrases from text in Excel
- Extract words from text in Excel
- How to count certain cells in Excel
- Statistical metrics in Excel
Change & replace tools
- Change Characters in Excel
- Change multiple cells at once in Excel
- Change words in Excel
- How to find and replace multiple values in Excel in bulk
- Math functions and procedures in Excel
- Transformation of ranges
Joining and splitting data tools for Excel
- Bulk edit hyperlinks in Excel
- Combine all columns into one in Excel
- Combine all sheets into one in Excel
- Combining data in Excel
- How to merge CSV files into one
- Merge open workbooks into one in Excel
SEM & SEO tools
- API integrations of !SEMTools
- Excel word combinations generator
- Extract URL from hyperlinks in Excel
- Google search suggestions – get thousands of them to Excel
- Import data from large CSV and TXT files into Excel
- N-gram analysis in Excel
- Open all links in Excel at once
- Parsing Title, H1, Description in Excel
- QR code generator in Excel
- Search cell contents in Google from Excel
- Slug generator in Excel: SEO-friendly URLs
- Working with AI in Excel
MS Excel functions glossary
- ABS
- AND
- BIN2DEC
- CHAR
- CODE
- CONCATENATE
- CONVERT
- COUNTA
- COUNTIF
- DATE
- DATEDIF
- DATEVALUE
- DAY
- DEC2BIN
- DEC2HEX
- DELTA
- EDATE
- EOMONTH
- EXACT
- FIND
- GESTEP
- HEX2DEC
- HOUR
- HYPERLINK
- IF
- IFERROR
- ISERR
- ISNA
- LEFT
- LEN
- LOWER
- MID
- MINUTE
- MONTH
- NETWORKDAYS
- NOT
- NOW
- OR
- PI
- PROPER
- REPLACE
- REPT
- RIGHT
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEARCH
- SECOND
- SEQUENCE
- SHEET, SHEETS
- Statistical functions in Excel
- SUBSTITUTE
- SUMIFS
- SUMPRODUCT
- TEXT
- TIME
- TIMEVALUE
- TODAY
- TRIM
- UNICHAR
- UPPER
- VALUE
- VLOOKUP
- WEEKDAY
- WEEKNUM, ISOWEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
Excel for beginners: questions and answers
- Array formulas in Excel
- Count cells with numbers in Excel
- Count characters in a range of cells in Excel
- Excel hotkeys (keyboard shortcuts)
- Find the position of the first number in a cell
- How many sheets are in an Excel workbook
- How to count the days in a month in Excel
- How to create a hyperlink in Excel: 10 ways
- How to create the alphabet in Excel
- How to find, replace and remove asterisks in Excel
- How to switch between sheets in Excel
- Personal Macro Workbook (PERSONAL.XLSB) in Excel
- Search from the end of a string in Excel
- Special characters in Excel