Frequently clients will show me a report that they have downloaded from a Main Frame Computer or a Database Report. The report contains multiple blank cells. In order for my client to insert a Pivot Table or to perform Subtotals, they must fill in the blank cells by copying the value for the cell above. I have watched, in amazement, as clients copy and paste – or even type in – the missing values. There is an efficient way to perform this task. Here are the Excel Concepts that I cover in this short – 3 minute – Excel video training lesson:
- Go To Special – Current Range
- Go To Special – Blank Cells
- Use Ctrl + Enter to register the formula into each cell in the selected range
- Copy, Paste Special Values to convert formulas to values
This tip will save you lots and lots of time and prevent careless data entries. If you like this tip, I have 50 similar tips to offer you on my DVD, “The 50 Best Tips for Excel 2007.” Click here to add my DVD to your Shopping Cart.
Subscribe to our RSS Feed
I was pleasantly surprised to see my DVD, “The 50 Best Tips for PowerPoint 2007″ reviewed today by noted author and speaker, Ellen Finkelstein.
Here is a link to Ellen’s review
Notice that the review is part of Ellen’s “PowerPoint Tips Blog.” I encourage you to go to Ellen’s website – www.ellenfinkelstein.com – to read and subscribe to her newsletter and to gather some great tips for improving your presentations. By registering, you can download a free white paper: “From Death by PowerPoint to Life by PowerPoint.” Check out Ellen’s site today.
Danny Rocks
The Company Rocks
Subscribe to our RSS Feed
In Part One, I showed you how to Consolidate Data By Position - where the range of cells was consistent in each of the Excel worksheets - Click on this link to go to this lesson.
In this lesson, I show you how to Consolidate Data By Category / By Label. You use this technique when the number of rows or columns containing values varies from worksheet to worksheet. For example, the number of sales representatives reporting may change each month. Or, some of the worksheets that you receive contain an extra column that you want to include in your consolidation. Consolidating Data by Category is very flexible as you will see in this lesson.
Subscribe to our RSS Feed
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!
-
I invite you to view, download or subscribe to my YouTube Channel for Excel Training videos by following this link.
Thank you!
Danny Rocks
Subscribe to our RSS Feed
There are many ways to Summarize data that is stored in multiple Excel Worksheets or Workbooks. Pivot Tables are great for producing summaries. However, many people do not use (do not know how to use Pivot Tables) so let me demonstrate how to use Excel’s Consolidate Data Tool to get the job done.
In this lesson, I will show you how to “Consolidate Data By Position.” I will take the data from four identical worksheets and consolidate the sales numbers in a new worksheet. First, without using a “Link” to keep the data in the consolidated worksheet current and then I show you how to create a link to the Source Data.
But… there is a “Got’cha Step” when you link sources. It is possible to “double your sales numbers” without realizing it! Not good – when you are found out.
Watch as I show you a “trick” – how to use the SUM() Function to total data across a contiguous group of Excel worksheets. It really is a great trick!
I continue this lesson on Data Consolidation in Part Two. Click on this link to see how to Consolidate Data By Category.
You can download and view this Excel Training Video at the iTunes Store. Follow this link to subscribe to the “Danny Rocks Tips and Timesavers” podcast.
And, you can learn “The 50 Best Tips, Tricks and Techniques for Excel 2007″ when you purchase my DVD – on sale now!
Subscribe to our RSS Feed
Here is a listing – with hyperlinks – to the free Excel Training Videos that I offer on my website. Simply click on the hyperlink for each Category to go directly to the Excel videos in that category. Note: Some of my Excel Videos are listed in multiple categories.
Excel Tips
If you like the free videos that I offer, I guarantee that you will enjoy my DVD – “The 50 Best Tips for Excel 2007″ - now on sale here on my website.
Excel Training Video Lessons – by Category:
“The 50 Best Tips for Excel 2007″ DVD is now on sale!
Subscribe to our RSS Feed
One way to ensure full and balanced participation in your meetings is to “cast the roles” that each participant plays during the meeting. Want to minimize the disruption of “agenda hijackers?” Assign specific roles for each participant. Want to maximize participation? Limit your meeting invitations to the people who have been cast to play a specific role in helping you to accomplish the purpose of your meeting.
In this video, I detail the roles and responsibilities for each of these “cast members:” Leader, Facilitator, Recorder, Timekeeper, Parking Lot Manager, Subject Matter Experts, Stakeholders, and Devil’s Advocate. In my experience I have found that when you help people to understand the role that they need to perform, you improve their performance.
Watch this 7 minute and 27 second video and let me know what you think. Do you have other roles to suggest? Have you tried this approach? If so, I invite you to add your comments below.
This is the second installment in my “Running Effective Meetings” series of podcasts. Follow this link to view the first installment. I invite you to subscribe to my – free – podcast at the iTunes store by following this link.
Subscribe to our RSS Feed
Do you carry around multiple versions of a PowerPoint file – one for each of your five customers? Have you ever carried the wrong version? Have you ever forgotten to update each version with the latest information?
If so, you need to learn how to create and run a PowerPoint Custom Slide Show. You can even hyperlink to custom shows within your main presentation! And, no more File Save As – you only use one file!
You can view this short PowerPoint Video here on my website, download it, or subscribe to my – free – podcast at the iTunes store.
This PowerPoint Training Video Lesson is typical of the tips that I offer on my DVD, “The 50 Best Tips for PowerPoint 2007.” Click here to buy it now.
Subscribe to our RSS Feed
As a small business owner or investor, you ask many“what-if?” questions. In preparing to present your business plan to an investor you want to know your “break even” point. Fortunately, Excel has a great tool – Goal Seek – that can save you time by creating multiple scenarios to help you determine your goal – to break even!
You can watch this Excel Video Lesson here – online – or you can download it to watch later, at your convenience. I invite you to subscribe to my podcast, “Danny Rocks Tips and Timesavers” at the iTunes store by clicking this link – this is a free subscription.
Subscribe to our RSS Feed
Social Media can help you to grow your business. In order to use social media successfully, it is helpful that you follow a proven process. The AIDA process has successfully guided direct mail marketers for years. It is a perfect match for helping you to get customers to click deeper into your website: to turn their curiosity into an action; to make a sale; to make an appointment.
To see how to apply AIDA (Attention, Interest, Desire, Action) to your internet marketing plan, click to watch – or download – this short 5 minute video.
Follow this link to subscribe to my podcast – “Danny Rocks Tips and Timesavers” – at the iTunes store.
Subscribe to our RSS Feed
Quickly Fill in Values for Blank Cells in an Excel Report [3:05m]: Play Now | Play in Popup | Download (49)
