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

Microsoft Excel’s RANK.EQ () function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ () with a conditional formatting rule to highlight ...

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

How to Create a Bracket in Excel. Whether you are helping your employees gear up for March Madness or pitting one salesperson against another in a race to the top, trying to figure out the ...

Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works.

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab ...

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Combine with Other Functions: Enhance your ranking analysis by combining the RANK function with other Excel functions like IF, VLOOKUP, or INDEX to create more complex formulas.

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.