Spreadsheet Planet
Time Saving Excel Tips & Tutorials
- Website
- spreadsheetplanet.com · all feeds from this site
- Feed URL
https://spreadsheetplanet.com/feed/
Read it in your FeedListing reader
Or add to: Feedly Inoreader Raw feed
Latest posts
-
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 ... Read more
-
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 ... Read more
-
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 ... Read more
-
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 ... Read more
-
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, ... Read more
-
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 ... Read more
-
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 ... Read more
-
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) ... Read more
-
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 ... Read more
-
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 ... Read more