MS Excel Tips | The Company Rocks

Danny October 10, 2013 Leave a Comment

How to Copy and Paste Cell Formatting Only in Excel

For the past several months, I have been teaching MS Excel online for the Continuing Education Courses at several major colleges here in the USA. It has been a great experience!.

One of my clients, VanderCook College of Music, has recently adopted Schoology for their Learning Management System (LMS). This is a robust framework for presenting course work and interacting with my students!

Now, when I assign my weekly assignments to my class, I can quickly spot the common “stumbling blocks” or questions that many student have.

While I was grading my Week #1 assignments, I found that many students were unfamiliar with Excel’s AutoFill Option for “Filling the Formatting Only” in a contiguous range of cells. So, as a start to a class discussion, I created this YouTube Excel Tutorial where I demonstrate three ways to “Paste the Formatting Only” from one location to multiple locations in an Excel Worksheet.

Before I presented my course work for Week #1, I surveyed my class and realized that the majority of students were either novice or “rusty” users of Excel. Nevertheless, I find that Excel users at all levels of experience will benefit from this @ 7 minute video tutorial.

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – to discover the many resources that I offer you!

Watch this Excel Video Tutorial in High Definition on my YouTube Channel – DannyRocksExcels!

Click below to watch this video now on YouTube!

Share and Enjoy:

Filed Under: Essential Excel Skills, Excel Training, MS Excel Tips, MS Excel Training Tagged: AutoFill Options, Excel Video Training, Format Painter in Excel, Learn to use AutoFill in Excel, Paste Special, Tips and Time Savers, Video lessons for 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 17, 2012 1 Comment

DannyRocksExcels on YouTube Recognized as a Top 10 Channel for MS Excel Tutorials

See the Complete List – Top 10 YouTube Channels

Click here to see the list of the Top 10 YouTube Channels for Excel Tutorials. I am honored to be included in this list!

Visit My YouTube Channel – DannyRocksExcels

I invite you to visit my DannyRocksExcels Channel on YouTube.

DannyRocksExcels on YouTube

As of today, I have published 250 Video Tutorials on YouTube. Many of my videos can be viewed in High Definition.

My videos have been viewed nearly 1.9 million times and my list of subscribers is close to 4,000.

My Top 10 Videos – The Last 7 Days

Here is a list of the 10 Most Viewed Excel Tutorials at DannyRocksExcels over the last 7 days – dating back from August 17, 2012. I have created Hyperlinks for each video. Just click on the title that you want to watch on YouTube:

Shop at My Secure Online Website

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – to preview all of the Training Resources that I offer you.

Share and Enjoy:

Filed Under: Excel Training, Most Viewed Excel Videos, MS Excel Tips, MS Excel Training, YouTube Videos by Danny Rocks

Danny September 5, 2010 1 Comment

Quickly Create a Series of Dates in Excel

In this lesson, I demonstrate two approaches to creating a series of dates in Excel:

Use Excel’s AutoFill Options to drag your mouse to fill in the series. Be sure to use the “AutoFill Options” button when you release your mouse.
Use an Excel Formula to increment the series of dates (by day, week, month, year, or even weekday.) This approach gives you the most flexibility if you will use a different starting date on copies of your worksheet.

I devote several lessons to Excel date formulas and date formatting on my DVD, “The 50 Best Tips for Excel 2007.” Click here to add it to your shopping cart.

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

Share and Enjoy:

Quickly Create a Series of Dates in Excel [ 5:41 ] Play Now | Play in Popup | Download (2096)

Filed Under: Excel Date and Time Functions, Excel Training, MS Excel Tips, Podcast Tips & Timesavers, Video Training Courses Tagged: AutoFill Options, Excel Date Functions, Excel Video Training, Learn to use AutoFill in Excel, Tips and Time Savers, Video lessons for Excel

Danny September 3, 2010 1 Comment

Use Excel’s Text-to-Columns Tool to Quickly Correct Date Entries

The Text-to-Columns tool in Excel is one of my favorites. I use it to quickly “parse” text elements in a cell. For example, to separate “First Name” from Last Name in a cell that contains the “Full Name” entry.

