Home Archives for Visible Cells Only in Excel
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: , , , , , , , , ,
September 24, 2011 Leave a Comment

How to Take Advantage of the Go To Special Dialog Box Options in Excel

Go To Special Options

Go To Special Options

In my opinion, the Go To Special Options Dialog Box offers some of the most useful tools in Excel!

Why?

Because,  you must…

Select Cells Before Performing an Action on these Cells

The “key” to understanding ANY MS Office or Windows Program is… You MUST select a single cell or a range of cells BEFORE you can perform an action on them – e.g. Formatting you selection, deleting your selection, editing your selection or auditing your selection.

Tips Presented in this Video Tutorial

  • Select cells with Comments – so that you can “format” these cells to make them easier to identify.
  • Select cells that contain Constant Numeric Values – so that you can easily “spot” cells that should – bu do not – contain formulas.
  • Select cells that contain Specific Types of Formulas – e.g. Text Formulas – to “audit” your formulas.
  • Find the “Last Cell” in your worksheet – the last cell that contains EITHER content OR FORMATTING – This can be an “eye-opener!” for you.
  • Select the cells that contain Data Validation – perhaps you failed to “validate” all of the cells in a range.
  • Select the cells that contain Conditional Formatting – perhaps your did not select ALL of the cells in a Range BEFORE you applied a Conditional Formatting RULE!
  • Learn how to select the “Visible Cells Only” before performing a copy and paste operation – especially helpful when copying the “collapsed cells” for an Excel Outline.

I am positive that Excel users at ANY LEVEL will be able to pick up at least one solid tip from this Video Tutorial. Please send me your comments to let me know what you learned – or what you need clarification on.

Watch Tutorial in High Definition Mode

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

Learn About My New Extended Length Excel Video Tutorials

I have just published the first in a series of “Extended Length” – 90 Minutes – Video Tutorials, “Excel Pivot Tables to Summarize, Analyze and Present Your Data.” Follow this link to learn more about this tutorial. I have created separate versions of the tutorial for Excel 2010, 2007 and 2003.

Link to this post!
Filed Under: Conditional Formatting, Data Validation, Excel Formulas, Excel Training, YouTube Videos by Danny Rocks Tagged: , , , , , , , , , , ,
October 7, 2010 Leave a Comment

Use the Visible Cells Command in Excel to Paste Subtotal Results

Earlier this week a client asked me to help her paste the Subtotal results to a new Excel workbook. She was frustrated and nearly hysterical because her manager needed the results in an hour. If you work with Subtotal reports in Excel I am sure that you share my client’s frustration.

The key to making this work is to use the “Visible Cells Only” command before you copy your selection. You can find this command on the “Find and Select” drop-down menu. If you like keyboard shortcuts, you can use Alt + ; for this command. However, remember to make your selection first!

Watch me demonstrate how this works in this short 4 minute 58 second Excel Video Lesson. You can also view it on iTunes and on my YouTube channel. This is one of the tips that I share on my DVD, “The 50 Best Tips for Excel 2007.”

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

Use the Visible Cells Command to Paste Subtotal Results [ 4:58 ] Play Now | Play in Popup | Download (734)
Link to this post!
Filed Under: Excel Training, Podcast Tips & Timesavers Tagged: , , , , ,