For a long time, I have been looking for a way to be more active in the crypto community, without having to blog. Time doesn’t allow for much blogging. I’m still balancing the working while homeschooling the kids, but so missing the crypto community and the involvement I once had.

Luckily enough some of my good friends have an interest in crypto and blockchain and very often our chats these days are around nothing more than this exciting industry and times. There is so much going on, so much to learn, daily news to keep on top of, new layers…

2020 is coming close to an end and it has probably been a year most of us are happy to say goodbye to. However, even with all the ongoings, I still feel like I have a lot to celebrate. The Excel Club blog has grown from strength to strength and thanks to you, I have seen a 92% increase in traffic to my blog this year. Thank YOU. Woot………it’s a massive achievement.

This year I published 25 Excel and Excel Related articles. From these 25 articles the most popular, based on your total views are (in reverse order)

Top Excel Blog posts published in 2020.

10. Women…

Over the years I have seen many things in Excel that has made me go “wow, I won’t do that again in a hurry”. Thankfully as the years have progressed, so has Excel and many of these problem items have been resolved with updates. However, there are still a few things that you should avoid doing in Excel or stop doing altogether. One of these is the use of the popular Merge cells in Excel formatting option. I beg of you, do not merge cells in Excel

Merging cells in Excel cause problems with sorting and moving data. In this…

VLOOKUP is one of those functions’ users tend to use over and over. At the start, it is hard to get your head around it but once you do, it provides great value. However, it also has its limitations. For example, on its own, it cannot look up to the left. You cannot do a horizontal lookup. You cannot add new columns to the dataset for fear of breaking the formula.

XLOOKUP aims to solve the limitations posed by VLOOKUP, it will be easier to read and write and it will calculate faster. …

The SUM function in Excel is probably the most widely used function available. In fact, it is the only formula that has its own keyboard shortcut (Alt & =). Therefore it should come as no surprise that this basic mathematical function has more powerful cousins available in Excel. These functions are known as SUMIF and SUMIFS.

Let's say you wanted to sum a column in your spreadsheet by specific criteria. Taking the example in the image below, let's say you wanted to sum the sales for just blue items. Using the formula =SUM(D2:D14) will result in a total for all…

Computerized Spreadsheets have been around for many decades (way more than I have been around). And as technology evolves so do spreadsheets. The use of spreadsheets has also changed, from simple record keeping to more complex analysis and presentations. But this increase in complexity brings its own element of risks. In this article, we are going to look at the five most common types of Spreadsheet risk. If there are risks there are also ways to control them. So we will also look at some simple controls you can put in place to minimize these risks.

Spreadsheet Risk 1

The first risk is…

Business Intelligence Case Study — The Small Business

In my last post, I gave you a brief explanation of Business Intelligence ( if you missed the post you can read it here). But what has this got to do with the small business or the employee? I can tell you that Business Intelligence is not just for multinationals and large organizations. This Business intelligence case study shows it can help any size company.

Business Intelligence Case Study.

Meet Joe.

Joe worked for a small family-run organization. He was a forward-thinking employee that worked in marketing. …

What is Business Intelligence?

Business Intelligence

Business Intelligence (BI) plays a key role in the strategic planning of a business. BI Tools (technologies, apps, and processes) allow an organization to store, to discover, to gather, to analyze and to visualize data. This makes it possible for decision-makers at all levels of an organization to act on information.

Business Intelligence Systems

Business intelligence systems are data-driven. They provide historical, current, and predictive views of business operations.

Most businesses collect large amounts of data. Data at the financial transaction level, data on tenders and quotes, customers, suppliers, contracts. Marketing data, error data, data on employees. Productivity data…

OFFSET Function to make Excels SUM function Dynamic

Everyone can use the SUM function in Excel. It is the most basic and used functions available. In fact, it is the only formula in Excel that has its own keyboard shortcut (Alt + =). However many users find difficulty when adding additional rows to the data which they are summing. The formula has taken cell references and this is causing problems.

OFFSET Function

To overcome this problem and make the SUM function moe dynamic we can use the OFFSET function. …

Paula Guilfoyle

CPA Accountant and Online Excel Instructor at

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store