Microsoft 365 or Office 2021: What should you choose?

microsoft Mar 04, 2021
Office 2021 or Microsoft 365? Why are there two competing products by Microsoft? What to look for when considering the best choice for you?

A brief history of Office software provisioning and consumption

Historically, Microsoft dominated the personal computing operating system, named Windows since 1985.

Watching successful productivity software take root in the office worker PC, offering word processors, electronic spreadsheets and database-centric applications, Microsoft did what it proves to do best every time: re-invent great innovations, creating highly appealing user experience,...

Continue Reading...

How to Create Your Own Web Service with Google Apps Script and Call it from Excel VBA

Ever needed to perform some Web task in service of your Excel VBA application? You can write your own web-service to do whatever you need * Popular use cases: access Google Sheets, Docs, Presentations, email and calendar from your Excel application!

Calling Web-services from Excel VBA

As I thoroughly explain and demonstrate in my online course: Beyond Excel Boundaries with VBA: Office, Files and Internet, you can send any HTTP request over an Internet connection from VBA using the WinHttp service library. Here’s a code snippet to send a request to some URL:


Continue Reading...

Microsoft Office vs. Google Office Suite – How Will This Battle Turn Out?

Microsoft dominates the Enterprise. Google Offers native “cloud” office solutions. Microsoft is storming the cloud with full power. Google is widely used for email, web-search and gaining a foothold in Enterprise too. How will this play out?

The idea for this Blog post came as I was forwarded a similar question on Quora to answer. I’ll offer my perspective for the discussion on this question.

  1. Microsoft was always best at identifying new tech trends too late, but successfully bridge the gap and win the market. That’s because they’re much better as a marketing...
Continue Reading...

Google Spreadsheets vs. Microsoft Excel: What Should You Choose?

You know an electronic spreadsheet is the right tool for your need, but you’re not sure which of the available products to choose. Two prominent options are suggested: Google Spreadsheets and Microsoft Excel. Let’s make it easier for you

First, let’s consider your requirements. The following list will help us frame the discussion:

  • Do you need multiple users to concurrently work on the solution, or can one person at a time exclusively work on it?
  • Do you need pixel-perfect visual design with wide flexibility over fonts, colors, forms design etc.?
  • Does the solution needs to...
Continue Reading...

Microsoft is Storming the Cloud. What’s the Future of VBA? Impressions and Thoughts from a Microsoft Meeting

Last Sunday was our monthly meeting at Microsoft's Offices in Raanana, Israel. We are Israel's Excel Masters - developers and trainers mostly. We meet once a month at Microsoft's office to learn new things and engage in discussions with Microsoft's managers * Below are my key takeaways and predictions from this meeting with Microsoft's Collaboration Customer Success Manager, Maor. Do we know what is the future of Excel VBA?

Cloud Cloud Cloud

Maor, who's leading the Collaboration Customer Success with the Large Enterprises in the local market, presented Microsoft's future (cloud, cloud,...

Continue Reading...

50% Complete

Two Step

Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!