Let’s look at a couple of ways to create a watermark in Excel. To follow along, download this Excel workbook. Not one, but two video demonstrations are also available at the bottom of this article on ...

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Learn how to make a flowchart in Microsoft Excel without using any external add-on - but with SmartArt Graphics or Shapes Tool.

Note: When creating bar charts with percentage data, Excel often sets the axis maximum to 1.2 by default, so it’s best to manually set it to 1.0 for accurate progress bars.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

How to Create Pulldowns in Excel. You can create a pull-down menu in Microsoft Excel 2010 by configuring a list of values in the Data Validation menu. This function provides viewers of your ...

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...