Category: Excel®

Use Multiple Worksheets to Create 3D Excel Charts

A 3D Excel formula allows you to calculate cells across multiple worksheets. It is incredibly useful for creating a summary sheet to share data with others. You can then share the results visually with the help of a 3D Excel Chart. Download and follow along with 3D Excel Charts.xlsx. Step-by-Step:…
Read More

Can You Permanently Save a Macro in Excel for Use in All Workbooks?

Have you ever lost your macro or decided it is just too useful for only one workbook? You can save your macro in PERSONAL.xlsb to apply the macro to all workbooks that you open and use on your computer. (Macros stored in personal.xlsb will not be available on other computers.)…
Read More

Excel Macro: Relative Reference

Excel records Macros in absolute mode by default. In absolute mode, a Macro will start working in the same cell it was in when it was recorded. If, when it was recorded, A1 was the active cell, then it will return to A1 and begin working from there no matter…
Read More

How to Calculate Median in an Excel PivotTable – Almost!

A frequent question that comes up when working with Excel PivotTables is how to calculate median using the table's filters and analysis. The short answer is "Excel doesn't do that". Meaning, there isn't a simple way to change the Value Field Settings to calculate "Median". The closest you can get…
Read More

How to Use an Excel IF Function

Sometimes you need your data to tell you more about itself. The versatile IF function is how you can turn raw numbers into useful information. For example: Your wholesale company charges different rates depending on the size of bulk orders – customers who order more receive volume discounts. You want…
Read More

How to Create PivotTables Using the Quick Analysis Tool in Excel

Storing information is only part of the useful things Excel spreadsheets can do. Once you have collected a set of data, Excel can help you organize it and analyze it. One of the most powerful tools for analysis is the PivotTable. PivotTables do more than generate graphs out of one…
Read More

The Right Way to Create an Excel Rolling Chart

Creating reports on a regular schedule is a common task for the business Excel user. When you need to create a Rolling chart that reflects data in a specific timeframe – such as the previous 12 months - you can quickly find yourself in a maintenance nightmare, updating your charts…
Read More

COUNTIFS – Excel’s COUNTIF for Multiple Criteria

As Excel users, we're never satisfied! We see a powerful function like COUNTIF that gives us the ability to find and tally data based on a huge assortment of specified criteria and we still want more. Namely, the ability to count our data based on multiple criteria specifications. COUNTIF a…
Read More

How to Make a Radar Chart in Excel

Pie charts, bar charts and line charts are familiar friends to Excel users. But there's a less well-known chart out there that can pack a lot of information into a single, visually powerful image. The Radar Chart, also sometimes called a spider or star chart, lets you compare multiple items…
Read More

Export Excel Charts to Word and PowerPoint Using Copy/Paste

Once you have spent the time crunching numbers and creating a beautiful chart in Excel, you'll probably find that you want to use it again and again in reports and presentations. Microsoft makes it easy to share objects between its Office programs, but few methods are easier than Copy/Paste. We…
Read More
< >