Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you want to find out how reliable your sample average is, you need the standard error, and Excel does not give you a single button for it. But nothing to worry about. It is easy to get once you know which functions to combine, and in this article I will show you a few …
If you have created a table in Excel, you may have noticed that it picks up a generic name like Table1 or Table2 on its own. That name tells you nothing about what is inside, and it makes your formulas harder to read later. The good news is that renaming a table takes only a …
If you have data split across two columns, like first names in one and last names in another, you may want to pull them together into a single column. And the tricky part is usually getting the spacing right so the names don’t end up squished together. But nothing to worry about. It’s a quick …
If you have a sample of data and you want to estimate the average for the whole group it came from, a single average number doesn’t tell the full story. You also want to know how much that average might be off. That’s what a confidence interval gives you. It’s a range around your sample …
If you have a few rows hidden in your worksheet and you want them back, Excel makes it quick. Most of the time it takes a couple of clicks. But sometimes you click around, try the obvious things, and the rows still won’t show up. That usually means something else is going on, like an …
If you have been working with Excel files for a while, you have likely seen both .xls and .xlsx file extensions and wondered what the difference is. And this is because Excel switched its default file format back in 2007, so older files still hang around with the .xls extension, while everything new uses .xlsx. …
If you’ve ever opened a CSV file in Excel and watched the formatting disappear, leading zeros vanish, or dates flip into something weird, you’re probably wondering whether you should even be using CSV in the first place. The short answer is that CSV and XLSX are very different formats built for very different jobs. In …
A growing annuity is a series of payments where the amount goes up by the same percentage every period. Something like a pension that rises with inflation each year, a stock dividend that keeps getting raised, or a lease with a fixed annual rent hike. Excel doesn’t have a built-in function for this (the way …
If you have a cell with text that’s longer than the cell width, Excel lets that text spill over into the next column when that column is empty. Google Sheets has a built-in Clip option that cuts off the extra text right at the cell border. Unfortunately, Excel does not have a built-in Clip option. …
©trumpexcel.com – Free Online Excel Training
