Category: Advanced Excel
Excel Standard Deviations and Error Bars for Better Graphs
It would be nice if all data was perfect, absolute and complete. But when it isn't, Excel gives us some useful tools to convey margins of error and standard deviations. If you work in a field that needs to reflect an accurate range of data error, then follow the steps…
Read More
How to Remove Spaces in Excel Data
Does this sound familiar? You are searching for data that you know you've entered, but a query for Joe Smith simply doesn't return any results. Or, how about – you are trying to add up two columns of numbers, but you keep getting errors. Often, these issues are caused by…
Read More
Developer Tab: Find the Tab that You Need for Macros, VBA and More
Does this sound familiar? You open a workbook that contains macros and see a Security Alert message. You can’t find the Macro Dialog Box, and you can see that all VBA content is disabled by the default version of the program. How familiar are you with the Developer tab? If…
Read More
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
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
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
Create an Excel Control Chart to Analyze Data
In this article, we'll show you how to construct an Excel control chart to analyze data and improve efficiency. Control charts are useful for monitoring any process that has a level of variation - for example, filling containers with a certain number of items. They can easily illustrate whether your…
Read More