Report Automation in Modern Excel

Create Magic with Power Query & Excel | taught by David Brown
  • 51 Videos
  • 9 Quizzes
  • 2 Surveys
  • 2 Multimedia
  • 11 Texts
  • 3 PDFs
  • 9 Disqus
  • 10 Downloads
  • 8.0 hrs

Course Curriculum

Course description

The Course will take you through a robust methodology for automating all your dashboards or reports.

The methodology will save you significant time in updating your routine reports. The Tool, when built will be fully autonomous requiring no Excel input from you; just dump your new data (transactions) into a designated folder and all your reports update like magic!

This is not a Beginner Excel course, it assumes that students have a basic understanding of Excel especially as it relates to the topics listed below.

  • Basic Excel Knowledge
    • Entering Data into Excel
    • Create and format simple Charts
    • Understand Cell Referencing (A1, $A$1, A$1, $A1)
    • Using the Excel Table Tool
    • Filter, sort, remove duplicates
  • Routine Reporting Skills
Read More

Instructor

David Brown
David Brown
FCA, Microsoft MVP

David Brown is an ATD Master Trainer and Master Instructional Designer. He is also a Microsoft MVP, an International Consultant to the World Bank, a Chartered Accountant and the founder and Managing Partner of dbrownconsulting, a Lagos-based consulting and Analyst training firm. David is also a regular speaker at International conferences and events.

David and his team at dbrownconsulting develop self-service reporting tools to automate the tedious process of cross reporting on LMS Data, HR & Training Data and Other Data silos in organisations, providing great insights for management with minutes without the need for new software.

He is also a passionate facilitator, he has trained thousands in technical courses such as Financial Modelling, Business Intelligence and Analytics with Power BI, Finance for non-Financial Managers and much more. He develops unique methodologies, frameworks and job aids to simplify tedious tasks at work as well as make the facilitation and learning of complex topics fun and sticky.

He was awarded the Microsoft MVP award in 2018 for his tireless support of the technical community where he hosts monthly online meetups in Excel & Power BI and Financial Modeling, Live events and thought leadership in Excel, Power BI and Data Analytics platforms. He also hosts a monthly webinar on Talent Development.

He leads a team of trainers/instructional designers in developing, designing and implementing blended learning courses for Analyst, his work can be viewed on www.OfficeTrainingHub.com and his firm's corporate website www.dbrownconsulting.net.

Contact him on LinkedIn on https://www.linkedin.com/in/davidbrownprofile/


Reviews (3)

Report Automation in Modern Excel - Excellent

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

Report Automation

by Otti Grant Onyeukwu
The training was very insightful and effective. Course content and delivery were exceptional. Being online made it even more efficient, I learnt at my own pace and time.

by Clariss Odejayi

Report Automation in Modern Excel - Excellent

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

Report Automation

by Otti Grant Onyeukwu
The training was very insightful and effective. Course content and delivery were exceptional. Being online made it even more efficient, I learnt at my own pace and time.

by Clariss Odejayi