Join the 1% of Excel users who know how to use the most powerful features and tools in Microsoft Excel
Excel Power View is a powerful new tool in Excel 2013 which will allow you to explore, visualize and present your data in ways you never knew possible.
Learn to use Power View to create powerful interactive graphical dashboards. Power View is an interactive data exploration, visualization and presentation experience that improves decision making and gives you strong insight in to your business.
Amazing Reports and Dashboards with Excel Power View is the second course to be released about Excel Business Intelligence. The Excel Business Intelligence suite of tools includes PivotTables, PowerPivot, Power View, PowerQuery, PowerMap and PowerBI.
Excel Business Intelligence skills and capabilities are in high demand as companies are using Excel to analyze their business data to generate new intelligence and insight. McKinsey Consulting recently released a report showing that approximately 1.5 million new management job positions are required in the United States with data analysis skills and capabilities.
This course introduces you to the Excel Power View interface, teaches you how to create tables and graphs, learn to easily filter data and ask questions of your data, perform powerful data analysis and develop interactive dashboards.
The course also includes how to create relationships between between two tables of data and how to easily create reports and visualizations from both data sources using simple drag and drop actions. The course teaches users how to easily create time based scatterplot and bubbleplot advanced visual analysis techniques.
This course is for any Excel user who develops management reporting or performs data analysis to gain new insight from data. Excel Power View is only available in specific versions of Excel 2013 so first confirm that you have the correct version of Excel.
The course includes two downloadable training datafiles and currently has 23 video lectures showing how to use Excel Power View.
This presentation provides you with an overview and an understanding of the course content.
This step by step guide will show you how to activate Excel Power View in Excel 2013
Please download the Excel training data set. This will allow you to copy the lectures and demonstrations that are in the course.
In this lesson we learn to create the data structure in Excel to be able to analyze our data using Power View and PivotTables.
Learn to add a new Power View canvas to Excel. This lessons shows you how to add a new Power View canvas.
Learn to create effective column charts in Power View.
Learn to create effective bar charts in Power View.
Create Piecharts to display percentage contributions in your data.
Learn to create maps and geographical analysis in Power View.
Scatterplots are a powerful data analysis tool allowing the user to identify correlations and outliers in data. Scatterplots easily allow managers to identify and understand data points that require focus and attention.
Please download the attached spreadsheet for the training data under the supplementary materials section.
Learn to create relationships between one or more tables of data in Excel. Power View develops reports and visualizations from the linked tables of data.
Develop reports and visualizations from tables with relationships in Power View.
Learn to create powerful scatterplot visualizations from tables with relationships in Power View
Create powerful interactive dashboards in Power View
Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio.
Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.
Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.
Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.