Skip to content
Getting Digital

Office & Productivity Tools Courses

Get more out of the software your workday already runs on, from Excel models to enterprise systems

Nobody is taught the software they use every day. They are shown it once, by a colleague in a hurry, and that is the gap this category exists to close. Three subcategories sit below it: Workspace & Collaboration Tools, Microsoft Office & Excel, and Enterprise Software (SAP & Oracle).

The tools here are learned by absorption rather than by study. Somebody shows you enough to finish today's task, you never go back, and years later you are still doing by hand what the software has automated since before you started. That is a gap you cannot notice, because it never feels like ignorance; it feels like work. Which is why structured instruction in this category repays faster than almost anything else on the site, and why it matters more now that an assistant will cheerfully write you a formula. A confidently wrong spreadsheet travels much further than a visibly broken one, because nobody checks it. Knowing what the answer should look like is the part that did not get cheaper.

Which of the three is yours

Open Microsoft Office & Excel if your day involves numbers in a grid. A spreadsheet is the most widely deployed programming environment in the world and almost nobody is taught it as one, so the gains are unusually blunt: XLOOKUP instead of VLOOKUP and its off-by-one failures, pivot tables instead of manual subtotalling, Power Query instead of the reformatting ritual you perform every Monday morning, VBA only once the rest has run out. Open Workspace & Collaboration Tools if your problem is coordination rather than calculation: shared documents, Google Sheets, permissions that are neither too tight nor wide open, and the automation layer that moves information between applications without a person retyping it. Open Enterprise Software (SAP & Oracle) for a different proposition altogether. These are the systems that run finance, procurement and payroll at scale, they are narrow and deep, and nobody should learn them speculatively; you study SAP or Oracle because your employer runs it or because a posting names it. The blurry boundary lies elsewhere, between a spreadsheet and a database, and these are the signs you have already crossed it:

  • More than one person edits the file, and edits are coordinated by asking in chat who currently has it open.
  • Somebody keeps a second copy, because the shared one is too slow, too locked or too fragile to touch.
  • Formulas reach into other workbooks, so opening the file raises prompts about links nobody can explain.
  • Nobody can say which version is current without checking a filename, a date or a colleague.
  • One sheet holds the data and the rest are attempts to summarise it, each slightly out of date with the others.

Past that point a better spreadsheet course is not the fix. What fits then is a database, PostgreSQL or anything comparable, plus enough SQL to ask it questions, and that puts you in technology & programming rather than here. Recognising the crossing early saves the year otherwise spent building something elaborate, unshareable and impossible to hand over. The opposite mistake is just as common and far less discussed: reaching for a database, or for an automation platform stitched together from triggers, when one well-built spreadsheet would have done the job and stayed readable for whoever inherits it. The test is how many people need to change the same data at the same time. One person, one file, no problem. And if the work has to show up on a CV rather than only in your week, the vendor exams under certifications cover the spreadsheet and analytics end of this directly.

Browse by subject

Workspace & Collaboration Tools

Work faster in the everyday stack - Google Workspace, Apple tools, and the collaboration apps modern teams live in
Explore Workspace & Collaboration Tools

Microsoft Office & Excel

Master the tools on every office PC - Excel from formulas to VBA, plus Word, PowerPoint, and the Microsoft 365 stack
Explore Microsoft Office & Excel

Enterprise Software (SAP & Oracle)

Navigate the systems large companies run on - SAP modules, Oracle applications, and enterprise workflows
Explore Enterprise Software (SAP & Oracle)

Frequently asked

Is an Excel course worth it if I already use Excel every day?
Usually more worth it, not less. Daily use without instruction produces confident habits rather than good ones, and the things you never learned are invisible to you by definition. The quick test: if you have never built a pivot table or cleaned a data set in Power Query, there is a large and immediate gain sitting there. If both are routine for you, the remaining wins are narrower and the better move is probably SQL.
How do I know when to stop learning Excel and learn SQL?
When the data outgrows the person maintaining it. Several editors, a second copy in circulation, formulas pointing at other workbooks, no reliable answer to which version is current: any two of those together mean the spreadsheet is now a database nobody administers. Excel skill still helps at that point, but it helps with the reporting layer, not with the storage problem underneath it.
Which enterprise system should I learn, SAP or Oracle?
Only a system your employer already operates, or one a job advert you are chasing names outright. These are the least transferable skills in the whole directory, since deep knowledge of one is close to worthless for the other, and the courses cost real time. That narrowness is also why the roles pay: supply stays small precisely because almost nobody learns these on spec.
Is there anything to learn about collaboration tools, or do you just use them?
You can use them without instruction, which is exactly why most teams' shared drives are unsearchable. What a course adds is the structural part: naming and permission conventions that survive staff turnover, the difference between a document that is stored and one that is findable, and the automation layer that removes recurring copy-and-paste work between applications. That is organisational skill more than software skill, and it transfers between vendors.
Do these skills still matter when an assistant can write the formula?
They matter more, in one specific sense. An assistant does not know that your regional codes changed in March, or that the source export silently pads numbers as text, so it will produce something plausible and wrong and you will be the only reviewer. Reading a formula, checking a range and sanity-testing a total are now the valuable half of the job. The typing was never the expensive part.

Why Learn Office & Productivity Tools?

Mastery of the tools most careers quietly depend on: Excel from first formulas to automation, the wider Microsoft 365 suite, Google Workspace, and the enterprise systems - SAP and Oracle - that large organizations run on. Small skill gains here compound daily, which makes this one of the highest-leverage course categories.

Last reviewed 26 September 2026 · Getting Digital