Microsoft Office Bundle

Course details

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.

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 Updated on 23 December, 2018