Author Archives: Excel Tips and Tricks from Pryor.com

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 in scheduling to make sure…
Read More

How to Add a Trend or Moving Average Line to Excel Chart

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 use some of the features…
Read More

Use an Excel Formula to Convert Text to Numbers

Excel is the go-to program when you need to organize data, create formulas and share information with the team. That being said, working with data in numerous places and applications can make the data import not as seamless as one would hope. Let’s say you transferred data from an external source into Excel and numbers were mistaken for text….
Read More

Share Data with an Excel Chart Secondary Axis

Placing two data sets in an Excel chart is an effective way to quickly understand data and make important business decisions. However, when the values in your data sets widely vary, your chart may be difficult to comprehend. A great way to mitigate this problem and make your data clear and easy to understand  is by…
Read More

Excel Macro to Delete Rows

In our fast-paced, technology-driven world, it doesn’t make sense to spend time clicking through rows and rows on a spreadsheet just to delete them. By using the power of Excel Macros, you can automate the process so that Excel will eliminate any and all flagged rows instantaneously. Let’s take a real-world example. Transfiguration, Inc., is…
Read More

Categories

Monthly Archives