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 …
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 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 …
How to Use Slicers in Excel (Beginner to Advanced Guide)
Slicers in Excel turn a PivotTable or Table filter into a set of buttons. Click East, and the report shows East. Click West, and it switches. That’s easier than opening …
Status Bar in Excel: Where It Is, What It Shows, and How to Customize It
The status bar in Excel is the thin strip at the bottom of the window, and it can total, average, or count any cells you select without a formula. It …
New Excel Functions in Microsoft 365 (With Examples)
Excel has picked up a lot of new functions over the last few years. If you only know XLOOKUP and maybe FILTER, you’re missing some really handy ones. In this …
How to Use Cell Styles in Excel
Cell Styles let you give titles, totals, inputs, warnings, and other worksheet elements consistent formatting without rebuilding that formatting one piece at a time. A style can control the font, …
Fixed Objects Will Move in Excel: How to Fix It
The “Fixed objects will move” warning can interrupt filtering or saving in Excel. It concerns worksheet objects, which can include pictures, buttons, shapes, and older cell notes. The awkward part …
How to Fix the Name Conflict Dialog Box in Excel?
The Name Conflict dialog is blocking your sheet copy, and resolving one conflict brings up another prompt for the next conflicting name. Yes to All ends that loop, but it …