2016

Word 2016 – 1.5.2 – Change the Page Orientation

We’ll see how easy it is to change the Orientation of the page from Portrait to Landscape – and back again.

DETAIL

Word 2016 – 1.5.1 – Create and Remove Page Breaks

This video shows you how to create Page Breaks where you want to place them. Then we look at how to delete Page Breaks, that you no longer need.

DETAIL

Word 2016 – 1.4.5 – Create/Remove Numbering

We’ll use the Numbering button to quickly and easily create or remove a Numbered List, but we’ll also look at when you should apply them.

DETAIL

Word 2016 – 1.4.4 – Create/Remove Bullets

We’ll use the Bullets button to quickly and easily create or remove a Bulleted List, but we’ll also look at when you should apply them.

DETAIL

Word 2016 – 1.4.3 – Change the Line Spacing

We’ll see where the default Line Spacing is displayed, and what it is. Then we’ll look at a quicker way of changing the Line Spacing – and setting it back to the default.

DETAIL

Word 2016 – 1.4.2 – Indenting Paragraphs

We’ll take a look at the buttons used for Indenting and ‘Outdenting’ our text. However, they only affect the left-hand side of the text, so we’ll also look at how you set Indents on the right-hand side of a paragraph.

DETAIL

Word 2016 – 1.4.1 – Paragraph Alignment

This video brings you through the four Paragraph Alignment buttons and how to use them.

DETAIL

Word 2016 – 1.3.8 – Can You Modify a Quick Part?

In previous videos I’ve mentioned that to modify a Quick Part, you just recreate it and save it over the previous one, with the same name. This video just demonstrates that for you.

DETAIL

Word 2016 – 1.3.7 – Delete a Quick Part

Now you know how to create a Quick Part, but where do you go to delete a Quick Part? This video shows you exactly that.

DETAIL

Word 2016 – 1.3.6 – Create a Quick Part

If you want to create your own Building Block, then you create it as a Quick Part. This video shows you how this excellent feature works.

DETAIL

Word 2016 – 1.3.5 – Understand Building Blocks

Understand what Building Blocks are and look at a small selection of them and see how to apply them.

DETAIL

Word 2016 – 1.3.4 – Understand Compatibility Mode

Older Word documents will open automatically into ‘Compatibility Mode’. This means some features that you might like to use, will not be available. See how to recognise when you’re in this mode, and how to convert to the latest version.

DETAIL

Word 2016 – 1.3.3 – Using the Format Painter

Another lovely feature that you really must know, is the Format Painter. Features like this, save hours of work!

DETAIL

Word 2016 – 1.3.2 – Using Basic Styles

There are a number of Styles that are available to use, the most common being the Heading 1 style and the Heading 2 style. We’ll take a quick look at these and see that once we use them, more Styles become available.

DETAIL

Word 2016 – 1.3.1 – Using the Mini Toolbar and Ribbon

We’ll look at changing the Font type and size using different methods. We’ll also change the Font colour and see that we have a Live Preview to help us make a choice.

DETAIL

Word 2016 – 1.2.1 – Select Text Mainly Using the Mouse

Click and drag is not the only way to select text. In fact, there are many other ways, and generally, they would be more efficient than click and drag. We’ll look at some of those ways, in this video.

DETAIL

Word 2016 – 1.1.8 – Use Help

We’ll take a look at using the Help feature and also see the different options that are provided, within that window.

DETAIL

Word 2016 – 1.1.7 – Print Preview

Before printing a document you should always look into Print Preview to get an overall view of it. We’ll also take a look at some of the options contained in the Preview area.

DETAIL

Word 2016 – 1.1.6 – Open, Edit and Save Changes to a Document

We’re going to open up the document we created in the previous video, make a small change, then Save that change.

DETAIL

Word 2016 – 1.1.5 – Create Folder, Save, Name and Close a Document

We’ll create a Blank document, quickly fill in some text, then Save and Close that document.

DETAIL

Word 2016 – 1.1.4 – View and Customise the Rulers

I like to work with the Rulers turned on permanently, so this video shows you how to turn them on. The default measurement of Rulers is to be in centimetres but you might prefer to use inches, so we’ll also see how to make that change.

DETAIL

Word 2016 – 1.1.3 – Customise the Ribbon

