Excel Charts - Visualization Secrets for Impressive Charts

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department!

Significantly Improve your Reports by using Advanced Excel Graph Techniques.

This Course Includes:

  • Downloadable Workbook to follow the demonstrations (and use the charts as your templates).

  • Downloadable Exercise Book (answers included).

  • Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training.

If you use Excel to generate reports and graphs, my hands-on Excel training provides you with an extremely advanced toolkit worth of knowledge that will take the design of your Excel charts, tables and reports to the next level. It will provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your Excel graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers.

Lauren says: "I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts."

John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken"

Paul says: "Course is clear, to the point and very dynamic. Excellent!"

Types of Excel Charts & Excel Graphs are presented:

The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information.

If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel.

Demonstration will be done using Excel 2010, but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have.

Why this course is different to other Excel courses:

I will not only demonstrate to you, but you will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first).

I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible.

I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that.

This course is split to 5 major parts:

  1. Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design.

  2. Behind the scenes secrets of dynamic charts in Excel, where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables.

  3. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most.

  4. New ways to compare performance: as in Actual data versus Budget, forecasts and previous year

  5. Effective Chart Combinations that are pivotal to management reports

This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them!

Who this course is for:

  • Controller or financial analyst responsible for creating monthly, quarterly or yearly reports
  • Finance or department manager looking for new effective visualization methods
  • A student planning to work as a business or financial analyst or in any function that will require data visualization
  • All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course

