Library

Course: Comparative Analysis Report & Database Executive Dashboard

Comparative Analysis Report & Database Executive Dashboard

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Excel is a great tool, and practically essential in the day to day of companies and our professional lives. Now, between many tools, buttons and functions do not limit us to always use basics funtion.

This time I bring you a course nothing boring excel. It is not the typical excel course of basic formats and functions, rather, it is a course where we are going to apply that knowledge that you already have, either because you took a course or your professional experience and we will build together great reports, dynamic updates, ideal for executive reports, with dynamic scenarios for data analysis ... You will be the Excel reference in your work environment.

★ Note: Course recently updated to give you two gifts... exclusive to this course: Dependent Lists (3 levels) and Activity Pyramids. ★

This course includes:

★ Master of Technology Instructor (M.Tech. 18 years of experience) who will support you in the analysis to create your reports and attentive to your queries.

★ Templates that we will develop together and a final template ready to verify your progress and be used.

Who should take this course?

  • You, who knows excel, but you need a hand to create clean, concrete, executive, dynamic and amazing report
  • All students who want to take a really practical excel course, without the tedious and long lessons of each and every one of their tools. Here we will see excel applied.
  • Data analysts to work through a special reports for it
  • You'd like to learn how to create interactive reports
Basic knowledge
  • Basic Excel Knowledge
  • Microsoft Excel installed and ready to roll (compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016)
What you will learn
  • Create Comparative Analysis Report (multi-scenarios)
  • How to add interactivity to your Excel reports - No VBA required
  • Build a database, from a scattered report
  • Create clean, concrete, executive and dynamic reports (Easy update)
  • Create the excel workspace with the appropriate printing format in an accurate way.
  • Create basic dynamic report
  • Create database dynamic reports
  • Create dependent lists and sublists - 3 levels. (Exclusive to this course)
  • Analyze results from a pyramid of activity. (Exclusive to this course)
Curriculum
Number of Lectures: 15
Total Duration: 02:08:21
introduction
  • Introduction  

    ¿What we will do in the course?

Base of Reports
  • Excel Sheet Base  

    From this class our base excel file will evolve until you convert it into a report for the comparative analysis and executive dashboard.


  • Required functions  

    We will analyze the main functions that we are using in the course.

  • Database  

    We will know what a database is and the importance of it for our reports in excel

  • Analyzing the Origin Report  

    We will analyze a dispersed database, in order to understand what is necessary to convert it into a real database.

  • Building the database  

    We will build the database from scattered data.

Basic Dynamic Report
  • Basic Dynamic Report.  

    We will build our first dynamic report.

  • Results: Basic Dynamic Report  

    Let's see what we accomplished in our first dynamic report.

Database Dynamic Report
  • Database Dynamic Report. Part 1  

    Let's build our Database Dynamic Report . Part 1

  • Database Dynamic Report. Part 2  

    We will finish our Database Dynamic Report

  • Results: Database Dynamic Report  

    Let's see what we achieved with our Database Dynamic Report

Dynamic Comparative Analysis Report
  • Dynamic Comparative Analysis Report  

    We are going to create a Comparative Analysis Report to analyze results in a dynamic way

  • Results: Dynamic Comparative Analytical Report  

    We have achieved it! We develop our Dynamic Comparative Analysis Report

Additional gift classes
  • Dynamic Dependent Lists 3 levels  

    Create dynamic dependent lists (Lists and Sub-lists) 3 leves, exclusive of this course.

  • Pyramid Activity  

    Pyramid Activity, a global and simple way to see our evolution

Reviews (0)