Home Archives for Work with Multiple Worksheets
March 20, 2013 4 Comments

2.9 Million Views for My YouTube Channel – DannyRocksExcels

2.9 million viewsThis morning, I passed the 2.9 Million views milestone for my DannyRocksExcel’s YouTube Channel!

Thank you to all who have supported my Excel tutorials since I began posting them in August, 2008.

Top 10 Excel YouTube Videos Year-to-Date in 2013

Here are the Top 10 Videos that have been viewed so far (January 1 – March 21) in 2013. Click on the hyperlink to watch the video(s) on YouTube:

  1. How to Create an Interactive Pivot Table Chart – 65,095 Lifetime views
  2. How to Use Advanced Filters in Excel – 84,557 Lifetime views
  3. How to Add a Check Box Control to an Excel Form – 87,327 Lifetime views
  4. Compare 2 Excel Lists to Spot the Differences – 84,325 Lifetime Views
  5. Use Excel’s Built-in Data Form to Edit & Filter Records – 65,325 Lifetime views
  6. Use the Solver Tool in Excel – 46,035 Lifetime views
  7. How to Use an Excel Data Table for “What-if” Analysis – 72,694 Lifetime views
  8. How to Merge Multiple Excel Workbooks to a Master Budget – 104,376 Lifetime views
  9. How to Create a Summary Report from an Excel Table – 38,502 Lifetime views
  10. Import Excel Data into Microsoft Access – 54,601 Lifetime views

Quickly Improve Your Excel Skills

I have created many Video Tutorial Packages that I offer for sale at my secure online shopping website – http://shop.thecompanyrocks.com I invite you to visit and preview my training resources for MS Excel and the other programs in the Microsoft Office Suite.

The “Special Bundles” of videos are very attractively priced!

 

 

 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Access Tips and Timesavers, Conditional Formatting, Excel Data Tables and Lists, Excel Forms, Excel Training, Most Viewed Excel Videos, Pivot Tables, What-if Analysis, Work with Multiple Worksheets, YouTube Videos by Danny Rocks Tagged: , , , , , , ,
December 14, 2011 2 Comments

Use an Excel Template to Customize a Worksheet with 52 Weeks of Employee Time Cards

Template for Time Cards in Excel

Time Card Templates in Excel

This is Part Two in my new series of Excel Tutorials where I share my best practice tips for creating 52 weeks of Employee Time Cards – for hours worked. In this segment, I focus on starting the process with an Excel Template.

Finding Templates for Time Cards

As I demonstrate in the video, there are at least two easy sources for finding a Time Card Template:

  1. Sample Templates Installed on your Computer
  2. Templates that you can preview and download from the Microsoft Office Templates Website

Examining Templates that You Download

Before you even think about duplicating the Excel Template that you just downloaded, it is important for you to take a few minutes to explore:

  • The Formulas used in the Template
  • The Formatting used in the Template – especially the formatting for Dates and Times
  • The Protection Applied (if any) to the cells or the entire worksheet

Creating Drop-down Menus for your Template

Since our premise here is that we will copy the template to 51 additional worksheets, it makes sense to use Data Validation to create a series of “drop-down menus” for Employee names and the Start Date for each week. I demonstrate how to do this in the video tutorial.

Links to Additional Video Tutorials in this Series

Additional Resources for Excel

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

Watch Tutorial in High Definition

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

Click to Watch Video Now

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Data Validation, Excel Training, Names for Cells and Ranges, Work with Multiple Worksheets, YouTube Videos by Danny Rocks Tagged: , , , , , , , , ,
December 12, 2011 3 Comments

Tips for Creating 52 Weeks of Employee Time Cards in Excel

Insert & Copy Worksheets

Insert & Copy Worksheets

We are now winding down the end of the year 2011. Several of my viewers and clients have asked my for help in creating one Excel Workbook that will contain 52 weeks of employee time card information:

  • Name and Department of Employee
  • Hours Worked each day of the week – Regular and Overtime
  • Number of Holiday / Sick Days that were used / that remain, etc.

First Tutorial in this Series

Rather than trying to create each individual – and some are very specific – request, I have decided to combine multiple requests into a series of Best Practice Tips for my general audience to consider.

In this lesson, I demonstrate:

  • Two methods for adding new blank worksheets to the Excel workbook
  • Two Methods for inserting an exact copy of an existing – and formatted – worksheet
  • My favorite tip – Fill Across Worksheets – either the formatting only, the contents only or the default setting – both formatting and contents.

Links to Additional Tutorials in this Series

Watch Tutorial In High Definition

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

Additional Resources at My Online Shopping Website

I invite you to visit my new – secure – online shopping website – http://shop.thecompanyrocks.com – and preview the many tutorials and resources that I offer you.

Watch Tutorial Now

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Excel Training, Format Cells in Excel, Tips and Time Savers, Work with Multiple Worksheets, YouTube Videos by Danny Rocks Tagged: , , , , , , , ,
December 14, 2010 1 Comment

Working with Multiple Worksheets in Excel

The 50 Best Tips

The 50 Best

In this video lesson, I share my tips for maintaining a consistent look when working with multiple worksheets in Excel. I will demonstrate how to:

  • Group multiple worksheets for editing
  • Make a copy of an Excel worksheet
  • Use the Fill Across Worksheet tool – to update Contents or Formats or Both – for a Group of worksheets

In a professional setting, it is important to make a consistent presentation of your Excel worksheets. You want each worksheet in the group to use the same formatting styles, headers and formulas. The tips that I demonstrate will definitely save you time and help you to maintain a consistent look.

Click here to watch this video in High Definition, Full Screen mode on my DannyRocksExcels YouTube Channel.

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

Invitation to Visit My New Secure Online Shopping Site

I have just opened my new, secure online shopping website. I invite you to visit http://shop.thecompanyrocks.com to see the new products that I have introduced in the year 2011.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Working with Multiple Worksheets in Excel [ 7:36 ] Play Now | Play in Popup | Download (1114)
Link to this post!
Filed Under: Excel Functions, Excel Training, Podcast Tips & Timesavers, Work with Multiple Worksheets Tagged: , , , ,