Office Mastery

Office Mastery I help people leverage the power of Microsoft Office to get more done in less time! Straight-talkin'. No jargon. Zero 'corporate-speak'.

Gold Coast based Microsoft training company serving individuals through to large multi-national organisations. across the Gold Coast, Northern NSW, Brisbane, Ipswich, Toowoomba, Sunny Coast and everywhere in between. Our Microsoft Certified Trainers will get you onto the right foot, boosting your confidence, slashing hours from your workload and improving your employer’s bottom line. Here we share all our best tips, insights, tidbits, tutorials, news, updates and discounts.

QUESTION: Do computers terrify, confuse or frustrate you (or someone you know)?If I GUARANTEED that you could confidentl...
21/09/2022

QUESTION: Do computers terrify, confuse or frustrate you (or someone you know)?

If I GUARANTEED that you could confidently "drive" your computer in 3 days (or less)

- without wasting another minute on "Dummies" books

- without nagging somebody to help you at every turn

- and master the basic "must have" computer skills ...
.. would you take me up on that offer?

I'm on a mission to help 100,000 people by offering a FREE COURSE to help "beginners" get started.

Doesn't matter if you have no formal computer education, a bad dose of technophobia or you can only type with one finger.

If you're still stuck at square 1, your world could change in just 3 days.

It's free to register, it's online and you can do this at your own pace.

Are you in? 👊

https://officelegends.academy/free-beginners-computer-course/

How do you copy styles between one Word document and another without having to recreate them?Great question.One approach...
21/09/2022

How do you copy styles between one Word document and another without having to recreate them?

Great question.

One approach is to use the Styles Organiser to first copy styles from the source document to the Normal template, then copy styles again from the Normal template to the destination document.

But that can be tedious, especially if you have many documents.

If you have a library of styles that you use a lot, then you can create a macro (and link it to a Quick Access icon) to make the process one-click-simple.

It's not hard, but it does involve a tiny bit of VBA.

So if that's not your cup of tea, move on!

But if you fancy giving it a crack, follow the steps in this post:

A simple macro to copy styles from one doc to another

ATTENTION: Are you frustrated that you're still at square 1 and don’t know your way around a computer? Does every little...
10/09/2022

ATTENTION: Are you frustrated that you're still at square 1 and don’t know your way around a computer?

Does every little thing seem HARD?

Does it seem like everything you touch BREAKS?

If I GUARANTEED that in 3 days or less you could confidently "drive" your computer ...
- without wasting another minute on "Dummies" books
- without nagging somebody to help you at every turn
- and master all the basic computer skills you absolutely must have to move forward ...
.. would you take me up on that offer?

I'm on a mission to help 100,000 people.

To help "beginners" like you get off the starting blocks and take the first few steps.

Doesn't matter if you have no formal computer education or a bad dose of technophobia.

Your world could change in just 3 days.

Are you next?

https://officelegends.academy/free-beginners-computer-course/

Cut & Paste and Copy Paste are 2 of the most common operations you do on your computer.Here are some popular methods and...
14/07/2022

Cut & Paste and Copy Paste are 2 of the most common operations you do on your computer.

Here are some popular methods and shortcuts, plus some smart tools that make this process a whole lot easier.

https://officemastery.com/cut-and-paste-and-more/



Check out the following beginner courses:
https://officemastery.com/computers-for-the-terrified/
https://officemastery.com/beginners-word-bootcamp/
https://officemastery.com/beginners-excel-bootcamp/

How to cut and paste (or copy-and-paste), using some popular methods and shortcuts, plus some smart tools that make it a whole lot easier.

So you've finished your spreadsheet. And it's beautiful. A work of art.Before you distribute your spreadsheet to your co...
05/07/2022

So you've finished your spreadsheet. And it's beautiful. A work of art.

Before you distribute your spreadsheet to your colleagues or to external clients, first use this Auditing Checklist to pick up and rectify any errors.

It's worth spending a few moments now to get this right, rather than suffer the embarrassment ... or worse ... the humiliation that could ensue.

Plus, this post gives you 2 useful things that Excel just does for you because it likes you!

https://officemastery.com/auditing-checklist-excel/



Check out the full Excel Mastery course:
https://officemastery.com/excel-mastery/

Use this Auditing Checklist to pick up and rectify any errors before you share or publish your spreadsheet. Plus 2 useful things that Excel just does for you because it likes you!

New to Excel? It's lonely in the beginning. Everything is foreign and it's hard to figure anything out. And it's easy to...
02/07/2022

New to Excel? It's lonely in the beginning. Everything is foreign and it's hard to figure anything out. And it's easy to be overwhelmed.

Luckily there are 3 places you can go right now to find help in Excel. A beginners guide.

https://officemastery.com/help-in-excel/



Check out the full Beginners Excel Bootcamp course:
https://officemastery.com/beginners-excel-bootcamp

Help in Excel: 3 places you can go as an Excel beginner when everything feels so overwhelming and lonely.

There's nothing worse than getting your spreadsheet just how you want it and then discovering that it's a nightmare to p...
28/06/2022

There's nothing worse than getting your spreadsheet just how you want it and then discovering that it's a nightmare to print.

Nothing fits. Some pages are full while others just have one column. Headings only appear on the first page.

Here are 10 steps to a perfect page setup for printing in Excel including:

🔷 Headings that repeat at the top of each page automaticall
🔷 Pages that break where you want them to
🔷 The best orientation and margin sizing
🔷 Properly constructed headers and footers
🔷 And more ...

https://officemastery.com/page-setup-excel/



Check out the full Beginners Excel Bootcamp course:
https://officemastery.com/beginners-excel-bootcamp
.. or the Excel Mastery course:
https://officemastery.com/excel-mastery

Spend time on page setup. Repeat headings automatically, control page breaks, create headers & footers and set margins and orientation.

Address

Southport, QLD

Website

Alerts

Be the first to know and let us send you an email when Office Mastery posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Office Mastery:

Shortcuts

Featured

Share

Category