Browsing Category
Microsoft Excel
48 posts
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.
How to Create a NESTED IF Function in Excel
I remember the exact spreadsheet where I first needed a nested IF. I was building a grading sheet…
How to Create a DATA VALIDATION in Excel
I learned the importance of data validation the hard way — after collecting a form response sheet where…
How to Create a FIND and REPLACE in Excel
I once inherited a spreadsheet with over 3,000 rows where someone had typed “N/A,” “n/a,” “NA,” and “-”…
How to Create a CONCATENATE Function in Excel
I remember the first time I needed to merge first names and last names from two separate columns…
How to Create a CHART Function in Excel
I still remember presenting a table of raw sales numbers to a room full of stakeholders and watching…
How to Create a AVERAGE Function in Excel
If you work with numbers in Excel even occasionally, you’ll eventually need to find the average of a…
How to Create a COUNTIF Function in Excel
There was a point in my early Excel days when I would manually scroll through hundreds of rows…
How to Create a SUMIF Function in Excel
I’ll admit that before I learned SUMIF, I used to filter data manually and then add up the…
How to Create a TIME Function in Excel
Time calculations in Excel confused me for a long time. I would type “9:30” into a cell expecting…
How to Create a DATE Function in Excel
Dates in Excel used to trip me up constantly. I’d import data from a system with dates split…