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.
To do sensitivity analysis in Excel, you change the inputs in a model and see how much the result moves. Excel’s What-If Analysis tools do this for many values at once, so you don’t have to retype each number and write down the answer. It’s useful whenever a forecast rests on guesses, like the price …
When Excel stops responding, you can usually get it working again by finding out what’s holding it up. It could be a heavy file, an add-in, or a problem with the Excel installation itself. But before you fix anything, you’ll want to get out of the freeze without losing your work. So I’ll show you …
To see version history in Excel, click the file name at the top of the window and choose Version History. You can then open any older copy of the file, and restore it if that’s the one you want. The catch is that this only works for files saved on OneDrive or SharePoint. So in …
If you have ever wanted one formula to return a whole list of results instead of just a single value, dynamic arrays are exactly what you are looking for. With dynamic arrays, a single formula can return many values that “spill” into the cells around it automatically. No dragging the formula down, no copy-paste. In …
You tried to sort your data, or dragged a formula down a column, and Excel stopped you with this message. The cause is merged cells sitting in the rows you’re working with. Excel can’t move those rows around independently, so it refuses to run at all. Despite what the message says, you don’t fix this …
If you have opened a file and seen Compatibility Mode next to the file name at the top, you may have noticed that some Excel features are greyed out. And this is because the file is saved in the old Excel 97-2003 format. Nothing is broken and your data is safe. In this article, I’ll …
If you have a stacked column or bar chart and you want to show the total on top of each stack, you’ll notice Excel doesn’t give you a direct option for it. The chart can happily label each segment’s value, but the one number people actually look for, the total of the stack, is missing. …
If you want to stop other people from opening your Excel file, you can add a password to it in less than a minute. For example, if you email a salary sheet to your manager, a password makes sure nobody else can open it, even if the email gets forwarded. But Excel has a few …
To fix the #SPILL! error in Excel, you need to find out what’s stopping your formula from filling the cells it needs, and then remove that obstacle. Most of the time, it’s something small sitting in the way. In this article, I’ll show you the common reasons you get this error and how to fix …
©trumpexcel.com – Free Online Excel Training
