WebEx By Cisco | The Company Rocks

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 27, 2011 Leave a Comment

How a Single Blank Cell Affects an Excel Pivot Table Report

As you will see in this Excel Video Tutorial, having a single blank cell in a data set will greatly affect how Excel Functions and Pivot Tables are designed and calculated.

Single Blank Cell in Data

Imagine, how a single blank cell, in a field of 848 records, can change the way your Pivot Table views the data type (text vs. the expected numeric data type) and subtotal function (Count vs. the expected SUM function).

Seeing is believing!

Preventing a Blank Cell from “Creeping into” your data set

Use the Keyboard Shortcut Ctrl + Down Directional Arrow to go to the last cell that contains data in a column. This is a great way to isolate “stray” blank cells that will have a great impact on your Pivot Tables and other calculations in Excel.

Also, in Excel 2007 and Excel 2010, look for where a “numeric” field is placed by default. A single blank cell will cause an (intended) numeric field to be placed in the Row (text) labels area. Even dragging this field into the VALUES Drop zone does not solve the problem because the COUNT Function will be used to Subtotal this field. This is a “disaster waiting to happen!”

Introducing My Extended Length Excel Video Recordings

This is my opportunity to introduce you to my new, extended-length (one-hour +) Excel Video Tutorials that you can download for only US $9.95!

Here is the link that gives you more information about this exciting new service:

http://www.thecompanyrocks.com/pivot-table-tutorial-videos-to-download-practice-files-instructional-manual-included/

I offer you multiple options:

If you are using Excel 2003, you can download the video recording for that version.
If you are using Excel 2007, you can download the video recording for that version.
If you are using Excel 2010, you can download the video recording for that version.
You can quickly download the PDF of Step-by step instructions for each version.
You can download the Excel Workbooks that I use in each recording.

Let me know what you think!

Let me know which topics you would like me to record for you to download.

Send me an email with your comments and suggestions: danny@thecompanyrocks.com

Watch This Video in High Definition

Follow this link to view this Excel Tutorial in High Definition on my YouTube Channel – DannyRocksExcels

Share and Enjoy:

How a Single Blank Cell Affects an Excel Pivot Table Report [ 7:21 ] Play Now | Play in Popup | Download (1129)

Filed Under: Excel Functions, Excel Training, Pivot Tables, Podcast Tips & Timesavers, WebEx by Cisco, WebEx Recordings & Webinars Tagged: Excel Functions, Excel Pivot Tables, Excel Video Training, Find Blank Cells in a Column or Row, Video lessons for Excel, WebEx Video Recordings

Danny May 24, 2011 Leave a Comment

My Extended Length Pivot Tables Video Recordings Available for Excel 2003, 2007 and Excel 2010

On my WebEx site – http://thecompanyrocks.webex.com – I have posted three, one-hour-plus video recordings to help you to learn how to create and customize Excel Pivot Tables:

Download “Free of Charge” Resources for Each Recording

Click on the hyperlinks above to go to a special landing page for each Excel version. From the landing page, you will find links to download the resources that accompany each version:

The Excel Workbook – in each version of Excel (2003, 2007, 2010) that I use during the video recording.
- These are stored on my “SkyDrive” at Windows Live – www.office.live.com – a free service for registered members.
The Step-by-Step Instructional Manual that I created for each Excel version of my recordings.
- Available as an Adobe Acrobat PDF or as a Word Document

Very Attractive Pricing for Recordings

I have decided to price each of these recordings – which you can download to your computer – at US$9.95

Imagine what you would have to pay to hire a trainer – per hour – to teach you these Pivot Table lessons!
Imagine how many pages in a book you would have to wade through to read about Pivot Tables!
Now, imagine being able to:
- Watch a video demonstration of the steps to take to create or customize a Pivot Table.
- Read – and make notes in – a written document that follows the steps that I demonstrate.
- Practice the techniqes that I demonstrate on the video with the actual Excel worksheets that I use.
- Skip back and forth to the chapter that you want to watch or review on the video recording.
- Download the recording for the exact version of Excel that you are using.
- Get all of this for only US$9.95

What You Will Learn on My Video Recordings

I have taken care to organize each of these topics “by chapter” – with starting points and ending points – on the recordings:

Create a Pivot Table in the Excel version that you are using.
- Spotlight the uniqe features of each version
Filter and Sort the Fields in your Pivot Table
Change the Data Source & Refresh your Pivot Table
Use Multiple Functions and Views to Calculate your Pivot Table
Create a Calculated (“virtual”) Field in your Pivot Table
Group Fields – e.g. turn daily transactions into a Month, Quarter, Year Pivot Table Report
Create and Filter Pivot Charts

