Home Archives for Tips and Time Savers
January 3, 2011 1 Comment

Get My New Popular Keyboard Shortcuts for Excel Chart – It’s Free When You Register

Click the link below to download my chart of Excel Keyboard Shortcuts as a PDF:
CR – Updated Chart of Popular Excel Keyboard Shortcuts
Excel Keyboard Shortcuts

Preview Excel Keyboard Shortcuts

 Hello and Welcome – to my new “Members Only” section of The Company Rocks website! 

I just published a new five-page Chart – “Popular Keyboard Shortcuts for Excel.” It is free for you to download as a PDF. 

This, along with additional content, will soon be inlcuded in my new “Exclusive Membership Content” area on my website. 

My Exclusive Membership Site is not quite ready to launch. So, I am offering this chart for you to download as a PDF from this post. 

To get this chart, click on this link –  

CR – Updated Chart of Popular Excel Keyboard Shortcuts 

New! Download My Free 50 Minute Video Recording Demonstrating Excel Keyboard Shortcuts

Click this link to learn how you can download my new “extended length” video recording. It is “free of charge!”

I am proud of the way my Excel Keyboard Shortcuts Chart turned out – and I think that you will get a lot of value out of this free resource. I organized the Keyboard Shortcuts by the following Tasks:

Excel Keyboard Shortcuts

  • Basic File Operations
  • Undo, Restore or Repeat Actions
  • Insert, Delete, and Copy Cells
  • Edit Data
  • Show / Hide Columns and Rows
  • Select Contiguous Cells
  • Navigate Within a Worksheet
  • Navigate Between Workbooks
  • Find, Replace, and Go To
  • Enter Data
  • Work with Cell Comments
  • Work with Names for Cells and Ranges
  • Work with Formulas and Functions
  • Work with Formula Precedent and Dependent Cells
  • Print Worksheet
  • Formatting Cells and Text
  • Work with Subtotals and Outlines
  • Work with Tables, Lists, and Filters
  • Work with Charts
  • Work with Excel Windows and Open Applications

So, as you can see, this is a comprehensive – but not exhaustive – list of the best Keyboard Shortcuts for Excel. I took care to ensure that these Keyboard Shortcuts will work for all versions of Excel from 2003 through version 2010. 

The 50 Best Tips

The 50 Best Tips Series

I have several video lessons that cover keyboard shortcuts on my DVD-ROM, “The 50 Best Tips for Excel 2007.” It is a best-seller and it is now on sale! Use Coupon SAVE-20-PCT at checkout and save 20% on any puchase at my online store. Click here to open a secure shopping cart. 

And let me know your thoughts on my Excel Keyboard Shortcut Chart. Do you have a favorite Keyboard Shortcut that you want to share with our readers? Add your comments below.

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

Link to this post!
Filed Under: Excel Training, Keyboard Shortcuts, Membership Content, Tips and Time Savers Tagged: , , , ,
January 1, 2011 Leave a Comment

The 10 Most Watched Videos at The Company Rocks During 2010

Reminder Note

Reminder Note

I like to look back to review the results of the past year. Which posts, which videos were the most popular, which videos were downloaded most often? As I look at this list of 10 videos, the clear winner – by category – is merging data from multiple worksheets. Three of the top 10 videos that were watch the most fall into this category!

Here is a listing of the 10 Video Lessons that were watched most frequently on my website – www.thecompanyrocks.com – during 2010:

1- Summarize Multiple Excel Worksheets – Consolidate by Position

2- Build an Accounts Receivable Aging Report

3- Use Pivot Tables to Summarize by Year, Quarter and Month

4- Simplify Data Lookups in Excel

5- Perform Break-Even Analysis with Excel’s Goal Seek Tool

6- How to Display Numbers During a PowerPoint Presentation

7- Make Excel Data Come Alive with Visualization Tools

8-  Excel 2003 Basics – Data Entry

9- How to Merge Multiple Excel Workbooks into a Master Budget

10- Consolidate Data from Multiple Excel Worksheets – Part 2 – by Category

If you enjoy these videos, you will enjoy my DVD-ROMs, “The 50 Best Tips for Excel 2007” and “The 50 Best Tips for PowerPoint 2007.” You can use my secure shopping cart to purchase them now.

I have reduced the purchase price of my Individual DVD-ROMs to $29.97 USD. You do not need a coupon to receive this special price. Simply, go to my online store – http://shop.thecompanyrocks.com

You can also watch my videos on iTunes. Click here to go to my Video Podcast, “Danny Rocks Tips and Timesavers” at the iTunes Store.

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

My most recent videos can be viewed in High Definition, Full Screen Mode on my YouTube Channel – DannyRocksExcels

