Microsoft Excel: Data Visualization W/ Excel Charts & Graphs

Microsoft Excel: Data Visualization W/ Excel Charts & Graphs - Druckversion

+- Techmeister Forum (http://mail.techmeister-board.com)
+-- Forum:

Direkt - Downloads

(http://mail.techmeister-board.com/forumdisplay.php?fid=7)
+--- Forum: Ebooks und Magazine (http://mail.techmeister-board.com/forumdisplay.php?fid=80)
+--- Thema: Microsoft Excel: Data Visualization W/ Excel Charts & Graphs (/showthread.php?tid=24327)

Microsoft Excel: Data Visualization W/ Excel Charts & Graphs - mitsumi - 15.12.2024

Microsoft Excel: Data Visualization W/ Excel Charts & Graphs

[Bild: 7198b98a40d721d38f8fbc24378eb79a.jpeg]

[Bild: 7198b98a40d721d38f8fbc24378eb79a.jpeg]

Last updated 11/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.24 GB | Duration: 4h 38m

Master 20+ Excel charts & graphs, build custom dashboards, and create advanced spreadsheet visuals w/ a top instructor!

What you'll learn
Understand WHEN, WHY, and HOW to use 20+ chart types in Microsoft Excel
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
Requirements
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
Description
Microsoft Excel isÂ an incrediblyÂ powerful and dynamic data visualizationÂ platformÂ for those willing to think beyond rows, columns, and spreadsheets,Â andÂ I'm here to prove it.This course gives you a deep, 100%Â comprehensive understanding of MSÂ Excel's latestÂ data visualization tools and techniques. I'll show you WHEN, WHY, and HOW to use each Excel chart type, introduce keyÂ data visualization best practices,Â and guide you throughÂ interactive, hands-on demos and Excel exercisesÂ every step of the way.We'll kick things off by exploring each of the 20+Â charts &Â graphsÂ in Excel, including:Â Bar & Column chartsHistograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)Line charts, Area charts &Â trend linesPies &Â DonutsScatter plots & Bubble chartsBox & Whisker charts (Office 365, Excel 2016 or Excel 2019)Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)Radar &Â Stock chartsHeat maps,Â 3-DÂ Surface & Contour chartsChoropleths & Geospatial mapsCustom Combo ChartsSparklinesFrom there we'llÂ dive into a series of advanced ExcelÂ demosÂ guaranteed to turn you into an absolute data visualization and analytics rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels;Â these are projectsÂ and dashboards adapted from actual, award-winningÂ workÂ featured by Microsoft, MIT, and the New York Times.We'll cover advanced Excel data visualization topics that you won't find anywhere else, including:Custom image overlay chartsAutomation with named ranges and OFFSET/COUNTAÂ functionsScroll &Â Zoom functionality with Excel form controlsAnimated charts to visualize changes over timeDynamic, custom Excel dashboardsValue-based chart formattingCustom gauge charts &Â pacing chartsGrid visuals using Excel array formulasWhether you're looking for a quickÂ primer, trying to diversifyÂ your ExcelÂ skill set, or hopingÂ to step up your Excel data visualizationÂ or business intelligence game inÂ a major way, this course is for you.See you there!-Chris (Founder, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics"Â to browse our full collection of Excel, Power BI, SQL,Â Tableau, Python, Alteryx & Machine Learning courses!Hear why this is one of the TOP-RATEDÂ Excel courses on Udemy, and the #1 Excel Data Visualization course:"Absolutely great stuff. I really enjoyed it!Â Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts &Â graphs."Nirav M."Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advancedÂ Excel visuals and custom charts &Â graphs. Loved all of it, and hope IÂ can learn more from this wonderful individual!"Robert C."At the first part I just said to myself, "Wow, Excel is capable of that? It's amazing!"Â Then at the second part I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel and data visualization courses!"Judit B.NOTE:Â Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2016, Excel 2019 or Office 365.
Overview
Section 1: Getting Started
Lecture 1 Course Structure & Outline
Lecture 2 READ ME: Important Notes for New Students
Lecture 3 DOWNLOAD: Course Resources
Lecture 4 Setting Expectations
Section 2: Data Visualization Best Practices
Lecture 5 Key Visualization Principles & The 10-Second Rule
Lecture 6 Good, Bad & Ugly Data Viz
Lecture 7 3 Key Questions for Effective Visualization
Section 3: Excel Chart Formatting & Customization
Lecture 8 Customizing Chart Elements, Layouts & Styles
Lecture 9 Configuring Chart Formats
Lecture 10 Changing Chart Types & Adding a Secondary Axis
Lecture 11 Creating & Applying Custom Chart Templates
Section 4: Mastering Basic Excel Charts & Graphs
Lecture 12 DEMO: Excel Bar & Columns Charts
Lecture 13 HOMEWORK: Bar & Column Charts
Lecture 14 DEMO: Excel Histograms & Pareto Charts (Office 365/Excel 2016+)
Lecture 15 HOMEWORK: Histograms & Pareto Charts
Lecture 16 DEMO: Excel Line Charts & Trendlines
Lecture 17 HOMEWORK: Line Charts & Trendlines
Lecture 18 DEMO: Excel Area Charts
Lecture 19 HOMEWORK: Area Charts
Lecture 20 DEMO: Excel Pie Charts, Donuts & Race Tracks
Lecture 21 HOMEWORK: Pies, Donuts & Race Tracks
Lecture 22 DEMO: Excel Scatter Plots
Lecture 23 DEMO: Excel Bubble Charts
Lecture 24 HOMEWORK: Scatter Plots & Bubble Charts
Lecture 25 DEMO: Excel Box & Whisker Charts (Office 365/Excel 2016+)
Lecture 26 HOMEWORK: Box & Whisker Charts
Lecture 27 DEMO: Excel Tree Maps & Sunburst Charts (Office 365/Excel 2016+)
Lecture 28 HOMEWORK: Tree Maps & Sunburst Charts
Lecture 29 DEMO: Excel Waterfall Charts (Office 365/Excel 2016+)
Lecture 30 DEMO: Excel Funnel Charts (Office 365/Excel 2016+)
Lecture 31 HOMEWORK: Waterfall & Funnel Charts
Lecture 32 DEMO: Excel Radar Charts
Lecture 33 HOMEWORK: Radar Charts
Lecture 34 DEMO: Excel Stock Charts
Lecture 35 HOMEWORK: Stock Charts
Lecture 36 DEMO: Excel Heat Maps with Conditional Formatting
Lecture 37 HOMEWORK: Heat Maps
Lecture 38 DEMO: Excel Surface & 3D Contour Charts
Lecture 39 HOMEWORK: Surface & Contour Charts
Lecture 40 DEMO: Geo-Spatial Mapping with Excel Power Map
Lecture 41 HOMEWORK: Power Map
Lecture 42 DEMO: Common Excel Combo Charts
Lecture 43 HOMEWORK: Combo Charts
Lecture 44 DEMO: Excel Sparklines
Lecture 45 HOMEWORK: Sparklines
Section 5: Next-Level Demos
Lecture 46 Setting Expectations
Lecture 47 DEMO: Creating Custom Image Overlay Charts
Lecture 48 DEMO: Using Binary Values to Highlight Time Periods
Lecture 49 DEMO: Automating Charts with Named Ranges (OFFSET & COUNTA)
Lecture 50 DEMO: Adding Scroll & Zoom Functionality Using Form Controls
Lecture 51 DEMO: Creating Interactive Area Charts to Show Changes Over Time
Lecture 52 DEMO: Building a Dynamic Excel Dashboard (Part 1)
Lecture 53 DEMO: Building a Dynamic Excel Dashboard (Part 2)
Lecture 54 DEMO: Dynamic Chart Formatting Based on Values
Lecture 55 DEMO: Dynamically Highlighting Segments of Data
Lecture 56 DEMO: Building a Custom Excel Pacing Chart
Lecture 57 DEMO: Designing a Custom Excel Gauge Chart
Lecture 58 DEMO: Visualizing Percentages Using Array Functions
Section 6: Wrapping Up
Lecture 59 BONUS LESSON
Anyone looking to create beautiful and effective data visualizations in Excel,MS 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, analytics or business intelligence
Screenshots

[Bild: ffce8dbc3c382942031d63020c314bbf.jpeg]

[Bild: ffce8dbc3c382942031d63020c314bbf.jpeg]