Excel Power Query, Power Pivot, Power Map & DAX Masterclass
Excel Power Query, Power Pivot, Power Map & DAX Masterclass |
What you'll learn:
Understand and install the Excel Power Query, Power Pivot, Power Map and Power View add-ins
Import data from spreadsheets, Access, SQL, text files and other sources
Add calculated fields and columns with Data Analysis Expressions (DAX) formula language
Create complex reporting systems
Learn from start to finish the powerful features of Excel Power Map
Design your Excel Dashboard with link buttons
What are KPI's and add key metrics
Create mind blowing Excel Pivot Charts from PowerPivot
Create powerful reports using Slicers and Timeline
Make an amazing interactive sales map using Excel Power View powerful add-in
Summarize data with Matrices, Cards and Tiles
Perform simple-to-sophisticated calculations like Month to date and Year to date
Analyze multiple tables together without the need to ever write VLOOKUP formulas again
Enroll now and master the creation of interactive Excel Dashboards!
100% risk free – 30 day money back guarantee! - Lifetime access
Office Productivity
Microsoft
DAX
couponCode=OKT20-1