Home
Search results “Advanced chart options excel”
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
 
14:48
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables. Download the files to follow along at the following link. http://www.excelcampus.com/pivot-table-checklist-yt I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?v=Jt_QqG-vRRw Get PivotPal: http://www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Views: 6815153 Excel Campus - Jon
Google Sheets Charts - Advanced- Data Labels, Secondary Axis, Filter, Multiple Series, Legends Etc.
 
51:50
Learn how to modify all aspects of your charts in this advanced Google Sheets tutorial. This tutorial covers Data Labels, Legends, Axis Changes, Axis Labels, Secondary Axis, Filter, Multiple Series, Compare Mode, Aggregate Columns & Rows, Gridlines, Trendlines and Much More.
How to build Interactive Excel Dashboards
 
52:26
Download file used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create an interactive dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac. Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks
Views: 1906365 MyOnlineTrainingHub
MS Excel - Advanced Filters
 
07:41
MS Excel - Advanced Filters Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Excel Dynamic Chart with Drop down List (column graph with average line)
 
08:09
Learn how to create an interactive chart in Excel that switches views depending on the selection from the drop-down list. In addition to creating dynamic chart ranges, I also show you how to create combo or combination charts in Excel. In this specific example, I show you how to add a horizontal average line to your column chart. This makes it simple to compare the values of the bars not just with one another but also with the average. The key to dynamic charts is to create a data preparation table that sits between your raw data and your chart. Smart Excel formulas help you do this dynamically. In this example, I use the Index and Match formula for data preparation. 🡻 Download the workbook here: http://www.xelplus.com/excel-dynamic-chart-with-drop-down/ Links to related videos: Index Match Basics: https://youtu.be/F264FpBDX28 Excel Charts Basics: https://youtu.be/DAU0qqh_I-A ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 69416 Leila Gharani
Advanced Automatic Organizational Chart Generator - Excel Template
 
02:24
Download here: https://www.someka.net/excel-template/advanced-automatic-organizational-chart-generator/ For all types and scales of organizations, it is indispensable to illustrate the reporting lines. At medium and large scale organizations having +40 employees, due to employee turnover or frequent assignment changes, keeping organizational schemes updated may become a puzzling situation. Because, in case of each organizational change, you have to deal with boxes, connections, levels and so on. Someka Automatic Organizational Chart Generator – Advanced Version provides generating an organizational chart for medium and large organizations, in JUST 3 STEPS: 1. Step: Type employee names, roles and reporting lines in Excel 2. Step: Select your reporting line layout (Below-Horizontal, Below-Vertical, Side-Horizontal, Side-Vertical) 3. Step: Click the button YOUR ORG CHART IS READY! What Does Someka Auto Org Chart Generator – Advanced Version Provide? 1. You Save Money Someka Auto Org Chart Generator is a cheaper tool compared to other organization chart generator tools. 2. You Save Time Someka Auto Org Chart Generator tool provides you to keep your reporting line data and prepare your organization chart, both in Excel. No need to deal with data transfer. 3. It’s User Friendly Someka Auto Org Chart Advanced Version offers 4 reporting line layout options: Below-Horizontal, Below-Vertical, Side-Horizontal, Side-Vertical. You can also change the box colors. Someka Org Chart Generator warns you about possible errors like illogical reporting lines. Someka Auto Org Chart Generator – Advanced Version Features: • Unique product for auto generation of org charts in excel • Recommended for medium and large organizations which have +40 employees • 4 Reporting line layout options: Below-Horizontal, Below-Vertical, Side-Horizontal, Side-VerticaL • Clear on sheet instructions (with turn on/off function) • Compatible with Excel 2010 and later versions. • Includes VBA code and macros, don’t forget to enable macros after you get it • Easy to use and nice design • Box design can be changeable • Export to PDF feature • Print Ready Download here: https://www.someka.net/excel-template/advanced-automatic-organizational-chart-generator/
Top 15 Advanced Excel 2016 Tips and Tricks
 
22:07
This is a continuation of my Top 25 Excel 2016 Tips & Tricks. It includes more advanced features and some additional tricks to help you become more productive using Excel and Office 365. Check out the original Excel 2016 video at https://youtu.be/EdnAeqxqdzM. Another 15 Excel 2016 Tips 7 Tricks: https://youtu.be/L9SKTj2gevA Contents: 1. Advanced Transpose 0:39 2. Calendar Picker 1:38 3. Slicers 3:05 4. Scenario Manager 4:22 5. CONVERT Function 7:09 6. Convert Currency Live 8:03 7. Hide Cells 10:14 8. Remove Blanks 10:48 9. People Graph 11:17 10. Track Changes 12:40 11. Advanced Filter 15:10 12. Analysis Tools 17:52 13. NETWORKDAYS Function 18:51 14. Embedding 19:38 15. Advanced Select 20:50
Views: 1008961 Sele Training
Advanced Excel - Data Validation and Drop-Down Lists
 
13:08
Learn how to use Data Validation tools in Excel to improve the accuracy of the data in your spreadsheets. One of the Data Validation features you'll learn in this video is how to create Excel drop-down lists so that the person entering data can simply click a button and choose from a list of possible entries. Movies Mentioned in this Video: Dirty Rotten Scoundrels: http://amzn.to/2xTpck1 The Princess Bride: http://amzn.to/2yk3tDc Ladyhawke: http://amzn.to/2xOhLsA Stardust: http://amzn.to/2yjJvs9 Young Sherlock Holmes: http://amzn.to/2xaJJNv Mystery Men: http://amzn.to/2yRmQ3r Music Mentioned in this Video: Classic Synthpop and New Wave: Depeche Mode - Violator: http://amzn.to/2utJMqp Alphaville - Forever Young: http://amzn.to/2tl4gle OMD - Messages: The Best of OMD: http://amzn.to/2uyz1Ct New Music by Classic Synthpop Bands: A-ha - Foot of the Mountain: http://amzn.to/2tbfrsv Alphaville - Catching Rays on Giant: http://amzn.to/2tbD445 Underground Modern Synthpop: Code 64 - Departure: http://amzn.to/2tbEtbd Echo Image - Compuphonic: http://amzn.to/2uEvzr4 ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
How to Create an Excel Waterfall Chart or Bridge Graph for Sales Analysis
 
