Home Archives for Create Subtotals in Excel
September 20, 2012 Leave a Comment

Instructional Guide “9 Essential Excel 2010 Skills” – Download for Free

Instructional Guide "9 Essential Excel 2010 Skills"

Instructional Guide “9 Essential Excel 2010 Skills”

I want you to discover the scope of the Excel Training that I offer on my new video tutorial, “9 Essential Excel 2010 Skills.” So, I am offering the PDF of the Step-by-Step Instructional Guide that accompanies the video tutorial.

Link to The Company Rocks Free Resources Page

Click on this link to begin the download process for the Instructional Guide.

Instructions for Downloading the Free Instructional Guide

  1. Add this product to your secure shopping cart at my website.
  2. During Checkout, you can choose to either Register or Shop as a Guest
  3. You will need to provide a valid email address in order to receive the actual link to download my Instructional Guide.
  4. Even though you will be downloading this product, I had to set it up as a physical product with “Free Shipping.”
  5. Shortly after you complete the checkout process you will receive an email that contains a hyperlink to the file that you will download.
  6. You will be downloading a “zipped” file. So, once the download is completed, be sure to “unzip” this file!
  7. I created my Instructional Guide using the free Adobe Acrobat Reader.

Read the Instructional Guide and then Purchase my Video!

I am convinced that once you see the scope of the training in Excel 2010 that I offer, you will want to purchase the video tutorial. I offer my video in tow versions:

List of the “9 Essential Excel 2010 Skills”

9 Essential Skills for Excel 2010

9 Essential Skills for Excel 2010 Video Tutorial

These are the 9 Essential Skills that I have identified for my video tutorial:

  1. Entering Data Efficiently in Excel 2010
  2. Selecting Cell Ranges Efficiently in Excel 2010
  3. Creating and Using Named Cell Ranges in Excel 2010
  4. Applying Styles and Formatting to Excel 2010 Worksheets
  5. Working with Structured Data Sets in Excel 2010
  6. Working with Excel 2010 Formulas and Functions
  7. Using Paste Special Options in Excel 2010
  8. Using Data Validation in Excel 2010
  9. Using Excel 2010 “What-if” Analysis Tools

Excel 2010 Practice Files Included

When you purchase my video tutorial, you receive the same Excel 2010 Worksheets that I used while filming each of the 25 video tutorials. Using the same files as you view my videos, you will be able to practice your new skills. And, of course, you also receive the same Instructional Guide that I am offering for free!

I welcome your feedback! Please send me your comments via email – danny@thecompanyrocks.com – or by adding a comment below.

Thank you!

 

Link to this post!
Filed Under: COUNTIF and SUMIF Functions, Data Validation, Everyday Calculations in Excel, Excel Basics, Excel Data Tables and Lists, Excel Formulas, Excel Functions, Excel Training, Format Cells in Excel, Goal Seek in Excel, MS Excel Tips, MS Excel Training, Names for Cells and Ranges, New in Excel 2010, Online Store for The Company Rocks, Subtotals and Outlines in Excel, SUMIF and SUMIFS Functions, Video Training Courses, What-if Analysis Tagged: , , , , , , , , , , , , , , , , ,
September 8, 2012 Leave a Comment

Review for my Latest Publication – “9 Essential Skills for Excel 2010”

Main Menu Essential Skills for Excel

Main Menu for “9 Essential Excel Skills”

I just received a fabulous review, from one of my viewers, for my video tutorial, “9 Essential Skills for Excel 2010.”

Read this Review

Product Reviews

It’s really a master piece!!

Posted by Tamoghna on 8th Sep 2012

“I was a beta tester of “9 Essential Excel Skills- Excel 2010” by Danny Rocks. In one word this is an excellent resource for anyone who wants to master those essential skills which are required to use excel professionally. There are total 9 chapters which consist of a series of dense but brief video lessons.

The lessons have been planned in a careful way so that the viewers are introduced from simple to more complex topics.

Surely you are going to be amazed by the incredible picture and sound quality of the videos. I had a feeling as if I was watching an excel movie while putting my head phone. Danny has several qualities as an instructor. His pace of delivery and voice modulation is just fantastic and if you are not an absolute excel-newbie watching a video just one time is enough. Before starting each lesson he gives a brief introduction so that you can connect what you learned in the previous lesson. He also repeats and stresses some part which you will find really helpful.

Another great take away from this video tutorial is a bunch of great keyboard shortcuts and best excel practices which you can expect only from an excel veteran. Among so many other things I was left with surprise why I didn’t use “page layout view” and “vertical alignment formatting” before! Even if you are an advanced excel user surely you are going to learn a lot of useful tricks including some commonly encountered gotchas and how to avoid them.