Learn how to create your own Ribbon tab, add commands to it, remove commands from it and then finally, how to delete your tab.

DETAIL

Word 2016 – 1.1.2 – Customise the Quick Access Toolbar

See how to add the commands you use the most, to the Quick Access Toolbar, how to remove commands and how to adjust their position. Once you have done this, you can close the document without saving and those commands will still be there next time you open Word.

DETAIL

Word 2016 – 1.1.1 – Open Word and Explore the User Interface

This video will help you to become familiar with some of the different components that make up the Word interface.

DETAIL

Excel 2016 – 3.12.6 – Move a Macro into the Personal Workbook

This video shows you the steps to take to move a Macro into the Personal Workbook, so that it is available to all Excel Workooks on your computer. This will be done using the VBA Editor. You will also see how to delete a Macro – and at the end of the video, you’ll see […]

DETAIL

Excel 2016 – 3.12.5 – Create a Button for a Macro

We’ll place a button onto the Quick Access Toolbar, then attach our Macro to it, so it is easy for us access, for future use.

DETAIL

Excel 2016 – 3.12.4 – Open a Workbook Containing a Macro

This video shows you the Security message that you should receive when you open a Workbook with a Macro in it. It will also explain why you get this message.

DETAIL

Excel 2016 – 3.12.3 – Save a Macro in a Workbook

Macros cannot be saved into .xlxs Workbooks, for security reasons. This video brings you through the steps required to save the Macro.

DETAIL

Excel 2016 – 3.12.2 – Create a Macro

The Macro that we are going to create involves four separate steps that we find ourselves doing on most of our Excel sheets. This video brings you through the steps required to create that Macro.

DETAIL

Excel 2016 – 3.12.1 – What is a Macro?

This video explains what a Macro is and shows us the Macro that we will be creating throughout these lessons.

DETAIL

Excel 2016 – 3.11.8 – AGGREGATE as a LOOKUP

Another great way to use this fabulous function, with a bit of mixed Absolute/Relative referencing thrown in.

DETAIL

Excel 2016 – 3.11.7 – AGGREGATE Like SUMPRODUCT

This is one for all the Excel nerds out there (you know who you are). This one shows you the structure to use if you want to add Conditions to the calculation.

DETAIL

Excel 2016 – 3.11.6 – Ignore Error Values Using Array Form

Just when you think it can’t get any better – it does! I love it!

DETAIL

Excel 2016 – 3.11.5 – Ignore Error Values Using Reference Form

See how to calculate right through a bunch of errors. This is SO brilliant!

DETAIL

Excel 2016 – 3.11.4 – Using the Array Form with SMALL

We’re looking at using the SMALL function on it’s own, then we’re looking at using it through the AGGREGATE function. This will show you when you would use one above the other.

DETAIL

Excel 2016 – 3.11.3 – Using the Array Form with LARGE

We’re looking at using the LARGE function on it’s own, then we’re looking at using it through the AGGREGATE function. This will show you when you would use one above the other.

DETAIL

Excel 2016 – 3.11.2 – Using the Reference Form with SUM

We’ll look at using 4 functions that do the same thing, and look at why you would use one over the other.

DETAIL

Excel 2016 – 3.11.1 – About the AGGREGATE Function

This function has the ability to replace 19 other Excel functions! Definitely one to know.

DETAIL

Excel 2016 – 3.10.8 – Calculate a Table of Values

Learn here how to combine conditions and calculations in a Table using the SUMPRODUCT Function.

DETAIL

Excel 2016 – 3.10.7 – Using Three Conditions

This video will show how to structure three conditions and two arrays of values – which means there will be five separate selections inside this SUMPRODUCT function.

DETAIL

Knowledge Market in Your Business

Knowledge Market is a great source for online video tutorials. We have developed a range of topics based on the applications that you use every day.
So whether you wish to refresh your existing knowledge - or you want to learn something new - we've got everything you need when you need it and where you need it.

Membership

Our Membership options have been developed to suit your specific needs. Contact us today to find out how we can be part of your office support infrastructure.

CONTACT

Email: kelly@knowledgemarket.ie

Performance Support and Learning for:
Microsoft Office – Excel, PowerPoint, Project, Word

Privacy & Cookies

This website uses Cookies. Continued use of the site will be deemed as your acceptance of this necessity.

Please read our Privacy Policy