Excel University Volume 3 Now Available!

EUV3_front_240wI’m pleased to announce the immediate availability of Excel University Volume 3 on Amazon!

Amazon link: amazon.com/dp/1500399434

The third installment in the Excel University series picks up right where Volume 2 leaves off. At the end of V2, we used many features and functions (SUMIFS, EOMONTH, data validation, concatenation, named references, DATE, and so on) to build a formula-based report. In V3, we build the same report without writing a single formula! We build it with the PivotTable feature.

The first section of V3 covers PivotTable fundamentals. The second section explores the report layout and design options that enable us to replace our formula-based reports when appropriate. The third section expands our view of the Excel reporting process, and examines ways to efficiently obtain external data, prepare it for use, and summarize it with reports and graphically with PivotCharts and other features.

Here are the chapters:

Opening Information

  • Chapter 1: Overview
  • Chapter 2: Selected Shortcuts

PivotTable Fundamentals

  • Chapter 3: PivotTable Basics
  • Chapter 4: Row Fields
  • Chapter 5: Value Fields
  • Chapter 6: Column Fields
  • Chapter 7: Filter Fields
  • Chapter 8: Updating Data
  • Chapter 9: Groups and Subtotals
  • Chapter 10: Value Formats
  • Chapter 11: Report Type Comparison

Working with PivotTables

  • Chapter 12: Options
  • Chapter 13: Report Layout and Design
  • Chapter 14: Multiple Value Fields
  • Chapter 15: Calculated Fields
  • Chapter 16: Calculated Items
  • Chapter 17: Show Values As
  • Chapter 18: Sorting
  • Chapter 19: Filtering
  • Chapter 20: Hybrid Reports with GETPIVOTDATA

Obtain > Prepare > Summarize

  • Chapter 21: Web Data
  • Chapter 22: External Data
  • Chapter 23: Text Files
  • Chapter 24: Data Preparation
  • Chapter 25: Accounting System Data
  • Chapter 26: Getting Graphic

I hope the content in this volume helps you get your work done more quickly…and remember…Excel rules!

Next Steps

I still have some things to do and am continuing to work hard on this volume. Over the next several weeks, I’ll be releasing the book that includes the Excel 2010 screenshots, working on the Kindle versions, and launching the related online course. I don’t have exact release dates yet, but am working as fast as I can and will keep you posted!

 

Posted in ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Our training programs start at $29 and will help you learn Excel quickly.

4 Comments

  1. Eve Peterson on October 9, 2014 at 10:56 am

    Congrats! Mazel Tov! Hurray! I will be sure to order. Also enjoy your posts and webinars through Surgent Mc Coy.

    Best,

    Eve

    • jefflenning on October 9, 2014 at 11:16 am

      Thanks Eve! Please enjoy V3…it is my best yet 🙂

  2. wilson on May 19, 2016 at 6:31 am

    Thank you Sir, very usual information since I in the process of getting my certification excel 77-420

    • jefflenning on May 26, 2016 at 7:53 am

      Welcome…and good luck!
      Thanks
      Jeff

Leave a Comment