How to Add and Customize Data Bars in Excel
Data bars in Excel let you compare numbers at a glance by drawing a bar inside each cell, with longer bars for larger values. You’ll find them under conditional formatting, …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
External Data Connections Have Been Disabled in Excel: How to Fix?
Excel’s yellow “External Data Connections have been disabled” bar tells you it has blocked your workbook’s data connections until you decide the file is safe. You can get this warning …
How to Calculate Autocorrelation in Excel
Autocorrelation in Excel helps you check whether values in a time series are related to earlier values, such as sales in consecutive months. Running CORREL on two shifted ranges gives …
How to Create a Stopwatch in Excel
A stopwatch in Excel lets you time a task or practice run and keep the result alongside your work. Excel has no built-in stopwatch, though. Its NOW function returns the …
Excel Not Saving Formatting: Causes and Fixes
You format an Excel sheet, save it, and reopen it only to find the colors, borders, or number formats gone. Most of the time, the cause is the file type …
How to Create Automatic Rolling Months in Excel
Automatic rolling months in Excel let your budget or forecast move forward without retyping the month headers every month or year. You can link all 12 months to one start …
How to Sum Multiple Matching Rows in Excel
When you need to sum multiple matching rows in Excel, VLOOKUP and XLOOKUP return only the first sale for a repeated name. I’ll use SUMIF for one name, SUMIFS when …
How to Create and Customize a Treemap Chart in Excel
A treemap chart in Excel helps you compare each category’s share of a total and see which items contribute most. It fills the chart with rectangles, called tiles, whose sizes …
How to Create, Use, and Remove XML Maps in Excel
An XML map in Excel lets you bring recurring order, invoice, or system-export files into the same worksheet layout each time. You can edit the imported values and send them …
How to Use COUNTIF with VLOOKUP in Excel
COUNTIF counts matches in Excel, while VLOOKUP returns one value. Together, they can count orders by customer name when the order log stores only customer IDs. You may also want …
How to Sum Every N Rows in Excel
Summing every N rows in Excel lets you pull every third value into one total, or turn monthly sales into separate quarterly totals. A plain SUM over the whole column …
How to Add a Calculated Item to a Pivot Table in Excel
A calculated item adds a new row or column inside an Excel PivotTable field, so you can combine or compare existing items without changing your source data. For example, you …