Earn And Excel Courses

MS Word 365 Module 2 written materials

2.1 Formatting big docs at a glance and applying headings

2.2 Explanation of headings

2.3 Spell check

2.4 Spell check cont'd

2.5 Removing extra paragraph and bullet spaces

2.6 Follow up formatting removing bulleted list spaces

MS Word 365 Module 3 written materials

3.1 Inserting a page break

3.2 Creating a table and entering data-text

3.3 Creating a table and entering data-text cont'd

3.4 Creating a table from scratch

3.5 Creating a table from scratch cont'd

3.6 Creating a table – borders and shading

3.7 Creating a table - text direction and shading

MS Word 365 Module 4 written materials

4.1 Preset margins

4.2 Orientation

4.3 Alignments and indenting

4.4 Margins manual adjustment

4.5 Formatting underline and bold

4.6 Cut and paste

4.7 Copy and paste

MS Word 365 Module 5 written materials

5.1 Applying bullets and picture bullets

5.2 Numbered list

5.3 Basic multilevel list

5.4 Paragraph numbering

5.5 Multilevel list with headings

5.6 Inserting a cover page

MS Word 365 Module 6 written materials

6.1 Convert text to table

6.2 Inserting and deleting rows and columns

6.3 Convert text to table with tabs

6.4 Working with text boxes

6.5 Working with text boxes cont’d

6.6 Linking text boxes

MS Word 365 Module 7 written materials

7.1 Building block explanation

7.2 Creating a building block from scratch

7.3 Delete a building block

7.4 Insert automatic date and time + update field

7.5 Section breaks

7.6 Text flow options

MS Word 365 Module 8 written materials

8.1 Insert header with building blocks

8.2 Insert footer with building blocks

8.3 Inserting page numbers and modifying where it starts

8.4 Insert header manually

8.5 Insert footer manually

8.6 All different views within Word

MS Word 365 Module 9 written materials

9.1 Find and replace

9.2 Creating shapes with fill and gradients

9.3 Adding text to shapes

9.4 Enter text with text box and group to objects

9.5 Grouping and resizing shapes

MS Word 365 Module 10 written materials

10.1 Insert and format a picture

10.2 Applying page colour

10.3 Applying, viewing and removing a watermark

10.4 Finding pages

10.5 Design a table manually

10.6 Setting repeat header rows

10.7 Removing all formatting and selecting headings

MS Word 365 Module 11 written materials

11. 1 Creating and applying a new style

11.2 Remove style from gallery

11.3 Save Word doc as PDF file

11.4 Viewing recent docs

11.5 Creating a new folder

11.6 Using MS Word translator

11.7 Using a template

11.8 Find and replace font and formatting

Advanced MS Word 365 Module 1 written materials

1.1 Mail merge with wizard

1.2 Manual mail merge

1.3 Mail merge envelopes with wizard

1.4 Mail merge labels with wizard

1.5 Customising the QAT (quick access toolbar)

1.6 Mail merge basic sorting

1.7 Mail merge advanced filtering

Advanced MS Word 365 Module 2 written materials

2.1 Viewing the TOC in different view modes

2.2 Creating and running a macro

2.3 Assigning shortcut key to macro

2.4 Deleting a macro

2.5 Removing extra paragraph and bullet spaces

2.6 Inserting indexes and creating bookmarks

2.7 Deleting indexes

2.8 Deleting bookmarks

Advanced MS Word 365 Module 3 written materials

3.1 Working with master docs

3.2 Inserting and deleting sub docs

3.3 Entering footnotes

3.4 Inserting captions and labels

3.5 Entering cross references

3.6 Creating modifying deleting citations placeholders and bibliography

3.7 Marking legal citations and creating TA

Advanced MS Word 365 Module 4 written materials

4.1 Removing hyperlinks

4.2 Inserting and modifying TOF

4.3 Alignments and indenting

4.4 Protect forms

4.5 Working and proof read with track changes

4.6 Comparing docs

Advanced MS Word 365 Module 5 written materials

5.1 Viewing and amending properties

5.2 Numbered list

5.3 Making a document as final

5.4 Adding and removing password to protect a doc

5.5 Restrict editing a doc

5.6 Inserting a cover page

5.7 Inserting non MS digital signature not secured

5.8 Changing style and automating captions

Intro to VBA

6. Building Logic with Select Case

7. The Importance of Loops

8. Introduction to Automation

9. Loops and Selecting Ranges

10. Manoeuvring and Macros

11. Constants and Variables

12. The MOST important line in VBA you need to know!

13. Putting together everything so far to demonstrate Automation

14. Macro File Formats

15. Developer Tab and Macro Security

16. Modules, Macros and Relative References

17. A first look at Buttons

18. Charting driven by Macros

19. Why Macros can go wrong and what to do about it

20. Handling Errors and Sheet issues

1. Introduction and Creating an MS Word Invoice from Excel

1a Word Invoice Generator

2. Gathering Data from MS Word documents in to Excel (Change Control Form)

3. Purchase Order System: Part 1 – Excel To Word

4. Purchase Order System: Part 2 – The Word Template

5. Purchase Order System: Part 3 – Save & Print Button

6. Purchase Order System: Part 4 – Word To Excel