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 work with measurement data and there is a need to convert the data from one length measurement unit to another, you can use some inbuilt formulas in excel to do that. For example, you may have a need to convert data in centimeters/millimeters to inches or feet. In this short tutorial, I will …
If you have a list of items or names or numbers, you can use simple formulas in Excel to randomize this list. I often need to use this when I’m creating tutorials where I need a random set of numbers or items. It could also be useful if you’re creating a random team in your …
When working with dates in Excel, sometimes you may want to know what day the date is (whether it’s a Monday or a Tuesday, or any other weekday). This could especially be useful in project planning, where some days could be for a specific task (such as having a project meeting or sending the progress …
If you’re working with large datasets in excel, getting Descriptive Statistics for this data set could be useful. Descriptive Statistic quickly summarizes your data and gives you a few data points that you can use to quickly understand the entire data set. While you can also calculate each of these statistical values individually, using the …
Macros in Excel are a game-changer if you have to deal with repetitive tasks. Macros allow you to automate many time-consuming tasks and also create some functions and functionalities that are not already built-in in Excel. As a part of the security measure, if you receive a file that has a macro, Excel will disable …
Named Ranges can be extremely useful when you’re working with a lot of data and formulas. Named ranges allow you to quickly name a cell or a range of cells so that instead of using the reference, you can use those names in the formulas. And when you get hooked to using named ranged, there …
When working with Excel spreadsheets, copying and pasting data is a frequent task. And many times, you will need to copy and paste an entire column (or multiple columns) in Excel. It could be a copy-paste in the same worksheet, or in any other worksheet or workbook. In this tutorial, I will cover everything that …
When working with Excel spreadsheets, sometimes you may have a need to get the name of the worksheet. While you can always manually enter the sheet name, it won’t update in case the sheet name is changed. So if you want to get the sheet name, so that it automatically updates when the name is …
Working with Excel means working with cells and ranges in the rows and columns in it. And if you work with large datasets, selecting entire rows and columns is quite a common task. Just like with most things in Excel, there is more than one way to select a column or row in Excel. In …
©trumpexcel.com – Free Online Excel Training
