Office Mastery

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 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 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 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/

Try these 14 INDEX switches to control the layout and output of your Word Index:
https://officemastery.com/word-index-switches

How to use images from a variety of different sources to add a professional touch to any spreadsheet.

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



Check out our Excel courses.
🔹 Beginners Excel Bootcamp: https://officemastery.com/beginners-excel-bootcamp
🔹 Excel Mastery: https://officemastery.com/excel-mastery

Using Images to Add Visual Interest and a Professional Finish to Any Spreadsheet How to use images from a variety of different sources to add a professional touch to any spreadsheet.

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/

Supercharge Your Cut and Paste: Popular Methods, Shortcuts and 2 Smarter Approaches 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.

Have you ever wondered what the function keys (F1 to F12) on the top row of your keyboard are for?

Here is a quick run down.
https://officemastery.com/function-keys/



Check out our course for people just starting out on computers - Computers for the Terrified!
https://officemastery.com/computers-for-the-terrified/

What do the function keys (F1 to F12) on the top row of my keyboard do? The function keys that run across the top row of your keyboard do different things in different programs. Here is an overview.

So, you've set up your Excel data. Now it's time to let loose with some formulas and functions.

Discover how to simply your formulas and bring the magic.

https://officemastery.com/excel-functions-for-beginners/



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

5 Excel Functions for Beginners: Simplify Your Formulas and Release the Magic Discover some starter Excel functions for beginners that let you simply your formulas and bring the magic.

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/

Excel Auditing Checklist: 2 Auto Features and 4 Tools to Quickly Identify and Rectify Errors BEFORE You Publish 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 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

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

Want to bring life to your dull black and white spreadsheet?
🔸
Discover 14 quick and easy tools in Excel to format a spreadsheet and make it look fantastic. A beginners guide.
🔸
https://officemastery.com/format-a-spreadsheet-beginners-guide/
🔸

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

14 Quick and Easy Ways to Format a Spreadsheet: Beginners Guide Discover a wonderful array of tools to format a spreadsheet and make it look fantastic.

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

10 Steps to a Perfect Print Page Setup in Excel With Auto-Repeat Headings and Controlled Page Breaks Spend time on page setup. Repeat headings automatically, control page breaks, create headers & footers and set margins and orientation.