Vafara Noéline June 3, 2021 Spreadsheet
When Microsoft Excel is used to manipulate, store and analyse data it can become extremely difficult to manage, let alone efficiently work to produce any meaningful insights. This is because with data sets large and small, the data must be meaningful, logical, structured, internally consistent and clean. This holds true regardless of whether the data has been imported into excel from another system or manually entered. In this computing age, most people know that for any data set to be useable it must first be relatively structured and clean. A spreadsheet and its table layout naturally encourages data to be somewhat structured, however ensuring data is clean is also difficult.
Microsoft plans to have this program up soon and now Google is beta testing a similar situation, which would allow you to do essentially the same thing. Why is this good? Well, consider the Digital divide in the world and if everyone just had a terminal rather than a big hard drive with lots of expensive stuff on the computer then they can store all their information at one location. By doing this, the computers would actually be terminals and it would be very inexpensive to make them, meaning that everyone in the world could afford to have one and everyone in the world could be online and interconnected in a giant collective of humanity. There would be no one who would be without the Internet and this would bring the world closer together in a common cause.
Structured Query Language, often referred to as SQL, is a grammar of instructions that allows us to tell a relational database to add, modify or delete data. The key benefit, pardon the pun, of SQL is that it allows us to craft instructions relating large sets of data together. In this way SQL is the natural complement to the single cell and formula based interface of spreadsheets like Microsoft Excel. Imagine you had five hundred appointments from your business calendar laid out in a table. Each appointment might have a day, time, location and description. Now imagine you also had five hundred appointments from your partners business calendar, also each having a day, time, location and description.
”Happy crapola!” he exclaimed, rising from the rollered chair and scooping accordion folds of printouts into his tattered briefcase. He snatched his worn black suit coat from a hanger on the back of the office door, switched off the fluorescent overheads, and walked to the executive offices in the adjoining building. When his audit week ended, Lester typically teamed with Lance Lott for a tour of the local watering holes. Lance was a marketing guy he‘d met when he first worked the Bourgeois account. Lance also was single, and resembled Keanu Reeves on a bad hair day. Lester considered him a ”chick magnet,” and although he himself never got lucky on their semi-annual expeditions, the other always disappeared with a babe on his arm. Lester decided, tonight would be HIS night.
These common complaints with Microsoft Excel filtering are heard time and time again by engineers, accountants, management consultants, bankers and finance professionals who work with data in Excel spreadsheets on a daily basis. Many spreadsheet users including financial modellers (who seem to be leading the charge) are turning towards Excel Add-ins and software tools that plug into Microsoft Excel to help them improve the in-built filtering logic of Microsoft Excel and thus analyse certain data sets quickly and easily.
Here‘s a very simple budget set up. Keep a simple income spreadsheet. List all the sources by name in column A. List how much each brings in in column B. And then, any notes you have for the income (like if it is temporary) in column C. You don‘t need to get very detailed with the income, because it only needs to be accounted for so that we can budget for it‘s use. And, the incomes use is in our expenses spreadsheet. This spreadsheet will be much more complex than the income one. You‘ll need a field for income that you carry over from the income sheet. You‘ll also need a field for a total expenses budgeted for. A third field will give us the budget surplus. We get that by subtracting the budgeted amounts from the income amount. A final field will subtract the actual amount spent from the income, and will serve to tell us where we stand in our budget. If you like, you can add another field that subtracts the actual amount spent from the amount budgeted.