I won’t be taken aback If this product goes every corner of the excel user community and becomes best seller in this field.”

Learn More About My Video Tutorial

I have produced the “9 Essential Skills for Excel 2010” in two formats:

Both versions include 4 hours of video instruction. 25 individual video tutorials. The Excel Practice files that I used while filming the video tutorials. A PDF of the Step-by-step Instructional Guide that I created for these video lessons.

Version for Excel 2007 Now Available!

DVD-ROM, "9 Essential Excel 2007 Skills"

DVD-ROM, “9 Essential Excel 2007 Skills”

I have just published “9 Essential Excel 2007 Skills” for DVD-ROM. Click to to get more information about my latest publication.

Secure Shopping at The Company Rocks

You can use a secure shopping cart to purchase my products at my online shopping website – http://shop.thecompanyrocks.com

 

 

Link to this post!
Filed Under: Excel Training, Online Store for The Company Rocks, Reviews, Video Training Courses Tagged: , , , , , , , , , , , , , , , , , , , , ,
August 30, 2012 Leave a Comment

Take a Complete,10 Minute, Video Lesson from my Latest Publication

9 Essential Excel 2010 Skills

9 Essential Excel 2010 Skills

I am very proud to announce my latest publication – “Nine Essential Skills for Excel 2010.” I have made my publication available in two formats:

What You Get with this Preview

Here, in this preview of my publication, I offer you one, complete, ten-minute, video tutorial from my video publication. This video tutorial demonstrates how to use Subtotals and Pivot Tables in Excel 2010. On my video publication, you will find 24 additional video tutorials just like this. You will get @ 4 hours of focused video instruction to help you to master the Essential Skills in Excel 2010!

The Nine Essential Skills for Excel 2010

Here are – in my opinion – The “Nine Essential Skills in Excel 2010”:

  1. Entering Data Efficiently – 4 video tutorials Run Time: 28:42
  2. Selecting Cell Ranges Efficiently – 2 video tutorials Run Time 13:28
  3. Creating & Using Named Cell Ranges – 2 video tutorials Run Time 16:00
  4. Applying Styles & Formatting – 3 video tutorials Run Time 22:49
  5. Working with Structured Data Sets – 4 video tutorials Run Time 32:00
  6. Working with Formulas & Functions – 4 video tutorials Run Time 52:16
  7. Using Paste Special Options – 2 video tutorials Run Time 17:18
  8. Using Data Validation – 2 video tutorials Run Time 12:34
  9. Using “What-if” Analysis Tools – 2 video tutorials Run Time 15:09

I have tried to offer a range of Video Tutorials that appeal to both the beginning Level and the Intermediate Level Excel user. That is why, I decided to separate each chapter into multiple episodes. In this manner, I can offer the Beginning Level Excel User the foundational instruction that they require without “boring” a more experienced user.

Supporting Materials Included in My Publication

In addition to the 25 individual video tutorials included in my package, you will also receive:

  • A PDF Instructional Booklet that you can print out to use as you follow each video lesson.
  • The actual Excel Workbook files that I used while filming these videos that you can use to practice your new Excel 2010 skills.

Learn More About this Publication

I invite you to click on this link to learn more about the “Nine Essential Excel 2010 Skills” Video Publication

Watch this Video Tutorial in High Definition

Follow this link to watch my video tutorial in High Definition on my YouTube Channel – DannyRocksExcels

View this Tutorial Now

 

Link to this post!
Filed Under: Excel Training, Online Store for The Company Rocks, Pivot Tables, Subtotals and Outlines in Excel Tagged: , , , , , , , , ,
July 9, 2011 Leave a Comment

Three and a Half Ways to Average Excel Data Using Criteria

AverageIf Function in Excel

AverageIf Function in Excel

It is easy to use Excel’s AVERAGE Function to get the average for an entire range of data. But, what if you are asked to produce a report that shows the average for select groups of records – for example, average test results for the female students only; or for the male students only? What approach do you take? What Functions do you use to produce this report?

Three and a Half Ways to Produce this Report

  • SUBTOTALS – Easy to use. Remember to sort your data first using the field that you want to subtotal.
  • AVERAGEIF Function – Very easy to use. Only works in Excel 2007 and Excel 2010.
  • DAVERAGE Function – Will work in any version of Excel. Easy to add or change the Criteria.
  • PIVOT TABLE – Very easy to create. No need to write a formula. Create report with @ 6 mouse clicks!

My Preferred Approach – Create a Pivot Table Report

While Pivot Tables are the most powerful tool in Excel, they are also one of the easiest tools to use in Excel! Why?

  • Because you can create a Pivot Table Report without writing a single formula!
  • You can create this Pivot Table Report with about six clicks of the mouse.
  • You cannot possibly harm your underlying data when you create Pivot Tables!