06:12
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ****************************************************************** An Excel Waterfall chart shows the cumulative effect of positive and negative amounts, based on a starting value Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 3705 Mellon Training
Microsoft Excel Training Advanced - Part 7 -  Formatting Axis and Gridlines within Charts and Graphs
 
16:02
Get the full course on Microsoft Excel 2010 advanced here: https://www.simonsezit.com/courses/microsoft/microsoft-excel-2010-advanced-training-tutorials/ In this Simon Sez IT training tutorial, learn how to format axis and gridlines within a chart/graph using Microsoft Excel. Get this course and other courses at https://www.SimonSezIT.com/ Click here for the next video in this 7-hour course - Learn Microsoft Excel 2010 advanced - Part 8 - Showing Trends within a Chart and Graph: https://www.youtube.com/watch?v=Lvq8cuCRECU View the entire Learn Microsoft Excel 2010 advanced course playlist: https://www.youtube.comhttp://www.youtube.com/playlist?list=PLzj7TwUeMQ3h3CdrlW1HftLfBLXNhn8sa Stay in touch: SimonSezIT.com: https://www.simonsezit.com/ The Simon Sez IT email newsletter: http://bit.ly/18bMwY0 YouTube Channel: http://bit.ly/foiItB Facebook: http://on.fb.me/14m8Rwl Twitter: http://bit.ly/177EU5J Google+: http://bit.ly/11JbHdb If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)
Views: 8368 Simon Sez IT
5 Advanced PivotTable Techniques
 
10:09
5 advanced PivotTable techniques in Excel. PivotTables are one of Excel's most important tools. This video demo's 5 advanced PivotTable techniques. View More Tips - http://www.computergaga.com The five different tips and the time they start is shown below. 00:44 - Grouping fields by month and year 02:12 - Showing data as a percentage of total 03:43 - Using Slicers 06:15 - Creating a calculated field 08:50 - Applying Conditional Formatting to a PivotTable Sign up for the online Xtreme PivotTables course to become a PIVOTTABLE MASTER http://goo.gl/JCUz5Y Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1
Views: 454513 Computergaga
Speedometer Gauge Charts learn how to create and use them in Excel Dashboards
 
10:55
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN *************************************************************** How to create a Speedometer Gauge Chart and learn how to use them in Excel Dashboards. Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining Youtube playlist: http://bit.ly/1xP3iqm **************************************************************** Amazing discount for my other courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 213341 Mellon Training
Understanding trendlines in Excel charts and graphs
 
06:34
Understanding trendlines in Excel charts and graphs. You can use trendlines as an important analysis feature in your spreadsheets. Great for projecting sales and budgets, and also how to see and interpret different types of trendlines.
Views: 28133 United Computers
How to Create Bullet Charts and Graphs in Excel
 
06:03
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ****************************************************************** How to Create Bullet Charts and Graphs in Excel Found in many dashboards, the bullet graph serves as a replacement for dashboard gauges and meters. Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 19312 Mellon Training
This Excel Chart will grab your attention (Infographic template included)
 
17:11
Learn how to create Excel graphs that are different to the norm but still visually effective. They are great to include in special reports and dashboards. Download the workbook here: http://bit.ly/2rCXXrE Complete Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards Note: This techniques is a part of my online Dashboard course. The link to the original report I mention in the video - https://business.udemy.com/blog/learning-predictions-2017/ This video shows you how to create special (non-standard) Excel graphs or info-charts in Excel. Not only that but it also shows you how you can conditionally format your graph to highlight specific categories. In this example, I show you how to highlight the week day that has the most users logged on to a system, but you can apply the same technique to any other logic as well. After that, I show you how you can add shapes to charts. This attracts the attention of your readers because it's different to what they are used to seeing. The problem with this technique is that it stretches out the shape for the bigger data sets so depending on the shape you are using, they are no longer harmonized. As a last step, I show you a trick you can use to create harmonized shapes in your Excel graphs. It's all a matter of proper data preparation before you draw out the chart. ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 298116 Leila Gharani
How to Create an Interactive Chart using Excel Scroll Bar - Form Controls
 
05:37
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ****************************************************************** Here is a dynamic way of presenting the information, for example month by month, based on your projections. A pretty effective way of presenting the information using form controls. Learn all the steps to create a powerful dynamic chart and the usefulness for the dashboards. Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 14044 Mellon Training
Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012
 
55:13
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012: Topics in Video: 1. What is Data Analysis? ( 00:53 min mark) 2. How Data Must Be Setup ( 02:53 min mark) Sort: 3. Sort with 1 criteria ( 04:35 min mark) 4. Sort with 2 criteria or more ( 06:27 min mark) 5. Sort by color ( 10:01 min mark) Filter: 6. Filter with 1 criteria ( 11:26 min mark) 7. Filter with 2 criteria or more ( 15:14 min mark) 8. Filter by color ( 16:28 min mark) 9. Filter Text, Numbers, Dates ( 16:50 min mark) 10. Filter by Partial Text ( 20:16 min mark) Pivot Tables: 11. What is a PivotTable? ( 21:05 min mark) 12. Easy 3 step method, Cross Tabulation ( 23:07 min mark) 13. Change the calculation ( 26:52 min mark) 14. More than one calculation ( 28:45 min mark) 15. Value Field Settings (32:36 min mark) 16. Grouping Numbers ( 33:24 min mark) 17. Filter in a Pivot Table ( 35:45 min mark) 18. Slicers ( 37:09 min mark) Charts: 19. Column Charts from Pivot Tables ( 38:37 min mark) Formulas: 20. SUMIFS ( 42:17 min mark) 21. Data Analysis Formula or PivotTables? ( 45:11 min mark) 22. COUNTIF ( 46:12 min mark) 23. Formula to Compare Two Lists: ISNA and MATCH functions ( 47:00 min mark) Getting Data Into Excel 24. Import from CSV file ( 51:21 min mark) 25. Import from Access ( 54:00 min mark) Highline Community College Professional Development Day 2012 Buy excelisfun products: https://teespring.com/stores/excelisfun-store
Views: 1550940 ExcelIsFun
AM 4322-3 Change Chart axes scale and display units microsoft excel 2007 ECDL Advanced ITQ3
 
07:58
AM 4322-3 Change Chart axes scale and display units Microsoft excel 2007 ECDL Advanced ITQ3
Views: 23285 Ron Taylor
Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards
 
02:44:10
Direct links to file: START FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20Seminar-StartFileSoYouCanFollowAlong.xlsx FINISHED FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20SeminarAllFinishedExamplesAfterVideoDone.xlsm Keyboards 0:01:47 Jump: Ctrl + Arrow 0:02:20 Go To Cell A1: Ctrl + Home 0:02:36 Format Cells dialog box or in a chart Format Chart dialog box: Ctrl + 1 0:03:40 Currency Number Format: Ctrl + Shift + 4 0:04:08 Highlight column: Ctrl + Shift + Arrow0:04:20 Currency Vs Accounting Number Format 0:05:00 Alt keys: 0:05:47 PivotTable: Alt, N, V, T 0:05:47 PivotTable 2003: Alt, D, P 0:05:47 Page Setup: Alt, P, S, P 0:05:47 SUM: Alt + = 0:08:38 "Put thing in cell and move selected cell up": Shift + Enter 0:09:35 "Put thing in cell and keep cell selected": Ctrl + Enter 0:09:35 Select sheet to right: Ctrl + PageDown 0:11:11 Select sheet to left: Ctrl + PageUp 0:11:11 Number Formatting As Façade: 0:11:52 Decimal Number Format 0:12:38 Date Number Format 0:13:56 Keyboard for today's hard caded date: 0:13:56 Time Number Format 0:17:10 Percentage Number Format 0:21:25 Efficient Formula Creation 0:25:01 Excel's Golden Rule: If a formula input can vary, put it in a cell and refer to it in the formula with a cell reference 0:25:01 Formula elements, types of formulas, types of data 0:25:01 Monthly Allocation Formula: illustrate formula input that can be hard coded into formula 0:27:00 Tax (inefficient formula): illustrate formula input that can should NOT hard coded into formula 0:27:35 Tax (efficient formula): illustrate Golden Rule 0:27:35 Net Cash In formula: illustrate Golden Rule 0:27:35 Net Income formula: illustrate formula with built-in function within a larger formula 0:30:00 In Balance? formula: illustrate Logical formula 0:30:40 First & Last Name Join Formula: illustrate Text formula 0:31:54 COUNTIF formula: illustrate counting with criteria 0:33:29 COUNTIF & Label formula: illustrate counting with criteria and how the join symbol is used with criteria 0:34:19 Clear Formatting 0:35:50 SUMIFS to add with two criteria 0:36:21 SUMIFS to add between 2 dates 0:38:08 Count workdays formula to illustrate new Excel 2010 function NETWORKDAYS.INTL 0:41:46 Relative and Absolute Cell References 0:41:46 Mixed cell references in budget formula 0:43:58 Lookup Formulas 0:49:50 VLOOKUP to lookup product price: illustrate Exact Match lookup 0:49:50 Data Validation List: 0:53:10 VLOOKUP and IFERROR 0:55:13 VLOOKUP to lookup commission rate: illustrate Approximate Match lookup 0:56:45 Retrieve record (2-way lookup) with VLOOKUP and MATCH 0:59:53 MATCH, ISNA and ISNUMBER functions to compare 2 lists 1:03:38 INDEX and MATCH to lookup Left 1:07:00 Pivot Tables 1:10:02 Proper Data Set 1:10:02 PivotTables Pivot Tables are Easy 1:12:00 Visualize Table First 1:12:00 Adding with One or Two Conditions (Criteria) 1:12:00 Report Layout 1:16:58 Number Formatting 1:17:44 Style Formatting, Create Your Own 1:19:05 Pivoting 1:21:21 Listing Two Fields in Row Labels 1:21:21 Collapsing Pivot Table Row 1:21:59 Changing Calculation: SUM to AVERAGE 1:22:42 Adding with Three Criteria 1:23:29 Filtering a Row (Show Top Two Regions), Clear Filter 1:24:46 Filter whole report with Report Filter 1:25:55 Show Report Filter Pages (30 PivotTables with 1 click) 1:27:55 Filter whole report with Report Filter or Slicer 1:28:30 Compare Formulas and PivotTables 1:30:13 Grouping Dates in PivotTables 1:33:42 Difference between Grouping Integers and Grouping Decimals 1:35:41 Pivot Chart 1:39:00 Show Values As: 1:40:45 Copy PivotTable 1:41:43 Running Totals & % Running Totals 1:42:00 % of Grand Totals, % of Column Total, % of Row Total 1:43:01 Difference From, % Difference From 1:44:17 Multiple Calculation in one PivotTable 1:46:26 Creating Second PivotTable from Second Cache of data using Excel 2003 keyboard shortcut for 3-step Wizard 1:47:54 Blank in number field causes PivotTable to Count by Default 1:49:30 Text in Date field prohibits Grouping of Dates 1:50:09 Recorded Macros For Reports: Basic Recorded Macro 1:51:05 Absolute References and save in Personal Workbook 1:55:10 How to trick the Macro Recorder into seeing a variable height report using Relative References 2:00:51 Rearrange records from vertical orientation to proper table using Relative References 2:09:01 Charts 2:13:35 Chart Types 2:13:35 Column Chart and How The Chart Wizard Interprets Data From Cells 2:17:48 Chart keyboards (Create Default Chart) 2:18:10 Select Data Source Dialog Box 2:20:30 Linking Chart Title to Cells 2:23:09 Saving Chart Templates 2:25:43 Setting Default Charts 2:26:48 Copy Charts 2:27:45 Bar and Stacked Bar charts 2:27:57 Line Chart & Change Source Data 2:31:39 Number Formatting to show "K" or "M" 2:34:52 Line Chart vs. X Y Chart 2:35:53 X Y Scatter 2:36:45 X Y Scatter Line Break Even Analysis Chart 2:41:28 Multiple chart types 2:42:42
Views: 3400605 ExcelIsFun
Advanced Excel - Flash Fill Tutorial 2018
 
07:10
Learn how to use the Flash Fill tool in Excel to quickly fill in data based upon a pattern you've established. Flash Fill can be a great time saver and is pretty fun to use. #exceltutorial #edtech ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
Better Excel Variance Charts to show percentage change (Simple & uncommon technique)
 
12:27
Complete Advanced Excel Chart Course: https://courses.xelplus.com/p/excel-charts-visualization-secrets-for-impressive-charts In a previous video (https://youtu.be/A3NfEkf8S0o), I showed you how you can use conditional formatting in Excel Column or Excel Bar charts. I also showed you how you can conditionally format the data labels in Excel graphs to show a different color if the values are positive to when the values are negative. What I didn't like about that chart was that it was too bulky - and it took away attention from the main column chart that showed the actual sales numbers. In this video, I show you how you can use the Excel error bar technique to create really thin bars (or thick lines) which has a more subtle effect. The result is a visually effective chart that doesn't distract the readers attention from the main chart but also communicates the difference to previous year visually as well. The chart doesn't just use the error bar technique but it also conditionally formats the bars so they are green if the data points are positive and red if the data points are negative. This technique works for Excel 2007, 2010, Excel 2013 and Excel 2016. ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 27503 Leila Gharani
How to Create Waterfall Charts in Excel - or Bridge Charts
 
08:12
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ************************************************************** Learn how to create a waterfall chart in Excel, showing the cumulative effect of positive and negative amounts. A waterfall chart is an advanced type of Excel column chart. You can use an Excel Waterfall chart to show the cumulative effect of positive and negative amounts, based on a starting value. For example, show the monthly net cash flow amounts in a waterfall chart, and quickly see which months had positive and negative results. The first and the last columns in a waterfall chart represent total values. The intermediate columns show positive or negative change from one period to another, ending up in the final total value. A waterfall chart is also known as an Excel bridge chart. These charts are useful for analytical purposes. For example if you want to make a sales analysis or a product earnings analysis, a waterfall chart is ideal. Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 110758 Mellon Training
Excel Dynamic Chart #4: Advanced Filter
 
05:40
See how to use the Advanced Filter to filter data for a dynamic Chart. Chart created from transactional data not aggregated data.
Views: 32178 ExcelIsFun
How to create a Pareto Analysis Chart in Excel - 80/20 Rule or Pareto Principle
 
04:14
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ****************************************************************** How to create a Pareto Analysis Chart in Excel - 80/20 Rule or Pareto Principle A Pareto chart combines a column chart and a line graph. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes. Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 118150 Mellon Training
Creating a chart in Excel: Video 2 - advanced formatting of legends, axis, and titles
 
03:40
Some more info on how to edit legend names, use the Design tab, and add axis data to your chart. Especially useful for bar and column charts, but will work with just about any chart Excel allows.
Views: 3787 Mary Sanseverino
How to Create Chart Templates for Default Chart Formatting in Excel
 
10:49
Learn how to create chart templates in Excel to quickly apply chart formatting options and properties to any new or existing chart/graph. Download the crtx file here:https://www.excelcampus.com/charts/chart-templates-default-formatting/ The default chart formatting in Excel typically includes a lot of extra elements that aren’t always needed for our charts. A nicely formatted chart should include only the minimal amount of elements (legend, axis, labels, gridlines, etc.). This makes the chart easier to read, and allows the data to tell the story. Chart Templates help us automate this process. We can save all the formatting options and settings to a Chart Template, and then apply the template to any new or existing chart. In this video you will learn how to create Chart Templates and apply them to your charts. I also explain how to manage the templates and where to find the ctrx files on your computer. In the next video I explain how to import those crtx files into Excel. Video #2 on how to import Chart Templates: https://youtu.be/bAcVDpXwuCQ Checkout my free 3-part video series on Pivot Tables & Dashboards to learn how to make the pivot table used in this video, and add it to an interactive dashboard. https://youtu.be/9NUjHBNWe9M
Views: 4300 Excel Campus - Jon
Pivot Table Excel Tutorial 2010, 2013 & 2016: Pivot Tables, Slicers, Charts & Dashboards
 
01:04:15
*** SPECIAL OFFER *** JOIN THE MYEXCELONLINE ACADEMY & GET 300+ EXCEL TUTORIALS FOR ONLY $1: https://www.myexcelonline.com/107-53.html In this Excel Pivot Table tutorial you will learn the most important tools within a Pivot Table for Microsoft Excel 2016, 2013, 2010 or 2007 - for Beginners or Advanced users. You will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. I am using Excel 2010 in this tutorial but you can also apply what I teach in Excel Windows versions 2007, 2013 & 2016 and Excel Mac versions 2011 and 2016. In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Excel Dashboards and get noticed by top management & prospective employers. DOWNLOAD THE FREE EXCEL WORKBOOKS FROM THIS VIDEO & BONUS PIVOT TABLE CHEAT SHEETS: https://myexcelonline.com/ytptwebinar You can jump to the following sections within this Excel tutorial by clicking on the time links below: 2:40 CREATE AN EXCEL PIVOT TABLE 3:14 Tabular format 4:13 No gaps in the data 4:48 Use Excel Tables 7:55 Create a Pivot Table 13:50 FORMAT AN EXCEL PIVOT TABLE 15:29 Refresh a Pivot Table upon data change 16:21 Number formatting 17:04 Pivot Table design 18:00 SUMMARIZE VALUES BY: COUNT & AVERAGE 18:20 Summarize by Count 18:35 Summarize by Average 20:30 SHOW VALUES AS CALCULATIONS 22:00 Show Values As: Running Total In (Year To Date) 24:55 Show Values As: Difference From Previous Month 28:10 GROUPING AN EXCEL PIVOT TABLE 28:30 Grouping Numbers 30:40 Grouping Dates 33:40 Group by Text 35:10 INSERT AN EXCEL SLICER 39:25 INSERT AN EXCEL PIVOT CHART 41:50 CREATE AN INTERACTIVE EXCEL DASHBOARD 46:00 BONUS PIVOT TABLE TIPS 46:27 Value for empty cells 46:54 Auto fit column widths on update 48:05 Option to Refresh data 49:00 What's due next month 49:56 Top 10 52:17 Expand Report filter to new worksheets *** SPECIAL OFFER *** JOIN THE MYEXCELONLINE ACADEMY & GET 300+ EXCEL TUTORIALS FOR ONLY $1: https://www.myexcelonline.com/107-53.html VIEW OUR FULL EXCEL ONLINE ACADEMY COURSE HERE WITH 200+ TUTORIALS: https://www.myexcelonline.com/107-46.html MyExcelOnline BLOG (300+ FREE Excel tutorials): http://www.myexcelonline.com/blog MyExcelOnline PODCAST: http://www.myexcelonline.com/podcast Get the Excel Insights From The Excel Experts! Comment and ask Questions about this video below and I will get back to you with the answer! If you enjoyed the video, please give a thumbs up, comment, share and do not forget to SUBSCRIBE to this channel to get my new Excel tutorials delivered straight to you! Thank You :) Cheers, JOHN MICHALOUDIS CHIEF INSPIRATIONAL OFFICER www.myexcelonline.com www.myexcelonline.com/blog www.myexcelonline.com/podcast
Views: 580838 MyExcelOnline.com
How to create a Clustered Stacked Column Chart in Excel
 
02:15
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ****************************************************************** In this video tutorial you'll learn how to create a Clustered Stacked Column Chart in Excel. Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 243623 Mellon Training
Excel Video 128 Pie of Pie Charts
 
06:24
Excel Video 128 introduces Pie of Pie Charts. A Pie of Pie Chart is simply a pie chart with a secondary pie chart that shows the detail of a portion of the primary pie chart. Often you'll have data where a couple of categories make up most of the total followed by a small group of categories often categorized as "Other." A Pie of Pie Chart lets you show the detail of the Other category of the primary pie in a secondary pie on the same chart. Excel gives you a couple of different options to decide which categories go into the secondary pie chart. You can also control how big the secondary pie chart is relative to the primary pie chart and how far apart the two charts are shown. One caution with Pie of Pie Charts is that it's usually best to make the secondary pie chart smaller than the primary pie chart and it's good to include data labels with values so that users don't mistakenly believe a big component of the secondary chart is actually bigger than the components of the primary chart. Excel also offers a Bar of Pie Chart that replaces the secondary pie chart with a bar chart. I'll briefly demonstrate that option at the end of Excel Video 128. I hope you find these videos helpful. Thanks for watching.
Views: 180276 PivotTableGuy
Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards
 
12:25
Improve your Excel dashboards by adding in dynamic charts that allow the user to control what they want to see. Link to complete course: https://courses.xelplus.com/p/professional-excel-dashboards Downloadable workbook available inside the course. In this lecture you will learn how to create a dynamic chart ranges - assume your raw data table is quite big and you'd like the user to specify from which category or date - and to which category & date, they'd like to view the chart data from. Excel Offset function is one formula that you can use to create dynamic ranges, but Excel's Index formula is a great alternative to the OFFSET function AND it's not a volatile function. Once we've figured out the right INDEX formula, we will copy and paste this into name manager and use the name for our chart range. This will provide us with a dynamic chart that only shows the user the range they'd like to view. More Index Match videos: Basics of Index Match: https://youtu.be/F264FpBDX28 Advanced Index Match: https://youtu.be/ontXHp9cwOQ Index Dynamic Ranges: https://youtu.be/YBehCWjcizg ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 45349 Leila Gharani
Advanced Charts Drawing Tools
 
01:45
Learn about the wide range of customizable drawing tools on Advanced Charts.
Views: 6783 FOREX.com
Easy Excel Tutorial - Excel Chart Options (18)
 
06:00
Welcome to the 18th Easy Excel tutorial! This is the third in the Easy Charts series. This tutorial covers more options available to you with Excel charts. This mostly covers the options available in the "Design" tab of Chart Tools. The next tutorial will cover more ways you can format your chart to make it look even more professional. Charts in Excel are very easy and with these tutorials, you WILL become an excel master! Remember to visit my site http://www.EasyProgramming.net to view my other programming tutorials! If you have any suggestions for future videos, feel free to comment and let me know. I hope you enjoy the video and if you have any requests feel free to let me know. Thanks for watching and remember to subscribe! ----------- Subscribe on YouTube: https://www.youtube.com/c/nazmusnasir Support me on Patreon: https://www.patreon.com/nazmus Follow me on Twitter: https://twitter.com/NazmusN Like me on Facebook: https://www.facebook.com/EasyProgrammingNet Follow me on Google+: https://plus.google.com/+NazmusNasir Check out my Github: https://github.com/naztronaut
Views: 3594 Nazmus Nasir
Excel-2007-Graphs-Chart-Legend
 
01:11
The Chart Legend, normally situated over here, makes it easier to understand what is happening in the chart, especially if there is more than one item. You can customize it, click on it, right click and say Format Legend and you get these options. Now these ones, Fill, Border Colour, Style, Shadow are pretty standard. The unique item here is called Legend Options and you'll see you can specify where the Legend should appear -- so maybe you want it to appear at the top and you'll see it has moved here. Bottom -- it is now shown at the bottom. Left, Right, Top Right. You can also see you can choose whether the Legend is allowed to overlap the chart or not. If I tick it off, you'll see now the Legend fills in there. Be aware as well that you are not constrained by only those options If you hover over it and get it to change to the little four arrows, click and you can drag it wherever you want to on your chart.
Advance Excel Part 1(Sorting, Filter, Conditional Formatting with Column chart - How to use Excel
 
19:02
MS Excel Options - How to use in MS Excel 2017, 2016, 2013, 2010, 2007 In this video, we've covered "MS Excel Options “Sorting, Filter, Conditional Formatting with Column chart Options”
Make Column Chart In Excel Hindi
 
07:22
Create Column Chart In Excel. Using Excel, you can create a column chart and give it a brand new, appealing look. As one of the most common chart types, a column chart is useful to compare data points in one or more data series. After you create a column chart, you can change the spacing between the columns. You can also create a floating column chart by hiding a data series in the chart. Data that is arranged in columns or rows on a worksheet can be plotted in a column chart. Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items. In column charts, categories are typically organized along the horizontal axis and values along the vertical axis. Consider using a column chart when: You have one or more data series that you want to plot. Your data contains positive, negative, and zero (0) values. You want to compare the data for numerous categories side by side. When you create a column chart, you can choose one of the following column chart subtypes: Clustered column and clustered column in 3-D Clustered column charts compare values across categories. A clustered column chart displays values in 2-D vertical rectangles. A clustered column in 3-D chart displays the data by using a 3-D perspective only. A third value axis (depth axis) is not used. Clustered column chart and clustered column chart in 3-D You can use a clustered column chart type when you have categories that represent: Ranges of values (for example, item counts). Specific scale arrangements (for example, a Likert scale with entries, such as strongly agree, agree, neutral, disagree, strongly disagree). Names that are not in any specific order (for example, item names, geographic names, or the names of people). NOTE: To present data in a 3-D format that uses three axes (a horizontal axis, a vertical axis, and a depth axis) that you can modify, use a 3-D column chart subtype instead. Stacked column and stacked column in 3-D Stacked column charts show the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. A stacked column chart displays values in 2-D vertical stacked rectangles. A 3-D stacked column chart displays the data by using a 3-D perspective only. A third value axis (depth axis) is not used. Stacked column chart and stacked column chart in 3-D You can use a stacked column chart when you have multiple data series and when you want to emphasize the total. 100% stacked column and 100% stacked column in 3-D 100% stacked column charts and 100% stacked column in 3-D charts compare the percentage that each value contributes to a total across categories. A 100% stacked column chart displays values in 2-D vertical 100% stacked rectangles. A 3-D 100% stacked column chart displays the data by using a 3-D perspective only. A third value axis (depth axis) is not used. 100% stacked column chart and 100% column chart in 3-D You can use a 100% stacked column chart when you have three or more data series and you want to emphasize the contributions to the whole, especially if the total is the same for each category. 3-D column 3-D column charts use three axes that you can modify (a horizontal axis, a vertical axis, and a depth axis), and they compare data points along the horizontal and the depth axes. 3-D column chart You can use a 3-D column chart when you want to compare data across the categories and across the series equally, because this chart type shows categories along both the horizontal axis and the depth axis, while the vertical axis displays the values. Cylinder, cone, and pyramid Cylinder, cone, and pyramid charts are available in the same clustered, stacked, 100% stacked, and 3-D chart types that are provided for rectangular column charts, and they show and compare data exactly the same way. The only difference is that these chart types display cylinder, cone, and pyramid shapes instead of rectangles.The columns chart is great way to represent data like target/achieved, etc in the most visually oriented manner. http://www.myelesson.org
Views: 79483 My E-Lesson
How to use REPT Function to Create Excel in-cell Miniature Charts
 
04:37
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ************************************************************** How to create Excel Mini Charts using REPT Function An in-cell chart is useful because it can instantly provide trending details. Learn how to make an instant, in-cell bar graph using REPT Function Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 3266 Mellon Training
Advance Excel Part 3 (Advance Sort, Find options, Bar Chart apply in report) - How to use Excel
 
16:40
MS Excel Options - How to use in MS Excel 2017, 2016, 2013, 2010, 2007 In this video, we've covered "MS Excel Options “Advance Sort, Find options, Bar Chart apply in report”
Excel 2010: Charts
 
04:55
In this video, you’ll learn more about charts in Excel 2010. Visit https://www.gcflearnfree.org/excel2010/working-with-charts/1/ for our text-based lesson. This video includes information on: • Identifying the parts of a chart • Using chart tools to change chart type, layout, and style • Switching row and column data • Keeping charts up to date We hope you enjoy!
Views: 134846 GCFLearnFree.org
How to Use Sparklines Chart in Microsoft Excel 2016
 
10:20
Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/ During this Microsoft Excel 2016 advanced training tutorial video, we will take a look at sparklines which is a type of chart used in financial application. Checkout some of our other training on YouTube: Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h5ZVxzp_a4UHRQBtXXgnxf Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35 VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge Stay in touch: SimonSezIT.com: http://www.simonsezit.com/ StreamSkill.com: http://streamskill.com/ YouTube Channel: http://bit.ly/foiItB Facebook: http://on.fb.me/14m8Rwl Twitter: http://bit.ly/177EU5J Google+: http://bit.ly/11JbHdb If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-) Hello again and welcome back to our course on Excel 2016 Advanced. In this and the next section we’re going to look at a couple of types of chart that are very often used in financial applications. Having said that, these two types of chart are very different indeed. And in fact the one we’re going to look at in this section, the Sparkline. Where it was introduced quite recently. It came in in Excel 2010. And Sparklines are unlike any of the other types of Excel Chart. Amongst the main differences are that Sparklines are not actually charts in the same way that things like Area Charts and Column Charts and so on are. These are tiny little charts and each chart fits into a worksheet cell. So it doesn’t sort of hover over a sheet. It fits into a cell. Now in fitting into a cell a Sparkline can have other cell content in the cell as well. But the key thing about Sparklines is that they are simple, visual indicators. Now we’re looking at a page here from Google Finance. Obviously this will be out of date by the time that you come to look at it but you’ve got some tiny little charts there. And very often in sources of financial information these tiny little charts are used to show the overall trend of something or perhaps to compare performance of one stock to another stock, that kind of thing. So let’s take a look at how we can use Sparklines in Excel 2016. So in order to demonstrate Sparklines I’m going to go back to the Team Sales 2015 data, the commission sheet we have here. And we’re going to draw Sparklines to show how each member of team A’s commission has progressed over the course of 2015. I’m going to put these Sparklines in column B. so let me just open up a spare column. Let’s make that slightly wider. And then on the Insert tab to the right of the Charts area there’s actually a Sparklines group. There are three types of Sparklines, Lines, Columns and Win/Loss Sparklines. Let’s start with the Line. Now that brings up a Create Sparklines dialog. And we basically have two selections to make. The first selection is for the data that we want to represent in the Sparklines. Now in this case that’s going to be the data from C4 to Q8. And where do we want the Sparklines to be placed? We want them to go in B4 to B8. Click on OK and there are our Sparklines. Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.
Views: 6298 Simon Sez IT
Create an Excel Doughnut Chart
 
01:06
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2fHmfc2 ****************************************************************** A doughnut chart is similar to a pie chart except for its ability to display more than one data series. Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 5227 Mellon Training
Excel: Charts
 
04:31
In this video, you’ll learn the basics of working with charts in Excel 2019, Excel 2016, and Office 365. Visit https://edu.gcfglobal.org/en/excel/charts/1/ for our text-based lesson. This video includes information on: • Understanding and inserting charts • Switching row and column data • Changing chart types • Moving and updating charts We hope you enjoy!
Views: 177352 GCFLearnFree.org
Master Advanced Charts & Graphs in Excel 2016
 
01:45
For more tips like this plus MUCH more, check out my best-selling course on Udemy, now only $25 (85% off!) https://www.udemy.com/advanced-excel-charts-graphs/?couponCode=DVYT25 Full course includes 6+ hours of content, downloadable resources and exercise files, 1-on-1 instructor support and a 100% money-back guarantee. Sign up today!
Views: 3859 Excel Maven
How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3)
 
15:19
http://www.excelcampus.com/charts/pivot-tables-dashboards-part-3 This is part 3 in the series on Pivot Tables and Dashboards. In this video we bring it all together to create the interactive dashboard. You will learn how to: - Group dates into months and years to create a time series trend chart. - Group amounts to create a distribution (histogram) chart. - Add slicers to your pivot tables and charts to make them interactive. - Lots of tips and shortcuts for formatting your charts. You can download the file to follow along at the following link. http://www.excelcampus.com/charts/pivot-tables-dashboards-part-3 Please subscribe to my free email newsletter to get your tutorials like this and get updated about PivotPal. Get PivotPal: http://www.excelcampus.com/pivotpal WATCH PART 1: https://www.youtube.com/watch?v=9NUjHBNWe9M WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Views: 1475718 Excel Campus - Jon
How to Use Pivot Charts in Microsoft Excel 2016
 
09:16
Get 20-hours of Excel 2016 training here ► https://www.simonsezit.com/course-category/excel/ During this Microsoft Excel 2016 advanced training tutorial video, we will take a look at creating pivot chart which is an excellent way of presenting the transactional data that we build into pivot tables. Checkout some of our other training on YouTube: Excel 2016 advanced training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3h5ZVxzp_a4UHRQBtXXgnxf Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFUdlWMkTLZL-Fr3oRGN35 VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g_ABHdUU7RoGJJm-YFr4_Y Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge Stay in touch: SimonSezIT.com: http://www.simonsezit.com/ StreamSkill.com: http://streamskill.com/ YouTube Channel: http://bit.ly/foiItB Facebook: http://on.fb.me/14m8Rwl Twitter: http://bit.ly/177EU5J Google+: http://bit.ly/11JbHdb If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-) Welcome back to our course on Excel 2016 Advanced. In the last few sections we’ve been looking at Pivot Tables. And in this final section on Pivot Tables we’re going to look at creating Pivot Charts which are an excellent way of presenting the kind of transactional data that we build into Pivot Tables. Now creating a Pivot Chart from a Pivot Table is simplicity itself. I’ve got a subset of the store data here. I’ve just got the January, February and March figures. Click anywhere inside the Pivot Table and click on the Analyze tab. And one of the options in there is Pivot Chart. Click on Pivot Chart and I get an Insert Chart dialog. Now the first thing that happens here is that you choose the sort of chart that you’d like to draw. There’s a whole selection of standard Excel Charts there, not all of which are suitable for use with Pivot Table type data. Now what Excel will normally do is to present a recommended chart. In this case it’s got a Clustered Column as the recommendation. Let’s go with the recommendation at the moment and click on OK. Now by default the chart is created on the same sheet as the Pivot Table. I’m going to move it to a separate sheet in just a moment. But first of all it’s easy to resize the chart so I’m going to make it bigger so it’s easier for you to see what’s going on. And now let’s look at the controls on this Pivot Chart. Now the first thing to note is that we have effectively three filters. We have a date filter facility, a branch filter facility and a department filter facility. And you can see easily which of these currently has a filter applied. Now again we’re in the situation that we can only actually see figures for five departments. They’re the only ones with sales over this period. But there is actually no department filter applied at the moment. There is a date filter applied. Of course it’s just showing the first three months of the year. And there is no branch filter applied. We’re seeing all of the branches. The point is though that once we’ve created the chart we can now filter it as much as we’d like to. So if I don’t want to include say the Phoenix figures I can filter them out here. And if I just want to show say coffee and tea I can switch everything else off. In fact of course there are no tea sales over that period but let’s go for coffee and tea. Click on OK. Effectively I can only see coffee sales for three of the branches and there are only coffee sales in February. Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.
Views: 5993 Simon Sez IT
How-to Group and Categorize Excel Chart Legend Entries
 
05:07
Check out the tutorial here: http://exceldashboardtemplates.com/how-to-group-and-categorize-excel-chart-legend-entries Ever had the desire to group and label your legend entries? I had the need recently with a 2 axes chart where I wanted to show which series should be compared against which vertical axis. This is a real cool tip and trick for all Excel Charts.
How to Create a Dynamic - Interactive Chart using Excel Tables
 
