In such cases, you can adjust the rows and columns to fit the text in the cell (so that the text is completely within the cell). This can be done using the AutoFit feature in Excel. In this tutorial, I will show you how to use Autofit in Excel using multiple ways. I will also cover some other Excel features you can use when you’re working with text data in Excel....

When to use Excel FALSE Function FALSE function returns the logical value FALSE. It does not take any input arguments. What it Returns It returns the logical value FALSE. Syntax =FALSE() Input Arguments It does not take any input arguments. Additional Notes FALSE function is best used when you are evaluating a condition, and if isn’t TRUE, you simply want to get the FALSE value in the cell. For example: =IF(AND(A1>0,A1<100),”Approve”,FALSE()) In this example, if the condition is not met, it simply returns FALSE as the result....

Here are the formatting features that can be quickly accessed through the Excel Ribbon. Suppose you have the data as shown below: With some simple data formatting steps, the data can look like a beauty queen. Here are some of the formats that can increase the readability: Give a border Make the headers Font Bold Give a cell color to headers Center Align the Headers All these options can be quickly accessed through the Excel ribbon....

In the projects I have worked so far, Milestone Charts (also known as timeline charts) are often one of the most discussed parts. A commitment to delivering is as important as the project itself. A milestone chart is an effective tool to depict project scope and timelines. In this post, I will show you a simple technique to quickly generate a Milestone chart in Excel. Something as shown below:...

When working with data in Excel, sorting the data is one of the common things you might have to do. In most of the cases, you need to sort a single column. But in some cases, there may be a need to sort two columns or more than two columns. For example, in the below dataset, I want to sort the data by the Region column and then by the Sales Column....

If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes can come in handy. You can also use it when you’re updating a file and need to keep a track of all the changes you do yourself. This can be helpful when you revisit it sometime later. In this tutorial, I will show you how to track changes in Excel....

I often use these when I am using formulas and I need to specify what a formula does and what a cell value means. If you’re collaborating with others, you can also add comments for other people’s reference. In this tutorial, I will show you all you need to know about comments – including how to insert comments in Excel, how to edit/delete comments, how to delete comments from the entire sheet or workbook, etc....

One common requirement is to multiply an entire column by a number (a constant value). In this tutorial, I will show you two easy ways to multiple an entire column with a given number. So let’s get to it! Mulitply Column with a Number Using Formula (Hardcoding the Value in Formula) Suppose I have a dataset as shown below, where I have the Sales Rep names in Column A and their current sales values in Column B....

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 this tutorial, I will show you how to select a column or row using a simple shortcut, as well as some other easy methods. I will also show you how to do this when you’re working with an Excel table or Pivot Table....

Now you have two options: Either recreate it again or go through it manually one step at a time, OR Use the 2 formula debugging techniques I am about to share. Keep reading! Excel Formula Debugging Method #1 – F9 Key Here is how this works: For example, suppose you have the text TrumpExcel in Cell A1, and in cell A3 you have the following formula: Excel Formula Debugging Method #2 – Evaluate Formula Step by Step Other Excel tutorials you may find useful:...

When you create a drop-down list, you can only make one selection. If you select another item, the first one is replaced with the new selection. He wanted to make multiple selections from the same drop down in such a way that the selections get added to the already present value in the cell. Something as shown below in the pic: There is no way you can do this with Excel in-built features....

When working with VBA, a variable is a location in your computer’s memory where you can store data. The type of data you can store in a variable would depend on the data type of the variable. For example, if you want to store integers in a variable, your data type would be ‘Integer’ and if you want to store text then your data type would be ‘String’. More on data types later in this tutorial....

In case you work with charts that are frequently updated, it’s better to create a dynamic chart range. What is a Dynamic Chart Range? A dynamic chart range is a data range that updates automatically when you change the data source. This dynamic range is then used as the source data in a chart. As the data changes, the dynamic range updates instantly which leads to an update in the chart....

A lot of times we have charts that have to handle empty data cells. Excel gives you the flexibility to decide how the empty cells should be treated. Suppose I have the data for date-wise sales of a product from a shop. Assuming that the shop is closed on Sunday and national holidays, there are some gaps on these days. Now if you plot this data in a chart in Excel, there are three options....

But in many cases, you may want to move the chart from the sheet where it’s created to another worksheet (or a chart sheet – which has nothing but the chart). This can be useful when you’re creating dashboards, where the data can be scattered throughout the workbook, but you can get all the important charts in the sheet that has the dashboard. When it comes to moving a chart to another sheet, you can:...

Excel INT Function Overview When to use Excel INT Function INT Function is used when you want to get the integer portion of a number. What it Returns It returns an integer number. Syntax =INT(number) Input Arguments number – the number for which you want to get the integer value. Excel INT Function Examples Below are three examples of using the INT function in Excel. Example 1 – Getting the Integer Part from a Positive number When you use INT function with a positive integer, it discards the decimal part and gives you the integer part of the number....

Unless you’re among the few lucky ones, you’ll most likely get your data in a format that would need some cleaning. One common use case of this would be when you get a dataset and you have to remove some characters from the left for this dataset. These could be a fixed number of characters that you need to remove from the left, or could be before a specific character or string....

Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For something that is so popular, it makes sense to have a decent knowledge on how to use these applications efficiently. In some job roles, a major part of the work involves working with these applications on a daily basis. I have been part of many interview panels where I have seen the candidates mention Excel as one of the skills they are expert in, but when asked a few questions on it, the expertise fizzled out....

In this blog post, I will show you how to use Excel Options to customize your workbooks and get a better spreadsheet experience. Accessing Excel Options To open the Excel Options dialog box: In Excel 2010/13: Go to File –> Options. In Excel 2007: Go to Menus –> Tools –> Excel Options. Don’t be overwhelmed with all the categories and checkboxes in the Excel Options dialog box. You do not need to change everything, and in most cases, default setting works just fine....

When to use Excel OFFSET Function Excel OFFSET function can be used when you want to get a reference which offsets specified number of rows and columns from the starting point. What it Returns It returns the reference that OFFSET function points to. Syntax =OFFSET(reference, rows, cols, [height], [width]) Input Arguments reference – The reference from which you want to offset. This could be a cell reference or a range of adjacent cells....