Category: Excel®
Creating a Graph with Mutiple Data Series in Excel Without a PivotChart
One of the most powerful advantages of a chart is its ability to show comparisons between data series, but you'll need to spend a little time thinking about what you want to show and how to organize it for excellent communication. Let's look at the ways that Excel can display…
Read More
A Great Way to Create an Excel Micro Timer
Professionals who are used to organizing their lives in Excel at some point wish Excel could include a timer to help keep track of common tasks. Tasks like tracking time spent on specific projects or monitoring hourly rate. A quick look, however, reveals that – unless you are an accomplished…
Read More
Three Excel Chart Add-Ins to Create Unique Charts and Graphics
There's no debating that Excel is a powerful, useful tool for gathering, analyzing and communicating all kinds of data. But even the biggest fan sometimes wishes for just a little bit more, especially when you want to create visual impact for your data in charts and graphics. Microsoft opened the…
Read More
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
Create a Date or Time Chart in Excel with XY-Scatter Charts
When you have data that involves time information, you may need some special tricks to get Excel to help you create useful charts. Here are some tips for editing time and date data in an Excel chart. These features apply to Excel 2007-2013, though the specific steps will vary based…
Read More
Learn about the Excel Find Formula
Sometimes getting valuable or actionable information out of your data is a bit like going on a treasure hunt: You spend a lot of time solving puzzles and putting together a "map" of formulas that will hopefully lead you to the goldmine of information hidden inside. The FIND function, and…
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
Use Excel Data Forms to Simplify Data Entry
Spreadsheets are valuable tools for organizing, manipulating, and analyzing data. But first you have to enter the data. This can be the least fun part of building a spreadsheet, especially if you have many columns of information that scroll horizontally off the screen. It can also be easy to introduce…
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
About Excel Formula Syntax: The Language of Formulas and Functions
Excel makes it a simple task to perform mathematical operations. Using Excel formula syntax, you can calculate and analyze data in your worksheet. As a reminder: Formulas are equations that combine values and cell references with operators to calculate a result. Functions are prebuilt formulas that can be quickly fed values without…
Read More