Excel Dashboards Masterclass


Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates
베스트셀러
4.3 (313개의 평점)
4,490명의 등록 수강생
무엇을 배우게 됩니까?
  • Create Professional Dynamic Excel Charts and Business Dashboards
  • Create amazing Interactive Charts in Microsoft Excel with real-world examples. BONUS: Excel Workbook files + Sample files included
  • Improve general Excel knowledge - Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macros
  • Create eye-catching visualizations
  • Follow along with included Excel project files
  • Learn from an instructor with over 16 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
  • Learn the most current version of Microsoft Excel
  • Course updated regularly
  • An instructor ready to answer your questions in less than 24 hours
  • Watch high-quality video lectures with lifetime access
  • Quizzes and exercises
  • Certificate of completion
요구 사항
  • This course was recorded with Excel 2013 but it's also compatible also with Excel 2016, 2007 and 2010
  • It is also compatible with Microsoft Office for Mac
  • Only basic prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel course
설명

*** Completely up-to-date for February 2017 ***

*** This course is fully subtitled in English! ***

Excel dashboards are a powerful way to leverage Excel functionality, build and manage better presentations and improve your Excel and data visualization skills. In this course I’ll show you how you can turn Excel into your own, personal Business Intelligence tool and create Interactive Charts and awesome Dashboards in Microsoft Excel.

Learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks

Content and Overview

Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Graphs and Dashboards?

While Excel offers dozens of chart types and hundreds of formatting options, making the right chart is the trickiest part. In order to use charts effectively, you'll need to understand how different charts are used.

In this course my goal is to give my students the practical knowledge, with real-world examples and step by step instructions, to create professional and designer-quality Charts and Dashboards in Excel.

With over 90 Lectures, quizzes, assignments, real-life Excel projects+SAMPLES and weekly updates, learning advanced Excel techniques has never been easier. This course is a concise and practical go-to guide for creating Interactive Charts and awesome Dashboards in Microsoft Excel. It also expands in to Pivot Tables, Pivot Charts, Conditional Formatting, Functions, Formulas and Macros.

You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee!

Plus you will get fast and responsive support within 24 hours.

What are you waiting for? Enroll now! (it is 100% no risk deal)


Why is this course different?

  • It's super practical. Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.
  • It's comprehensive and fast. Microsoft Excel charts are complex, that's why the course is broken down into bite-sized pieces
  • The course also expands in to Conditional Formatting and Functions-Formulas
  • I update the Excel class monthly with new lectures!
  • It has a quiz after section so to prove that you have learned the material.
  • You will learn the version of Microsoft Excel (2013) but the concepts are compatible with Excel 2016, 2010, Excel 2007 and the brand new Excel 2016
  • Compatible with Microsoft Office for Macintosh


What am I going to get from this course?

  • How to select the correct Excel chart type for your data.
  • How to create amazing data visualizations in a matter of seconds!
  • The most important elements of a Microsoft Excel chart, like chart and plot area, Design and Format tab, data labels, gridlines, legends, titles, axes, layouts and much more
  • Modifying an Excel chart visually: styles and colors, create a pictograph, Excel's camera tool, shapes, effects, text etc.
  • Basic Excel chart types like Column charts, Bar charts, Pie charts, Line charts, 3D charts, Scatter charts, Bubble charts, Stock charts, Surface charts and Radar Excel charts.
  • How to create mini charts like Sparklines and make data analysis fun!
  • Advanced Excel chart types like Combo charts, Pareto charts, Gantt charts, Gauge-Speedometer charts, Waterfall Charts, Bullet charts and Frequency charts.
  • How to create impressive Dynamic Professional Excel Charts with 5 different methods.
  • How to create Business Dashboards and Excel Reports.
  • How to create Excel Pivot Tables, Pivot Charts and how to add Slicers to help you filtering your data.
  • Create a Histogram in Excel, using Frequency Distribution.
  • How to create all types of Excel Sparklines.
  • The secrets of linking Excel Graphs with other programs and printing charts
  • Bonus material : Excel most useful shortcuts etc
  • How to create and use Functions-Formulas for Excel Charts.

Enrol now and enjoy the course!




Who is this course for? 

  • Entrepreneurs
  • Students
  • Business Professionals
  • Everyone who wants to master Excel Graphs, Pivot Charts and Dashboards
  • Students with willingness for learning

Only basic prior experience in Microsoft Excel or spreadsheets is required to get the most out of this Excel course.

At the end of this Microsoft Excel class you will be given a Certificate of Completion.


Testimonials for this Course

"I learned so many new excel tricks from this course. It covers almost everything. Andreas impressed me for updating his course so often! It worth every cent. Great job!" - Chris K

===================================================================

"Outstanding course! Very thorough and easy to understand. Sample spreadsheets make it very simple to follow along and provide hands on work. I would highly recommend this course." - Kelli Kellen

===================================================================

