Information of news
  • Views: 0
  • Author: downeb
  • Date: 25-11-2013, 03:17
 (Votes #: 0)

Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training)

Category: Tutorial

Download Now

Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training)

Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons
English | 1.74GB
Genre: E-learning




Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training)

7 Hours of Video Instruction

Explore the most popular and some of the lesser known features of Excel " PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel as your guide!

• Start-to-finish personal training on Excel 2013: just watch and learn!

• Simple, quick video walkthroughs of the tasks you perform most often!

• Great personalized training at a fraction of the cost...for everyone who doesn't have time to read a book!

These video lessons will ensure that you can harness the power of Excel faster and more easily than ever before! In 89 quick video lessons, Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel shows how to increase your productivity and optimize Excel's best tools and features. Expert Bill Jelen simplifies powerful features including Formatting, Calculations, Sort & Filter, DAX Calculated Fields, Troubleshooting, Animation and more! Truly harness the power built into Excel! Just watch: You’ll master high-powered skills at your own pace"and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2013 fast"from novices to experienced power users.

Part I: The Basics

1 - Use a Pivot Table to Summarize Detailed Data

2 - Your Manager Wants Your Report Changed

3 - Add or Remove Fields from an Existing Pivot Table

4 - Summarize Pivot Table Data by Three Fields

5 - Why Does the Pivot Table Field List Dialog Keep Disappearing?

6 - Move or Change Part of a Pivot Table

7 - Update Data Behind a Pivot Table

8 - Why Does This Look Different from Excel 2003? Return to the Classic Pivot Table Layout

Part II: Formatting

9 - Compare Four Ways to Show Two Values Fields in a Pivot Table

10 - Kill Compact View

11 - Eliminate Blanks in the Outline Format of a Pivot Table

12 - Suppress Grand Totals in a Pivot Table

13 - Replace Blanks in a Pivot Table with Zeros

14 - Specify a Number Format for a Pivot Table Field

15 - Format Pivot Tables with the Gallery

16 - Add a Format to Gallery

17 - Selecting Parts for Formatting

18 - Icon Set in a Pivot Table

Part III: Calculations

19 - Create a Report That Shows Count, Min, Max, Average, Etc

20 - Percent of Parent, Rank, Running Total In

21 - Calculated Fields in a Pivot Table

22 - Add a Calculated Item for Budget - Actuals

23 - Instead of Using Calculated Items Group Text Fields

Part IV: Sort & Filter

24 - Present a Pivot Table in High-to-Low Order by Revenue

25 - Manually Re-sequence the Order of Data in a Pivot Table

26 - Limit a Pivot Report to Show Just the Top 12 Customers

27 - Filtering a Pivot Table

28 - Add Visual Filters to a Pivot Table with Slicers

29 - Timelines vs Multiple Slicers

Part V: Features

30 - See Detail Behind One Number in a Pivot Table

31 - Group Daily Dates by Month in a Pivot Table

32 - Create a Year-over-Year Analysis

33 - Stop GetPivotData from Appearing

34 - Group by Week in a Pivot Table

35 - Group Numbers to Create Frequency Chart

36 - Grouping one pivot table groups all pivot tables; new Cache

Part VI: Uses

37 - Create a Unique List of Customers with a Pivot Table

38 - Use a Pivot Table to Compare Two Lists

39 - Fixing Customer Name problems Using a Pivot Table

40 - Show Text Fields for a Pareto Chart

Part VII: Tips

41 - Base your pivot table on a Table When New Data Might Be Added

42 - Show Yes/No As the Values in a Pivot Table

43 - Create Perfectly Formatted Pivot Tables Using GETPIVOTDATA

44 - Create a Worksheet for Every Customer Using Show Report Filter Pages

45 - Controlling Multiple Pivot Tables with One Set of Slicers

46 - Reduce Pivot Table Workbook Size by 50% Before Sending

47 - Create a Pivot Table from Access Data

48 - Create a chart from a pivot table with Pivot Charts

Part VIII: Troubleshooting

49 - Compatibility between versions

50 - Force Missing Months to Show in a Pivot Table

51 - Whatever Happened to Multiple Consolidation Ranges in Pivot Tables?

52 - Cleaning up bad data before creating a pivot table

53 - Pivot Data Where the Source Data Has Dates Stretching Across the Columns

Part IX: PowerPivot

54 - Using the Data Model in Excel 2013 to Join Two Tables

55 - Distinct Count in Excel 2013

56 - True Top Five in Excel 2013

57 - Using Named Sets for Asymmetric Reports

58 - Getting PowerPivot

59 - Load Data into PowerPivot

60 - Define Relationships in the PowerPivot Window or Diagram View

61 - Creating the Pivot Table - Compare Choices

62 - Changing the Calculation from Sum & Other Differences

Part X: DAX Calculated Fields

63 - DAX Measures

64 - Use DAX Measures to Calculate a Range

65 - Use DAX Measures to un-apply a Filter

66 - Using a Calendar Table for Time Intelligence

67 - Time Intelligence Functions

68 - Disconnected Parameter Tables with FILTER()

69 - Actuals vs Budget

70 - Using IF(VALUES in a Measure

71 - Build Slicers on Lookup Tables

72 - First Initial Slicer (and turning off cross-slicer filtering)

73 - Convert the Pivot Table to Cube Formulas

Part XI: Power View

74 - Preparing your data for PowerView

75 - Adding a Power View Worksheet

76 - Adding a Dashboard Element as a Table

77 - Converting Table to a Chart

78 - Explicit and Implicit Slicers

79 - Understanding the Filter Pane

80 - Using Tile Boxes

81 - Replicating Charts Using Multiples

82 - Showing Data on a Map

83 - Showing Images in Table or Card View

84 - Formatting Power View

85 - Animating a Scatter Chart over Time

Part XII: GeoFlow

86 - Adding data to GeoFlow

87 - Flying through the map

88 - Animating GeoFlow

89 - Building a tour in GeoFlow

LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more.
With a Premium account you can download files having Fullspeed !

Uploaded Links


Lumfile Links


Secureupload Links

Direct Download


Tags: PivotTables, PowerPivot, GeoFlow, MrExcel, LiveLessons, Training


Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training) Fast Download via Rapidshare Hotfile Fileserve Filesonic Megaupload, Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training) Torrents and Emule Download or anything related.
Dear visitor, you went to website as unregistered user.
We encourage you to Register or Login to website under your name.

Add comments

Name:*
E-Mail:*
Comments:
Enter Code: *