Download a One Hour- Plus / In-depth Video Tutorial on Pivot Tables – for $9.95

I have created a series of Excel Video Tutorials that you can download for $9.95 US Dollars each. Here is a link to my informational page that gives you the details.

  • Are you Using Excel 2003? – I created a video recording for Pivot Tables using Excel 2003 that you can download for $9.95!
  • Are you Using Excel 2007? – I created a video recording for Pivot Tables using Excel 2007 that you can download for $9.95!
  • Are you Using Excel 2010? – I created a video recording for Pivot Tables using Excel 2010 that you can download for $9.95!

As with all of my products, I guarantee that you will be 100% Satisfied or I will refund your purchase price – no questions asked!

My Extended length Excel Training Video Recordings are hosted at: http://thecompanyrocks.webex.com – I use the secure shopping cart at WebEx by Cisco Systems, so you can be sure that your personal information is safe and secure.

Watch Video in High Definition on YouTube

Follow this link to watch this video tutorial in High Definition mode on my YouTube Channel – DannyRocks Excels

Get My DVD-ROM, “The 50 Best Tips for Excel 2007” for only $29.97

Three and a Half Ways to Average Excel Data with Criteria [ 9:24 ] Play Now | Play in Popup | Download (1375)
Link to this post!
Filed Under: Excel Functions, Excel Training, Pivot Tables, Podcast Tips & Timesavers, Subtotals and Outlines in Excel, WebEx by Cisco, WebEx Recordings & Webinars Tagged: , , , , , , , , , , , ,
May 20, 2010 1 Comment

Changing Pivot Table Summaries in Excel 2007

In this Excel Video Lesson I demonstrate how to show an additional Pivot Table Summary, “Percentage of Total,”  alongside a traditional ( Sum of Amount) subtotal. It is easy to do – if you know where to look. In the Field Settings Dialog Box for your Pivot Table, click on the “Show Values As” tab and then select the option that you want from the drop-down listing. In this lesson I use “% of Column.”

Watch me demonstrate how to do this.

If your want to learn the best tips for Excel, I encourage you to purchase my DVD – “The 50 Best Tips for Excel 2007.” Click here to enter my secure shopping site and make your selection. I guarantee your satisfaction 100%. If you are not satisfied, then I will refund your purchase price.

Additional Resources

Extended Length – 90 Minutes – Video Tutorials for Excel Pivot Tables now available – Download or on DVD-ROM

You can view – and download – this video on YouTube. I welcome you to subscribe to my YouTube Channel, DannyRocksExcels

Learn how you can “Quickly Create Pivot Tables” in Excel

Related Excel Training Videos

Link to this post!
Filed Under: Excel Training, Pivot Tables Tagged: , , , , ,
February 11, 2010 2 Comments

Video Tour My DVD – The 50 Best Tips for Excel 2007

I invite you to join me on a four minute, seven second video tour of my new instructional DVD, “The 50 Best Tips, Tricks & Techniques for Excel 2007.”

This DVD is different. If you want to learn Excel and you are pressed for time (and who isn’t these days?) this is the DVD for you. I give you over 5 1/2 hours of focused video instruction. The average length of each video lesson is 6 1/2 minutes! So you can find the topic that you want, learn it, and put it into practice at home or at work in under 10 minutes!

As a bonus, I include the 50 Excel worksheets that I used to create and film the video lessons. Now you can practice the tips to master your new Excel skills!

Follow this link if  you want to see the complete list of the 50 video lessons on my DVD.

Are you ready to purchase “The 50 Best Tips for Excel 2007?” Follow this link to enter the online bookstore for The Company Rocks. This is a secure shopping site. And, I guarantee that you will be satisfied with your purchase. If you are not satisfied with your purchase, I will refund you money – no questions asked!

Sincerely,

Danny Rocks

Related Videos

Link to this post!
Filed Under: Excel Training, MS Excel 2007 DVD, MS Excel Tips, Online Store for The Company Rocks, Tips and Time Savers, Video Training Courses Tagged: , , , , , , , , , , ,
June 7, 2009 2 Comments

My New DVD – The 50 Best Tips for MS Excel 2007 is now on sale

50 Best Tips fo MS Excel

New! Now available from the online store at www.thecompanyrocks.com

Do you ever have one of those “A-ha” moments? You know – those moments when everything falls into place. When everything becomes crystal clear. When you finally “get it!”

Well, here is your opportunity to experience 50  “A-ha” moments. Here is a great way for you to learn “The 50 Best TIps, Tricks, and Techniques for Microsoft Excel 2007.”