In this short – 3 minute, 23 seconds – video, I demonstrate another way to use Text-to-Columns. I show you how to separate the “Year,” the “Month” and the “Day.” A client called me in a panic – they downloaded daily transactions from their mainframe computer into Excel. However, the “dates” appeared as – e.g. 20100901 – and they could not find a way to format the dates as – e.g. 9/1/2010

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

Share and Enjoy:

Use Excel Text-to-Column Tool to Correct Date Entries [ 3:23 ] Play Now | Play in Popup | Download (829)

Filed Under: Excel Functions, Excel Training, MS Excel Tips, Podcast Tips & Timesavers, Text Functions Tagged: Excel Video Training, Excel's =DATE() Function, Text to Columns in Excel, Video lessons for Excel

Danny August 24, 2010 1 Comment

View My Excel Training Videos on YouTube

YouTube

Two years ago, in August 2010, I started uploading my Excel video training lessons to my YouTube Channel – DannyRocksExcels. Now there are 93 Excel videos available. I was originally reluctant to post my video content on YouTube because I selfishly wanted to restrict my videos to my own website. After a conversation with a colleague, I changed my mind and began to upload all of my Excel videos to YouTube.

Why?

YouTube attracts a much more diverse audience than I could ever hope to attract on this website.
YouTube makes it easy to download and share my videos with others.
YouTube has a great analytics program – Insight – that allows me to gain valuable information about my audience.
YouTube is now showing several of my most popular videos as ads automatically (via Google AdSense)
I have good interaction with my viewers on YouTube – comments, requests for new videos, etc.

When I look at the numbers on YouTube I am amazed!

Here is a summary:

My Excel Videos have been viewed almost 200,000 times over the past two years.
One Video (Introduction to Pivot Tables) has been viewed over 20,000 times!
My DannyRocksExcels Channel on YouTube now has over 500 subscribers.

I invite you to view, download or subscribe to my YouTube Channel for Excel Training videos by following this link.

Thank you!

Danny Rocks

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

Share and Enjoy:

Filed Under: Add Video to Your Website, Excel Training, MS Excel Tips, MS Excel Training, Video Response to Viewers Tagged: "What-if" Analysis in Excel, Data Validation, Excel Keyboard Shortcuts, Excel Pivot Tables, Excel Video Training, Group Dates in Pivot Tables, MS Excel Training, Video lessons for Excel

Danny May 24, 2010 Leave a Comment

How to Save Hours Updating Pivot Tables in Excel 2007

This Excel 2007 Training Video could – conservatively – save you at least one hour each month when you need to update your Pivot Tables!

What is that worth to you and your company? $100.00? $500.00? – Multiply that by 12 for each month in the year…

Have I got your attention yet?

Watch this short – 3 minute and 20 second video lesson – and you can thank me – or learn more ways to save time and money by purchasing my DVD – “The 50 Best Tips for Excel 2007”

If you watched this short – 3 minute 20 second video lesson, you can tell that I am excited about this topic. Would you like to trade 3 1/2 minutes to watch this video in order to save hundreds of $$$ each month to get an updated Pivot Table? If your answer is anything other than “Yes!”, please send me an email – I would like to know what I am missing.”

Enjoy this video – and enjoy spending or investing the savings that you reap each month by applying this technique!

Want to save even more money? – Purchase my DVD – “The 50 Best Tips for Excel 2007″ – Click here to shop at my secure website.

Want to find a specific – and FREE – Excel Video Training Lesson? Click here to visit my Index of Excel Video Training Lessons.

You can watch this Excel video on YouTube. I have almost 200 videos on my YouTube channel – DannyRocksExcels

Learn how to “Quickly Create Pivot Tables” in Excel

Share and Enjoy:

Filed Under: Excel Data Tables and Lists, Excel Training, MS Excel Tips, MS Excel Training, Pivot Tables Tagged: Append Data, Excel 2007 Tables, Excel Pivot Tables, Excel Video Training, productivity, Save Time in Excel 2007, Tips and Time Savers, Update Pivot Table Source Data, Video lessons for Excel

Danny May 21, 2010 Leave a Comment

How to Take Advantage of Excel 2007 Tables

One of the major improvements in Excel 2007 is working with Tables. In this lesson I demonstrate Five Benefits for Working with Excel 2007 Tables:

