[ad_1]
Because it was launched in 1985, Microsoft’s Excel has grow to be the go-to spreadsheet program amongst monetary professionals—and, indisputably, it stays a robust software. There are loads of causes why it’s retained its reputation for many years. However the rise in cloud computing, particularly because the starting of the COVID-19 pandemic, and the exponential development of the quantity of information companies gather have modified the best way we work, probably ceaselessly.
At the moment’s collaborative, cloud-based enterprise atmosphere is the place some great benefits of Google Sheets actually stand out. Nonetheless, there are lots of finance and enterprise professionals who’re nonetheless working with Excel spreadsheets in the identical manner that many people realized within the precloud period, even those that have switched to Microsoft’s cloud-based Microsoft 365.
In 2016, the economic equipment manufacturing firm the place I oversee monetary information analytics took the numerous step of shifting all of its 11,000 workers to Google’s G Suite, now Google Workspace—becoming a member of the rising variety of companies making the swap from Excel. Consequently, I’ve been utilizing Google Sheets nearly day by day since then, changing into a self-taught professional in its performance and revolutionary methods of working. I’ve used Google Sheets to construct discounted cash-flow fashions for big acquisitions, to handle complicated integration initiatives, for monetary planning and evaluation, and, fairly often, as a substitute for a whiteboard after I wish to sketch one thing in an internet assembly.
On this article, I share a few of the benefits of Google Sheets, highlighting the options which have dramatically improved my productiveness. I additionally present an introduction to Google Apps Script, a robust software for automating workflows and increasing Google Sheets’ performance.
I don’t, nevertheless, present a head-to-head characteristic matchup of Excel versus Google Sheets; functionalities change so shortly that such an evaluation would grow to be out of date inside weeks. As a substitute, I give attention to Google Sheets’ benefits and the brand new methods of working that the emergence of on-line productiveness instruments have enabled. I additionally contact on a few of the unfavorable features of constructing the shift from Microsoft.
The Benefits of Google Sheets
The primary benefits Google Sheets has over Excel are seamless collaborative performance, the power to deal with extraordinarily massive initiatives and information units via its integration with BigQuery, and the automation alternatives out there via Google Apps Script. Whereas Excel and others additionally supply these capabilities, Google has made them so intuitive and end-user-friendly that even essentially the most change-averse finance professionals can shortly rise up to hurry and begin seeing tangible advantages.
Simple Collaboration
Probably the most speedy benefit of utilizing Sheets is the means to collaborate seamlessly. Within the outdated model of working, you’d use a grasp file that somebody needed to “personal,” which was (in a greatest case situation) stored in a shared community folder or painstakingly emailed forwards and backwards amongst customers.
In distinction, Sheets incorporates a number of modes of collaborating, starting from the asynchronous—when collaborators work independently and principally at completely different instances, in the identical file—to real-time simultaneous collaborative modifying. With asynchronous modifying, you should utilize the remark characteristic to alert individuals to questions or issues and assign them duties that they’ll mark full after they end them.
Good chips put fast data on the person’s fingertips with out their having to click on out of the doc. For instance, individuals chips determine the individual accountable for particular duties and supply a hyperlink to their contact data, whereas file and calendar occasion chips put context and extra supplies at hand. Mixed with the timeline view characteristic, which allows customers to visualize time-associated information, sensible chips make Sheets a superb hub not just for monetary evaluation but in addition as a hub for actions and data, together with all features of initiatives.
Modifying a spreadsheet stay with different colleagues is a robust manner of working. The productiveness of two or three people who find themselves all extremely expert with Google Sheets shortly constructing out a monetary or working mannequin collectively in actual time is a exceptional sight in comparison with the outdated manner of working. The a number of cursors in several colours, shifting throughout the display on the identical time to construct a mannequin, look nearly like a time-lapse video of a portray being created.
There’s additionally room for several types of contributors. Not everybody wants to have the ability to edit a spreadsheet, for instance. View- and comment-only choices keep safety and information integrity whereas granting visibility to those that want it.
Constructed-in Model Management
If you happen to’ve ever had the painful expertise of a spreadsheet crash past restoration that ends in hours of misplaced work, you may need developed the behavior of saving recordsdata steadily. That is superb—if cumbersome—for one individual working alone, however when a number of variations of a file start to flow into amongst colleagues and somebody forgets to replace the file identify, chaos can ensue.
Google Workspace makes it potential to have only one file all through the lifetime of the mission, because of its built-in model monitoring. Accessible via “See model historical past” within the menu, this characteristic means that you can see all edits made to a doc via a useful timeline. It additionally contains the identify of the one who made every change. Each alteration is saved and you may “rewind” to any earlier level within the file’s life, again to when it was first created. Not solely that, however for any particular person cell, you’ll be able to choose “Present edit historical past” and click on again via every edit to see who modified it, when, and to which worth.
This characteristic is offered to each Google Workspace person. Microsoft customers will want both SharePoint or OneDrive to entry model historical past for Excel.
Working at Scale
One of many misconceptions my colleagues and I had once we adopted Sheets was that it could be superb for small calculations—roughly like a sophisticated calculator—however not helpful for bigger fashions or information units. However because it seems, Google Sheets is simply as highly effective as a desktop software. As I display under, Google Sheets can capably deal with massive monetary fashions, and it could actually connect with Google BigQuery to investigate large information units.
For instance, whenever you’re engaged on an M&A mission, one of many many paperwork you’re more likely to want is a monetary mannequin to gather all of the related historic monetary information and numerous forward-looking situations based mostly on drivers. If you happen to typically work on M&A, then you almost certainly have a tendency to start out from a template that accommodates all the pieces you want, akin to standardized monetary statements, valuation calculations, and many others. The present doc then grows over the course of the mission to include monetary and tax due diligence changes into the historic financials, utilizing business/market due diligence to assist the varied situations for monetary projections.
Over the course of a number of months, the file can develop to dozens of tabs with a fancy internet of hyperlinks between them. Sheets not solely handles the massive quantity of interconnected information properly however, because of its model historical past characteristic, you’ll by no means once more yell “Who modified the low cost price?!” when your valuation mannequin output is unexpectedly off.
Analyzing Very Giant Knowledge Units
As I discussed, Google Sheets connects to Google BigQuery, Google Cloud’s information warehouse and analytics engine, which lets you analyze large information units instantly in Sheets. BigQuery can home your whole group’s information and make it out there for analytics use, whether or not for evaluation by area consultants akin to finance professionals or for superior machine studying use circumstances led by an information science workforce.
To display the facility of this course of, I as soon as used the next instance in a Sheets coaching session at work:
- From inside Sheets, I linked to one of many public information units in BigQuery: Chicago taxi journeys. On the time, this contained 195 million rows of information.
- Then I created a pivot desk from the complete information, with the time of day and day of week on the 2 axes, and the variety of journeys as values.
- Lastly, I utilized conditional formatting, akin to utilizing purple to signify peak hours, to make the patterns stand out extra clearly.
Your complete course of took lower than two minutes.
Until you’re within the taxi enterprise, this specific information evaluation is probably not very helpful, but it surely exhibits how shortly you’ll be able to analyze massive information units utilizing the mix of BigQuery and Sheets to successfully acquire and talk insights.
To supply one other instance of Sheets pivot desk utilization, a finance skilled may want to drag information from completely different techniques into one evaluation—maybe one consolidation system holds higher-level information that must be reconciled in opposition to a number of detailed information sources. If your organization makes the info out there via BigQuery, you’ll be able to, with just some clicks, hyperlink every information supply into one spreadsheet and put the related views subsequent to one another. You possibly can then shortly carry out typical spreadsheet calculations proper subsequent to—and utilizing information from—your BigQuery-powered pivot tables or extracts.
You may as well create charts and formulation utilizing information from BigQuery information units. You probably have your whole monetary information in BigQuery, you’ll be able to develop analyses and experiences in a short time.
Connecting to Exterior Knowledge Sources
With the ability to pull information right into a spreadsheet as a way to work with it’s a elementary want for monetary professionals. Google Sheets gives numerous built-in formulation that do that, such because the Googlefinance components, which helps you to pull information instantly from Google Finance. Though not corresponding to knowledgeable service akin to Bloomberg, it’s however a superb software for acquiring public inventory and forex data, like these closing bell costs for Alphabet inventory in January 2018:
There are additionally different, extra basic methods to get information from the net. The performance to extract an HTML desk or checklist instantly from a web site can, for instance, be helpful with monetary, market, or different publicly out there data that you just wish to retrieve and work with.
Connecting to the Complete Google Workspace
Google Apps Script is a robust software that opens nearly limitless potentialities not solely to increase and automate workflows in Sheets, but in addition to attach it with different elements of Google Workspace. This automation software seamlessly connects Sheets, Drive, and BigQuery operations into one workflow. I’ve quite a few examples at work the place now we have used Apps Script to create numerous copies of a template reporting spreadsheet, robotically downloaded completely different monetary data from BigQuery into every of them, after which shared every model with completely different individuals. This ensured that numerous groups might see solely their very own delicate information, like prices.
Does Google Sheets Have Any Disadvantages?
I’ve been evangelizing Google Sheets. Nonetheless, not everyone seems to be bought on its advantages but. And I feel that’s due to considered one of Sheets’ drawbacks: A lot of its advantages rely upon collaboration with others, and also you’ll discover that uneven adoption in your group will place limits on how briskly you’ll be able to take full benefit of a few of the options.
Additionally, Google Sheets, like several software program, can have its small annoyances, akin to a keyboard shortcut or two that aren’t what you’ll anticipate or a characteristic that’s lacking or doesn’t behave the best way you need. In lots of circumstances, although, these annoyances are primarily an issue for customers nonetheless habituated to Excel relatively than a purposeful weak point of Google Sheets.
One other downside is that Excel’s success depends on its ecosystem of plugins, lots of which aren’t (but) out there for Google Sheets. Which means should you can’t replicate what you want with Google Apps Script, utilizing Sheets means you might must toggle between each purposes.
Enhanced Collaboration Wins Out
Spreadsheets are one of the vital essential instruments, if not the most essential software, for a lot of finance and enterprise professionals. They’re our canvases, our notepads, and our devices. Over the course of our careers, we spend 1000’s of hours utilizing them. We’d like our experiences with them to be nice and environment friendly.
I’ve seen large productiveness advantages from the collaboration options and different improvements that include utilizing web-based productiveness purposes like Google Sheets as in comparison with their conventional desktop counterparts. Cloud-based Microsoft 365 has grow to be extra sturdy lately, however its collaborative performance nonetheless has not completely caught up to in the present day’s calls for.
There are additionally immense productivity-enhancing advantages from studying to make use of these instruments past the elementary stage, as I hope I’ve demonstrated. With traits akin to elevated distant collaboration and the necessity to analyze ever-larger information units persevering with, discovering the functionalities that give you the results you want is essential, and the enterprise case for evaluating Google Sheets retains getting stronger.
This text has lately undergone a complete replace to include the most recent and most correct data. Feedback under could predate these adjustments.
Additional studying on the Toptal Weblog:
[ad_2]
