Excel Tag

Kicking off a new year of Snowflake blogs seemed like a great opportunity to give you the tips and tricks of connecting to Snowflake from Excel. Businesses have been using databases to get data for Excel workbooks forever, but looking through the depths of Google,...

Do you ever have those watercooler debates at work that never get a real sense of finality? A coworker claims the trade OKC made for Carmelo Anthony was worth it, and you know in your heart that they are completely wrong, but you keep it...

Before we look at data preparation using Excel and Tableau Prep, we need to ask a question. It’s always a healthy discipline to ask questions first and use technology to answer them second. Take a look at the question, look away from the screen then take...

Four years ago, I wrote a blog post speculating about future business intelligence workflow and tools for business information systems that would provide the capabilities of high-priced legacy enterprise business information systems but at a fraction of the cost. Part of that post included a...

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,...

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

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072