Download WebEx Recording

Download My Recordings at WebEx

Go to http://thecompanyrocks.webex.com and on the left side of the screen click on “Attend a Session – Recorded Sessions” to find the recording that you wish to download.
Register and enter your payment information – this is a secure shopping site.
Download the recording – also download the WebEx Recording Player so that you can play the ARF recording.
- I recommend that you “Save” your recording on the download page. Play it from your directory of choice after it has downloaded
- From the ARF Player for the WebEx Recording, you can convert the recording to another video format (MP4, AVI, WMV or SWF)

I welcome your feedback. Send me your questions, comments and suggestions for future recordings.

Share and Enjoy:

Filed Under: Excel Training, MS Excel Training, Pivot Tables, Video Training Courses, WebEx by Cisco, WebEx Recordings & Webinars Tagged: Calculated Fields in Pivot Tables, Excel Pivot Tables, Excel Video Training, Filtering Pivot Tables, Group Dates in Pivot Tables, Hide Details in Pivot Tables, Pivot Charts, Refresh Pivot Tables, Training, Video lessons for Excel

Danny May 22, 2011 2 Comments

Still Using Excel 2003? Download My Video Tutorial Pivot Tables 2003 to Summarize, Analyze and Present Data

Video Tutorial for Excel 2003 Pivot Tables

Excel 2003 PivotTables Video

By popular demand, I have created an “Extended Length” ( 69 minutes) video tutorial in Excel 2003 that you can download – for US$9.95 – “Create Pivot Tables in Excel 2003 toe Summarize, Analyze and Present the Information in Your Data.”

Quite a few of my customers and viewers are still using Excel 2003. Are you one of them? If so, this is welcome news for you! If you can even find a video tutorial for Excel 2003, chances are it was created “ages ago.” I incorporate current video technology to view online or to download 69 minute video tutorial that will teach you everything that you need to know to create, modify and present a PivotTable or PivotChart Report using Excel 2003.

What You Will Learn from this Video Recording

Here are the topics that I cover – each as an individual chapter on the recording:

Creating a PivotTable in Excel 2003
Filtering and Sorting Fields in an Excel 2003 Pivot Table
Refreshing your PivotTable; Changing the Source Data for your Excel 2003 PivotTable
Changing the Functions and Type of Calculations in your Excel 2003 PivotTable
Creating a Calculated Field in an Excel 2003 PivotTable
Grouping an Excel 2003 PivotTable Field (e.g. Month, Quarter, Year from a series of Daily Transactional Data)
Creating and Modifying and Excel 2003 PivotChart

Skip to Individual Chapters on the Video Recording

If you have ever purchased a recording of a “live” Excel Webinar, you know that one frustration is: “How do I get to the specific part of the recording that I want to learn or repeat?”

The last thing that I want you to worry about is “getting stuck” with watching my video recording from start to finish! NO! NO! NO!

That is why I recorded this video webinar with you in mind – I created an easy to follow Table of Contents on the recording so tht you can skip to or repeat an indivual chapter or starting point!

I am confident that you will enjoy this feature!

How to Get Started