I spent almost three months filming these short Excel training videos. I worked hard to create this DVD in order to make it easy for you to learn how to remain productive at work while learning to use the new Excel 2007 interface.

And, the Excel 2007 interface is really quite different.

So different, that many long-time Excel users just give up on it and return to the tried and true Excel 2003 program.

And that is too bad. Because, Excel 2007 allows you to perform so many business tasks faster and better. But … first, you must get over “the initial learning curve” to understand how to navigate in Excel 2007.

This DVD makes it easy for you to learn how to use Microsoft Excel 2007 – guaranteed!

In selecting the 50 Best Tips for Excel 2007, I wanted to include tricks that all Excel users could put to use – now! I include tips at the Introductory, Intermediate and Advanced levels.

Each lesson is short – five to six minutes on average – and focused on just one topic. Each lesson on the DVD is self-contained – I teach you how to solve one problem per lesson.Overall, the DVD contains 5 1/2 hours of training on Excel 2007!

This DVD is available exclusively from the SkillPath Seminars bookstore. They are offering it for sale at the introductory price of $49.95 Here is a link to the demonstration / order now page.

I am proud of this product. I know that you will gain some new insights into how to get the most out of Excel 2007. I welcome  your feedback. Please drop me a note  – danny@thecompanyrocks.com Or … add your comments below for all readers to share.

Thank you for your support!

Danny Rocks

Link to this post!
Filed Under: Excel Training, MS Excel 2007 DVD, Online Store for The Company Rocks Tagged: , , , , , , , , , , , ,
October 27, 2008 Leave a Comment

Consolidate Data as a Quick Alternative to Subtotals

I have a great tip for you! When you need to produce a quick summary report of your data, use Consolidate in place of Subtotals. Here’s why:

  • You don’t have to sort the data when you consolidate.
  • You can use multiple functions (SUM, AVERAGE) in adjacent columns in your report.
  • You can easily copy and paste the Consolidated Summary Report to another workbook or into Word.

Watch this short video as I demonstrate how to use Data Consolidate in place of Subtotals.

Steps to follow in this lesson:

  1. Select an empty cell. Choose Data – Consolidate.
  2. In the dialog box, choose the Function that you want (SUM is the most common) and then select your data range (including the Column Headers) and click ADD.
  3. Be sure to check the Use Labels in “Top Row” and “Left Column.” Click OK
  4. A quirk – The Label for the Category does not appear when you Consolidate Data – Simply copy & paste it from cell A1.
  5. Repeat these steps to add an additional Function – e.g. AVERAGE to your Consolidation Report.
  6. Copy and paste the Consolidated Data to another workbook or to another application – e.g. MS Word.
  7. Contrast this quick alternative to creating Subtotals.
  8. The real “Time Saver” comes from the ability to quickly copy the Consolidated Summary.
  9. The “Gotcha” to remember with Subtotals is to choose “Edit – Go To – Special – Visible Cells Only” before you copy the Level 2 Subtotals. If you omit this step, you will discover that you have copied ALL of the data and not just the summary!

Find the Excel Training Video that you want – Click here for the Index to all Excel Topics

Learn how to “Master Excel in Minutes – Not Months!”

Link to this post!
Filed Under: Consolidate Excel Data, Excel 2003 Video Lessons, Excel Training, Tips and Time Savers Tagged: , , , ,
August 9, 2008 Leave a Comment

Review Custom List Sorting, Subtotals, and Consolidation in Excel

This video reviews 4 Excel topics. Creating a Custom List and then sorting according to the Custom List; Creating Subtotals and also Consolidating Data according to Category.

These topics are consistently the most viewed on my website.

Here are the steps to follow in this Excel Video Lesson:

  1. Enter the values for your Custom List in either a column or row. Select the list and then Spell Check it (F7 key is the shortcut.)
  2. With the list still selected, go to Tools, Options, Custom List Tab, Import, OK.
  3. To sort data using the Custom List, be sure to click Options and then select the custom list from the drop-down in “First key sort order.”
  4. Sort your list prior to creating Subtotals. Data, Subtotals and then make selections in the dialog box.
  5. Consolidate Data by Category: First, select the top cell where your Consolidation Report will appear. Then select Data, Consolidation. Select the Reference Range to be consolidated. When consolidating “By Category,” be sure to select your Top Row (Labels) as well as the data. Click Add.
  6. Be sure to check the “Use labels in:” Top Row and Left Column boxes. Click OK.

Find the Excel Video Lesson that you want – Index to all Excel Topics

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.

Related Excel Video Lessons

Link to this post!
Filed Under: Excel Training, Most Viewed Excel Videos Tagged: , , ,