Course Description

This Virtual course is designed to Sharpen your Excel, PowerPoint, Word, Outlook, and Office 365 Apps skills to triple your productivity on the job. This is not a beginner course but highlights the most efficient and time-saving features of these applications. The course highlights many shortcuts, tips, and tricks to make you more productive and efficient on the job you do. This course has 220 Lessons which you would need to cover within a study time not less than 68.1 hours. By the end of this course, you would be able to:

  • Practice the basic features of Office 365 via an e-Learning platform.

  • Organize and manage email productively with Outlook.

  • Implement advanced rules and automations in Outlook. Understand the best scenarios to use Microsoft Teams to stay organized and build effective team collaboration tools.

  • Identify and practice best practices for handling the most common analysis challenges in Excel. Recall our top 5 productivity tips for the latest version the major applications in the Office 365 suite.

  • Interpret exactly how the Excel engine works and use this knowledge to proffer solutions to various case study-based exercises in class.

  • Apply the most productive Automation features available in Word to cut down document creation and editing time.

  • Effectively utilize similar features across the office suite: shapes, tables, pictures, SmartArt.

  • Build engaging presentations by harnessing storytelling tools in PowerPoint.

  • Engage your audiences by applying our productive structured approach to preparing presentations.

  • link Excel, Word, and Outlook to automate mail merge and bulk document processing.

Countdown timer

Use this section to create urgency for your offer.

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Course curriculum

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

    1. Virtual Course Overview

      FREE PREVIEW

    2. Getting Ready for Virtual Training

    3. How to use this Platform

    4. How to use our Virtual Training Platforms

    5. Course Brochure & Agenda

      FREE PREVIEW

    6. Course Manual

    7. Your Expectations

    8. Ask the Trainer

      FREE PREVIEW

    1. What is Office 365?

    2. Sign in to Office

    3. Working from anywhere with Office.com

    4. Update your Profile on Office 365

    5. How to change your Office 365 Password

    6. Getting Office 365 on your Android Phone

    7. Getting Office 365 on your iPhones & iPads

    8. Office 365 on Windows phones

    9. How to Setup One Drive for Business

    10. How to Setup a SharePoint Site

    1. Overview of Office 365

    2. Create, Save & Open Files

    3. Create a File from a Template

    4. Renaming your Files

    5. Switch between Online and Desktop

    6. Zoom in or out

    7. View files in Split and multiple windows

    8. Preview and Print Files

    9. Office 365 Basics Quiz

    1. The Microsoft Word Interface

    2. What is Word

    3. Create a Document

    4. Add and Edit Text

    5. Add and Format Text

    6. Create and Format a document

    7. Creating bulleted and numbered lists in Word

    8. Research, edit, and design in Word

    9. Changing Line Spacing in Word

    10. How to Apply Styles to your Document

    11. How to Apply Themes to your Document

    12. Inserting Headers and Footers in your Document

    13. Inserting and Modifying Page Numbers in your Document

    14. Working with Page Breaks

    15. Word 2016 for Windows keyboard shortcuts

    16. Chapter Quiz

    1. Lab 01 - How Excel Works

    2. What is Excel

    3. How Excel Works

      FREE PREVIEW

    4. Managing Dates, Validations & Format Styles

    5. Advanced Formatting in Excel

      FREE PREVIEW

    6. Excel Formatting Syntax

    7. Reporting Framework & the 7 Golden Rules of Data

    8. The role of the Control & Report Sheets

    9. Using the VLOOKUP Function

    10. Working with the Excel Table Tool

    11. Planning your PivotTable reports with Fields List

    12. Creating a simple PivotTable Report

    13. Chapter Quiz

    1. What is PowerPoint

    2. Create and Format a Presentation in PowerPoint

    3. Design in PowerPoint

    4. Working with the Slide Master

    5. Align Objects in PowerPoint

    6. Stacking Shapes, Pictures and Objects

    7. Add, rearrange, duplicate and delete slides

    8. Apply a Slide Layout

    9. Using Themes in PowerPoint

    10. Inserting Pictures in PowerPoint

    11. Adding a Background Picture to your slide

    12. Add or record Audio in your slides

    13. Chapter Quiz

About this course

  • $750.00
  • 187 lessons
  • 1 hour of video content

Other courses for you

  • $2,000.00

    $2,000.00Advanced Financial Modeling Course

    Buy Now

  • $1,200.00

    $1,200.00Reporting & Analytics with Power BI

    Buy Now

  • $199.00

    $199.00Microsoft Excel Fundamentals for Analysts

    Buy Now

What People Have to Say...

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. ”

Rasheed Davis

“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”

Ipigansi Okumo

“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.”

Otti Grant Onyeukwu

“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.”

Akinwunmi Bello

“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”

Tomilola Sadare

“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.”

Adebayo Aderohunmu

Some of our Clients

FAQ

  • How does Virtual Training Work?

    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.

  • How long is each Virtual Session?

    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.

  • How long do I have access to the course content and platform?

    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.

  • Can I defer my Session?

    Deferral requests are treated on a case by case basis. Please email [email protected] with your request.

  • Are the videos available offline?

    Our videos are only available for streaming online. But you can download all exercise files and materials.

Instructor

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.