Using Visual Studio Tools for Office (VSTO) with Excel lets you use C# (or your other favorite .NET language to leverage the power of Excel. But you will have to learn how the syntax for the Excel object model as opposed to just using VBA syntax. This post shows you how to use Excel ranges [...]
Archive | Microsoft Excel RSS feed for this section
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 [...]
Excel: Make a bar meter graph in a cell using REPT
This nifty little Excel tip comes via LifeHacker.com, originally given by JuiceAnalytics. You can create a sweet little bar meter chart by using the REPT() function. REPT is short for repeat. Here’s how: Format the cells you want to show your meters in as Arial, 8 pt to give it a tight look. Here’s a [...]
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 [...]
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 [...]
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 [...]
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 [...]
Subscribe
Subscribe to our e-mail newsletter to receive updates.
