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?” …
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 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 …
Excel Automatic Update of Links Has Been Disabled: How to Fix?
Excel shows the yellow “Automatic update of links has been disabled” bar when a workbook pulls information from another file and Excel pauses that connection for safety. Until you allow …
How to Fix the “Cannot Insert Object” Error in Excel
Excel’s “Cannot insert object” error can appear when you embed a file or add an ActiveX control. The fix depends on which object you’re inserting. On current Microsoft 365 builds, …