Looking for some awesome Excel tips and tutorials? You’re at the right place.
Here you’ll find a collection of amazing excel tips that will make you an Excel Ninja and save a lot of time.
All the Excel tips are covered in detail with supporting images and a video (in most of the cases).
If you’re a beginner in Excel, you can start from out Learn Excel section.
You also find tips and tutorials on various Excel topics such as charting, dashboards, and VBA. In addition to the tutorials, you will also find some useful Excel templates that you can download for free.
You will also find Excel formula tips to get common tasks done using the formulas. You can also visit the Excel Functions section to learn about most commonly used Excel functions such as VLOOKUP, INDEX, OFFSET, COUNTIF, IFÂ and so on..
Also check out our Online Excel Training courses on Excel (Basic to Advanced), Dashboard, and VBA.
If you want to find out how spread out a set of numbers is, variance is the measure you’re after. The tricky part is that Excel has more than one variance function, and picking the wrong one gives you the wrong answer. The choice mostly comes down to one question: is your data a sample …
If you want to predict future numbers in Excel, like next month’s sales or next quarter’s demand, you do not have to guess or do the math by hand. Excel can look at your past data, spot the trend, and project it forward for you. In this article, I’ll show you how to forecast in …
If you have a worksheet with a header or footer you no longer want, you may sometimes face an issue deleting them. And this is because headers and footers only show up in Page Layout view and Print Preview, not in the regular Normal view. So they are not really stuck. You just need to …
If you have a long worksheet and want to tidy it up so you can collapse sections out of the way and focus on what matters, grouping rows is exactly what you need. Maybe you tried hiding rows, but then you lose the easy on-off toggle. Grouping fixes that. It puts a little plus and …
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 …
©trumpexcel.com – Free Online Excel Training
