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.
Once you’re done using formulas to get the desired results, you may want to remove the formulas and keep the data you got as a result of these formulas. This is often done to remove formulas you no longer need and save processing power (as formulas recalculate every time you make a change in the …
Sometimes, when you’re organizing data, creating charts, or analyzing information, you may need to swap two cells (i.e., change the position of two cells). While there is no built-in feature in Excel to swap cells, this can easily be done using a simple mouse drag-and-drop technique or the old and traditional Cut-Paste method. In this …
Most of the time, the data in Excel is arranged in columns, and it is more common to split the text in a cell into multiple columns rather than rows. But in some cases, you may want to split the text into multiple rows in Excel. For example, if you have multiple names in a …
Scientific notation is a format that allows us to write very large or very small numbers in a consistent decimal format. This can be useful when you are working with large numbers and you do not want them to take up a lot of space in your Excel worksheet. In such a case, you can …
Most of the time, when working with Excel, you need to restructure your data before you can start any kind of analysis. One common task many Excel users have to do is convert columns into rows in their existing dataset. This is usually the case when you get your data set from a database or …
It’s a common data analysis task to count the number of cells with a value that is less than a specific threshold. For example, if you have sales figures of different sales reps in a column, you may want to know how many sales reps were not able to meet the given sales target. Or …
Whenever I’m working with financial data, I have to clean and format it so it’s more readable. One of the things I often have to do is change the format of the cells that contain figures such as revenue or profit to show them in millions. For example, instead of showing 5735241, it’s better to …
I was recently working on a project where I had to create QR codes (Quick Response codes) in bulk in Excel for some of the URLs I had in a column. I figured out a couple of different ways to do this, and in this article, I’m going to share four methods you can use …
Excel has multiple count-related functions that allow you to quickly analyze large data sets. A common task for many people Is to count cells that contain a value in between two specific numbers. For example, if you are analyzing sales data for different Sales Reps in your company, you may want to know the number …
©trumpexcel.com – Free Online Excel Training
