Home Archives for MS Excel Training
April 26, 2010 3 Comments

Introducing Pivot Tables in Excel 2007

If you are already familiar with Pivot Tables, Excel 2007 makes Pivot Tables easier to create – you do not have to drag fields onto the template with the mouse! There are other improvements as well – and I cover the highlights in this lesson.

If you have never created Pivot Tables – or if you gave up in frustration – then this short, 9 minute and 48 second lesson will get you started. I explain that Pivot Tables help you to get answers about your data.

Let’s get started to create a Pivot Table in Excel 2007!

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

Learn how to “Quickly Create Pivot Tables and Charts.”

You can watch this Excel Training Video on YouTube

Related Excel Video Lessons:

Link to this post!
Filed Under: Excel Training, Pivot Tables Tagged: , , ,
June 7, 2009 2 Comments

My New DVD – The 50 Best Tips for MS Excel 2007 is now on sale

50 Best Tips fo MS Excel

New! Now available from the online store at www.thecompanyrocks.com

Do you ever have one of those “A-ha” moments? You know – those moments when everything falls into place. When everything becomes crystal clear. When you finally “get it!”

Well, here is your opportunity to experience 50  “A-ha” moments. Here is a great way for you to learn “The 50 Best TIps, Tricks, and Techniques for Microsoft Excel 2007.”

I spent almost three months filming these short Excel training videos. I worked hard to create this DVD in order to make it easy for you to learn how to remain productive at work while learning to use the new Excel 2007 interface.

And, the Excel 2007 interface is really quite different.

So different, that many long-time Excel users just give up on it and return to the tried and true Excel 2003 program.

And that is too bad. Because, Excel 2007 allows you to perform so many business tasks faster and better. But … first, you must get over “the initial learning curve” to understand how to navigate in Excel 2007.

This DVD makes it easy for you to learn how to use Microsoft Excel 2007 – guaranteed!

In selecting the 50 Best Tips for Excel 2007, I wanted to include tricks that all Excel users could put to use – now! I include tips at the Introductory, Intermediate and Advanced levels.

Each lesson is short – five to six minutes on average – and focused on just one topic. Each lesson on the DVD is self-contained – I teach you how to solve one problem per lesson.Overall, the DVD contains 5 1/2 hours of training on Excel 2007!

This DVD is available exclusively from the SkillPath Seminars bookstore. They are offering it for sale at the introductory price of $49.95 Here is a link to the demonstration / order now page.

I am proud of this product. I know that you will gain some new insights into how to get the most out of Excel 2007. I welcome  your feedback. Please drop me a note  – danny@thecompanyrocks.com Or … add your comments below for all readers to share.

Thank you for your support!

Danny Rocks

Link to this post!
Filed Under: Excel Training, MS Excel 2007 DVD, Online Store for The Company Rocks Tagged: , , , , , , , , , , , ,
April 9, 2009 Leave a Comment

Save Time and Maintain Consistency When Entering Data

This is every company’s nightmare: You have a list of Customer Names that are entered in multiple worksheets by multiple employees. The (nightmare) result – you have multiple misspellings of the Customer Names! This is GIGO (“Garbage In, Garbage Out”). This is a mess!

This is preventable!

In this Excel Training Video I demonstrate three tips to save you time and help you to maintain consistency when entering long text labels into your worksheets. The Tips:

  1. Use Data Validation – Choose from a List
  2. Use a Named Constant  – you type =”Shortcut” and get the Customer Name spelled out correctly
  3. Use MS Office’s AutoCorrect Option – Create your “Replace and Replace With” in Excel and you can use it in Word and PowerPoint

Here are the steps to follow in this lesson:

  1. Enter the list of Customer Names in a worksheet. Highlight the list and type a NAME for this range into the Name Box. Remember to begin your Name with a letter and you can not use a Space in the Name.
  2. Tip # 1 – Use Data Validation – Allow – List. You can watch my lesson on Data Validation.
  3. Tip # 2 – Create a Named Constant. You can watch my lesson on Named Cells, Ranges & Constants.
  4. Tip # 3 – Use MS Office’s AutoCorrect Option – Go to Tools – AutoCorrect Options in any MS Office Program. For the “Replace” entry, type in your “Shortcut.” I like to make my 1st character an”_” so that it is easy to find, edit or replace. For the “Replace with” type in the full Customer Name. Remember to ht the SPACEBAR when you use this in Word & PowerPoint!

It is easy to find the Excel Training Video you want to view – Search my Index of Excel Topics

New! Danny’s DVD Training Series, “The 50 Best Tips for …” is now available at the online store for The Company Rocks

Link to this post!
Filed Under: Excel Basics, Excel Training Tagged: , , , , , ,
March 25, 2009 Leave a Comment

12 Excel Practice Files to Download

I want to thank the viewers who emailed me and responded to the Poll on this blog. I have now uploaded 12 Excel Practice files to this blog. Follow this link to navigate to the Download Excel Practice files page.

  • Click on the Practice file that you are interested in.
  • Right-click the Icon to determine how and where to open the practice file.
  • The Practice files are saved as “Interactive Web Pages.” From here, you can decide to work with the file over the Internet or to save it to disk as an Excel Workbook.

I will be adding additional Practice files – approximately three each week – so check back to locate the latest files that I have downloaded. If there is a particular file that you want to work with, email me your request – danny@thecompanyrocks.com and I will make it available as quickly as I can.

Thank you for your continuing support of The Company Rocks!

Sorry, there are no polls available at the moment.
Link to this post!
Filed Under: Excel Training, Interactive Webpages Tagged: , ,
July 2, 2008 Leave a Comment

Welcome to my MS Excel Blog!

Welcome! This is my new blog  “The Company Rocks Excels” – devoted exclusively to sharing “tips & time-savers” when you use Microsoft Excel.

I train individuals and groups to get the most out of MS Excel for Windows. My clients range from students to Fortune 500 executives. I have trained clients in a variety of industries; in the United States, Canada and Australia.

Most of my clients realize that they use only a fraction of Excel’s powerful features. And… they want to learn how to tap into Excel’s power in order to:

  • Save time
  • Be more productive
  • Gather and analyze data from remote sources
  • Link data sources to produce consolidated reports
  • Analyze data to spot trends and opportunities
  • Present data in a clearly understood, professional manner

On this blog, I share my best tips with you. Each lesson is brief (between 3 and 8 minutes) and  to the point (1 concept per video).

Many of these tips will show you how to transition from your familiar work in MS Excel 2003 to the dramatically different Excel 2007 interface.

The current version, 2007, is quite different – to say the least! Many clients are initially intimidated by the radically different interface. I will help you to transition to the new version – when you are ready.

So, check in often to see the latest tips that I add to the blog. And… please feel free to share your own “tips and time-savers” with our readers.

Ask questions. I will answer them individually as quickly as I can.

Sincerely,

Danny Rocks

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

Find the video lesson that you want – Index to all Excel Tips

Link to this post!
Filed Under: Excel Training Tagged: , ,
« Previous Page