Capacity Development Masterclass
Learn Excel, PowerPoint, Word, Outlook and Office 365 Apps and triple your productivity on the Job. This is not a beginner course, but highlights the most time saving features of these applications.
As a virtual Course you need to complete all this prework before the end of the 4 Week period. Please visit the Virtual Sessions section for Details on Links and Assignments
Virtual Course Overview
Getting Ready for Virtual Training
Register for the Virtual Sessions
How to use this Platform
How to use our Virtual Training Platforms
Course Manual
Your Expectations
Ask the Trainer
What is Office 365?
Sign in to Office
Working from anywhere with Office.com
Update your Profile on Office 365
How to change your Office 365 Password
Getting Office 365 on your Android Phone
Getting Office 365 on your iPhones & iPads
Office 365 on Windows phones
How to Setup One Drive for Business
How to Setup a SharePoint Site
Overview of Office 365
Create, Save & Open Files
Create a File from a Template
Renaming your Files
Switch between Online and Desktop
Zoom in or out
View files in Split and multiple windows
Preview and Print Files
Office 365 Basics Quiz
The Microsoft Word Interface
What is Word
Create a Document
Add and Edit Text
Add and Format Text
Create and Format a document
Creating bulleted and numbered lists in Word
Research, edit, and design in Word
Changing Line Spacing in Word
How to Apply Styles to your Document
How to Apply Themes to your Document
Inserting Headers and Footers in your Document
Inserting and Modifying Page Numbers in your Document
Working with Page Breaks
Word 2016 for Windows keyboard shortcuts
Chapter Quiz
Lab 01 - How Excel Works
What is Excel
How Excel Works
Managing Dates, Validations & Format Styles
Advanced Formatting in Excel
Excel Formatting Syntax
Reporting Framework & the 7 Golden Rules of Data
The role of the Control & Report Sheets
Using the VLOOKUP Function
Chapter Quiz
What is PowerPoint
Create and Format a Presentation in PowerPoint
Design in PowerPoint
Working with the Slide Master
Align Objects in PowerPoint
Stacking Shapes, Pictures and Objects
Add, rearrange, duplicate and delete slides
Apply a Slide Layout
Using Themes in PowerPoint
Inserting Pictures in PowerPoint
Adding a Background Picture to your slide
Add or record Audio in your slides
Chapter Quiz
10,000+ people are learning on our platform
“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended. ”
“Excel Essentials for Reporting is a wonderful course. It unearths the secrets on which Excel is built and presents it in a very simple manner. I found a solution to a problem I have grappled with for a long time in this course. DBrown training did a great job that deserve to be commended. Thank you for this course and may your reward be great in your chosen enterprise of expanding the frontiers of knowledge in the IT industry. Regards. Engr. Okumo Ipigansi”
“Your course on Report Automation in Modern Excel is indeed an eye opener as to the many possibilities in Microsoft Excel. The training is superb and very informative with great content. I enjoyed every minute of the videos and it has provided me with a greater level of understanding, additional skills and knowledge, to aid my numerous tasks in the office. Report Automation in Modern Excel is suitable for all who analyze data. The course delivery is excellent. DBrown Consulting, please keep it up.”
“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”
“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”
“I particularly love the flow of teaching, its unconstrained. Also, the fact that you are spurred to practise on your own, and tweak as you are taught - not been spoonfed. I am always waiting for the release of the next class. Thank you David.”
You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.
Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.
You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.
Deferral requests are treated on a case by case basis. Please email [email protected] with your request.
Our videos are only available for streaming online. But you can download all exercise files and materials.