Paladone I Love Spreadsheets Mug

Product Information

If you’re into coding, working with Excel in your programs can be really fun! The most common way to connect with Excel is using Visual Basic for Applications (VBA), which is what most Microsoft Office programs are programmed with. There are many resources available online but here’s a great starter. 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? Andreas Jonsson, cofounder and chief executive of LinkedIn analytics app Shield, says spreadsheets can save you crucial time and money in the early days of a startup. 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.

Imagine a world without spreadsheets; hard as this may be, they are not fit for the purpose you might be using them for. What in an ideal world would make your life easier? A web based tool, a built in communications platform, a central point for everyone to work in, from designers through to marketers, the ability to manage multiple output channels from one point? Another option is using an API. As a starting place, here’s an article about how to read spreadsheets using an API in Python. With an API, we’re able to use other languages like Java or R as well!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. Ability to limit access to data, or spreadsheets, within a workbook that contains sensitive information. It’s reported that close to 90% of spreadsheets contain errors — given that Microsoft reports over 1 billion O365 users globally — we’re dealing with an erroneous spreadsheet pandemic! However, when they obtained the actual spreadsheet used for the original calculations, they identified three errors.

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.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?! Okay, we’re talking basic stuff here. The more advanced user can use spreadsheets to automatically retrieve data from the internet to perform calculations and serious analytical deep dives into the data held. Sounds kind of interesting, how do I do this?

Start by analyzing your processes and identify what your pain points are. Where do you regularly experience frustrations are there any easily identifiable challenges in your marketing process. After a week of extensive research compiling offers from major banks and credit card companies, I sent my sister an Excel spreadsheet breaking down her options,” he says. “Soon, that spreadsheet was forwarded widely outside of my family and friends. That’s when I realised there was a real shopability problem in financial services where consumers had to sift through banks’ dense materials for information.” My love for you grows... because you save me time and money An approval process that releases a financial model, or a spreadsheet of any kind, into ‘production’. This approval process should certify that the workbook has passed an audit and is available for general use. ⚠ RISK 5 — SPAGHETTI JUNCTION Suddenly, I have error terror! So, what are the most common risks, and what can we do about them? ⚠ RISK 1 — WHERE ARE THE SPREADSHEETS? 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.

About this product

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 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. If you run into problems, let me just say that you aren’t alone. Here are the ones that I ran into during my own merging experience: On April 16, doctoral student Thomas Herndon and professors Michael Ash and Robert Pollin, at the University of Massachusetts Amherst, released the results of their analysis of two 2010 papers by Reinhard and Rogoff. Reinhart and Rogoff’s work showed average real economic growth slows (a 0.1% decline) when a country’s debt rises to more than 90% of gross domestic product (GDP) — and this 90% figure was employed repeatedly in political arguments over high-profile austerity measures. An inventory of pre-approved templates with documented approval and owners, categorized into levels of risk I expect that, in many cases, the answer to that is they either don’t plan, or they spend ages writing stuff out on paper.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? 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. As a finance leader, I’ve become accustomed to workbooks linking to other workbooks — it’s often the only way to enable multiple workstreams to work simultaneously to create a collated set of financial numbers. What transpires is an untraceable spaghetti junction of formulae and spreadsheets that no one has the time, nor the capacity, to investigate. Tentatively, I put my trust in original preparer in the absence of easy traceability of inputs and formulae. Can you think of another system in finance that doesn’t have access controls built in? For good reason, the Sarbanes-Oxley Act of 2002 (SOX) requires that all organisations should behave ethically and limit access to financial data. Data breaches and leaks are not uncommon, and can lead to significant financial loss for a company — recently evidenced by the FinCEN leaks in the US. 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?