Ebook: Advanced Data Usage in Excel with PivotTables

Excel Spreadsheets

One of the great advantages of using Excel is the ability to manipulate data in a simple way with the use of formulas, functions, tables and graphs. If you have intermediate knowledge, you'll already be able to generate automatic reports and extract intelligence from your spreadsheet. Now, if you want to use data in an advanced way, you need to know the world of tables and dynamic charts.

In this free ebook with more than 50 pages on dynamic charts and graphs, we will cover practical examples and step by step to get you started using this tool today. Believe me, it is much simpler than you think! See our ebook and take the test:

700x200_dynamic tables

See the ebook structure we have prepared for you:

  1. Introduction to Dynamic Tables
  2. Usage Restrictions
  3. PivotTable Items
  4. 1 Practical Example
  5. Step by Step Construction and Use
  6. Dynamic Graphics
  7. 2 Practical Example
  8. Advanced Topics

With these topics you will learn how to use and will also know exactly all the details so you never get lost while making a PivotTable. To leave you with a taste of want more, follow some pages of the ebook:

1 - We show you exactly which fields and areas to use, we give you some practical cases to exemplify how to drag, what order to do and have the best possible result.

Ebook: Advanced Data Usage in Excel with 1 PivotTables

2 - In addition, we also show you how to use dynamic charts in the process

Ebook: Advanced Data Usage in Excel with 2 PivotTables

Download the ebook right now:

700x200_dynamic tables


Excel Spreadsheets
previous articleKnow the Excel Order function
Next articleAll the content you need about Excel
Administrator and turismologist, passionate about the possibilities that Excel gives to managers, entrepreneurs and students. He is the managing partner of the spreadsheet department at LUZ - Spreadsheets (luz.vc) and is responsible for the development of spreadsheets with business and personal focus commercialized in its website. He also teaches online Excel courses (cursos.luz.vc) and likes to help thousands of planners through the LUZ Forum and Blog.


  1. Hi Rafael, it is pity that all your ebooks are in Portuguese… even that describing paid spreadsheets ie cash flow. Also movies in youtube. Do you have any in English?


Please, write your comment
Please enter your name