- Excel Formulas & Functions
- IF Statements
- IFS Statement
- XLOOKUP in Excel
- VLOOKUP in Excel
- HLOOKUP in Excel
- INDEX in Excel
- MATCH in Excel
- INDEX and MATCH in Excel
- OFFSET in Excel
- SUMIFS Formula
- SUMIF Formula
- COUNTIFS Formula
- COUNTIF Formula
- SUMPRODUCT Formula
- Create Pivot Tables
- Insert an Excel Slicer
- Create Sparklines
- Unique Random Number
- Excel Degree Symbol
- Excel Convert Function
- Stock Prices in Excel
- Excel Count Characters
- Excel Drop Down List
- Show Formulas in Excel
- Insert Delta Symbol in Excel
- Insert Excel Checkbox
- Split Cells in Excel
- Find and Remove Duplicates in Excel
- Income Tax Calculator
- Todays Date in Excel
- Match Multiple Text Criteria
- Lock Excel Cells
- List All Sheet Names Formula
- Find a Match in All Sheets
- Count Between Dates
- A Game of Bingo
- Using Indirect to Sum Data
- Partial Cell Match
- Hightlight Odd and Even Numbers
- Rank Based on Condition
- Find Duplicates in List
- Prevent Duplicates Entries in Excel
- Cascading List with Formula
- Lookup Row and Header
- Lookup Left Most Value
- Count Text in Cell
- Filter with Formula
- Sum YTD Data
- Transpose Range to Single Column
- Sum Based on Sheet Name
- Traffic Light Effect in Excel
- World Clock Conversion in Excel
Common and Quirky Excel Problems
The articles in the following segment are non-VBA solutions to common and quirky Excel problems. There are a lot of basics which are left off this list. I have chosen to focus on the things I found interesting. I plan to add to this list of articles as I am continually finding new and interesting problems.
Native Excel
Photo by Andrew James on Unsplash