Gantt charts are essential tools for project managers. But if you are a beginner or only need this type of chart for one project, you can save money on expensive software and make a Gantt chart in Excel….
Have you received a JSON file that you’d like to convert to Microsoft Excel format? Excel offers a built-in option to help you import it without third-party parsing tools. Here’s how you can do it.
Excel makes creating a chart or graph easy, but there are certain things you can do to make your chart more effective. This list of tips can make your graph a successful visual display of your data.
If you use conditional formatting in Microsoft Excel, then you probably know you can use more than one rule at a time. To control those rules as well as edit, delete, or duplicate one, you can use the Rules Manager….
With Microsoft Excel’s built-in options, you can quickly and easily convert your comma-separated values (CSV) files to Excel format (XLSX). Here’s how you perform this conversion on your computer.
Do you have a date in your spreadsheet that you want to turn into the day of the week? If so, Microsoft Excel has multiple features and functions to help you do that. We’ll show you how to use them.
Do you want to count the number of cells that contain any or specific text while ignoring all other cells? If so, Microsoft Excel has a dedicated function to help you do that. We’ll show you how to use it….
Calculating the square root of numbers is common in mathematical equations. If you’d like to perform that calculation in Microsoft Excel, you have a couple of ways to do that. We’ll show you how.
Conditional formatting is a terrific feature for automatically applying highlights or font formats to cells. If you have an Excel spreadsheet that contains dates, you can use this feature to make certain dates stand out and e…
Calculating the median is useful in many cases. With its MEDIAN function, Microsoft Excel makes it easy to find the median for any odd or even set of numbers. Here’s how.
If you have a PDF document such as a bank statement or financial report, you may want to pull this information into Microsoft Excel. With a built-in feature, you can easily import and automatically convert a PDF to Excel….
Microsoft Excel makes it easy to count the number of full days between two specific dates. You can use either an arithmetic operator or an Excel function to do that. We’ll show you both ways.
Finding the average (also called the arithmetic mean) comes in handy in various calculations. Microsoft Excel makes it easy to calculate the average, and we’ll show you multiple ways to do that.
Need to stamp a date on a spreadsheet? In Microsoft Excel, you have multiple ways to add today’s date in your spreadsheets. You can add both static and dynamic dates, and we’ll show you how.
By default, Microsoft Excel names your tables “Table1”, “Table2”, and so on. If you’d prefer custom names, you can rename your tables in Excel. It’s easy, and it works similarly to assigning names to cell ranges….
Even though Microsoft Excel offers a good selection of chart types, you may have a situation where you need something outside the norm. A chart that overlaps may be what you need. Here’s how to make one….
Are those long names spreading across multiple cells in your Microsoft Excel spreadsheet? If so, break up the text by starting a new line in the same cell. We’ll show you two ways to do just that.
Have you ever been tasked with combining spreadsheet data? Maybe you have your team’s expense sheets or sales counts that need to be consolidated into one. Here, we’ll show you how to combine data from spreadsheets in Microso…
Gridlines make it easier to read through data tables, which is why Excel adds them by default. They aren’t always necessary in a spreadsheet, however, so we’ll show you how to easily hide them when you don’t need them….
Drawing a line crossing your text is easy with Microsoft Excel’s strikethrough option. You can use a keyboard shortcut or a graphical menu to strikethrough your text. We’ll show you both methods.
Graphs and charts give you an easy way to display data at a glance. But what if you want to focus on a particular part of your chart? By applying a filter to an Excel chart, you can emphasize specific data….
When you insert a table in your spreadsheet, Microsoft Excel automatically applies certain formatting to your table. If you’d rather keep your table plain and simple, you can remove its formatting. We’ll show you how….
If you need to generate one or more random numbers for business, education, or another purpose, you can do so right in Microsoft Excel. You can get random numbers using either a random number generator tool or an Excel funct…
Do you no longer need a table in your Microsoft Excel spreadsheet? If so, you can use one of two methods to remove a table from your spreadsheet. We’ll show you how.
If you want to add a visual to your Excel spreadsheet that summarizes data at a glance, a chart is perfect. Depending on the type of data you have, however, it can be difficult to know which chart fits the best….
