Home Archives for The 50 Best Tips for Excel 2007
December 20, 2010 1 Comment

Learn How to Quickly Create Excel Pivot Table Reports

Excel Data Set

Data Set in Excel

Many people are curious about Excel Pivot Tables. They would like to learn how to create a Pivot Table, but they fear that that will take too long and be difficult to learn. 

Here’s the good news! Pivot Tables are one of the most powerful tool in Excel AND Pivot Tables are also one of the easiest Excel Techniques to learn! It sounds like a contradiction, doesn’t it? 

How would you like to turn this data set – with over 500 rows of data … 

into this Pivot Table Summary Report with @ six clicks of the mouse? 

Pivot Table Row & Column

Pivot Table Summary

 That’s all it takes. With a Pivot Table you turn long lists of data into summarized information that highlights the trends and patterns in your business. 

Special: Save 20% on any purchase! Use Coupon SAVE-20-PCT during Checkout! 

I can teach you how to get started on the road to mastering Excel Pivot Tables. On my DVD-ROM, “The 50 Best Tips for Excel 2007,” I have the following Pivot Table video lessons: 

  • Introducing Pivot Tables – Run time: 8:23
    • Why Use Pivot Tables?
    • How to Create a Pivot Table
    • How to Modify a Pivot Table
    • How to Update a Pivot Table
  • Grouping and Charting in Pivot Tables – Run time: 5:50
    • Grouping Pivot Table Fields by Month, Quarter and Year
    • Grouping Pivot Table Fields by Week
    • Collapsing and Expanding Pivot Table Fields
    • Creating Pivot Charts
  • Using New Pivot Table Features in Excel 2007 – Run time: 7:46
    • Base Your Pivot Table on an Excel Table
    • Adjust Pivot Table Report Layouts
    • Apply Conditional Formatting to Pivot Tables
    • Insert Blank Rows in Your Pivot Table Report
The 50 Best Tips

The 50 Best Tips Series

As you can see from the “Run times,” each lesson is focused on one Excel technique. If you don’t have a lot of time and you want to quickly learn how to create Pivot Tables, my DVD-ROM is the best place to begin. 

Here is a PDF that you can download to see the content and Run times for each of my tips: The 50 Best Tips for Excel 2007 Detailed Content Listing 

And, here is a link to my Archive of Free Pivot Table Videos  on The Company Rocks website. 

Learn how to “Quickly Create Excel Pivot Table Reports and Charts” 

Thank you! 

Danny Rocks

Link to this post!
Filed Under: Excel Training, MS Excel 2007 DVD, New in Excel 2007, Online Store for The Company Rocks, Pivot Tables Tagged: , , , , ,
September 26, 2010 Leave a Comment

How to Create and Modify Excel Pivot Tables

How is it possible that the most powerful tool in Excel is also one of the easiest tools to use? An Excel Pivot Table is, in my opinion, the most powerful tool for analyzing data and presenting it as valuable and actionable information. And, an Excel Pivot Table is also one of the easiest tools to use.  

Summarize Data with Pivot Tables

Create a Pivot Table

Create a Pivot Table in six steps:  

  1. With one cell in the data table selected, I clicked on the Insert Tab of the Ribbon and clicked Pivot Table.
  2. I made one change to the default settings – I clicked a cell on the current worksheet to place my Pivot Table.
  3. On the Pivot Table Field List, I placed the Division Field in the Columns area and the Products Field  in the Rows area,
  4. Also on the Pivot Table Field List, I placed the Sales Field in the Values area.
  5. To format the Sales field Subtotals, I Right-clicked a single number and chose Value Field Settings – Number Format.
  6. I also changed the name from “Sum of Sales” to “Sales Revenue.”

It’s that easy! Try it yourself. You will be amazed at how easy it is to create your first Pivot Table. And… as an added bonus, with a Pivot Table you can not harm the underlying data! Pivot Tables work with a “virtual snapshot” of your actual data. Because a Pivot Table uses a “memory cache”  of your data, you can quickly swap your data fields from Rows to Columns to Filters, etc. This is done quickly and efficiently. 

