Earn And Excel Courses

MS PowerPoint 365 Module 2 Notes

2.1 Shapes filled with pictures

2.2 Arranging Shapes 1

2.3 Arranging Shapes 2

2.4 Aligning, grouping and resizing shapes

2.5 How to use shapes

2.6 Merging vs Grouping

2.7 Shapes - all merging options

2.8 Creating customised shapes

MS PowerPoint 365 Module 3 Notes

3.1 Working with SmartArt 1

3.2 Working with SmartArt 2

3.3 Organisational chart - Manual vs SmartArt

3.4 Organisational chart - more tips

3.5 Arrow diagram

MS PowerPoint 365 Module 4 Notes

4.1 Guides, Rulers & Gridlines

4.2 Smart Guides and shapes

4.3 Smart Guides and text boxes

4.4 Inserting and formatting text plus setting up tabs

4.5 Changing margins within shapes

4.6 Working with bullets

MS PowerPoint 365 Module 5 Notes

5.1 Working with sections

5.2 Creating a Slide Master 1

5.3 Creating a Slide Master 2

5.4 Slide Master placeholders

5.5 Slide Master change placeholder shape

5.6 Slide Master change placeholder points

5.7 Changing default style to shapes and text boxes

MS PowerPoint 365 Module 6 Notes

6.1 How to insert Excel data within PowerPoint

6.2 How to insert Excel chart within PowerPoint

6.3 How to create a chart within PowerPoint

6.4 Animating Excel Charts in PowerPoint

6.5 Adding Elements to Excel Charts in PowerPoint

6.6 Working with Word in PowerPoint

6.7 Word outline in PowerPoint

MS PowerPoint 365 Module 7 Notes

7.1 How to add slide numbers

7.2 Mergers and Acquisitions presentation

7.3 Shapes with gradient fill

7.4 Shapes – copy format and edit points

7.5 Shapes – formatting lines and arrows

MS PowerPoint 365 Module 8 Notes

8.1 How to add footnotes

8.2 How to check for consistency

8.3 Reviewing slides with markups

8.4 Inserting tables

MS PowerPoint 365 Module 9 Notes

9.1 How to create a logo slide

9.2 Design Ideas on and off

9.3 Spell check

9.4 Adding notes and printing slides and handouts

Introduction to VBA

6. Building Logic with Select Case

7. The Importance of Loops

8. Introduction to Automation

9. Loops and Selecting Ranges

10. Maneuvering 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

Introduction

1. Why PowerPoint?

2. Introduction to the Object Model

3. Programming in PowerPoint 1: Basics

4. Programming in PowerPoint 1: Shapes

5. Programming in PowerPoint 1: Tables

6. Opening PowerPoint from Excel

7. Pasting an Excel range as an Image in PowerPoint

8. Translating Excel data into a table in PowerPoint 1

9. Translating Excel data into a table in PowerPoint 2: Multiple Slides

10. Drawing Shapes in Excel

11. Translating Excel data into Shapes in PowerPoint