Subtotals And Outlines In Excel

Danny September 20, 2012 Leave a Comment

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

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

Add this product to your secure shopping cart at my website.
During Checkout, you can choose to either Register or Shop as a Guest
You will need to provide a valid email address in order to receive the actual link to download my Instructional Guide.
Even though you will be downloading this product, I had to set it up as a physical product with “Free Shipping.”
Shortly after you complete the checkout process you will receive an email that contains a hyperlink to the file that you will download.
You will be downloading a “zipped” file. So, once the download is completed, be sure to “unzip” this file!
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 Video Tutorial

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

Entering Data Efficiently in Excel 2010
Selecting Cell Ranges Efficiently in Excel 2010
Creating and Using Named Cell Ranges in Excel 2010
Applying Styles and Formatting to Excel 2010 Worksheets
Working with Structured Data Sets in Excel 2010
Working with Excel 2010 Formulas and Functions
Using Paste Special Options in Excel 2010
Using Data Validation in Excel 2010
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!

Share and Enjoy:

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: "What-if" Analysis in Excel, Absolute cell reference, AutoFill Options, COUNTIF Function, Create Subtotals in Excel, Data Validation, Excel Functions, Excel Video Training, Go To Special dialog box, IF() Function, Keyboard Shortcuts in Excel, Learn to use AutoFill in Excel, Lookup Functions in Excel, Named Cell in a formula, Paste Special, SUMIF Function, Video lessons for Excel, VLOOKUP Function

Danny August 30, 2012 Leave a Comment

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

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”:

Entering Data Efficiently – 4 video tutorials Run Time: 28:42
Selecting Cell Ranges Efficiently – 2 video tutorials Run Time 13:28
Creating & Using Named Cell Ranges – 2 video tutorials Run Time 16:00
Applying Styles & Formatting – 3 video tutorials Run Time 22:49
Working with Structured Data Sets – 4 video tutorials Run Time 32:00
Working with Formulas & Functions – 4 video tutorials Run Time 52:16
Using Paste Special Options – 2 video tutorials Run Time 17:18
Using Data Validation – 2 video tutorials Run Time 12:34
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

Share and Enjoy:

Filed Under: Excel Training, Online Store for The Company Rocks, Pivot Tables, Subtotals and Outlines in Excel Tagged: Apply Filters in Excel, Create Subtotals in Excel, Excel Pivot Tables, Excel Subtotals, Excel Video Training, Filter on Cell Value in Excel, Go To Special dialog box, Remove Filters in Excel, Video lessons for Excel, Visible Cells Only in Excel

Danny July 9, 2011 Leave a Comment

Three and a Half Ways to Average Excel Data Using Criteria

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

Share and Enjoy:

Three and a Half Ways to Average Excel Data with Criteria [ 9:24 ] Play Now | Play in Popup | Download (1375)

Filed Under: Excel Functions, Excel Training, Pivot Tables, Podcast Tips & Timesavers, Subtotals and Outlines in Excel, WebEx by Cisco, WebEx Recordings & Webinars Tagged: AverageIf Function in Excel, Cgange Subtotal Function in Pivot Tables, Create Subtotals in Excel, Database Functions in Excel, DAVERAGE Function in Excel, Excel Functions that use Criteria, Excel Pivot Tables, Excel Video Training, Format Numbers in Pivot Table Fields, New in Excel 2007, Records that Match Criteria, subtotal your data, Video lessons for Excel

Danny June 2, 2011 1 Comment

Don’t Subtotal Excel Data, Use Subtotal Function Instead

Subtotal Function Numbers

I used to love creating Subtotaled Reports. They are useful. They are easy to create. But they are also “clunky.” In my opinion, there are too many steps to take when you wish to see a Subtotal for a different field or to use a different function in your Subtotals.

Let me introduce you to the Subtotal Function in Excel. Here are several ways to take advantage of this function:

You can place the Subtotal Function in any cell on your worksheet – it does not have to reside directly below your data field.
You can use the Subtotal Function in connection with Data Filters – to get the subtotal for the visible cells in a filter.
You can use any of the 11 functions available to the Subtotal Function (Sum, Average, Count, etc.)

Watch This Video in High Definition on YouTube

This file size for this video is a little bigger than usual. So, to watch it, click on this link to view it in High Definition Mode on YouTube.

Subtotal Function Part Two

I have decided to film a second video lesson on the topic of the Subtotal Function – Using Subtotal Function in Excel Tables and Lists. Click on this link to watch my second video on this topic.

Watch or Download My 24 minute Introduction to Pivot Tables Video Recording

I have started to posted a series of “extended length” video tutorials online at: http://thecompanyrocks.webex.com – Follow this link to get more information about viewing or downloading my “free” Introduction to Pivot Tables.”

Get my best-selling DVD-ROM, “The 50 Best Tips for Excel 2007” for only $29.97!

Share and Enjoy:

Filed Under: Excel Data Tables and Lists, Excel Functions, Excel Training, Subtotals and Outlines in Excel, YouTube Videos by Danny Rocks Tagged: Excel Subtotals, FIlter a List in Excel, Subtotal a Filtered List, Subtotal Function, subtotal your data

Danny December 24, 2010 1 Comment

How to Outline an Excel Worksheet

Many Excel worksheets – e.g. Budgets and Sales Reports – can be improved by applying an Outline. With an Outline, you can switch your focus between looking at the “big picture” and examining the details. An outline is especially useful when you are presenting numbers “interactively.” For example, when you are using a Projector and Screen to present Quarterly Sales Results during a meeting.

: Outline Commands

If you have set up your Excel worksheet in a “hierarchical” structure – SUMs at the bottom and to the right of each category, creating an outline is simple:

Create the Outline

Select a single cell in the worksheet.
On the Data Tab of the Ribbon (Excel 2007) go to Group – Auto Outline.
You now see the Outline Symbols “+ and -” above each column and to the left of each row. Depending on your data, you will also see numbers that represent the “level” of Outlining available.

Examine the Formulas

When a client sends me an Excel worksheet, one of the first steps that I take is to find all of the cells that contain formulas. A quick way to do this is with the F5 Keyboard Shortcut. This opens the “Go To” Dialog Box. Choose “Special” and then select “Formulas.” Now, all of the cells that contain Formulas are highlighted. If everything is correctly organized, then I apply the “Auto Outline” command to the worksheet.

Keyboard Shortcuts

Use the Ctrl + 8 keyboard shortcut to “toggle” between Hiding and Displaying the Outline Symbols. This is a great tip to learn – you still have the Outline, but your screen looks cleaner. And … I guarantee that several people in your audience will ask you “How did you do that?”

Custom Views

During the video lesson, I also show you how and why to apply Custom Views to your Outlines. A Custom View allows you to quickly display a different perspectives of your data. Set them up in advance – it is almost like having a PowerPoint slide presentation inside your Excel worksheet outline!

You can watch this Excel video lesson in High Definition, Full Screen mode on my DannyRocksExcels YouTube channel.

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

Share and Enjoy:

How to Outline an Excel Worksheet [ 7:25 ] Play Now | Play in Popup | Download (1100)

Filed Under: Excel Training, Podcast Tips & Timesavers, Subtotals and Outlines in Excel Tagged: Custom Views in Excel, Excel Keyboard Shortcuts, Excel Video Training, Excel's GoTo Command, Group Data in Excel, Outline Excel Worksheets, Video lessons for Excel

Danny Rocks “Training You to Excel”

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

Link to The Company Rocks Free Resources Page

Instructions for Downloading the Free Instructional Guide

Read the Instructional Guide and then Purchase my Video!