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 …
Steve Scott
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 …
How to Create a Sunburst Chart in Excel (Multi-Level Pie Chart)
Excel’s native Sunburst chart is what many people mean when they refer to a multi-level pie chart. Excel has included it since 2016, so you don’t need to hand-build nested …
How to Make a Bell Curve in Excel
A bell curve (also called a normal distribution curve) shows how values spread out around an average. Most values sit near the middle, and fewer show up as you move …
How to Create a Stacked Waterfall Chart in Excel
A stacked waterfall chart shows how a total moves from a starting value to an ending value, step by step. It also splits each step into the parts that caused …
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 …
SUMIF vs SUMIFS Function in Excel: What’s the Difference?
The SUMIF and SUMIFS functions in Excel add values that meet conditions, such as rental fees collected by a particular branch. SUMIF checks one condition. SUMIFS checks one or more …