Einloggen Kostenlos testen

Follow us

Willkommen bei Bookboon

Um unsere Dienste anbieten zu können, sind wir auf eine Reihe essentieller Cookies angewiesen.

Details zu Cookies ansehen
Kategorien Unternehmen
home.book.professional_ebook

Excel PivotTables Made Easy

A Step-by-Step Guide to PivotTables in Excel

von Alan Murray
95
Sprache:  English
This book is a complete guide to PivotTables in Excel. In this step-by-step guide, you will learn all you need to know about PivotTables in Excel.
Professional Plus Mitgliedschaft 30 Tage gratis, danach $6.99/Monat
Zugriff auf das Buch in unserem eReader; keine Werbung im Buch
Beschreibung
Inhalt

This book is a complete guide to PivotTables in Excel.PivotTables are one of the most popular and powerful tools in Excel. In this step-by-step guide, you will learn all you need to know about PivotTables in Excel.You will learn to;

  • Create your first PivotTables
  • Group, sort, filter and change calculations
  • Customise PivotTables styles and layouts
  • Use Slicers for interactive reports
  • Work with PivotCharts
  • Modify settings so PivotTables work how you want them to
  • Use the data model to create PivotTables from multiple tables.

About the Author

Alan is an Excel trainer, YouTuber, and Microsoft MVP. He has been helping people in Excel for over 20 years. He loves training, and seeing users succeed with Excel.Alan runs his own blog - Computergaga and has a YouTube channel, also named Computergaga, with over 530 videos and over 28 million views.He organises a free Excel meetup group in London where people can go to learn, chat and share about Excel.

  • About the Author
  • Introduction
  1. Getting Started with PivotTables
    1. Insert a PivotTable from a Range
    2. Insert a PivotTable from a Table
    3. Arranging PivotTable Fields
    4. Number Formatting
    5. Sort PivotTable Values
    6. Refresh PivotTable Data
  2. PivotTable Calculations
    1. Change PivotTable Function
    2. Group PivotTable Data
    3. Show Values As Percentages, Running Totals and Rankings
  3. PivotTable Styles and Other Design Settings
    1. Show and Hide PivotTable Totals
    2. PivotTable Report Options
    3. PivotTable Styles
  4. Filter your PivotTables and Using Slicers
    1. Report Filter
    2. Field Filter
    3. Using Slicers
  5. Using PivotCharts
    1. Insert a PivotChart
    2. Modify the PivotChart
  6. Customise your PivotTables to Work for You
    1. PivotTable Options
    2. Default PivotTable Layout Options
  7. Working with the Data Model – An Introduction
    1. Introduction to our Data
    2. Create Relationships Between Tables
    3. Create a PivotTable from the Data Model
Schreiben Sie eine Rezension
Über den Autor/die Autorin
Alan

Alan Murray

home.book.discover_author
home.book.related_content