Course curriculum

  • 1

    Welcome to the Course!

  • 2

    Introduction to Power Platform

    • Introduction to Power BI

      FREE PREVIEW
    • Introduction to Power Apps

    • Introduction to Power Automate

    • Introduction to Power Virtual Agent

    • Setting Up a Trial Environment

    • Introduction to Power Platform

  • 3

    Understanding Apps

    • Understanding Apps

    • Types of Power Apps

    • Canvas

    • Portal Apps

    • Build your Power App

    • Customise your PowerApps

    • Automate your App

    • Add a new a screen

    • Add the Home button

    • Create your home screen

  • 4

    Understanding Power Automate

    • Introduction to Robotic Process Automation

  • 5

    Understanding Power Virtual Agents

    • Steps for creating your first bot

  • 6

    Understanding Power BI

    • Building standard Visualizations

    • Introduction to Power BI Service

  • 7

    Virtual Sessions

    • Session 1

    • Session 2

  • 8

    Process Automation with Power Automate and Power BI

    • How Power BI Started

    • 4 Applications of Power Platform

    • What is Power BI

    • What Power Automate can do

    • Process Automation-

    • 4 Applications of Power Platform(David Brown Version)

    • Creating Folders in Outlook

    • Interface of Power Automate

    • Flow design in Power Automate

    • SharePoint Folder for database

    • Connecting Power BI to SharePoint

    • Understanding Power Query

    • Refresh in Power BI

    • Publishing in Power BI

    • Settings in Power BI service

    • Flow design for dataset refresh

    • Outlook, Sharepoint and Power BI practical flow

  • 9

    Evaluate the virtual classroom course

    • Instructions

    • Evaluate & get your Certificate

    • How to Attach your Certificates to your LinkedIn Profile

Top selling courses

  • $1,200.00

    $1,200.00Advanced Financial Modeler Virtual Training

    Buy Now
  • $750.00

    $750.00Reporting & Analytics with Power BI Virtual Training (5 Weeks, 6 sessions)

    Buy Now
  • $199.00

    $199.00Microsoft Excel Fundamentals for Analysts

    Buy Now
  • $99.00

    $99.00Report Automation in Modern Excel

    Buy Now

Some of Our Clients

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

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 training@dbrownconsulting.net 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(s)

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.

Wale Yusuf

Microsoft MVP & MCT

Adewale is a Microsoft Most Valuable Professional (MVP) in the Data Platform and a Microsoft Certified Trainer (MCT) in Business intelligence and analysis, among other certifications he is a Microsoft certified Solution Associate and a Microsoft Certified Power Platform Functional Consultant. Wale facilitates our Data Analytics courses including, Excel, Office 365, Power BI, Power Apps and Advanced Presentation Skills. He is passionate about impacting knowledge to the community and currently leads many usergroups and communities driving Data Analytic Competencies.

David Abu

Microsoft MVP & MCT

David is a passionate trainer who specializes in business intelligence using Power B.I, Power Query, reporting and visualization using DAX. David is a is a Microsoft Most Valuable Professional (MVP)in the Data Platform and a Microsoft Certified Trainer in Business intelligence and analysis, among other certification he is a Microsoft certified Solution Associate and Professional in BI Report.