Learn Microsoft Excel Data Visualization & Data Analysis Free Video Course Download
Learn Microsoft Excel Data Visualization & Data Analysis Free Video Course Download
Microsoft Excel Data Visualization Master 20+ Excel charts & graphs and build custom visuals with a best-selling Excel instructor. Learn Microsoft Excel Data Visualization & Data Analysis Free Video Course Download.
Course Video Size : 1 GB High Quality Video Content
Original Author: Click Here
What you will learn:
- Understand WHEN, WHY, and HOW to use 20+ chart types in Excel 2016+
- Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and more
- Master unique tips, tools and case studies that you won’t find in ANY other Excel course, guaranteed
- Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
- Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
- Build 10+ Excel projects designed to take your data visualization skills to the next level
Description of Make Money From Adsense:
Request that individuals what comes mind when they consider Excel, and chances are they will state “spreadsheets”. In all actuality, Excel is an extraordinarily amazing and dynamic information representation stage for those ready to think past lines, sections, and crude pie outlines – and I am here to demonstrate it.
This course gives you a profound, 100% far reaching comprehension of Excel is most recent information representation devices and strategies. I will give you when, why, and how to utilize each Excel outline type, present key information representation best practices, and guide you through intuitive, hands-on demos and Excel practices at all times.
We will kick things off by investigating every one of the 20+ diagrams and charts presented in Excel 2016, including:
- Bar and Column graphs
- Histograms and Pareto graphs (Office 365, Excel 2016 or Excel 2019)
- Line graphs and pattern lines
- Territory diagrams
- Pies and Donuts
- Dissipate plots and Bubble diagrams
- Box and Whisker diagrams (Office 365, Excel 2016 or Excel 2019)
- Tree Maps and Sunbursts (Office 365, Excel 2016 or Excel 2019)
- Cascade and Funnel graphs (Office 365, Excel 2016 or Excel 2019)
- Radar and Stock diagrams
- Warmth maps, 3-D Surface and form outlines
- Chloropleths and Geospatial maps
- Custom combo diagrams and charts
- Sparklines
From that point we will plunge into a progression of 12+ progressed Excel demos ensured to transform you into a flat out information viz rockstar. These aren’t “reading material” demos that you can discover on Excel YouTube channels; these are ventures adjusted from genuine, grant winning work highlighted by Microsoft, MIT, and the New York Times. I have manufactured my examination profession around information representation, and I can assist you with doing likewise.
We will cover progressed Excel information viz themes that you won’t find anyplace else, including:
- Custom picture overlay outlines
- Mechanization with named ranges and OFFSET/COUNTA capacities
- Parchment and Zoom usefulness with Excel structure controls
- Vivified outlines to envision changes after some time
- Dynamic, custom Excel dashboards
- Worth based graph arranging
- Custom check outlines and pacing diagrams
- Framework visuals utilizing Excel cluster equations
- Progressed Excel Formulas and Functions
- Information Visualization with Excel Charts and Graphs (you are here)
- Information Analysis with Excel PivotTables
- Exceed expectations Power Query, Power Pivot and DAX
- Exceed expectations Pro Tips for Power Users
Requirements for this course:
- Microsoft Excel, ideally 2016+ or Office 365 for PC (some charts are not available in other versions of Excel)
- Mac users are welcome, but note that the user experience will be significantly different across platforms
Course content For Microsoft Excel Data Visualization :
1.Getting Started
- Course Structure & Outline
- READ ME: Important Notes for New Students
- DOWNLOAD: Course Resources
- Setting Expectations
2. Data Visualization Best Practices:
- Key Visualization Principles & The 10-Second Rule
- Good, Bad & Ugly Data Viz
- 3 Key Questions for Effective Visualization
3. Excel Chart Formatting & Customization:
- Customizing Chart Elements, Layouts & Styles
- Configuring Chart Formats
- Changing Chart Types & Adding a Secondary Axis
- Creating & Applying Custom Chart Templates
- Excel Chart Customization
4.Mastering Basic Excel Charts & Graphs:
- DEMO: Excel Bar & Columns Charts
- HOMEWORK: Bar & Column Charts
- DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+)
- HOMEWORK: Histograms & Pareto Charts
- DEMO: Excel Line Charts & Trendlines
- HOMEWORK: Line Charts & Trendlines
- DEMO: Excel Area Charts
- HOMEWORK: Area Charts
- DEMO: Excel Pie Charts, Donuts & Race Tracks
- HOMEWORK: Pies, Donuts & Race Tracks
- DEMO: Excel Scatter Plots
- DEMO: Excel Bubble Charts
- HOMEWORK: Scatter Plots & Bubble Charts
- DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+)
- HOMEWORK: Box & Whisker Charts
- DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+)
- HOMEWORK: Tree Maps & Sunburst Charts
- DEMO: Excel Waterfall Charts (Office 365/Excel 2016+)
- DEMO: Excel Funnel Charts (Office 365/Excel 2016+)
- HOMEWORK: Waterfall & Funnel Charts
- DEMO: Excel Radar Charts
- HOMEWORK: Radar Charts
- DEMO: Excel Stock Charts
- HOMEWORK: Stock Charts
- DEMO: Excel Heat Maps with Conditional Formatting
- HOMEWORK: Heat Maps
- DEMO: Excel Surface & 3D Contour Charts
- HOMEWORK: Surface & Contour Charts
- DEMO: Geo-Spatial Mapping with Excel Power Map
- HOMEWORK: Power Map
- DEMO: Common Excel Combo Charts
- HOMEWORK: Combo Charts
- DEMO: Excel Sparklines
- HOMEWORK: Sparklines
- Basic Excel Chart Types
5. Next-Level Demos:
- Setting Expectations
- DEMO: Creating Custom Image Overlay Charts
- DEMO: Using Binary Values to Highlight Time Periods
- DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA)
- DEMO: Adding Scroll & Zoom Functionality Using Form Controls
- DEMO: Creating Interactive Area Charts to Show Changes Over Time
- DEMO: Building a Dynamic Excel Dashboard (Part 1)
- DEMO: Building a Dynamic Excel Dashboard (Part 2)
- DEMO: Dynamic Chart Formatting Based on Values
- DEMO: Dynamically Highlighting Segments of Data
- DEMO: Building a Custom Excel Pacing Chart
- DEMO: Designing a Custom Excel Gauge Chart
- DEMO: Visualizing Percentages Using Array Functions
- Advanced Excel Data Visualization Techniques
6.Wrapping Up:
- More from Maven Analytics
Who this course is for:
- Anyone looking to create beautiful and effective data visualizations in Excel
- Excel users who have basic skills but want to master advanced charts, graphs & dashboards
- Students looking for an engaging, hands-on, and highly interactive approach to training
- Anyone looking to pursue a career in data analysis or business intelligence
