Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to PowerView|
This presentation provides you with an overview and an understanding of the course content.
About Excel Power View
|Lecture 3||1 page|
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.
|Section 2: Creating a PowerView Report|
Introduction to the First Section
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 your first table on PowerView.|
|Learn the PowerView menu options and how they affect your dashboards|
|Learn to use the Tiles feature to easily and quickly filter and view your data.|
|Learn to easily create different types and formats of Tables in PowerView.|
|Easily create different methods of aggregation such as average, distinct count, count, max and min|
Pop Outs and Filtering Tables
|Section 3: Graphs and Visualizations|
Introduction to Graphs and Visualizations
Learn to create effective column charts in Power View.
Learn to create effective bar charts in Power View.
Learn to use Line graphs to display trends in data.
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.
Understanding how scatterplots change over time provides new insight and intelligence from data.
|Section 4: Data Relationships|
Introduction to Data Relationships
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
|Section 5: Interactive Dashboards|
Introduction to Interactive Dashboards
Create powerful interactive dashboards in Power View
|Section 6: Conclusion|
Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and techniques making it easy for learners to harness the power of Excel PivotTables, PivotCharts, PowerPivot, Power Query, PowerView and Power BI.
Ian has been training learners on these powerful technologies for a number of years making it easy for the business user 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 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.