How to Create an Attendance Tracker in Excel
An attendance tracker in Excel lets you mark who was present, late, absent, sick, or excused each day, then turns those marks into totals and an attendance percentage. Setting up …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to VLOOKUP From Another Sheet in Excel
VLOOKUP from another sheet is what you need when your prices or product details live on one tab and the rows you’re filling in live on another. The lookup works …
How to Count Words in Excel (in a Cell or Range)
If you want to know how many words are in a cell, Excel won’t tell you the way Word does. There’s no word count button and no WORDCOUNT function. What …
How to Create a Dynamic Named Range in Excel
A dynamic named range in Excel is a name that grows with your data, so a formula, drop-down list, or chart that uses it picks up new rows automatically. A …
How to Use Structured References in Excel
Structured references in Excel let a formula use a Table’s name and column headers, like Sales[Amount], instead of cell addresses such as C2:C9. They make formulas easier to read. They …
How to Calculate Simple Interest in Excel
Simple interest is the easy kind of interest to work out in Excel. You multiply the principal by the annual rate and the time, and interest is only ever charged …
How to Create a Timesheet in Excel (Hours Worked, Breaks & Overtime)
A timesheet in Excel looks simple until real shifts show up. There’s a lunch break in the middle, a shift that ends after midnight, and a week that runs past …
How to Calculate a Running Count of Occurrences in Excel
A running count of occurrences numbers each repeat of a value as you go down a list. The first Billing ticket gets 1, the next one gets 2, and so …
How to Calculate Percentage in Excel (Percentage Formula)
Calculating a percentage in Excel always comes down to a division or a multiplication. The hard part is knowing which number goes where. “What share of the total is this?” …
How to Convert a Unix Timestamp to a Date in Excel
When you export data from a database, an API, or a server log, dates often show up as Unix timestamps like 1720096496 instead of something you can read. A Unix …
Data Validation in Excel: How to Add, Use, and Remove It
Data validation in Excel lets you control what someone can type into a cell, so a status column doesn’t end up with “Out”, “out”, and “OUT”. You pick a rule, …
How to Calculate Pass or Fail in Excel (Multiple Subjects)
If a student has to pass every subject, you can’t just look at the average. One low score can hide behind good marks in the others. For example, a student …