Link to this post!
Filed Under: Consolidate Excel Data, Excel Basics, Excel Financial Tools, Excel Training, Goal Seek in Excel, Lookup Functions in Excel, Most Viewed Excel Videos, Pivot Tables, Powerpoint Techniques Tagged: , , , , , , , ,
December 22, 2010 Leave a Comment

I Picked Up a New Tip Today – Filtering Your Excel Data

Yesterday, I posted an Excel Video Lesson on how to Filter your data. I focused on taking advantage of the Date Filters, Text Filters, and Number Filters introduced in Excel 2007. Today, in my email inbox, I received a great tip from Chandoo – whose tag line is “Become Awesome in Excel.”

Chandoo’s Tip – which I did not know – is to Right Mouse Click on any cell in your Excel Data Set and choose Filter – Filter by Selected Cell’s Value. As Chandoo points out, this only works in Excel 2007 and higher versions. I already use this tip in Microsoft Acces. In fact it is one of the Video Tips that I share on my DVD-ROM, “The 50 Best Tips for Access 2007.” So why didn’t I know that this would work the same way in Excel 2007? Because, I needed someone to point this out to me. Thank you Chandoo!

For me, the take-away point is to continue to explore other resources to learn from other expert users. Each – e.g. Mr. Excel – Bill Jelen; Mr. Spreadsheet – John Walkenbach, etc.) – has their own perspective on Excel. Each presents a topic in a slightly different manner. Each day is an opportunity to expand my knowledge base.

I also picked up another tip from Chandoo’s post – use the Ctrl + Shift + L Keyboard Shortcut to automatically add the Filter Drop Down Buttons to your Field Header Labels. I will use this tip on a regular basis. Now, I do not have to pick up the mouse to go to the Data Tab on the Ribbon and select Filter.

If you are using Excel 2007 and higher, note that you can also use this tip (rightmouse click in a cell) to filter by the selected cell’s Icon, Font Color and Cell Background Color. Data Visualization is one of the really great improvements introduced in Excel 2007. Click here to go to my video lesson on Data Visualization.

Tip from Chandoo
Chandoo’s Tip

I recommend that you check out Chandoo’s Excel Blog by clicking on this link. You can click on the RSS Button – or go to http://feeds2.feedburner.com/PointyHairedDilbert directly to start receiving Chandoo’s Excel tips delivered automatically to your e-mail Inbox.

 
And, by the way, you can receive my new posts automatically by going to http://feeds.feedburner.com/DannyRocks which is my RSS feed on Feedburner.
 
I have now added Chandoo’s site to my Blogroll – so just click on the link whenever you visit The Company Rocks website.
 
Let me know if you have a special tip or a favorite website or blog that you want to share with our readers. Add your comment below.
Learn how to “Master Excel in Minutes – Not Months!”
Link to this post!
Filed Under: Data Filters and Queries, Excel Data Tables and Lists, Excel Training Tagged: , , , , , , ,
December 18, 2010 5 Comments

The 50 Best Tips for Excel 2007 – Download Detailed Content Listing

By request, I have created a detailed content listing of each of “The 50 Best Tips for Excel 2007” available for you to download. Not only do you get a List of the 50 Best Tips, you also get details of the learning points in each tip and the Run time for each video lesson.  

Excel Tip List

Excel DVD Tips

You can download: 

If you would like to receive this detailed content listing as an Excel File, please click on this link to contact me directly. I will email you the file as an attachment. 

There are over 5 1/2 hours of focused video instruction on my DVD-ROM.The files are Shockwave Flash Files and they play in any Internet Browser (Internet Explorer, FireFox,Safari, etc.) 

As a bonus, the DVD-ROM contains the 50 Excel Workbooks that I use in the video lessons. Use these workbooks to recreate the lessons that you learn on the video. 