Go to http://thecompanyrocks.webex.com and click on “Recorded Sessions” to see the list of all of my Recorded Video Lessons on WebEx by Cisco.
Click on this link to open the Video Recording, “Excel 2003 Pivot Tables to Summarize and Analyze Data”
Register for this recording (First Name, Last Name and email address) so that I can assist you quickly if you need help with downloading the recording or accessing the support materials.
Enter your payment information US$9.95 using PayPal or a Credit Card – This is a SECURE WEBSITE.
Download this video recording. I recommend that you:
1. Download the WebEx by Cisco ARF Recorder/ Player. Once you have opend the Video Recording, you can convert it to a different format (e.g. WMV (Windows Media), SWF (Flash Format) or MPEG4 (MP4 Format)
2. Save the File to a Folder on your hard disk drive.
Watch the video recording.

Download the Support Material for this Video Recording

Here is a link to the web page that I created for this video recording. Follow the hyperlinks to view online or download the Excel Workbook that I used in this recording as well as the Step-by-Step Instructional Manual that accompanies this recording.

Give Me Your Feedback

As I develop these “Extended Length” video recordings, I seek your feedback. Tell me what you liked. Tell me what you did not like – any why. Send me your suggestions for future topics for my video tutorial recordings.

Share and Enjoy:

Filed Under: Excel 2003 Video Lessons, Excel Training, Pivot Tables, WebEx by Cisco, WebEx Recordings & Webinars Tagged: Add Subtotals to Pivot Table Groups, Calculated Fields in Pivot Tables, Excel 2003 Training Video, Excel Pivot Tables, Excel Video Training, Extended Length Video Tutorials for Excel, Filter Fields in Pivot Tables, Grand Totals in Pivot Table Reports, Group Dates in Pivot Tables, Pivot Table Calculations, Pivot Table Charts, Pivot Tables in Excel 2003, Refresh Pivot Tables, Sort Fields in Pivot Tables, Video lessons for Excel

Danny May 18, 2011 Leave a Comment

Download My 75 Minute Video Tutorial on Excel 2007 Pivot Tables

Table of Contents for Recording

I have just recorded and published a 75 Minute Video Tutorial titled, “How to Create and Modify a Pivot Table in Excel 2007 to Summarize, Analyze and Present the Information in your Data Set.”

It is published on my WebEx by Cisco site: http://thecompanyrocks.webex.com Follow this link to go directly to this recording.

There is a charge for this recording – US$9.95 In addition to the recording you get:

A Step-by-step instructional manual
Access to the Excel workbook files that I used for this recording

Not to brag , but I think that this video tutorial is excellent! I spent many hours planning out the exercises, working through the timing of each chapter of the video and practicing my delivery. I am happy with the result. And, more important, I think that you will also be satisfied with what you will learn from this recording!

What You Will Learn on My Recording

My goal is to give you a comprehensive understanding of Excel 2007 Pivot Tables. But to give you the opportunity to learn this in “bite-size chunks” that can replay when necessary. I created realistic exercises to illustrate each topic. Also notice that I have created a Table of Contents for the recording so that you can go to a specific chapter on the recording. You can stop and start at any point.

How to Download this Recording

Go to http://thecompanyrocks.webex.com or click on this link to go to the main menu.
Click on “Recorded Sessions.”
Click the link for the recording, “Excel 2007 Pivot Tables to Summarize Data.”
Register for this session (First Name, Last Name and email address).
Enter payment information (PayPal or Credit Card). This is a secure site!
Follow the instructions to Download my recording.
Recommended – you can also download the ARF Recorder to view the recording.
At this point you can decide to convert the recording to a different format. E.g. WMV (Windows Media Player), SWF (Flash) or MP4 (MPEG4)
At the end of the recording, you are taken to a web page with links to download the Instructional Manual and to download the Excel Workbook that I used during this recoring.

Give Me Your Feedback

I welcome your comments and suggestions for future video tutorial recordings. You can add your comments below or send them to me via email.

Share and Enjoy:

Filed Under: Excel Training, Pivot Tables, WebEx by Cisco, WebEx Recordings & Webinars Tagged: Calculated Fields in Pivot Tables, Date Filters in Excel, Excel 2007 Tables, Excel Pivot Tables, Excel Video Training, Filtering in a Pivot Table, Group Dates in Pivot Tables, New in Excel 2007, Pivot Charts, Refresh Pivot Tables, Top 10 Filter, Video lessons for Excel

Danny April 25, 2011 4 Comments

Free Video Recording of Excel Keyboard Shortcuts to Download

I have just published a 50 Minute Video Recording on which I demonstrate the most popular Keyboard Shortcuts for Excel. The great news – for you – is that you can download this video recording for FREE! If you prefer to view this online, you can do so – for FREE!

Download My Excel Workbooks

Download Excel Workbooks

In addition, I have published the Excel Workbooks, Adobe PDFs and PowerPoint files that I use during this 50 minute video online. You can access them – for FREE!

I store them as “public documents” for you to download on my “Sky Drive” at Windows Live! Here is the direct link:

http://cid-644f2f857aa6afdc.office.live.com/browse.aspx/Public%20WebEx%20Documents/Excel%20Keyboard%20Shortcuts%20Part%201

In order to access these files, you will need a “free” Windows Live account (First Name, Last Name, email address). You can also use your HotMail account to login.

My Extended Length Video Recordings on WebEx

I have recently began to publish “extended length” video recordings at http://thecompanyrocks.webex.com – This 50 Minute video is my 5th recording on the site. I offer it to you “free of charge.” However, you must register (fitst name, last name, email address) with WebEx by Cisco before you can download the recording or view the recording online.

In this format, I can offer “specialized instruction” for Excel Pivot Tables, Macros, Public Speaking Courses, etc. I can also offer instruction in older (Excel 2003) and newer (Excel 2010) programs. In addition, I can create a specialized recording “just for you.” Contact me to learn about how to organize this!

Landing Page for More Information

Information about Links and Downloads

Rather than repeat what I have already written, here is the link to the special Landing Page that I have created for this 50 minute video recording. On the Landing Page, I have included all of the direct links to the download pages for the video, the Excel files, PowerPoints and Adobe Acrobat documents that I used on this recording.

I invite you to view or download these new resources that I have made available. When you have a chance send me your comments, questions and suggestions for future recordings!

Danny Rocks

The Company Rocks

Watch This Video Lesson in High Definition

Click here to go to my DannyRocksExcels YouTube Channel where you can view this tutorial in High Definition.

Share and Enjoy:

Free Video Recording of Keyboard Shortcuts to Download [ 8:51 ] Play Now | Play in Popup | Download (1317)

Filed Under: Excel Training, Keyboard Shortcuts, Podcast Tips & Timesavers, Video Training Courses, WebEx by Cisco Tagged: Download Excel Workbooks, Excel Keyboard Shortcuts, Excel Training Videos, Excel Video Training, Excel Video Tutorials, SkyDrive at Windows Live, Video lessons for Excel, WebEx Video Recordings

Danny April 19, 2011 Leave a Comment

Download My Excel Workbooks and Step-by-Step Instructional Manuals for Free!

Finally! I have figured out a way to allow my viewers to download the Excel Workbooks, Word Documents, PowerPoint Presentations, etc. that I use in my video lessons. For the past few months, I have been able to give you a direct link to download the Adobe Acrobat files that I create. For example:

My problem has been that – Starting in Office 2007 – the underlying file structure of each program (Excel, Word, PowerPoint, etc.) has changed and it is no longer possible to “Publish to the Web” the worksheets, documents and presentations that I offered in the past. I will spare you the boring details of why and how this has happened, because I have good news for you!

Enter, “The Cloud!”

Cloud Computing

You have probably seen or heard this advertising slogan recently. Here is how I have just discovered how “The Cloud” can work for both you and me:

I have created a Danny Rocks “Sky Drive” folder where I can post – and you can download – the Workbooks, Documents and Presentations that I create and choose to share!

Initially, I am uploading – and sharing – the workbooks, documents, PDFs, etc. that accompany the extended video recordings that I offer on my http://thecompanyrocks.webex.com site.

This is a new development for me and The Company Rocks. I offer a series of extended length ( 25 minute to 60 minutes) video tutorials.

Information about this Video Recording
As I write this posting, I have 4 modules – each offered “free of charge” – for you to view and / or download.

Go to http://thecompanyrocks.webex.com to see what I currently offer you!

As I gather feedback, activity, statistics, etc. I may extend the range of downloadable content that I create – My decision will depend upon your feedback, so please add your comments below in this posting!

My Next Level of Product Offerings

I am on a journey to evolve the range and detail of the products and services that I offer you, my loyal viewers and subscribers. I wnat to be responsive to your needs. So, that meanrs that the more feedback that I get from you – my viewers and subscribers – the better I can structure my offerings. I welcome your feedback!

Based on some great feedback from my viewers and subscribers, I have just begun to create a series of extended length ( 25 to 45 minutes) video tutorials. The initial tutorials will be offered “free of charge.” Other video tutorials will be carry a modest – I might add, aggressive – pricing model! My goal is to give you the product and content that you need at a price that is mutually acceptable! You, and your level of supposrt will tell me what is acceptable – please give me your feedback!

Extended Video Tutorials Now Online

You can now view or download – after registering – at WebEx by Cisco – for these video tutorials that I have posted:

Introduction to Pivot Tables in:
- Excel 2007
- Excel 2003
Merge Mailing Labels in:
- Office 2007
- Office 2003

I hope that you find these links and videos helpful. Please add your feeback via the comments section below this post.

Sincerely,

Danny Rocks

www.thecompanyrocks.com

Share and Enjoy:

Filed Under: Download Files from Video Lessons, Excel Training, Integrating MS Office Programs, Pivot Tables, WebEx by Cisco, WebEx Recordings & Webinars Tagged: Download Excel Workbooks, Excel Video Training, Merge Mailing Labels in Office 2003, Merge Mailing Labels in Office 2007, Merging Mailing Labels in Word, Pivot Table Drop Areas, Video lessons for Excel

Danny Rocks “Training You to Excel”

Three and a Half Ways to Average Excel Data Using Criteria

Three and a Half Ways to Produce this Report

My Preferred Approach – Create a Pivot Table Report

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

Watch Video in High Definition on YouTube

How a Single Blank Cell Affects an Excel Pivot Table Report

Preventing a Blank Cell from “Creeping into” your data set