How to Analyze Time-Series Data in Excel
Time-series data records how something changes over time, such as daily website visits, monthly sales, or annual expenses. Looking at the numbers alone can make it hard to tell a …
Steve Scott
Horizontal Scrolling Not Working in Excel: How to Fix It
When horizontal scrolling stops working in Excel, you can get stuck looking at the same columns even though the worksheet extends to the right. The cause depends on what still …
How to Calculate Years of Service in Excel
Calculating years of service in Excel starts with an employee’s hire date and the date you want to measure their service through. First, decide whether you need completed years or …
How to Smooth Data in Excel
Smoothing data in Excel helps you see a pattern when individual values jump up and down. Instead of treating each jump as a change in direction, you calculate a series …
How to Convert Seconds, Minutes, and Decimal Hours to Time in Excel
To convert seconds, minutes, or decimal hours to time in Excel, divide by 86400, 1440, or 24 respectively. Then apply the custom format [h]:mm:ss to display the result as hours, …
How to Highlight Cells That Contain Text from a List in Excel
Conditional formatting in Excel can highlight a cell when its text contains any word from a separate list. The word can appear anywhere in the cell, so a search for …
How to Calculate Pro Rata Amounts in Excel
A pro rata calculation in Excel works out a proportional amount, such as a charge for part of a month or each team’s share of a bill. Multiply the full …
How to Calculate Credit Card Interest in Excel
Calculating credit card interest in Excel helps you estimate a billing cycle’s charge and see how purchases and payments affect it. Multiplying a balance by the annual percentage rate (APR) …
How to Build a SlopeGraph in Excel
A slope graph in Excel compares the same categories at two points in time. Each category gets a line between its earlier and later values, so you can see what …
How to Calculate Area Under a Curve in Excel
Calculating the area under a curve in Excel turns a series of measurements into a total, such as the volume pumped from flow readings. The calculation depends on what you …
How to Calculate Payback Period in Excel
Calculating payback period in Excel tells you how long a project’s net cash inflows take to recover its initial investment. Equal annual inflows make this a division problem. Unequal inflows …
How to Hide Notes in Excel (One Cell or All Notes)
You can hide notes in Excel without deleting them. Hiding a note box usually leaves its red corner indicator visible, and hovering over the cell can display the note again. …