Are you also proficient in both applications? Do you believe the differences are significant, aside from the absence of Power Query? How well does your familiarity with Excel translate to Google Sheets?
Hey! I switched to Google Sheets 'coz it just feels more snappy and easy to access on different devices. Some Excel formulas work a bit different, but once you get used to it, it’s a breeze! Plus, i love not having to install updates al the time haha.
In my experience, transitioning from Excel to Google Sheets was quite smooth, especially because the core functionalities are quite similar. While Excel is definitely more powerful when it comes to handling larger datasets and offers advanced features like Macros, Google Sheets shines in collaboration and real-time updates. If your work is more collaborative in nature, you might find Google Sheets more beneficial. Also, Google’s support for apps script can make up for some Excel-lacking functions, bridging a bit of that gap.