Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to ...

In this article, I’ll show you how to create a YOY chart by using Microsoft Excel’s PivotTable and PivotChart features. SEE: Software Installation Policy (TechRepublic Premium) I’m using ...

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 ...

It also provides you some Process diagram templates that you can use to draw a flowchart in Excel. Just add a process SmartArt graphics and edit the steps for the process to create your own flowchart.

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 ...

Commissions do not affect our editors' opinions or evaluations. A Microsoft Excel spreadsheet is one of the most versatile business tools around. It’s no surprise that Excel is a common default ...