You have a spreadsheet with information missing because it was summarised for viewing as a report, but this format is no good for data analysis. You know you want to fill the empty cells with values, but how do you do it quickly? Perhaps you copied data from a report somewhere, and some columns were summarised with blank spaces sorta like the spreadsheet below. As you … [Read more...] about How To Fill Empty Cells In Excel With Values Above
All Articles
Would you like to know how the web works?
I knocked this info graphic together as a high level overview of how the web works and more specifically how websites work to give you a big picture idea on how the individual parts of web technology fit together. So let me take you through the graphic. … [Read more...] about Would you like to know how the web works?
Mac Smart Folders Can Help Keep You Sane
The step by step tutorial to get you up and running and super productive with mac smart folders real fast. The Problem Maybe you have come across this issue before. You are building up notes or are creating articles for future blog posts and you want to categorise them. … [Read more...] about Mac Smart Folders Can Help Keep You Sane
Excel Advanced Filter – Criteria to Show Blank Cells
Today I had a problem in Excel that crops up quite often, namely how to filter to find blank cells or how to filter to exclude blank cells. … [Read more...] about Excel Advanced Filter – Criteria to Show Blank Cells
How To Automate Tasks With Microsoft Excel VBA
Microsoft Office uses VBA as it's macro or programming language. If you'd like to learn to automate tasks with Excel VBA check out the video below and read this article. We'll give you an 80/20 overview of how to get coding vba macros for excel like an expert, enjoy... Lets get you coding fast, … [Read more...] about How To Automate Tasks With Microsoft Excel VBA