Category: Excel®
How to Record an Excel Macro (Part 2)
Do you want a practical way to make repetitive tasks in Excel easier and faster? Say you receive a spreadsheet every week from a reseller that markets your products. You perform the same changes weekly to adjust the format of the sheet to your company’s standards. You also run a…
Read More
Excel Macro Examples for Use (Part 1)
How much of your time do you spend on spreadsheets? You manually enter line after line of data and then painstakingly format it. This method might be fine for small, infrequent jobs, but imagine the time that could be saved if repetitive steps were automated! There are numerous Excel Macro…
Read More
Share Visual Data with Excel Color Formula
Spreadsheets are great for managing large amounts of information and deriving new insights from data, but they can be difficult to comprehend at a glance. When you need to share information with non-technical colleagues or want to visualize your data, an excel color formula can be your best friend. Your…
Read More
Impress Your Colleagues with Excel Dial Charts
If you’re looking for a modern way to visualize your data, check out the Excel dial chart. Dial charts are a natural fit for dashboard-style interfaces and are also referred to as speedometer charts because of the visual similarity to a car’s speedometer. Dial charts work well for indicating performance…
Read More
The Ins and Outs of Excel Rounding Formula
There are several Excel functions that will help you round numbers to the appropriate format. You can create formulas using these functions to get your data looking the way you want it. An Excel rounding formula allows for rounding to a specific number of decimal places, the nearest even or…
Read More
Guide to Using $ in Excel Formulas
There might be times when you do not want Excel to adjust all or part of your formula automatically. For example, you may have a table of standard multipliers that you use in the formula and want the same cell to always be used to multiply. The answer: an absolute…
Read More
Use Excel Auto-fill for Formulas and More!
Problem: You have a standard salary multiplier for overtime hours that you want to calculate the same way every time. The formula you generate needs to appear along an entire row of data, and across several worksheets, but you don’t want to type it out each time. Solution: Copy your…
Read More
Create an Excel Pivot Chart from Your PivotTable
Problem: You have data with thousands of donors and their annual gifts listed. The PivotTable you are using still doesn't help you see which donors gave the most or how many donors gave you donations at various giving tiers. Solution: Create a PivotChart. You may need a visual representation of…
Read More
How to Share Big Picture Data with an Excel Timeline Chart
It can be difficult to quickly, efficiently communicate project timelines. A graphic representation of your deadlines and milestones can clear up a somewhat complicated meeting. Think of project management. You can see when certain processes are started and completed in relation to other processes. Or, try an Excel timeline chart…
Read More
How to Add an Average Line in Excel Charts for Trending Data
When looking at a newly created chart in Excel, it can be difficult to tell which way the data is trending. These charts are often composed of thousands of points of data. Sometimes we can tell which way the data is moving over time, but other times we have to…
Read More