CG数据库 >> Excel With Excel Pivot Tables: GetPivotData & Macros

Excel With Excel Pivot Tables: GetPivotData & Macros的图片1Excel With Excel Pivot Tables: GetPivotData & Macros

340 MB | 2 hours | Video: AVC (.MP4) 1280x720 30fps | Audio: AAC 44.1KHz 2ch

Genre: eLearning | Language: English

The

GETPIVOTDATA formula

in a Pivot Table allows you to create custom reports that are not available with a Pivot Table. This is a powerful feature and not many people use it to its full advantage. I show you how easy it is to implement the GETPIVOTDATA formula.

Macros

allow you to automate a repetitive task within Excel so you can save lots of time. I show you how easy it is to create a Macro to automate different Pivot Table commands.

No matter if you are a

Beginner or an Advanced user of Excel

, you are sure to benefit from this course which goes through a specific Excel Pivot Table tool. The course is designed for Excel 2007, 2010 or 2013. In this course there are

FREE downloadable Excel workbooks

for each tutorial that you can keep forever.

https://www.udemy.com/excel-with-excel-pivot-tables-getpivotdata-macros/

Excel With Excel Pivot Tables: GetPivotData & Macros的图片2

发布日期: 2015-03-17