Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Abonneren
Bereik wereldwijd miljoenen mensen door optimaal gebruik te maken van je kennis.
Meer informatie
Je winkelwagentje is leeg.
Verder winkelen
Microsoft Excel Pivot Tables - Beginner to Advanced
Score 4,6 van de 5(4,512 scores)
17.221 studenten
Gemaakt doorKyle Pew • 2,000,000+ Students, Office Newb
Laatst bijgewerkt: 1-2023
Engels

Wat je leert

  • Prepare Microsoft Excel data for PivotTable reporting
  • Connect PivotTables to various data sources
  • Create and manage PivotTable calculations
  • Format PivotTables for presentations
  • Update PivotTable source data
  • Create and manage Excel Data Models to pull in data from multiple sources
  • Create and manage data relationships
  • Create Dashboard elements in a PivotTable

Verwante onderwerpen verkennen

Cursusinhoud

10 secties • 59 colleges • Totale lengte van 4u 32m

  • Microsoft Excel PivotTables - Beginner to Advanced Course Introduction5:45
  • Excel PivotTable Course Exercise Files (DOWNLOAD)2:33
  • Excel PivotTable Course QA (ASK QUESTIONS)2:56
  • CHALLENGE 01: Post to the Course QA

Vereisten

  • Familiar with working in Microsoft Excel

Beschrijving

WHY EXCEL PIVOT TABLES

Mastering Microsoft Excel PivotTables will change the way you approach reporting. Through a few clicks of the mouse Excel PivotTables allow you to quickly and efficiently summarize large data sets.

COURSE DESIGNED TO HELP YOU SUCCEED

This Microsoft Excel PivotTables - Beginner to Advanced course will take your skills from absolute PivotTable beginner to Advanced PivotTable user. Each section of the course has been designed to focus on a specific skill set. Once that skill set is mastered, then you will move to the next section that builds upon the previous skill set. After completing the first few sections of the course you will feel like you can conquer the world with the reports you can create, but there's more.

Each section contains instructor lead lectures with step-by-step instruction and encouragement to try the various topics for yourself, using the course provided exercise files. Each section also contains mini challenges where you can practice the skill you are mastering with additional exercises and quizzes on the topics.

WHAT YOU'LL LEARN

  • Create dynamic reports that will help with making intelligent business decisions

  • Capture data from a single source or from multiple related sources

  • Apply proper list design techniques to make reporting a breeze

  • Summarize data with built in Excel functions and custom calculations

  • Format your report for clear presentation

JOIN ME

Enroll now and learn to harness the power of Microsoft Excel PivotTables.


Voor wie is deze cursus bedoeld:

  • This course is intended for users familiar with working in Microsoft Excel but wish to master working with Excels PivotTable feature.
  • Microsoft Excel users who want to become more efficient in summarizing and reporting on large datasets within Excel

Misbruik rapporteren