Learn how to “Quickly Create Excel Pivot Table Reports and Charts.”

Here, on the website of The Company Rocks, I offer many free Excel Training Videos to help you get started to create and modify Excel Pivot Tables. Here are the links to the Introductory set of Pivot Table video lessons: 

You can also search for free Excel Pivot Table Video Lessons by following these links: 

“The 50 Best Tips for Excel 2007” DVD

Excel Tip List

Excel DVD Tips

You can also purchase my DVD, “The 50 Best Tips for Excel 2007.”It is affordable and it offers over 5 1/2 hours of focused Excel training tips, tricks and techniques. 

Follow this link to start shopping with my secure shopping cart. I guarantee that you will enjoy my Excel Video Tips. If you are not 100% satisfied, I will refund your purchase price with no questions asked!

Link to this post!
Filed Under: Excel Training, Pivot Tables Tagged: , , ,
December 30, 2009 Leave a Comment

The Online Store for The Company Rocks has Opened for Business!

DVDs of The 50 Best Tips for Excel and PowerPointI am proud to announce that my online store for The Company Rocks is now open!

You can now purchase my two DVDs without leaving my website.

“The 50 Best Tips for Excel 2007” contains over 5 1/2 hours of training. Each video lesson focuses on one tip and you can learn it in @ 6 minutes! The tips range from Beginning Level to the Advanced level. The majority of Tips (30 tips) are at the Intermediate level. If you enjoy the lessons that I post here, now you can own a DVD of the 50 Best Tips – now for Excel 2007!

“The 50 Best Tips for PowerPoint 2007” contains over 7 hours of training on two DVDs! I put a lot of effort into producing this DVD – and the customers who have already purchased it tell me that has immediately improved their presentation skills.

This DVD is unique!

Because, I do not teach PowerPoint as a “techie.” Rather, I am a professional speaker and trainer and I show you how to use PowerPoint as a tool to use during your presentations. Of course I show you how to create animations and how to create custom PowerPoint shows. But, significantly, I demonstrate how best to use custom animations and why you should prepare Custom PowerPoint shows. If you think you know PowerPoint, think again. I guarantee that you will learn new techniques for PowerPoint and … you will learn how to take advantage of the many great new graphic features available in PowerPoint 2007.

I invite you to visit my online store. The DVDs are in stock and attractively priced. I know that you will learn new tips and refine your skills in PowerPoint and Excel when you watch one of my lessons.

  • Invest 10 minutes to learn a new productivity tip – and, save yourself hours of frustration and avoid having to rekey data entries in Excel 2007.
  • Invest 10 minutes to learn a new presentation tip – and, learn how to deliver presentations using PowerPoint 2007 that get you the sale or get your audience to take action.
  • Invest 10 minutes and learn how to use the new Office 2007 interface. I show you how to always have your favorite commands right at your fingertips.

Finally, let me wish you a very Happy New Year in 2010!

Sincerely,

Danny Rocks

danny@thecompanyrocks.com

Link to this post!
Filed Under: Excel Training, MS Excel 2007 DVD, MS PowerPoint 2007, Online Store for The Company Rocks Tagged: , , , , , ,
February 17, 2009

Will be back posting Excel Video Lessons – Soon!

Hello Friends!

The 50 Best Tips

The 50 Best Tips Series

I have been working on an Excel Training Video project for commercial release – hence, my lack of postings.

This project has required focused attention and research. I have almost completed this project – and I will be back posting additional Excel Video Lessons this week. Thank you for your patience, understanding and continuing patronage.

I have now completed all five of the Microsoft Office 2007 Training DVD-ROMs. You can purchase The 50 Best Tips for – Excel, PowerPoint, Word, Outlook and Access 2007 online using my secure shopping cart. Click here to begin shipping.

Sincerely,

Danny Rocks

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, MS Excel Training, New in Excel 2007, Online Store for The Company Rocks Tagged: , , , , , ,