How to make advanced data structures for reporting in Excel
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 5.5 Hours | Lec: 50 | 0.98 GB
Genre: eLearning | Language: English
A case study for transforming data structures or dashboards into reporting layouts in 5 steps
The aim of this course is to give you a combination of knowledge about basic and advanced functions and functionalities provided by Microsoft Excel, while guiding you in creating a dashboard and/or advanced data structures step by step from the beginning till the very end.
When I started learning Excel, I realized that it is very
important to know Excel functions, but knowing them is not enough. You
have to build it into your daily work and start thinking the way Excel
I would like to give you a case study, where starting from the beginning we are building a dashboard together while explaining all the necessary steps to do so. My goal is to show you how to create an interactive, automated, easy to use data structure for reporting purposes by using basic and advanced functions, moreover, designing and advanced controlling elements.
With this course I will focus on a real-life example I had
to face during my work and try to shed light on what Excel is capable
of. The structure of the course touches the basics as well, so that if
you do not have a strong basis, it still gives you guidance and a firm
fund to continues and handle more complex data structures and dashboards. My aim is to show you how the functions work and then give you some tips how to use them in creating data structures.
Although this case study covers one specific problem and its solution, I would encourage you to use all the skills you can learn from it, as dozens of similar structures can be created on the basis of the curriculum you find in this course.
In case you have any question, please let me know, I will gladly help you.
I wish you all the best for the course!