Excel Tag

I rarely ever receive pristine data, and I’d wager that’s true for most of us working in data analysis or business intelligence. Data can come to us from dozens—if not hundreds—of sources, and it certainly requires some preparation to make it useful. One of the...

I'm a chartered accountant, and my background is in building finance functions and creating financial performance analysis reporting functions. I trained in a public practice, and after around six years, moved into industry. I've been working in industry for the last seven years, and analysing...

Tableau isn't just a useful tool for visualising and analysing data. There's no doubt it has enabled me to improve and optimise my team, but there's another benefit I did not initially appreciate when I first began using Tableau. Coming from the world of Excel,...

So, a little about me, the author: I'm a chartered accountant and my background is in building finance functions and creating financial performance analysis reporting functions. I trained in a public practice and, after around six years, moved into industry. I've been working in industry...

Over the course of the past year, I’ve combined my love of genealogy with an increasing interest in data visualization. I’ve long had an Ancestry.com account, but I always wanted a more visual representation of where I came from. Cue Tableau. After working in short...

This post builds off of two great previous posts about Tabcmd by Kate Treadwell and Tanner Ladd. Please refer back to these posts if you have questions about setting up Tabcmd and distributing PDFs. The goal of this post is to show you how to use...

The Problem Many times, it is necessary to display content in Tableau in a verbose manner. For example: displaying comments from a survey or showing lengthy project descriptions or calls to action in an executive dashboard. Connecting Tableau to a database with long string fields or textarea...

Scenario Our sales team collects information and forecasts possible sales using a data-table called ‘Opportunities’.  If a sales opportunity converts to an actual sales lead, the customer and his information is moved to the ‘Leads’ table.  Opportunities that do not convert remain on the original table.  Additionally,...

Kickstarter has been making waves in recent months as the premier place for crowd funding.  Projects range from big to small, from purely entertainment to potentially life changing. There’s a lot to love about this dream factory. However, there’s been controversy as well.  All projects are not always what they appear...

I came across this issue today where opening a network file caused Excel 2003 to hang or crash. Opening the file locally worked normally.   Removing security updates KB2541025 and KB2502789 immediately resolved the issue.   Credit Technet:    Link...

Have you ever had to look at two excel documents at the same time? By default it will open the excel documents in different tabs in the same window. It can get pretty annoying if you really need to see both at the same time. Luckily,...

Excel and myself, we don't get a long very well. Excel, for some reason thinks it's really cool and neat that it can make anything that looks like a URL or email address clickable and making the text blue with a nice underline as an...

  Do you long for Excel 2003's simple toolbar?  While I like the Excel 2007 version,  it does take up a lot of screen real estate.  How can you minimize the toolbar but still have the quick-clicking features available?  The answer, build a Quick Access toolbar. Selecting...

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK