 Hi everybody! This is a short video to demonstrate how we can conduct data visualization right within Excel using Excel functions. In Excel we can create built-in charts or pivot charts to present data graphically. On the right there's a few sample of these charts that we use, plain old charts that sometimes meets our business demands, but as technology and the business advance that oftentimes these plain old charts couldn't convey the information that we want to extract out of the data more intuitively. And there are many ways to present the data nowadays beyond what you see here. And how can we do that? So for instance when we need to present the data in a 3D manner like a 3D control of a mountain or any any object that nowadays 3D modeling can generate. Or when we need to present data within the geographic information system content such as Google map as a background so that we can show information over the map. Or we have a need to present the data with a heat map again with geographic back information. Or some other special graphs that could easily present the data or connections between the data if otherwise would be difficult to convey. So with all these information obviously Excel couldn't do it. And what are the options that beyond Excel you could buy expensive software and spend many weeks to learn how to use it. And eventually it goes down to create a few charts that you need specifically. And does it worth it in terms of money and time? Or you can think of another way that is any easy way or a more cost effective way to to come up with these graphs easily. And with Excel you can get it done in minutes and a lot of these charts are free to you. So in some in summary that Excel has built-in graphic tools that sometimes couldn't meet your business demands and Excel is presented as a low-cost and agile option that you can easily generate intuitive or interactive charts. Excel is an open platform that based on the cloud so you can assess these tools anywhere as long as you have internet. And as a user you can easily conduct these data visualization right within Excel. And the nice thing doesn't stop here as a developer actually you can customize your app in your favorite programming language be it Python, Java or others and you can share the developer app over the Excel platform to others. So with Excel you can only draw plain old charts and within five minutes any user could generate all of these charts right within Excel and we're going to show how. So let's quickly go over what is Excel. Excel stands for Excel tool. Excel is an Excel adding tool that backed by cloud-based application libraries and knowledge base to help you to be more productive at work. And it has many nice features including one click for all applications and it is simple and yet parametric modular tools that allows you to do simple logic but many times for many data that you need to process repetitively it is one button click essentially. And you can host the library or application library both at local or on the cloud depends on what you need and you can easily customize archive and share these apps with others. And let's quickly go over the interface should you not familiar with the interface right now. Once you install our client end which is very light-duty you have user account here that basically manages what are the apps that you would be able to access and once you log in you can come in and search for any apps that you can run directly out of Excel and those apps will generally operate the data that you have prepared here. And once you familiar with the apps and you want to use them over and over without need to search for them you can make them favorite apps here and you can customize your layout to show different favorite apps under different circumstances for instance you want to work on Excel functions you can use this layout and if you want to use data visualization you can change to data visualization app group. So that's all you need to use Excel X tool. Ribbon customization this video will demonstrate how to customize the X tool ribbon. Sometimes multiple repeated functions must be used to complete a task or a user performs certain tasks more than others and does not want to repeatedly search for the same function. The X tool ribbon can be customized and interchanged by the user from a blank spreadsheet click on the X tool tab make sure the X tool account is registered and signed in clicking on the layout tab enables browsing through existing ribbons if they have been created or imported. To create or import a ribbon click on the customize layout button the applications on the ribbon can be separated by group and multiple ribbons can be created for multiple purposes click on the add new app button to add a function to the ribbon app appearance details can be modified at any time by clicking on the modify app button details such as layout group image size and description can be changed anytime previously created ribbons can be imported by clicking on the import button imported files or zip files ribbons can also be exported to share or be used on another computer by clicking on the export button these files are also compressed ribbons can also be renamed anytime by clicking on the rename layout button ribbons can also be deleted by clicking on the delete button applications can be deleted by clicking on the delete selected app button application order can also be changed by clicking on the arrow buttons this is how your icons will appear on the ribbon according to group depending on your specified size these are small to run an app simply click on the icon and the X tool tab will appear then enter the data as usual and run the function thank you hi everybody this is a short video to go over the data visualization package one that we offer to this course and with X tool platform we can have many apps to generate various data visualization charts based on different needs and the implementation of these apps could using many different type of language or techniques and we'll quickly go over some of them here and for one is that and let's go over the apps one by one in the first app is we use Python to create 3d generate 3d surface plots and second one is that we use JavaScript to create force arrow interactive charts that third is that we use geographic information system to plot pins on Google map or we can use this geographic information system plot many data other data on Google map as well and we can use all to show dashboard type of plots for the data in statistical applications and we can use JavaScript to plot scatter plots scatter points and there are other apps that we can plot for multiple stock that we can collect the stock real-time information and present them in in a conventional or prevailing stock price graphs and so on so forth thank you very much force arrow chart this video will demonstrate how to create a force arrow chart in Excel by using X tool it would be ideal if this graphic could be created by only using Excel functions some third party apps create data visualizations but the capabilities are limited the graphics aren't animated most significantly it costs money X tool can create this dynamic animated chart in seconds for free from a blank spreadsheet click on the X tool tab make sure you're signed in then click on the X tool button once the program is open search with the key word arrow since this is going to be a force arrow chart click on the force arrow chart function this demonstration will be using the sample data from the existing knowledge base once clicked a spreadsheet with the essential information needed for running this app will appear this is the sample data that will be used X tool has already grouped the data needed to create this chart together by performing the Excel list selected range function when ready to perform the function highlight the gray area on the chart listing the input data instead of clicking on knowledge base like last time click on run click on collect selection address to confirm the set of data needed for the chart if this is a frequently run task archive it by either selecting a blank cell where the formula can be pasted and click on write app name on the main X tool tab then right click and choose the X tool option to run or the function can be pinned to your customizable ribbon edit preferences here and add app it will appear here according to your designated preferences once app is run and the data has processed a browser window will open and your completed graphic will appear thank you scatter plot this video will demonstrate how to create a scatter plot in Excel by using X tool it would be ideal if this graphic could be created by only using Excel functions some third party apps create data visualizations but the capabilities are limited the graphics aren't animated most significantly it cost money X tool can create this dynamic animated chart in seconds for free from a blank spreadsheet click on the X tool tab make sure you're signed in then click on the X tool button once the program is open search with the keyword scatter since this is going to be a scatter plot click on the plot scatter points function this demonstration will be using the sample data from the existing knowledge base once clicked a spreadsheet with the essential information needed for running this app will appear this is the sample data that will be used X tool has already grouped the data needed to create this chart together by performing the Excel list selected range function when ready to perform the function highlight the gray area on the chart listing the input data instead of clicking on knowledge base like last time click on run click on collect selection address to confirm the set of data needed for the chart if this is a frequently run tasks archive it by either selecting a blank cell where the formula can be pasted and click on write app name on the main X tool tab then right click and choose the X tool option to run or the function can be pinned to your customizable ribbon edit preferences here and add app it will appear here according to your designated preferences once app is run and the data has processed a browser window will open and your completed graphic will appear thank you data plot on a Google map this video will demonstrate how to create a data plot on a Google map by using X tool it would be ideal if this graphic could be created by only using Excel functions some third-party apps create data visualizations but the capabilities are limited the graphics aren't animated most significantly it costs money X tool can create this dynamic animated visualization for free in seconds from a blank spreadsheet click on the X tool tab make sure you're signed in then click on the X tool button once the program is open search with the keyword Google since this is going to be a data plot on a Google map click on the plot data on Google map function this demonstration will be using sample data from the existing knowledge base once clicked a spreadsheet with the essential information needed for running this app will appear this is the sample data that will be used X tool is already grouped the data needed to create this chart together by performing the Excel list selected range function when ready to perform the function highlight the gray area on the chart listing the input data instead of clicking on knowledge base like last time click on run click on collect selection address to confirm the set of data needed for the graphic if this is a frequently run task archive it by either selecting a blank cell where the formula can be pasted and click on write app name on the main X tool tab then right-click and choose the X tool option to run or the function can be pinned to your customizable ribbon edit preferences here and add the app it will appear here according to your designated preferences once the app is run and the data has processed a browser window will open then your completed graphic will appear thank you Sankey diagram this video will demonstrate how to create a Sankey diagram by using X tool it would be ideal if this graphic could be created by only using Excel functions some third-party apps create data visualizations but the capabilities are limited the graphics aren't animated most significantly it costs money X tool can create this dynamic animated visualization in seconds for free from a blank spreadsheet click on the X tool tab make sure you're signed in then click on the X tool button once the program is open search with the keyword sand key since this is going to be a Sankey diagram click on the product category Sankey function this demonstration will be using sample data from the existing knowledge base once clicked a spreadsheet with the essential information needed for running this app will appear this is the sample data that will be used Excel has already grouped the data needed to create this chart together by performing the Excel list selected range function when ready to perform the function highlight the gray area on the chart listing the input data instead of clicking on knowledge base like last time click on run click on collect selection address to confirm the set of data needed for the graphic if this is a frequently run task archive it by either selecting a blank cell where the formula can be pasted and clicking on the right app name on the main X tool tab then right click and choose the X tool option to run where the function can be pinned to your customizable ribbon edit preference here and add the app it will appear here according to your designated preferences once the app is run in the data is processed a browser window will open then your completed graphic will appear thank you migration animation map this video will demonstrate how to create a migration animation map by using X tool it would be ideal if this graphic could be created by only using Excel functions some third-party apps create data visualizations but capabilities are limited the graphics aren't animated most significantly it costs money X tool can create this dynamic animated visualization for free in seconds from a blank spreadsheet click on the X tool tab make sure you're signed in then click on the X tool button once the program is open search with the keyword migration since this is going to be a migration animation map click on the migration animation function this demonstration will be using the sample data from the existing knowledge base once clicked a spreadsheet with the essential information needed for running this app will appear this is the sample data that will be used Excel has already grouped the data needed to create this chart together by performing the Excel list selected range function when ready to perform the function highlight the gray area on the chart listing the input data instead of clicking on knowledge base like last time click on run click on collect selection address to confirm the set of data needed for the graphic if this is a frequently run task archive it by either selecting a blank cell where the formula can be pasted and clicking on write app name on the main X tool tab then right click and choose the X tool option to run or the function can be pinned to your customizable ribbon edit preferences here and add the app it will appear here according to your designated preferences once the app has run and the data is processed a browser window will open then your completed graphic will appear thank you stepped waterfall chart this video will demonstrate how to create a step of waterfall chart by using X tool it would be ideal if this graphic can be created by only using Excel functions some third-party apps create data visualizations but the capabilities are limited the graphics aren't animated most significantly it costs money X tool can create this dynamic animated visualization in seconds for free from a blank spreadsheet click on the X tool tab make sure you're signed in then click on the X tool button once the program is open search with the he word waterfall since this is going to be a stepped waterfall chart click on the stepped waterfall function this demonstration will be using the sample data from the existing knowledge base once clicked a spreadsheet with the essential information needed for running this app will appear this is the sample data that will be used X tool has already grouped the data needed to create this chart together by performing the Excel list selected range function when ready to perform the function highlight the gray area on the chart listing the input data instead of clicking on knowledge base like last time click on run click on collect selection address to confirm the set of data needed for the graphic if this is a frequently run task archive it by either selecting a blank cell where the formula can be pasted and clicking on the right app name on the main X tool tab then right click and choose the X tool option to run or the function can be pinned to your customizable ribbon edit preferences here and add the app it will appear here according to your designated preferences once the app has run and the data is processed a browser window will open then your completed graphic will appear thank you basic radar chart this video will demonstrate how to create a basic radar chart by using X tool it would be ideal if this graphic could be created by only using Excel functions some third-party apps create data visualizations but the capabilities are limited the graphics aren't animated most significantly it costs money X tool can create this dynamic animated visualization in seconds for free from a blank spreadsheet click on the X tool tab make sure you're signed in then click on the X tool button once the program is open search with the keyword radar since this is going to be a basic radar chart click on the radar basic function this demonstration will be using the sample data from the existing knowledge base once clicked a spreadsheet with the essential information needed for running this app will appear this is the sample data that will be used X tool is already grouped the data needed to create this chart together by performing the Excel list selected range function when ready to perform the function highlight the gray area on the chart listing the input data instead of clicking on knowledge base like last time click on click on collect selection address to confirm the set of data needed for the graphic if this is a frequently run task archive it by either selecting a blank cell where the formula can be pasted and clicking on right app name on the main X tool tab then right click and choose the X tool option to run or the function can be pinned to your customizable ribbon edit preferences here and add the app it will appear here according to your designated preferences once the app is run and the data is processed a browser window will open then your completed graphic will appear thank you congratulations you have covered many aspects of the data visualization using Excel and powered by X tool and we go over the data visualization means and methods within Excel and what are the additional needs that we have for data visualization with current technology development and how we can offer them be above and beyond Excel and we also introduce X tool as an option for you to easily create all of these charts right within Excel without relying expensive and complicated software and we go over two packages of X tool data visualization applications that for the package one we demonstrate that we can use various technology you basically JavaScript Python or R to present the data in various manner or present the data in the matter of graphical information system or 3d rendering and so on so forth and in the second package we focus on business intelligence only we use a third-party eCharts library to create many business intelligence related charts right within Excel so with that what is the few things that we want to remember out of this course is that if you think Excel is powerful in terms of data visualization you would see that through the sample apps Excel with cloud technology will make you a Superman at work so it is only an introductory course for these sample X tool apps that we have developed you would be able to find much more extra application that on our platform you can go to our website to find more about it and the goal of this course is not only introduce these applications but rather explain the idea and implementation process to boost your productivity at your work and our platform is structured to be open for any developer to contribute and register the app and share with anybody over the world and you can customize your own knowledge base or application library on the platform as well so the information beyond this course is available at our website www.goldparator.com you can always email us if you have any additional increase and we will send periodically the latest news about our development and on YouTube we have a series of channels that talk about various aspects of the X tool applications one of them is business intelligence or data visualization apps that you can easily learn from the videos in fact all of the apps that we included in this course is included in the YouTube as well so the meetup is that we if you live in San Francisco Bay area we have local meetup group that meet regularly search for Excel in Bay area on meetup and if you have any question or further needs you can always email me at thenew.do at goparator.com thank you very much have fun with data visualization with Excel and X tool