Expected Outcomes

  1. Significantly improve your Excel reports to create more powerful graphs that communicate your information in the best manner Learn creative & simple techniques that allow you to create your own Excel charts from scratch Create dynamic Excel charts. Why? To save time! I have seen many cases where people are unnecessarily manually updating graphs. This costs considerable time and nerves. Impress your management by including new Excel graphs in your reports (such as my Pin chart for variances) Apply Best Practice methods to considerably improve the design of your Excel charts and tables Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most Use effective Chart Combinations that are pivotal to management reports Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year Learn by doing. Download the Demo Excel Workbook and follow each section with me. Once you complete a section, you will do an exercise to test your understanding. Learning by doing works best! Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas. Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports Show more Show less Curated for the Udemy Business collection Requirements Existing experience and knowledge of Excel's basic charting options and formulas This course is aimed for current intermediate to advanced Excel users and will significantly build on existing knowledge Demonstration is done using Excel 2010. However, the focus of this training is to teach you new methods of doing things which you can do regardless of the Excel version you have Description Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! Significantly Improve your Reports by using Advanced Excel Graph Techniques. This Course Includes: Downloadable Workbook to follow the demonstrations (and use the charts as your templates). Downloadable Exercise Book (answers included). Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training. If you use Excel to generate reports and graphs, my hands-on Excel training provides you with an extremely advanced toolkit worth of knowledge that will take the design of your Excel charts, tables and reports to the next level. It will provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your Excel graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers. Lauren says : " I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts. " John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken " Paul says: " Course is clear, to the point and very dynamic. Excellent! " Types of Excel Charts & Excel Graphs are presented: The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information. If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel. Demonstration will be done using Excel 2010 , but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have. Why this course is different to other Excel courses: I will not only demonstrate to you, but you will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first). I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible. I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that. This course is split to 5 major parts: Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design. Behind the scenes secrets of dynamic charts in Excel , where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most. New ways to compare performance : as in Actual data versus Budget, forecasts and previous year Effective Chart Combinations that are pivotal to management reports This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them! Who this course is for: Controller or financial analyst responsible for creating monthly, quarterly or yearly reports Finance or department manager looking for new effective visualization methods A student planning to work as a business or financial analyst or in any function that will require data visualization All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course Show more Show less Featured review Chuck Garmon 160 courses 55 reviews Rating: 5.0 out of 5 a year ago Really value the explanation and importance of setting up the report to tell the story effectively without overloading on data that is not as important. Amazing instructor! Very confident in explaining the best path forward and why! Show more Show less Course content 15 sections • 81 lectures • 8h 30m total length Expand all sections Introduction & Scope 3 lectures • 9min Course Introduction & Scope Preview 07:10 Download Excel Files HERE 01:14 Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts 00:38 Effectively Communicate & Present Data Trends 5 lectures • 37min Effective Presentation of Quantitative Data - Overview 01:51 Table Design - Best Practices 02:57 Excel Chart Design - Best Practices 05:00 Understanding the Chart Tools Environment 18:13 Simple Shortcuts to Save Time 08:30 Best Practice & Chart Options 5 questions Behind-the-Scenes Secrets of Dynamic Charts 2 lectures • 5min Never Manually update your Excel Charts again! 03:56 Top Excel Functions that will save you time 01:28 Behind-the-Scenes Secrets - Excel Chart Updates When New Data is Added 5 lectures • 38min Excel Tables are a Time Saver 08:27 When Tables fail Use this Function 10:58 Excel Name Manager & OFFSET as a Great Team 09:15 OFFSET without Name Manager to Update your Excel Chart 09:11 Exercise - Dynamic Excel Charts 00:18 Behind-the-Scenes Secrets - Getting the Interactive Dashboard Effect 6 lectures • 30min Index and Match for an Interactive Chart that shows Different Views 02:19 Index & Match - The Index Part 04:36 Index & Match - The Match Part 02:55 The Dream Team - INDEX & MATCH 07:00 Mix it all for Major Time Saving - Yes it becomes a Dashboard! Preview 12:53 Exercise - Function for Interactive Charts 00:17 Behind-the-Scenes Secrets - Automatic Sorting of Bars in Excel Charts 4 lectures • 13min Automatic Sorting of the Bars in an Excel Bar Chart - Overview 01:18 Automatic Sorting in Excel - The RANK Function 06:30 Automatic Sorting in Excel - Unique RANK 04:38 Exercise - Automatic Sorting of Bars 00:20 Behind-the-Scenes Secrets - Automatic Legend Positioning 5 lectures • 25min Perfect Positioning of Series Labels 02:03 Excel Chart Series Label Positioning - Simple Line Series 07:39 Excel Chart Series Label Positioning - Changing Line Series Preview 06:20 Excel Chart Series Label Positioning - Stacked Column Chart 08:46 Exercise - Automatic Legend Positioning 00:18 Secret Techniques that Bring Attention to Key Chart Elements 9 lectures • 1hr 18min Highlight key Areas for Faster & Easier Readability Preview 03:06 Excel Conditional Format Column Colors for Best Impact 09:22 Excel Conditional Format Bar Colors 03:06 Conditionally Color Neg/Pos Columns & Data Labels 13:25 Better Alternative for Variance Charts in Excel 11:59 Vertical Lines to Create Dividers 09:05 Error bars as Dividers 07:53 Use Dynamic Annotations to Direct Reader Attention 19:33 Exercise - Bring Attention to Key Chart Elements 00:19 Design Tables that Highlight & Impress 6 lectures • 27min Conditional Formatting for Easy-to-Read Tables - Overview Preview 02:30 The Conditional-Formatting-Free method - Use Symbols 08:12 Highlight Table Rows Based on Values 06:59 Using Smart Color Coding in Tables 04:22 Use Symbols or Bars for Easier Readability 04:55 Exercise - Design Tables with Focus 00:17 Measuring Performance - Actual Versus Budget/Target 11 lectures • 1hr 32min Measuring Performance, doing Comparisons & predicting the Future Preview 02:35 Excel Column Chart Combinations 07:39 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines 08:01 Variances With a Bar Chart - The Professional Method #1 18:13 Variances With Two Bar Charts - Professional Method #2 21:53 Measuring Performance - Bullet Charts Overview 01:48 Vertical Bullet Chart with Percentages in Excel 09:53 Vertical Bullet Chart with Absolute Values in Excel 06:31 Horizontal Bullet Chart in Excel 11:22 Horizontal Bullet Chart - The Easy Method 03:40 Exercise - Effective Charts to Measure Actual to Budget Performance 00:17 5 more sections Instructor Leila Gharani Microsoft MVP, Bestselling Instructor 4.7 Instructor Rating 66,575 Reviews 214,882 Students 9 Courses Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time . Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes. Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria. Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions. She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course. Leila's passion is learning, sharing and solving difficult data analysis problems. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fbd95fa2546a',m:'35919a71ac91c6de28f4acf24c7dea8dccc8cbef-1627841014-1800-AVV3VOuIRzxbO9MoqnA6HjbTSjI6rlskgZcb5HdL+4MZEwobeHIN+USFlOuVq0wZO0S7dM3srFdf1A+3sssz/lVHuBJHOYiJ6/IwsW7HjhvsQQq6YRS82OKa+FdBm8xgsmz+kYgideSztRxynu2C+8Fyf6bIfXm/SqOYpl4MRmKe+x0ogEjrem9kLsnmYWlQ7CUOikz5Rxq+R8YvxSuOolo=',s:[0x569664e397,0x5387155c14],}})();
  2. Learn creative & simple techniques that allow you to create your own Excel charts from scratch Create dynamic Excel charts. Why? To save time! I have seen many cases where people are unnecessarily manually updating graphs. This costs considerable time and nerves. Impress your management by including new Excel graphs in your reports (such as my Pin chart for variances) Apply Best Practice methods to considerably improve the design of your Excel charts and tables Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most Use effective Chart Combinations that are pivotal to management reports Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year Learn by doing. Download the Demo Excel Workbook and follow each section with me. Once you complete a section, you will do an exercise to test your understanding. Learning by doing works best! Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas. Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports Show more Show less Curated for the Udemy Business collection Requirements Existing experience and knowledge of Excel's basic charting options and formulas This course is aimed for current intermediate to advanced Excel users and will significantly build on existing knowledge Demonstration is done using Excel 2010. However, the focus of this training is to teach you new methods of doing things which you can do regardless of the Excel version you have Description Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! Significantly Improve your Reports by using Advanced Excel Graph Techniques. This Course Includes: Downloadable Workbook to follow the demonstrations (and use the charts as your templates). Downloadable Exercise Book (answers included). Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training. If you use Excel to generate reports and graphs, my hands-on Excel training provides you with an extremely advanced toolkit worth of knowledge that will take the design of your Excel charts, tables and reports to the next level. It will provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your Excel graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers. Lauren says : " I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts. " John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken " Paul says: " Course is clear, to the point and very dynamic. Excellent! " Types of Excel Charts & Excel Graphs are presented: The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information. If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel. Demonstration will be done using Excel 2010 , but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have. Why this course is different to other Excel courses: I will not only demonstrate to you, but you will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first). I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible. I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that. This course is split to 5 major parts: Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design. Behind the scenes secrets of dynamic charts in Excel , where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most. New ways to compare performance : as in Actual data versus Budget, forecasts and previous year Effective Chart Combinations that are pivotal to management reports This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them! Who this course is for: Controller or financial analyst responsible for creating monthly, quarterly or yearly reports Finance or department manager looking for new effective visualization methods A student planning to work as a business or financial analyst or in any function that will require data visualization All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course Show more Show less Featured review Chuck Garmon 160 courses 55 reviews Rating: 5.0 out of 5 a year ago Really value the explanation and importance of setting up the report to tell the story effectively without overloading on data that is not as important. Amazing instructor! Very confident in explaining the best path forward and why! Show more Show less Course content 15 sections • 81 lectures • 8h 30m total length Expand all sections Introduction & Scope 3 lectures • 9min Course Introduction & Scope Preview 07:10 Download Excel Files HERE 01:14 Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts 00:38 Effectively Communicate & Present Data Trends 5 lectures • 37min Effective Presentation of Quantitative Data - Overview 01:51 Table Design - Best Practices 02:57 Excel Chart Design - Best Practices 05:00 Understanding the Chart Tools Environment 18:13 Simple Shortcuts to Save Time 08:30 Best Practice & Chart Options 5 questions Behind-the-Scenes Secrets of Dynamic Charts 2 lectures • 5min Never Manually update your Excel Charts again! 03:56 Top Excel Functions that will save you time 01:28 Behind-the-Scenes Secrets - Excel Chart Updates When New Data is Added 5 lectures • 38min Excel Tables are a Time Saver 08:27 When Tables fail Use this Function 10:58 Excel Name Manager & OFFSET as a Great Team 09:15 OFFSET without Name Manager to Update your Excel Chart 09:11 Exercise - Dynamic Excel Charts 00:18 Behind-the-Scenes Secrets - Getting the Interactive Dashboard Effect 6 lectures • 30min Index and Match for an Interactive Chart that shows Different Views 02:19 Index & Match - The Index Part 04:36 Index & Match - The Match Part 02:55 The Dream Team - INDEX & MATCH 07:00 Mix it all for Major Time Saving - Yes it becomes a Dashboard! Preview 12:53 Exercise - Function for Interactive Charts 00:17 Behind-the-Scenes Secrets - Automatic Sorting of Bars in Excel Charts 4 lectures • 13min Automatic Sorting of the Bars in an Excel Bar Chart - Overview 01:18 Automatic Sorting in Excel - The RANK Function 06:30 Automatic Sorting in Excel - Unique RANK 04:38 Exercise - Automatic Sorting of Bars 00:20 Behind-the-Scenes Secrets - Automatic Legend Positioning 5 lectures • 25min Perfect Positioning of Series Labels 02:03 Excel Chart Series Label Positioning - Simple Line Series 07:39 Excel Chart Series Label Positioning - Changing Line Series Preview 06:20 Excel Chart Series Label Positioning - Stacked Column Chart 08:46 Exercise - Automatic Legend Positioning 00:18 Secret Techniques that Bring Attention to Key Chart Elements 9 lectures • 1hr 18min Highlight key Areas for Faster & Easier Readability Preview 03:06 Excel Conditional Format Column Colors for Best Impact 09:22 Excel Conditional Format Bar Colors 03:06 Conditionally Color Neg/Pos Columns & Data Labels 13:25 Better Alternative for Variance Charts in Excel 11:59 Vertical Lines to Create Dividers 09:05 Error bars as Dividers 07:53 Use Dynamic Annotations to Direct Reader Attention 19:33 Exercise - Bring Attention to Key Chart Elements 00:19 Design Tables that Highlight & Impress 6 lectures • 27min Conditional Formatting for Easy-to-Read Tables - Overview Preview 02:30 The Conditional-Formatting-Free method - Use Symbols 08:12 Highlight Table Rows Based on Values 06:59 Using Smart Color Coding in Tables 04:22 Use Symbols or Bars for Easier Readability 04:55 Exercise - Design Tables with Focus 00:17 Measuring Performance - Actual Versus Budget/Target 11 lectures • 1hr 32min Measuring Performance, doing Comparisons & predicting the Future Preview 02:35 Excel Column Chart Combinations 07:39 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines 08:01 Variances With a Bar Chart - The Professional Method #1 18:13 Variances With Two Bar Charts - Professional Method #2 21:53 Measuring Performance - Bullet Charts Overview 01:48 Vertical Bullet Chart with Percentages in Excel 09:53 Vertical Bullet Chart with Absolute Values in Excel 06:31 Horizontal Bullet Chart in Excel 11:22 Horizontal Bullet Chart - The Easy Method 03:40 Exercise - Effective Charts to Measure Actual to Budget Performance 00:17 5 more sections Instructor Leila Gharani Microsoft MVP, Bestselling Instructor 4.7 Instructor Rating 66,575 Reviews 214,882 Students 9 Courses Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time . Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes. Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria. Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions. She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course. Leila's passion is learning, sharing and solving difficult data analysis problems. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fbd95fa2546a',m:'35919a71ac91c6de28f4acf24c7dea8dccc8cbef-1627841014-1800-AVV3VOuIRzxbO9MoqnA6HjbTSjI6rlskgZcb5HdL+4MZEwobeHIN+USFlOuVq0wZO0S7dM3srFdf1A+3sssz/lVHuBJHOYiJ6/IwsW7HjhvsQQq6YRS82OKa+FdBm8xgsmz+kYgideSztRxynu2C+8Fyf6bIfXm/SqOYpl4MRmKe+x0ogEjrem9kLsnmYWlQ7CUOikz5Rxq+R8YvxSuOolo=',s:[0x569664e397,0x5387155c14],}})();
  3. Create dynamic Excel charts. Why? To save time! I have seen many cases where people are unnecessarily manually updating graphs. This costs considerable time and nerves. Impress your management by including new Excel graphs in your reports (such as my Pin chart for variances) Apply Best Practice methods to considerably improve the design of your Excel charts and tables Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most Use effective Chart Combinations that are pivotal to management reports Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year Learn by doing. Download the Demo Excel Workbook and follow each section with me. Once you complete a section, you will do an exercise to test your understanding. Learning by doing works best! Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas. Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports Show more Show less Curated for the Udemy Business collection Requirements Existing experience and knowledge of Excel's basic charting options and formulas This course is aimed for current intermediate to advanced Excel users and will significantly build on existing knowledge Demonstration is done using Excel 2010. However, the focus of this training is to teach you new methods of doing things which you can do regardless of the Excel version you have Description Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! Significantly Improve your Reports by using Advanced Excel Graph Techniques. This Course Includes: Downloadable Workbook to follow the demonstrations (and use the charts as your templates). Downloadable Exercise Book (answers included). Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training. If you use Excel to generate reports and graphs, my hands-on Excel training provides you with an extremely advanced toolkit worth of knowledge that will take the design of your Excel charts, tables and reports to the next level. It will provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your Excel graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers. Lauren says : " I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts. " John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken " Paul says: " Course is clear, to the point and very dynamic. Excellent! " Types of Excel Charts & Excel Graphs are presented: The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information. If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel. Demonstration will be done using Excel 2010 , but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have. Why this course is different to other Excel courses: I will not only demonstrate to you, but you will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first). I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible. I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that. This course is split to 5 major parts: Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design. Behind the scenes secrets of dynamic charts in Excel , where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most. New ways to compare performance : as in Actual data versus Budget, forecasts and previous year Effective Chart Combinations that are pivotal to management reports This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them! Who this course is for: Controller or financial analyst responsible for creating monthly, quarterly or yearly reports Finance or department manager looking for new effective visualization methods A student planning to work as a business or financial analyst or in any function that will require data visualization All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course Show more Show less Featured review Chuck Garmon 160 courses 55 reviews Rating: 5.0 out of 5 a year ago Really value the explanation and importance of setting up the report to tell the story effectively without overloading on data that is not as important. Amazing instructor! Very confident in explaining the best path forward and why! Show more Show less Course content 15 sections • 81 lectures • 8h 30m total length Expand all sections Introduction & Scope 3 lectures • 9min Course Introduction & Scope Preview 07:10 Download Excel Files HERE 01:14 Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts 00:38 Effectively Communicate & Present Data Trends 5 lectures • 37min Effective Presentation of Quantitative Data - Overview 01:51 Table Design - Best Practices 02:57 Excel Chart Design - Best Practices 05:00 Understanding the Chart Tools Environment 18:13 Simple Shortcuts to Save Time 08:30 Best Practice & Chart Options 5 questions Behind-the-Scenes Secrets of Dynamic Charts 2 lectures • 5min Never Manually update your Excel Charts again! 03:56 Top Excel Functions that will save you time 01:28 Behind-the-Scenes Secrets - Excel Chart Updates When New Data is Added 5 lectures • 38min Excel Tables are a Time Saver 08:27 When Tables fail Use this Function 10:58 Excel Name Manager & OFFSET as a Great Team 09:15 OFFSET without Name Manager to Update your Excel Chart 09:11 Exercise - Dynamic Excel Charts 00:18 Behind-the-Scenes Secrets - Getting the Interactive Dashboard Effect 6 lectures • 30min Index and Match for an Interactive Chart that shows Different Views 02:19 Index & Match - The Index Part 04:36 Index & Match - The Match Part 02:55 The Dream Team - INDEX & MATCH 07:00 Mix it all for Major Time Saving - Yes it becomes a Dashboard! Preview 12:53 Exercise - Function for Interactive Charts 00:17 Behind-the-Scenes Secrets - Automatic Sorting of Bars in Excel Charts 4 lectures • 13min Automatic Sorting of the Bars in an Excel Bar Chart - Overview 01:18 Automatic Sorting in Excel - The RANK Function 06:30 Automatic Sorting in Excel - Unique RANK 04:38 Exercise - Automatic Sorting of Bars 00:20 Behind-the-Scenes Secrets - Automatic Legend Positioning 5 lectures • 25min Perfect Positioning of Series Labels 02:03 Excel Chart Series Label Positioning - Simple Line Series 07:39 Excel Chart Series Label Positioning - Changing Line Series Preview 06:20 Excel Chart Series Label Positioning - Stacked Column Chart 08:46 Exercise - Automatic Legend Positioning 00:18 Secret Techniques that Bring Attention to Key Chart Elements 9 lectures • 1hr 18min Highlight key Areas for Faster & Easier Readability Preview 03:06 Excel Conditional Format Column Colors for Best Impact 09:22 Excel Conditional Format Bar Colors 03:06 Conditionally Color Neg/Pos Columns & Data Labels 13:25 Better Alternative for Variance Charts in Excel 11:59 Vertical Lines to Create Dividers 09:05 Error bars as Dividers 07:53 Use Dynamic Annotations to Direct Reader Attention 19:33 Exercise - Bring Attention to Key Chart Elements 00:19 Design Tables that Highlight & Impress 6 lectures • 27min Conditional Formatting for Easy-to-Read Tables - Overview Preview 02:30 The Conditional-Formatting-Free method - Use Symbols 08:12 Highlight Table Rows Based on Values 06:59 Using Smart Color Coding in Tables 04:22 Use Symbols or Bars for Easier Readability 04:55 Exercise - Design Tables with Focus 00:17 Measuring Performance - Actual Versus Budget/Target 11 lectures • 1hr 32min Measuring Performance, doing Comparisons & predicting the Future Preview 02:35 Excel Column Chart Combinations 07:39 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines 08:01 Variances With a Bar Chart - The Professional Method #1 18:13 Variances With Two Bar Charts - Professional Method #2 21:53 Measuring Performance - Bullet Charts Overview 01:48 Vertical Bullet Chart with Percentages in Excel 09:53 Vertical Bullet Chart with Absolute Values in Excel 06:31 Horizontal Bullet Chart in Excel 11:22 Horizontal Bullet Chart - The Easy Method 03:40 Exercise - Effective Charts to Measure Actual to Budget Performance 00:17 5 more sections Instructor Leila Gharani Microsoft MVP, Bestselling Instructor 4.7 Instructor Rating 66,575 Reviews 214,882 Students 9 Courses Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time . Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes. Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria. Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions. She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course. Leila's passion is learning, sharing and solving difficult data analysis problems. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fbd95fa2546a',m:'35919a71ac91c6de28f4acf24c7dea8dccc8cbef-1627841014-1800-AVV3VOuIRzxbO9MoqnA6HjbTSjI6rlskgZcb5HdL+4MZEwobeHIN+USFlOuVq0wZO0S7dM3srFdf1A+3sssz/lVHuBJHOYiJ6/IwsW7HjhvsQQq6YRS82OKa+FdBm8xgsmz+kYgideSztRxynu2C+8Fyf6bIfXm/SqOYpl4MRmKe+x0ogEjrem9kLsnmYWlQ7CUOikz5Rxq+R8YvxSuOolo=',s:[0x569664e397,0x5387155c14],}})();
  4. Impress your management by including new Excel graphs in your reports (such as my Pin chart for variances) Apply Best Practice methods to considerably improve the design of your Excel charts and tables Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most Use effective Chart Combinations that are pivotal to management reports Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year Learn by doing. Download the Demo Excel Workbook and follow each section with me. Once you complete a section, you will do an exercise to test your understanding. Learning by doing works best! Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas. Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports Show more Show less Curated for the Udemy Business collection Requirements Existing experience and knowledge of Excel's basic charting options and formulas This course is aimed for current intermediate to advanced Excel users and will significantly build on existing knowledge Demonstration is done using Excel 2010. However, the focus of this training is to teach you new methods of doing things which you can do regardless of the Excel version you have Description Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! Significantly Improve your Reports by using Advanced Excel Graph Techniques. This Course Includes: Downloadable Workbook to follow the demonstrations (and use the charts as your templates). Downloadable Exercise Book (answers included). Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training. If you use Excel to generate reports and graphs, my hands-on Excel training provides you with an extremely advanced toolkit worth of knowledge that will take the design of your Excel charts, tables and reports to the next level. It will provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your Excel graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers. Lauren says : " I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts. " John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken " Paul says: " Course is clear, to the point and very dynamic. Excellent! " Types of Excel Charts & Excel Graphs are presented: The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information. If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel. Demonstration will be done using Excel 2010 , but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have. Why this course is different to other Excel courses: I will not only demonstrate to you, but you will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first). I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible. I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that. This course is split to 5 major parts: Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design. Behind the scenes secrets of dynamic charts in Excel , where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most. New ways to compare performance : as in Actual data versus Budget, forecasts and previous year Effective Chart Combinations that are pivotal to management reports This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them! Who this course is for: Controller or financial analyst responsible for creating monthly, quarterly or yearly reports Finance or department manager looking for new effective visualization methods A student planning to work as a business or financial analyst or in any function that will require data visualization All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course Show more Show less Featured review Chuck Garmon 160 courses 55 reviews Rating: 5.0 out of 5 a year ago Really value the explanation and importance of setting up the report to tell the story effectively without overloading on data that is not as important. Amazing instructor! Very confident in explaining the best path forward and why! Show more Show less Course content 15 sections • 81 lectures • 8h 30m total length Expand all sections Introduction & Scope 3 lectures • 9min Course Introduction & Scope Preview 07:10 Download Excel Files HERE 01:14 Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts 00:38 Effectively Communicate & Present Data Trends 5 lectures • 37min Effective Presentation of Quantitative Data - Overview 01:51 Table Design - Best Practices 02:57 Excel Chart Design - Best Practices 05:00 Understanding the Chart Tools Environment 18:13 Simple Shortcuts to Save Time 08:30 Best Practice & Chart Options 5 questions Behind-the-Scenes Secrets of Dynamic Charts 2 lectures • 5min Never Manually update your Excel Charts again! 03:56 Top Excel Functions that will save you time 01:28 Behind-the-Scenes Secrets - Excel Chart Updates When New Data is Added 5 lectures • 38min Excel Tables are a Time Saver 08:27 When Tables fail Use this Function 10:58 Excel Name Manager & OFFSET as a Great Team 09:15 OFFSET without Name Manager to Update your Excel Chart 09:11 Exercise - Dynamic Excel Charts 00:18 Behind-the-Scenes Secrets - Getting the Interactive Dashboard Effect 6 lectures • 30min Index and Match for an Interactive Chart that shows Different Views 02:19 Index & Match - The Index Part 04:36 Index & Match - The Match Part 02:55 The Dream Team - INDEX & MATCH 07:00 Mix it all for Major Time Saving - Yes it becomes a Dashboard! Preview 12:53 Exercise - Function for Interactive Charts 00:17 Behind-the-Scenes Secrets - Automatic Sorting of Bars in Excel Charts 4 lectures • 13min Automatic Sorting of the Bars in an Excel Bar Chart - Overview 01:18 Automatic Sorting in Excel - The RANK Function 06:30 Automatic Sorting in Excel - Unique RANK 04:38 Exercise - Automatic Sorting of Bars 00:20 Behind-the-Scenes Secrets - Automatic Legend Positioning 5 lectures • 25min Perfect Positioning of Series Labels 02:03 Excel Chart Series Label Positioning - Simple Line Series 07:39 Excel Chart Series Label Positioning - Changing Line Series Preview 06:20 Excel Chart Series Label Positioning - Stacked Column Chart 08:46 Exercise - Automatic Legend Positioning 00:18 Secret Techniques that Bring Attention to Key Chart Elements 9 lectures • 1hr 18min Highlight key Areas for Faster & Easier Readability Preview 03:06 Excel Conditional Format Column Colors for Best Impact 09:22 Excel Conditional Format Bar Colors 03:06 Conditionally Color Neg/Pos Columns & Data Labels 13:25 Better Alternative for Variance Charts in Excel 11:59 Vertical Lines to Create Dividers 09:05 Error bars as Dividers 07:53 Use Dynamic Annotations to Direct Reader Attention 19:33 Exercise - Bring Attention to Key Chart Elements 00:19 Design Tables that Highlight & Impress 6 lectures • 27min Conditional Formatting for Easy-to-Read Tables - Overview Preview 02:30 The Conditional-Formatting-Free method - Use Symbols 08:12 Highlight Table Rows Based on Values 06:59 Using Smart Color Coding in Tables 04:22 Use Symbols or Bars for Easier Readability 04:55 Exercise - Design Tables with Focus 00:17 Measuring Performance - Actual Versus Budget/Target 11 lectures • 1hr 32min Measuring Performance, doing Comparisons & predicting the Future Preview 02:35 Excel Column Chart Combinations 07:39 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines 08:01 Variances With a Bar Chart - The Professional Method #1 18:13 Variances With Two Bar Charts - Professional Method #2 21:53 Measuring Performance - Bullet Charts Overview 01:48 Vertical Bullet Chart with Percentages in Excel 09:53 Vertical Bullet Chart with Absolute Values in Excel 06:31 Horizontal Bullet Chart in Excel 11:22 Horizontal Bullet Chart - The Easy Method 03:40 Exercise - Effective Charts to Measure Actual to Budget Performance 00:17 5 more sections Instructor Leila Gharani Microsoft MVP, Bestselling Instructor 4.7 Instructor Rating 66,575 Reviews 214,882 Students 9 Courses Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time . Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes. Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria. Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions. She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course. Leila's passion is learning, sharing and solving difficult data analysis problems. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fbd95fa2546a',m:'35919a71ac91c6de28f4acf24c7dea8dccc8cbef-1627841014-1800-AVV3VOuIRzxbO9MoqnA6HjbTSjI6rlskgZcb5HdL+4MZEwobeHIN+USFlOuVq0wZO0S7dM3srFdf1A+3sssz/lVHuBJHOYiJ6/IwsW7HjhvsQQq6YRS82OKa+FdBm8xgsmz+kYgideSztRxynu2C+8Fyf6bIfXm/SqOYpl4MRmKe+x0ogEjrem9kLsnmYWlQ7CUOikz5Rxq+R8YvxSuOolo=',s:[0x569664e397,0x5387155c14],}})();
  5. Apply Best Practice methods to considerably improve the design of your Excel charts and tables Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most Use effective Chart Combinations that are pivotal to management reports Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year Learn by doing. Download the Demo Excel Workbook and follow each section with me. Once you complete a section, you will do an exercise to test your understanding. Learning by doing works best! Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas. Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports Show more Show less Curated for the Udemy Business collection Requirements Existing experience and knowledge of Excel's basic charting options and formulas This course is aimed for current intermediate to advanced Excel users and will significantly build on existing knowledge Demonstration is done using Excel 2010. However, the focus of this training is to teach you new methods of doing things which you can do regardless of the Excel version you have Description Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! Significantly Improve your Reports by using Advanced Excel Graph Techniques. This Course Includes: Downloadable Workbook to follow the demonstrations (and use the charts as your templates). Downloadable Exercise Book (answers included). Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training. If you use Excel to generate reports and graphs, my hands-on Excel training provides you with an extremely advanced toolkit worth of knowledge that will take the design of your Excel charts, tables and reports to the next level. It will provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your Excel graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers. Lauren says : " I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts. " John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken " Paul says: " Course is clear, to the point and very dynamic. Excellent! " Types of Excel Charts & Excel Graphs are presented: The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information. If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel. Demonstration will be done using Excel 2010 , but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have. Why this course is different to other Excel courses: I will not only demonstrate to you, but you will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first). I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible. I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that. This course is split to 5 major parts: Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design. Behind the scenes secrets of dynamic charts in Excel , where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most. New ways to compare performance : as in Actual data versus Budget, forecasts and previous year Effective Chart Combinations that are pivotal to management reports This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them! Who this course is for: Controller or financial analyst responsible for creating monthly, quarterly or yearly reports Finance or department manager looking for new effective visualization methods A student planning to work as a business or financial analyst or in any function that will require data visualization All in all, if you’re responsible for presenting your data graphically and you need to do this with Excel, you will benefit from the methods I teach in this course Show more Show less Featured review Chuck Garmon 160 courses 55 reviews Rating: 5.0 out of 5 a year ago Really value the explanation and importance of setting up the report to tell the story effectively without overloading on data that is not as important. Amazing instructor! Very confident in explaining the best path forward and why! Show more Show less Course content 15 sections • 81 lectures • 8h 30m total length Expand all sections Introduction & Scope 3 lectures • 9min Course Introduction & Scope Preview 07:10 Download Excel Files HERE 01:14 Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts 00:38 Effectively Communicate & Present Data Trends 5 lectures • 37min Effective Presentation of Quantitative Data - Overview 01:51 Table Design - Best Practices 02:57 Excel Chart Design - Best Practices 05:00 Understanding the Chart Tools Environment 18:13 Simple Shortcuts to Save Time 08:30 Best Practice & Chart Options 5 questions Behind-the-Scenes Secrets of Dynamic Charts 2 lectures • 5min Never Manually update your Excel Charts again! 03:56 Top Excel Functions that will save you time 01:28 Behind-the-Scenes Secrets - Excel Chart Updates When New Data is Added 5 lectures • 38min Excel Tables are a Time Saver 08:27 When Tables fail Use this Function 10:58 Excel Name Manager & OFFSET as a Great Team 09:15 OFFSET without Name Manager to Update your Excel Chart 09:11 Exercise - Dynamic Excel Charts 00:18 Behind-the-Scenes Secrets - Getting the Interactive Dashboard Effect 6 lectures • 30min Index and Match for an Interactive Chart that shows Different Views 02:19 Index & Match - The Index Part 04:36 Index & Match - The Match Part 02:55 The Dream Team - INDEX & MATCH 07:00 Mix it all for Major Time Saving - Yes it becomes a Dashboard! Preview 12:53 Exercise - Function for Interactive Charts 00:17 Behind-the-Scenes Secrets - Automatic Sorting of Bars in Excel Charts 4 lectures • 13min Automatic Sorting of the Bars in an Excel Bar Chart - Overview 01:18 Automatic Sorting in Excel - The RANK Function 06:30 Automatic Sorting in Excel - Unique RANK 04:38 Exercise - Automatic Sorting of Bars 00:20 Behind-the-Scenes Secrets - Automatic Legend Positioning 5 lectures • 25min Perfect Positioning of Series Labels 02:03 Excel Chart Series Label Positioning - Simple Line Series 07:39 Excel Chart Series Label Positioning - Changing Line Series Preview 06:20 Excel Chart Series Label Positioning - Stacked Column Chart 08:46 Exercise - Automatic Legend Positioning 00:18 Secret Techniques that Bring Attention to Key Chart Elements 9 lectures • 1hr 18min Highlight key Areas for Faster & Easier Readability Preview 03:06 Excel Conditional Format Column Colors for Best Impact 09:22 Excel Conditional Format Bar Colors 03:06 Conditionally Color Neg/Pos Columns & Data Labels 13:25 Better Alternative for Variance Charts in Excel 11:59 Vertical Lines to Create Dividers 09:05 Error bars as Dividers 07:53 Use Dynamic Annotations to Direct Reader Attention 19:33 Exercise - Bring Attention to Key Chart Elements 00:19 Design Tables that Highlight & Impress 6 lectures • 27min Conditional Formatting for Easy-to-Read Tables - Overview Preview 02:30 The Conditional-Formatting-Free method - Use Symbols 08:12 Highlight Table Rows Based on Values 06:59 Using Smart Color Coding in Tables 04:22 Use Symbols or Bars for Easier Readability 04:55 Exercise - Design Tables with Focus 00:17 Measuring Performance - Actual Versus Budget/Target 11 lectures • 1hr 32min Measuring Performance, doing Comparisons & predicting the Future Preview 02:35 Excel Column Chart Combinations 07:39 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines 08:01 Variances With a Bar Chart