Tag Archives | Microsoft Excel

excelcameratool

Excel Tip: The Camera Tool – a cool view

Excel’s Camera tool is a really cool, but relatively obscure tool that lets you create a window on your spreadsheet that shows a vignette of a block of cells. The screen clip shown here demonstrates it in action. The Camera tool is pretty well hidden, so the first trick is finding the button to add […]

Continue Reading
Excel Stoplight Chart screenshot

Excel: Scatter chart with Stoplights

My friend Peter strikes again. This time, it’s a very cool take on the scatter chart. Using the Offset function in Excel, you can create a chart that gives you the stoplight dashboard effect. The math behind this is a bit tricky, but it’s all right there in the Excel formulas. Like the scrolling graph […]

Continue Reading
Excel: Scrolling chart screenshot

Excel: Create Scrolling Charts

My friend Peter showed me a very cool method of creating a graph or chart that lets you scroll through the time periods (or your x-axis) using a scroll bar. It involves setting up a few defined ranges containing formulas and using a scroll bar to control the starting point of your x-axis. You configure […]

Continue Reading

Awesome Utilities Add-In for Excel

I stumbled across an awesome utility add-in for excel that will save you tons of time doing mundane little formulas and formattings to your data. The folks over at ASAP Utilities have created this wonderful tool and it’s completely free for the taking. There must be over 100 functions in this add-in, here’s a few […]

Continue Reading
favicon

Excel: Turn a Column into a Row and Vice Versa

Just got a call today from an accountant wondering how to turn a column of data into a row. If you don’t know, you’ll love it…so simple: Highlight the cells you want to flip the orientation on Ctrl-C to copy (or copy button…whatever you like) Click Edit/Paste Special (might have to expand your Edit menu […]

Continue Reading

Powered by WordPress. Designed by Woo Themes