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.
As you scroll horizontally across a worksheet with many columns, the columns at the beginning of the worksheet scroll out of view. Usually, the first column (or the first few columns) has the headers for each row. And when you scroll to the right of your worksheet, it would be helpful if the headers in …
Tell me if this has happened to you – you’re working on an Excel spreadsheet, and as soon as you press any of the arrow keys, the entire page moves instead of moving the cursor to the next cell. This happens because, somehow, the Scroll Lock has been enabled, and you need to turn off …
What do you do when you have to get the sum of cells in a column? Do you use the SUM function? While that’s the right way to do this, I hope you’re not manually entering the SUM formula and selecting the range to get the sum of all the values in the column (or …
When working with name data sets in Excel, you may want the names to be in a specific format. Usually, the names are either in the ‘First Name Last Name’ format (such as Joe Davis or Sumit Bansal). In some specific situations, you may want the names data to be formatted as Last Name, First …
When you copy a cell or range of cells in Excel and paste it somewhere else, it pastes the entire content of the cells, including the formatting. But do you know that you can also copy the column width? Excel allows you to copy cells and paste selectively (such as only pasting the values or …
Pivot tables are used by hundreds of thousands of people every day to analyze and summarize large amounts of data. Pivot Tables are fairly easy to use, and most Excel users get the hang of it after using it a couple of times. So if you’re a fan of Pivot Tables and use them quite …
Many Excel users use the terms ‘Formula’ and ‘Function’ interchangeably. While this does no harm in most cases, it’s good to have a proper understanding of what a formula is and what a function is in Excel. And, of course, it is going to give you a lot of opportunities to correct others and brag …
While this may be a basic question for many Excel users, I have been asked multiple times about the difference between rows and columns in Excel. While one obvious difference is the placement of the row versus column in Excel, there is more to it. In this article, I will cover the differences between rows …
It’s a common requirement to calculate the date after a specific number of weeks from the current date or any other given date. This is especially helpful while planning a project where you have a tentative idea of how much time a task would take and want to know when it will be completed (by …
©trumpexcel.com – Free Online Excel Training
