Paladone I Love Spreadsheets Mug

Product Information

The ability to simply, and securely, link workbooks directly to a data source — eliminating the need to replicate data by copy/paste ⚠ RISK 2 — TOO MANY COOKS

It’s not uncommon for spreadsheets to proliferate across an organisation. with work becoming more decentralized and teams working remotely, I’m willing to bet there are multiple copies of every spreadsheet hanging over the metaverse. And yet, there is no inventory or repository kept of all spreadsheets in use. Enable role profile access to be provisioned per spreadsheet. Access could be edit or read-only. Copy/paste functionality could be a privilege rather than a default permission. It’d be great to see some comments around what you use spreadsheets for, what application you use to create / edit them and what related projects you might like to see. What is the business impact of managing a marketing function with the wrong toolset & what would the impact be if you changed things? An inventory of pre-approved templates with documented approval and owners, categorized into levels of risk

Overview

Just mentioning Excel, spreadsheets or workbooks is often enough to send most people to sleep. If they do manage to stay awake, they’ll want to change the topic of conversation. Although, if their only experience with spreadsheets is what we were taught at school, I’d be the same so I totally get it. II. Then, upload your spreadsheets and choose your join type. I typically choose Full Join (which Power Query will automatically choose for you), but you can play around and look at which preview fits your needs best. I know there’s more to a spreadsheet than that, pretty charts, macros, the ability to manipulate data (although I do have to admit that pivot tables are beyond me), however, at its core the above definition is pretty accurate. If this is the case then why are so many organisations still using spreadsheets to manage their marketing campaigns? CFOs must have confidence in their data. They must know the exact data sources that feed into their financial reports — and their providence. The reality is that many finance departments don’t have visibility into data flows across their spreadsheet landscape. The data links between the different spreadsheets across departments, regions, and models are routinely undocumented and so impossible to view and accurately decipher. Dear spreadsheet — if it’s not too much to ask, can you make it easy for me to see where the data is coming from?

So, spreadsheets — while I 💓 you, there are some areas we need to work on. I went ahead and made a list (I hope you’ll forgive me 🤨!) The definition of merging spreadsheets is right in its name — we want to combine two or more spreadsheets into a single spreadsheet. This is a really essential skill to learn for any novice Excel users out there. Interesting… what should I already know? Partly I think it’s symptomatic of a ‘we’ve always done it this way’ culture and partly because its more difficult to demonstrate return on investment - if a sales person doesn’t have a phone, they can’t make sales calls, simple as that. Does that make it right? Definitely not. I know how wierd it sounds to say “I love spreadsheets!”. I mean, you don’t hear people saying things like “I love Word documents!”, or, “I love JPEGS!” do you?! A graphical representation of the interrelationships within a workbook would be really useful. I know I can trace precedents — but it’s a horrible process 🥱

I’m not alone either! In 2017, research showed that 71% of organizations are using excel to collect data across business units. The demand for end user computing (EUC) applications has never been higher. Even with the proliferation of platforms across finance, many teams are still reconciling and aggregating data in spreadsheets despite unprecedented investment in IT solutions. The ex-auditor in me shudders when I think of the risks inherent in spreadsheet use across finance. Now they pretty much do anything,” he says. “The flexibility has been growing a lot and doesn’t show signs of stopping. That’s why at Rows we built the spreadsheet that works as modern teams do — it’s data-rich, collaborative and crazy fast. You can build anything from everyday tasks and lead lists, to automated reports and internal tools” The Reinhart-Rogoff Facepalm Moment — Harvard’s Carmen Reinhart and Kenneth Rogoff are two of the most respected and influential academic economists active today. Or at least, they were. Ultimately, in my mind, they’re used to organise chaos. A tornado of information is organised into rows, columns and sheets and suddenly, the world makes sense again.

I love spreadsheets! I genuinely do. It may possibly be the nerdiest thing I’ve ever admitted to. Maybe it’s the IKEA effect, having invested 20 years honing vlookup skills, formatting pivot tables, and choosing just the right graph to make my financial data mean something to someone, or maybe I just like the feeling of sinking into that comfortable spreadsheet memory foam. Don’t get me wrong, my spreadsheets are far from perfect, but I just can’t walk away.

${Product.ProductName}

I’m going to start with the easiest types of spreadsheet merging and then move onto the harder types of merging. After that, I’ll include some common problems I ran into and some other methods of merging spreadsheets that you could use! I love a good spreadsheet and for calculating numbers and organizing information in columns and rows there’s nothing better. Surely your marketing department deserves a better toolset to deal with the challenges in today’s complex digital age?