Automatically expand in size to add Columns (Fields) and Rows (Records)
Use Natural Language Formulas – Copied down the column automatically!
Total Rows Tool – great for seeing the results in filtered lists
Easy to use Filters for Dates (Last Week, Next Quarter, etc.), Text and Numbers (Above Average, Top 10, etc.)
Improved Formatting – Use Live Preview to see what style options look like before you select them

You can view and download this Excel video lesson – for free – on iTunes. Click here to visit my Podcast, Danny Rocks Tips and Timesavers at the iTunes store.

If you enjoyed this Excel Video Lesson, I invite you to purchase my DVD, “The 50 Best Tips for Excel 2007” – You can shop with confidence at my secure web store.

I help you to find the Excel Training Video Lesson that you want – Visit my Index of Excel Video Lessons

You can watch – and download – this Excel Video Training Lesson on You Tube. Subscribe to my YouTube Channel – DannyRocksExcels

Learn how to “Quickly Create Pivot Tables in Excel”

Share and Enjoy:

Filed Under: Excel Data Tables and Lists, Excel Formulas, Excel Training, MS Excel Tips Tagged: Excel 2007 Tables, Excel Video Training, Filter by Time Period, New in Excel 2007, Top 10 Filter, Video lessons for Excel

Danny May 15, 2010 Leave a Comment

I Have Updated My Index of Excel Video Lessons

As part of the process of reorganizing my website, I have updated my “Index of Excel Video Lessons” page. The content of this page will be updated as I add each new Excel Video Training Lesson. So, I suggest that you click here to go to the Video Index and then save the page as one of your “Favorites” if you want to learn how to really get the most out of Excel or to find a quick answer when you are using Excel.

On the Index Page you can see an organized listing of my Excel Videos by Category – e.g. Formulas, Formatting, Pivot Tables “What-if” Analysis, etc. Each lesson is “hyperlinked” so that you can just click on the topic to go directly to the lesson that you are interested in.

I indicate in the title if the lesson is specific to Excel 2007. All my new Excel video lessons are created using Excel 2007.

If there is a topic that you would like me to cover, send me an e-mail message – danny@thecompanyrocks.com

If you enjoy my video instruction, I encourage you to purchase my DVD, “The 50 Best Tips for Excel 2007.” The DVD contains over 5 1/2 hours of Tips, Tricks & Techniques to help you to master the program – and to save a considerable amount of time while working in Excel! Click here to enter my secure shopping site.

Thank you for your support and encouragement!

Danny Rocks

Share and Enjoy:

Filed Under: COUNTIF and SUMIF Functions, Everyday Calculations in Excel, Excel Basics, Excel Data Tables and Lists, Excel Date and Time Functions, Excel Financial Tools, Excel Formulas, Excel Functions, Excel Training, Import Data into Excel, Lookup Functions in Excel, MS Excel 2007 DVD, MS Excel Tips, MS Excel Training, Online Store for The Company Rocks, Pivot Tables, Text Functions, Tips and Time Savers, Training, Video Training Courses, What-if Analysis Tagged: Excel Video Training, MS Excel Training, Tips and Time Savers, Video lessons for Excel

Danny May 13, 2010 2 Comments

View Excel Worksheets Side by Side

This is another Excel 2007 Video Lesson that I created in response to a view’s request for help. Excel 2007 makes it quite easy to view two worksheets “side by side,” but there are a couple of “got’cha steps” to be aware of in order to make this work for you.

First, I want to clarify the difference between three similar words that I use in this lesson – “Windows, Workbooks, Worksheets.” We will be opening up multiple Windows in order to compare multiple Worksheets which can be part of one or more Workbooks. “Windows, Workbooks, Worksheets” – Oh My!

It is easier to show you the difference, so let’s view this lesson.

If you enjoyed this Excel Video Lesson, you will enjoy my DVD, “The 50 Best Tips for Excel 2007.” You can purchase it here on my website at my secure storefront. Click here to start shopping!

You can watch this Excel Video Lesson on YouTube – Visit my channel, DannyRocksExcels

Danny Rocks “Training You to Excel”

How to Copy and Paste Cell Formatting Only in 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!