Excel Power

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query  eBooks & eLearning

Posted by Rare-1 at Oct. 3, 2016
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query By Ken Puls, Miguel Escobar
English | ISBN: 1615470344 | 2015 | EPUB | 212 pages | 9.82 MB

Excel 2013: Creating Excel Power Pivot and Power View Dashboards (Repost)  eBooks & eLearning

Posted by ksenya.b at Sept. 2, 2016
Excel 2013: Creating Excel Power Pivot and Power View Dashboards (Repost)

Excel 2013: Creating Excel Power Pivot and Power View Dashboards
Duration: 1h 12m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch | English | 1.74 GB
Genre: eLearning | Level: Intermediate | Exercise Files included

Excel Power Map A Power BI Tool for Reporting Professionals  eBooks & eLearning

Posted by naag at July 17, 2016
Excel Power Map A Power BI Tool for Reporting Professionals

Excel Power Map A Power BI Tool for Reporting Professionals
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 36M | 138 MB
Genre: eLearning | Language: English

Learn Excel Power Map, a 3-D data visualization tool to look information in new way that you can't see with 2-D charts.

Excel Power Pivot and Power Query For Dummies  eBooks & eLearning

Posted by AlenMiler at March 27, 2016
Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies by Michael Alexander
English | Apr 11, 2016 | ISBN: 111921064X | 304 Pages | AZW3/MOBI/EPUB/PDF (conv) | 42.83 MB

A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query?

Mastering Excel: Power Query  eBooks & eLearning

Posted by AlenMiler at March 1, 2016
Mastering Excel: Power Query

Mastering Excel: Power Query by Mark Moore
English | Feb. 1, 2016 | ASIN: B01BD63SSU | 71 Pages | AZW3/MOBI/EPUB/PDF (conv) | 10.1 MB

Welcome another lesson in the Mastering Excel series. This lesson is a slight departure from previous lessons. This lesson is looking into the future and delving into what Excel is becoming: a powerhouse for data analysis.

Microsoft Excel - Power Of Macros In 60 Minutes  

Posted by naag at Dec. 28, 2015
Microsoft Excel - Power Of Macros In 60 Minutes

Microsoft Excel - Power Of Macros In 60 Minutes
MP4 | Video: 1280x720 | 72 kbps | 44 KHz | Duration: 2 Hours | 166 MB
Genre: eLearning | Language: English

A short step-by-step video series on how to use one of Excel's most powerful tools to automate work, the Macro Recorder.
Amazing Reports and Dashboards with Excel Power View

Amazing Reports and Dashboards with Excel Power View
MP4 | Video: 1280x720 | 53 kbps | 44 KHz | Duration: 3 Hours | 485 MB
Genre: eLearning | Language: English

Learn to use the new Excel 2013 PowerView feature to create powerful interactive dashboards and analyze data.

Lynda - Excel Power Pivot DAX in Depth  

Posted by U.N.Owen at June 8, 2015
Lynda - Excel Power Pivot DAX in Depth

Lynda - Excel Power Pivot DAX in Depth
Size: 434MB | Duration: 2h 25m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English

You cannot get far in Excel Power Pivot, the future of personal business intelligence, without an understanding of DAX: Data Analysis Expressions. This course teaches you how to unlock DAX's power by understanding its fundamental elements: its syntax, operators, data types, and functions, including the revolutionary CALCULATE function.
Lynda - Creating Excel Power Pivot and Power View Dashboards

Lynda - Creating Excel Power Pivot and Power View Dashboards | 1.71GB
Duration: 1h 12m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English

All it takes to point your business in the right direction are some strategic insights from your data. In this course, author Ron Davis uses the Power Pivot and Power View plugins to build robust dashboards for analyzing key metrics in Excel—all in just over an hour.

Lynda - Data Modeling with Excel Power Pivot  

Posted by Max-X at Nov. 18, 2014
Lynda - Data Modeling with Excel Power Pivot

Lynda - Data Modeling with Excel Power Pivot
English | Nov 18, 2014 | .MP4 | Video: AVC 1280x720 15&30fps | Audio: AAC 48KHz 2ch | 491 MB
Genre: E-learning

Aggregating and analyzing data from different sources is made easy with Excel's Power Pivot plugin. But before you can glean insights from your data, you'll need to know how to build an effective data model, or collection of tables. In this course, Ron Davis covers all the steps for data modeling with Excel: adding data sources, setting up relationships between tables, and adding hierarchies. Additionally, he explores the power of DAX, the language behind the calculated columns and calculated fields that make for powerful PivotTables.