02:05
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ****************************************************************** An easy and automatic way to create a chart that depends on a data set with a varying number of rows, using Table feature. ****************************************************************** Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** Amazing discount for my other courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 3847 Mellon Training
Visualizing Data with Excel Charts Part - 1 | Graphical Representation of Data | Edureka
 
26:35
( Advanced MS Excel 2010 - https://www.edureka.co/advanced-ms-excel-self-paced ) Watch Sample Class recording: http://www.edureka.co/advanced-ms-excel-self-paced?utm_source=youtube&utm_medium=referral&utm_campaign=excel-part-1 Advanced MS Excel 2010 course covers all the Excel functions to perform financial, mathematical or statistical calculations such as, DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros. You will also get to implement an Excel project towards the end of the course. Objectives: 1) Understand Excel Abilities and its Functions. 2) Explain Data Security, Formatting and Analyzing concepts. 3) Understand the specialized functions like DSUM, DMAX etc. 4) Explain the advanced options of Pivot Table. 5) Summarize data by using Sparklines. 6) Record and play a macro. 7) Edit a macro using VBA Editor. 8) Explain how to manage scenarios. 9) Describe the restrictions and manipulating techniques. 10) Identify the charts Elements 11)Create dynamic Charts by using Pivot Charts 12)Explain the chart Layout and style 13)Describe the process of mapping a simple document Related Blog : http://www.edureka.co/blog/advanced-ms-excel?utm_source=youtube&utm_medium=referral&utm_campaign=ms_excel_2010_tutorial_1 Edureka is a New Age e-learning platform that provides Instructor-Led Live, Online classes for learners who would prefer a hassle free and self paced learning environment, accessible from any part of the world. The topics related to MS Excel 2010 have extensively been covered in our course'Advanced MS Excel 2010' For more information, please write back to us at [email protected] Call us at US: 1800 275 9730 (toll free) or India: +91-8880862004
Views: 2748 edureka!
Create an Excel Burndown Chart in Simple Steps
 
05:44
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2enNnyN ****************************************************************** Hello Excel Funs, in this video tutorial we are going to build a Burndown Chart in Excel. Until now we learned how to create a Gantt Chart, helpful for a project progress. But a Burn Down chart is a great project management tool which shows if a set of tasks are completed ahead of or behind schedule Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining Youtube playlist: http://bit.ly/1xP3iqm **************************************************************** Amazing discount for my other courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 21321 Mellon Training
Chart Types and Chart Elements in Excel
 
11:43
$10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: http://bit.ly/2fHmfc2 ****************************************************************** Subscribe to channel: http://bit.ly/1KWfq14 View the blog: http://bit.ly/1irPr6y Website: http://www.mellontraining.com Udemy page: https://www.udemy.com/u/andrewex Facebook: https://www.facebook.com/mellontraining Twitter: https://twitter.com/mellontraining Linkedin: gr.linkedin.com/in/andreasexadaktylos Youtube channel: http://www.youtube.com/mellontraining ****************************************************************** How to make a Chart or Graph in Excel Learn the fundamentals of an Excel Chart - the basic elements, and when to use the right type of chart. Is there a way to create a chart in a second? 1st PART: Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data. A chart has many elements. Some of these elements are displayed by default, others can be added as needed. You can change the display of the chart elements by moving them to other locations in the chart, resizing them, or by changing the format. You can also remove chart elements that you do not want to display. After you create a chart, you can modify any one of its elements. 2nd PART (03:15) : A simple chart in Excel can say more than a sheet full of numbers Bar chart or Line? Scatter plot or box plot? These are the questions we ask ourselves when we set out to make a chart. Because, “Selecting right chart for our data” is very important to tell our story. In this lecture, we will learn how to choose the best chart based on our data and situation. 3rd PART (07:24): Building charts and graphs is one of the best ways to visualize data in a clear, easily digestible manner. Here are the simple steps you need to select Data and build a Chart or Graph in Excel. ****************************************************************** Amazing discount for my courses! Python Programming for Beginners : $10 Coupon Link (original price: $50) https://www.udemy.com/python-programming-for-absolute-beginners/?couponCode=STUDENTS10 A Python Practical Programming Course for Absolute Beginners - Learn how to Code in Python and Improve your Productivity ---------------------------------------------------------------------------- Excel Dashboards & Excel Charts Masterclass: $10 Coupon Link (original price: $195) https://www.udemy.com/excel-charts-learn-everything-about-charts-with-excel-2013/?couponCode=SALE10 Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates ---------------------------------------------------------------------------- Excel Macros Mastery & Excel VBA for Non-Programmers: $10 Coupon Link (original price: $95) https://www.udemy.com/excel-macros-excel-vba-for-non-programmers/?couponCode=SALE10 Become a proficient Excel Macro Programmer in a very short time + Excel VBA for beginners. Excel Templates included. ---------------------------------------------------------------------------- Excel Power Pivot & Excel Power BI Masterclass: $10 Coupon Link (original price: $95) https://www.udemy.com/stunning-excel-dashboards-with-powerpivot-and-power-view/?couponCode=SALE10 Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013 ---------------------------------------------------------------------------- Top 100 Microsoft Excel Hacks with Excel 2016: $10 Coupon Link (original price: $20) https://www.udemy.com/excel-hacks-and-tips-with-excel-2016/?couponCode=SALE10 The Best 100 Excel Tips & Hacks with Microsoft Excel 2016 - Excel Templates Included ---------------------------------------------------------------------------- Excel Advanced Charts : $10 Coupon Link (original price: $75) https://www.udemy.com/create-excel-charts-and-graphs-in-2-hours/?couponCode=SALE10 Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included ---------------------------------------------------------------------------- The Complete Gmail Course - 25 Gmail Strategies & Hacks: $10 Coupon Link (original price: $20) https://www.udemy.com/your-gmail-productivity-unleashed-destroy-gmail-timewasters/?couponCode=SALE10 Boost your Productivity with 25+ Gmail Techniques like Gmail Filters , Security , IFTTT . Master Email Communication
Views: 3612 Mellon Training