Category: Excel®
Excel What-if Analysis: Scenarios
If you think of Excel as just a database for storing dead data, you will be pleasantly surprised to learn about Excel's What-if analysis tools. Excel offers several features that allow a user to make predictions, or evaluate outcomes based upon variable inputs. In this article, we are going to…
Read More
Excel Macro Tutorial for Beginners
To follow using our example, download MacrosForBeginners.xlsx Once you get comfortable navigating Excel, it won't be long before you start to hear about this wondrous feature called a "Macro" that can leap tall projects with a single keystroke and make boring tasks go by faster than a speeding bullet. While…
Read More
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