"A strongly recommend the course for all type of excel users. The lecturer follows a systematic and inspiring approach to present the most important techniques for data visualization with Excel." - Tommy Kalman

===================================================================

*** learning is more effective when it is an active rather than a passive process *** Euripides Ancient Greek dramatist

대상 수강생은 누구입니까?
  • Everyone who wants to master Excel Charts
  • Business Professionals
  • Students
  • Entrepreneurs
  • Students with a willingness for learning

이 강좌의 커리큘럼
모든103개의 강의 확장05:09:00
INTRODUCTION
11:34

Be a Great Student!
00:53

Download the Excel Project Files + Course Study Tracker
00:19

Introduce Yourself! 
00:27


Building an Effective Data Model (NEW 03/2016)
02:51

I need your help!
01:02
+
ANALYZING A DASHBOARD WITH FUNCTIONS (NEW 10/2015)
4개의 강의15:46
+
BEGINNERS: INTRODUCTION TO CHARTS
7개의 강의18:50
+
UPDATING, SHARING AND PRINTING A CHART
5개의 강의12:27
+
BEGINNERS: BASIC BUILD-IN CHART TYPES
12개의 강의24:42
+
FORMATTING & CUSTOMIZING CHARTS
9개의 강의34:32
+
GRAPHICS FOR CHARTS & DASHBOARDS
8개의 강의12:44
+
DASHBOARDS COMPONENTS: SPARKLINES - MINI CHARTS
5개의 강의14:24
+
ADVANCED CHARTS & DASHBOARD COMPONENTS
15개의 강의01:01:47
+
INTERACTIVE CHARTS & DASHBOARD CONTROLS
8개의 강의27:58
4개의 추가 섹션
강사 정보
Andreas Exadaktylos
4.5 평균 평점
867개의 리뷰
11,174명의 수강생
7개의 강좌
Teacher|Msc Computer Scientist

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.

I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.

I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.

I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 17 yearsI am a professional Forex Trader for over 5 years.

I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.

I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies.

수강생 피드백
4.3
평균 평점
후기
Andres Guillermo Munoz
16일 전

The course has a lot of focus con charts, less focus on tables, pivots and data analysis, however for an "almost" beginner person or someone who uses it for basic operations, it is great to move to a medium level of expertise with Excel. In my particular case, I found very useful the Slicers examples, the Box&Whisker charts, and Waterfall charts. I would recommend sharing examples of more complex dashboards in the last sections as wells as indicate how to use the Waterfall charts by default coming with Excel 2016. As a conclusion, for someone who is familiar with excel and wants to move a to a medium expertise level and more professional looking data presentation, this course is great, easy to follow, easy to understand. Great job Andreas!

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Steven Calvert
2달 전

I was asked to provide charts and dashboards at work and realised that this was not one of my strong points.

This course was fantastic in helping me understand the concept behind charts and dashboards.

I would recommend this course

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Jeremy Harper
2달 전

Maybe my knowledge and skill set of excel is making these courses much easier than expected. Again, since I haven't experienced the whole course and have learned practically nothing about dashboards, a 3-star rating seems appropriate. Hopefully as we go on in the course, we will get to create sample dashboards that I can use while at work.

UPDATE** I've finished the course now, and I have learned some very useful tips and tricks about functions/shortcuts. The next thing I want to work on learning is formatting a dashboard with more appealing colors and styles.

I thought my experience with pivot tables was minimal, but I was able to do everything he did in this course with pivots tables before even taking this class.

Some more expert ways of using pivot tables would be another good lecture.

Overall, good course for beginners/intermediate users.

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Sean Whorley
2달 전

The segments goes fast and hard to understand at times? additionally he does not go to deep thus far.

Andreas Exadaktylos(강사)2달 전

Hi Sean,

Thank you so much for taking time out of your busy day to leave a review for my course. Is there anything I can do to improve my course?

Please message me with some specific ideas of what I can do to improve it.

Thanks! Andreas

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Gary Weeks
3달 전

Course is an excellent overview of all chart types with innovative techniques for displaying data. Very good preparation course for building dashboards.

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Brian York
11일 전

It's a good course but I get sick of being asked to rate the course over and over, and found it quite distracting from the actual material. Most of the sample material is good, though sometimes instructor moves very quickly. One of the excel files appears to be missing.

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Aaron Ford
3달 전

This course is very informative, and showed me lots of ways I can manipulate the data set and present it in a readable format.

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Bill Hengen
5달 전

This is really good course. I like how the explanations are clear and detailed. I've really learned a lot.

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Steve Wood
4달 전

Excellent course! The material was pertinant to my needs and paced well with my learning ability.

리뷰가 도움이 되었습니까?   
감사합니다! 본 리뷰의 피드백을 제출하셨습니다.
Alex Wuden
14일 전

Very comprehensive, great structure and clear instructions. Probably the best Excel course in my opinion. Well done!



태그로 다른자료 검색
의견 0 자료등록      목록