Microsoft Office Bundle

Provided by

Enquire about this course

About the course

This Microsoft Office Bundle will teach you everything you need to know to master Microsoft Office, Excel and powerpoint.

In the basic Microsoft Office skills course delivered by a certified trainer, you will learn all the basics and proficiency in the 4 paramount pieces of software. These real life and practical skills are invaluable in the home and the workplace and will enable you to achieve confidence and job satisfaction with practice!

In the Microsoft Excel - 300 Module Masterclass you will acquire the skills needed to turn Excel into a personal business intelligence tool. You will learn creative interactive charts, super dashboards and formulas as well as easy & complex formulas and how to print from partial & full workbooks. You will also learn to format, use for data analysis and manage worksheets using real world examples and step-by-step instructions.

The powerpoint course offers a step-by-step guide through the essential aspects, including improving your workflow and teaching you some useful techniques. Learn how to engage your audience with creative visuals and improve the look and functionality of your presentations. You can impress colleagues, superiors and clients and get more out of your work

​

Curriculum

Microsoft Office Essential Skills

Part 1 - Introduction

Part 2 - Microsoft Office Word Essential Skills

Part 3 - Microsoft Office Outlook Essential Skills

Part 4 - Microsoft Office Excel Essential Skills

Part 5 - Microsoft Office PowerPoint Essential Skills

Part 6 - Next Steps

Quiz

​

Microsoft Excel - 300 Module Masterclass!

Part 1 - My Top Ten (10) Hacks and Tips

Part 2 - Excel Interface

Part 3 - Workbooks and Worksheets

Part 4 - Formatting

Part 5 - Organizing and Working with Data

Part 6 - Numbers, Dates and Formulas

Part 7 - Tables and Pivot Tables

Part 8 - Charts

Part 9 - Creating, Resizing and Modifying Charts

Part 10 - Formatting & Customising Charts

Part 11- Updating & Printing Charts

Part 12 - Working With Text, Pictures, Shapes and Effects

Part 13 - Basic Chart Types

Part 14 - Master Excel Charts

Part 15 - Get Started With Power Pivot and Power View

Part 16 - Calculated Fields - Columns & Dax Formula Language

Part 17 - KPI, Key Metrics and Design Your Dashboard > PART:1

Part 18 - Design Your Dashboard > PART:2

Part 19 - Create an Amazing Sales Map With Power View

Part 20 - Completing Your Dashboard

Part 21 - Analysing a Dashboard With Functions

Part 22 - Beginners: Basic Build-in Chart Types

Part 23 - Formatting & Customising Charts

Part 24 - Graphics for Charts & Dashboards

Part 25 - Dashboards Components: Sparklines - Mini Charts

Part 26 - Advanced Charts & Dashboard Components

Part 27 - Interactive Charts & Dashboards Controls

Part 28 - Analysing a Dashboard With Pivot Tables & Charts

Part 29 - Dashboards: Putting it All Together

Part 30 - The Basics of Macros

Part 31 - Enter the world of VBA

Part 32 - Get in-depth with Macros

Part 33 - How to create your First Piece of Code

Part 34 - Supercharge Macros and VBA with Loops

Part 35 - Ready-to-use Excel Macros

Quiz

​

PowerPoint Masterclass

Part 1 - Introduction

Part 2 - Good practices & necessary knowledge

Part 3 - Design a 14-slide presentation!

Part 4 - More Slide Designs & Ideas!

Part 5 - Finishing touches important to a presentation

Part 6 - BONUS LESSONS: Additional PowerPoint knowledge

Part 7 - Conclusion

Part 8 - Logo Introduction

Part 9 - Logo Intro #1 - Gamer style

Part 10 - Logo Intro #2 - Corporate style

Part 11 - Wrap-up

Part 12 - Quiz

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

Could you be making CV mistakes that are sabotaging your job search? It’s quite possible, and easily fixed, by addressing these common CV mistakes.