I invite you to visit my online store ( http://shop.thecompanyrocks.com) to purchase the DVD-ROM for “The 50 Best Tips for Excel 2007.” Click here to start shopping using my secure shopping cart. I guarantee your complete satisfaction with my products. If you are not satisfied, I will refund your purchase price with no questions asked. 

You will learn how to “Master Excel in Minutes – Not Months!”

Sincerely, 

Danny Rocks

Link to this post!
Filed Under: Excel Training, Online Store for The Company Rocks Tagged: , ,
November 29, 2010 1 Comment

My Most Viewed and Downloaded Videos for Excel and PowerPoint

My iTunes Podcast

Danny on iTunes

I began to post my videos as podcasts at the iTunes store this past summer. Since then, my video lessons for Excel and PowerPoint have been viewed and downloaded many times. I am thirlled. And, I thank you for your support and encouragement.

Here are the links – on my website – to the most popular video episodes. I have organized them by category in the order of their popularity. You can click on any link to view or download that video from my website. Or, you can go to my video Podcast by clicking on this link – “Danny Rocks Tips and Timesavers” Podcast on iTunes.

Merging and Consolidating Excel Worksheets

 PowerPoint Presentations

Data Visualizations

What-If Analysis in Excel

Importing Data From Other Programs

Pivot Tables

Excel Tables

Social Media

Formula Errors

Please add your comments below – or on my iTunes Channel. I welcome your feedback.

You can learn how to “Master Excel in Minutes – Not Months!”

Sincerely,

Danny Rocks

Link to this post!
Filed Under: Consolidate Excel Data, Excel Data Tables and Lists, Excel Functions, Excel Training, Goal Seek in Excel, Import Data into Excel, Integrating MS Office Programs, Most Viewed Excel Videos, MS Excel Training, New in Excel 2007, Pivot Tables, Podcast Tips & Timesavers, Powerpoint Techniques, Presentations, Public Speaking, What-if Analysis Tagged: , , , , , , , , , , , ,
October 23, 2010 Leave a Comment

How to Add Scroll Bar Controls to Excel Forms

This is the fourth in my continuing series of Excel training video lessons on Adding Form Controls to your worksheets. Here, I demonstrate how to Add Scroll Bar Controls to a Loan Scenario. Form Controls help to make your Excel worksheets “interactive,” and they are great tools to add when you distribute spreadsheets to users who may not be proficient in Excel.

Understand the Cell Link

The key concept to understand with Form Controls is the “Cell Link.” The form controls are merely “drawing shapes” until you actually link them to a cell that controls their output. The “got’cha” step for Scroll Bars – as with Spin Buttons – is that the Maximum Value is 30,000. So, if you want a control to show a loan amount of, for example, $300,000.00 you make the Maximum value 300 and then create a formula that references the “cell link” and multiplies it by 1,000.

In my research on Form Controls, I rarely find authors who mention this point – and, in my experience, this is how most Excel users get “tripped up” when they want to add Form Controls to workbooks to make them interactive. Watch as I walk you through each step in this process.

Please, let me know if this video lesson has helped you to better understand how Excel Form Controls work. Add your comment below – I promise to respond to your comments!

Danny

You can click on this link to view the other videos in my series on Form Controls in Excel.

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

How to Add Scroll Bar Controls to Excel Forms [ 5:32 ] Play Now | Play in Popup | Download (1981)
Link to this post!
Filed Under: Excel Forms, Excel Formulas, Excel Training, Podcast Tips & Timesavers, Video Training Courses Tagged: , , , , , , ,
October 16, 2010 Leave a Comment

How to Add a Check Box Control to an Excel Form

Judging by the comments that I get from many clients, adding a “Check Box Control” to and Excel Form is not as easy as it appears at first glance.

And, I agree! I, too, struggled with adding Form Controls in Excel. Most of the explanations that I read seemed to add more confusion than clarification!

Spin Buttons in Excel

Spin Button Controls

That is why I created this Excel Training Video: to  lead you through the process; to save you some time and to ease your frustration.

Key Points to Remember:

  1. In Excel 2007, be sure to display the “Developer Tab” on the Ribbon in order to to Insert any Form Control.
  2. Choose the Controls in the “Forms Controls” and NOT in the Active X Controls.
  3. After you “draw” the Control Box on your Form, be sure to select a “Cell Link” to enable the Check Box Control.
  4. Remember that a Check Box Control can only be applied when the result of the Formula or Option is a Logical Value – either a result of  “True or False.”

Don’t be scared off! I find that this is an Excel concept that is better presented “visually.” I struggled for some time when I “read” how to add form controls.

So … I welcome your thoughts – “True or False.” Did I make this easy for you to understand?

Please feel free to add your comments below!

Watch My Video on YouTube

Follow this link to watch my tutorial on my YouTube Channel – DannyRocksExcels

Watch Video Now

 

Master Excel in Minutes Training Resources

I have created a series of extended length Excel Training Videos. I invite you to visit my secure online shopping site to:

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

How to Add a Check Box Control to an Excel Form [ 10:15 ] Play Now | Play in Popup | Download (1315)
Link to this post!
Filed Under: COUNTIF and SUMIF Functions, Excel Forms, Excel Training, Most Viewed Excel Videos, Podcast Tips & Timesavers, YouTube Videos by Danny Rocks Tagged: , , , , , , , ,
October 5, 2010 Leave a Comment

5 Tips for Displaying Numbers – Article Published on Indezine

Geetesh Bajaj, Microsoft MVP, started a group discussion, “PowerPoint is Not Excel and Word,”on LinkedIn. I joined the discussion and added a link to one of my PowerPoint Training Videos. Geetesh, in turn, asked me to contribute a written article on this topic for his website – Indezine. Here is the link to the article:

Article on Indezine Website

Published on Indezine

http://www.indezine.com/articles/5tipsfordisplayingnumbers.html

 

I encourage you to visit the Indezine website to find the resources and tips you need to improve your next presentation – whether you use PowerPoint or not.

You will also learn to master PowerPoint by watching my DVD, “The 50 Best Tips for PowerPoint 2007.” The DVD is on sale now – click here to add it to your secure shopping cart.

Link to this post!
Filed Under: Powerpoint Techniques, PowerPoint Video Training, Presentations Tagged: , , , , , , , ,
October 3, 2010 Leave a Comment

My Video Podcast has been downloaded 4,800 times

My iTunes Podcast

Danny on iTunes

OK, so let me brag a little. I launched my Video Podcast, “Danny Rocks Tips and Timesavers,” in June 2010 on iTunes. When I looked at the number of downloads and views, I was amazed to see that the number had surpassed 4,800 – I am thrilled.

Thank you for your support and encouragement. And, one viewer has reviewed my podcast:

Customer Reviews

Concise training      

by ChipAv

These are very specific and concise training modules on individual aspects of Excel and Powerpoint. (Also a few on meeting management and social media.) No nonsense, down-to-business, accurate, and professional. If one of these matches the skill you want to quickly acquire, you should like these.

I invite you to view, download, subscribe or review my video podcasts – either individually or as a whole. Here is the link to my iTunes video podcast:

http://itunes.apple.com/podcast/danny-rocks-excel-tips/id374923275 – If you like what you see, then pass this link on to a friend or colleague.

You can add your comments below and feel free to use one of the Social Media Icons at the bottom of this post.

 

Link to this post!
Filed Under: Add Video to Your Website, Business Communications, Excel Training, Podcast Tips & Timesavers, Powerpoint Techniques, Tips and Time Savers, Word Tips Tagged: , , , , , , ,
September 24, 2010 Leave a Comment

List of My Most Popular Posts and Pages

Summer – in the Northern Hemisphere – is now behind us. I went back to survey the videos and pages on my website that had the most views during the Summer of 2010. 

Here is a listing of my “Top 10 Video Posts” and my “Top 5 Pages.” Click on the Links for each title to go directly to the Video Lesson or Page.

The “Top 10 Video Posts” on The Company Rocks Website:

  1. Simplify Data Lookups in Excel
  2. Make Excel Come Alive with Visualization Tools
  3. Build an Accounts Receivable Aging Report
  4. Summarize Multiple Excel Worksheets – Consolidate Data by Position
  5. How to Merge Multiple Excel Workbooks into a Master Budget
  6. Use Pivot Tables to Summarize by Year, Quarter and Month
  7. Perform Break Even Analysis with Excel’s Goal Seek Tool
  8. 2 Reasons to Format Cells Before You Enter Data in Excel
  9. Hide and Show Details in Excel Pivot Tables
  10. Use Vlookup Function to Prepare a Payroll Statement

The “Top 5 Pages” Viewed on The Company Rocks Website:

  1. The Excel Home Page
  2. Index to Excel Video Lesson Topics
  3. List of “The 50 Best Tips for Excel 2007”
  4. Excel Training Videos by Category
  5. The 50 Best Tips for PowerPoint 2007

The Danny Rocks Tips and Timesavers Podcast

During the Summer of 2010, I started my own video podcast at the iTunes Store. These podcasts are free of charge. The video resolution is optimized for viewing on an iPad, iPod or other portable media device.

The DannyRocksExcels Channel on YouTube

Over the past two years I have posted 104 video lessons on my “DannyRocksExcels” Channel on YouTube.

The DannyRocksPowerPoint Channel on YouTube

I maintain a separate channel on YouTube – “DannyRocksPowerPoint”– to post my PowerPoint Tips and Narrated PowerPoint Presentations. I invite you to vist my channel to view, download and share these videos with your friends and colleagues. Click here to go to my YouTube Channel.

“The 50 Best Tips for …” series of DVDs

I offer five DVDs for sale on this website. Click here to start your shopping cart. I guarantee your satisfaction. If you are not 100% satisfied with my DVDs, I will refund your purchase with no questions asked!

You can learn how to “Master Excel in Minutes – Not Months!”

Here is a listing of the DVDs that I offer for sale. Click on the link for each title to go to the list of the tips that I offer on each DVD:

Link to this post!
Filed Under: Excel Training, Most Viewed Excel Videos, Podcast Tips & Timesavers, Powerpoint Techniques Tagged: , , , , , , , ,
« Previous Page
Next Page »