Build Excel Charts And Graphs

Build practical Excel charts for data visualization

What you'll learn
Excel Chart Tools
Excel Advanced Data Visualization
Data Visualization With Pivot Chart And Slicers
Working With Chart Formats
Requirements
No experience necessary
Description
Buff your skills to keep your job and get a raise in ANY economic climate. This course BUNDLE keeps your skills sharp and your paycheque up!Use chart toolsBuild basic charts and graphsBuild advanced charts and graphs and moreThis masterclass is without a doubt the most comprehensive course available anywhere online. Even if you have zero experience, this course will take you from beginner to professional.Frequently Asked QuestionsHow do I obtain a certificate?Each certificate in this bundle is only awarded after you have completed every lecture of the course.Many of our students post their Mammoth Interactive certifications on LinkedIn. Not only that, but you will have projects to show employers on top of the certification.Is this an eBook or videos?The majority of this course bundle will be video tutorials (screencasts of practical coding projects step by step.) We will also have several PDFs and all source code.Can't I just learn via Google or YouTube?This bundle is much more streamlined and efficient than learning via Google or YouTube. We have curated a massive 5-course curriculum to take you from absolute beginner to starting a high-paying career.How will I practice to ensure I'm learning?With each section there will be a project, so if you can build the project along with us you are succeeding. There is also a challenge at the end of each section that you can take on to add more features to the project and advance the project in your own time.Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top-selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency-minded software for technology workers like you. Try a course today.

Overview

Section 1: 01. Introduction to the Course

Lecture 1 1.1 Introduction To The Course

Lecture 2 1.2 Introduction Of The Instructor

Lecture 3 1.3 Course Requirements

Lecture 4 1.4 How To Get Excel

Section 2: 02. Dashboards Introduction

Lecture 5 2.1 What Will We Learn In This Section

Lecture 6 2.2 What Are Dashboards

Lecture 7 2.3 Answers You Need Before You Start A Dashboard

Lecture 8 2.4 Best Practices For Dashboard Layout

Lecture 9 2.5 Best Practices For Dashboard Colors

Lecture 10 2.6 Section Summary

Section 3: 03. Build a Dashboard Project

Lecture 11 3.1 What will we learn in this section

Lecture 12 3.2 Build a Wireframe in Excel

Lecture 13 3.3 Prepare Raw Data for Dashboard

Lecture 14 3.4 Prepare Calculation sheet

Lecture 15 3.5 Section Summary

Section 4: 04. Scrolling Data Table

Lecture 16 4.1 What will we learn in this section

Lecture 17 4.2 Build a Combo Box

Lecture 18 4.3 Complex Lookup

Lecture 19 4.4 Build a Scrolling Data Table

Lecture 20 4.5 Conditionally Format Actual Values vs Budgeted Values

Lecture 21 4.6 Conditional Headers

Lecture 22 4.7 Section Summary

Section 5: 05. Show Top Indicators

Lecture 23 5.1 What will we learn in this section

Lecture 24 5.2 Show Top Matches Over and Under Budget

Lecture 25 5.3 List Box to Select Indicators

Lecture 26 5.4 Toggle Between Top Over or Under

Lecture 27 5.5 Section Summary

Section 6: 06. Scrollable Line Chart

Lecture 28 6.1 What will we learn in this section

Lecture 29 6.2 Prepare Data for Scrolling Chart

Lecture 30 6.3 Scrollable Line Chart

Lecture 31 6.4 Remove Crashing Lines

Lecture 32 6.5 Toggle Visibility of Line Series

Lecture 33 6.6 Finetune the Line Series

Lecture 34 6.7 Section Summary

Section 7: 07. Interactivity

Lecture 35 7.1 What will we learn in this section

Lecture 36 7.2 Add Interactivity to Reports with Pivot Slicers

Lecture 37 7.3 Column Chart Controlled by Slicer

Lecture 38 7.4 Pivot SLicer Sorting

Lecture 39 7.5 Select Only 1 Slicer

Lecture 40 7.6 Dynamic Comments with Slicers

Lecture 41 7.7 Section Summary

Section 8: 08. Finetune the Dashboard

Lecture 42 8.1 What will we learn in this section

Lecture 43 8.2 Add Calculations for Variances in Pivot Tables

Lecture 44 8.3 Conditional Formatting in Pivot Tables

Lecture 45 8.4 Refresh Pivot Table with Easy VBA

Lecture 46 8.5 Section Summary

Section 9: 09. Course Summary

Lecture 47 9.1 Course Summary and Next Steps

Anyone interested in data visualization in spreadsheets