We all know that to make a chart we must specify a range of values as input. But what if our range is dynamic and keeps on growing or shrinking. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows?
Today I’ll show you how to automate an Excel chart with just two keystrokes. I’ll first show you the typical way that most users accomplish adding data to a chart, and then I’ll share the simple technique that eliminates this mundane need.
Visual Design is a concept that many people don’t think about when using Excel. These are simply three things you should keep in mind whenever creating an Excel output.
Here are the top ten ways to clean the data, and briefly describe the importance to data mining
Excel is the most important and powerful search marketing tool. Here are some tips and tricks to successful data analysis.
Excel is fantastic tool for number crunching. PivotTable, it is arguably the most powerful tool in Excel. There’s simply no better way to quickly make sense of a large set of data
Formatting is an overlooked skill when it comes to Excel. It is essential for communicating results clearly and powerfully.
Learn 10 cool techniques that will make your Excel charts way sexier. We’re now going to jump into the really fun stuff: charting data out in Excel.
If your intent is to someday become an Excel power user, you will need a solid understanding of all the lookup formulas available to you. Below is list of the most popular Excel lookup formulas with tutorials linked as reference.
In an effort to help us all, I went in search of the most helpful Excel hacks to make data entry and calculation easier. Here are five gems I bookmarked for my own use.