Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Hyperlinks are Excel’s shortcut way to jump to the required data point in the same workbook, a different workbook, or an external URL. While hyperlinks are mostly static links, here is the way you can use to create dynamic hyperlinks. By Dynamic Hyperlinks, I mean links that change based on the selection (or any other …
Excel has a handy feature called Excel Tables, which makes data management and analysis a lot easier. If you’re an Excel beginner, you may think an Excel Table is data in a tabular format. But that’s not the case. When data is arranged in rows and columns in the worksheet, it’s just plain regular data. …
Wherever there is data, there is a need to filter it. Excel Data Filter feature gives you many ways to filter the data – based on text, value or date. Excel Data Filter Suppose you have the data as shown below: To activate Excel data filter for this data, select the entire data and click …
Data Validation in Excel lets you control the data that can be entered in a cell. You can restrict the user to enter only a specified range of numbers or text or date. You can also use data validation functionality to create an Excel drop down list (which is definitely one of the coolest and …
Working with data all day long in Excel could be boring. Sometimes, there is no alternative to it, however, you can still bring in some colors and zing to it by using Excel features to format the data. Formatting the data in Excel can increase its readability tremendously. Let me introduce you to some of …
I often use scatter chart with many data points. One of the most irritating things is to spot the data point in Excel chart. Excel does not give you a way to display the names of the data points. While there are many add-ins available to do this, I will show you a super cool (without add-in) …
A line break in Excel can be used to end the current line and start a new line in the same cell (as shown below). Notice that in the pic above, Morning is in the second row in the same cell. You may want to insert a line break in Excel when you have multiple …
If you work involves reporting the actual and target data, you may find it useful to present the actual values versus the target values in a chart in Excel. For example, you can show the actual sales values versus the target sales values, or the satisfaction rating achieved versus the target rating. There can be …
Imagine you have created a super long formula in Excel. While you are proud of yourself, there is a minor glitch. It is returning an error or an unexpected value. Now you have two options: Excel Formula Debugging Method #1 – F9 Key Here is how this works: For example, suppose you have the text …
©trumpexcel.com – Free Online Excel Training
