Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 38 Minute(s)
Language
English
Taught by
Yasser Elsherif
Rating
2 views
Course Overview
Learn how to generate automated Excel reports and executive slides in few seconds
A typical monthly executive report can take days and hours to generate and thus wasting valuable time you can use for analysis or other important work.
This course will teach you the concept of automated reports through a set of examples and reveal the power of Excel in reducing the time-consuming routine work.
Not only that but also you will learn how to automate the generation of powerpoint slides in just a few seconds, so the total time from receiving the monthly update to distributing the executive slides would be reduced to minutes.
Course Content
- 7 section(s)
- 13 lecture(s)
- Section 1 Introduction
- Section 2 Example Dashboard
- Section 3 Supporting functions
- Section 4 Settings sheet
- Section 5 Dynamic graphs
- Section 6 PowerPoint update
- Section 7 More possibilities
What You’ll Learn
- How to run frequent reports extremely fast
- How to simplify reports with settings
- Creating automated tables, charts and text phrses
- Design automated slides for report distribution
- Automatically update PowerPoint template
Skills covered in this course
Reviews
-
JJack van Gils
Very practical 'to the point' course on automating (powerpoint) reporting. The VBA-code could be explained more extensively though.
-
RRolf Aabotsvik
I liked the course. It is short and concise and shows the concept of automating the production of a powerpoint well.
-
AAnthony Yao
Great too bad not much walkthrough for the vba code
-
IIlias Assreb
Very clear explanation!
