- 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
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 Masterclass
- Part 1 - My Top Ten (10) Hacks and Tips
- Part 2 - Excel Interface
- Part 3 - Workbooks and Worksheets
- Part 4 - Formatting
- Part 5 - Organising 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
Check out more details
here.
About OfCourse Learning:
OfCourse Learning is a lifestyle and self improvement online learning platform. They cater for a variety of needs from well being courses such as, CBT and NLP to career based courses covering relevant topics for Personal Assistants and Human resource employees. They also carry a good selection of Hobby style courses such as, Music, art and many more.
All of the courses are video led, with supplementary PDF material and the majority include multiple choice assessments. Once a purchase has been made you will receive instant unlimited access to the course, tutor and other fellow students via the course forum. An automatically generated certificate will be awarded on completion of any of their courses.
Conditions
Valid from Mar 8, 2019
Expires Jun 8, 2019
Limit: 10 per user and 10 as gift for others
Customers need to register with OfCourse in order to take part in the course. One coupon is valid for one course only. Valid only for the specified course. Non-transferable. Course must be completed by the original purchaser or gift recipient only. Cancellation of registration/enrollment will make the coupon void. No refunds unless required by law. No cashback. Not to be used with any other offer.
See the rules that apply to all deals.
Sold by
OfCourse Learning
Business in Trade