Microsoft Office Bundle

This 3-course Microsoft Office Bundle, that will teach you how to master Microsoft Office, Excel and PowerPoint, improve workflow and impress colleagues and clients.

Certificate of completion

Digital certificate - Included

Bundle Highlights

• Includes 447 lectures and 22 hours of content
• Quiz assessment to consolidate your learnings through the course and practical learning alongside the tutorials
• Covers things like spellchecking, email folders, Excel calculations, diagrams and images for your presentations.
• Engage your audience better with creative visuals
• Improve the look and functionality of your presentations.
• Covering a range of topics from printing on Excel to complex formulas, button functions & how to use them for presentations.
• Learn to use Excel for business & professional purposes.

Course Overviews

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

This 3 course bundle is ideal for anyone wanting to improve their Microsoft Office skills

This bundle has no prerequisites