In today’s podcast, a five line macro that will allow you to scale a selected range. This macro was inspired by engineers in one of my recent VBA seminars. They had been using a similar tool for years and we were surprised it was a five line macro to replicate the tool. Episode 695 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Duration : 0:3:18
Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula in a 2 minute podcast. Episode 454 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Duration : 0:3:41
Continuing in my series of Excel Tutorials for analyzing the year-end inventory of I retail store, I demonstrate how to use Excel Functions and Formulas.
In this case, using just three “hard coded” numbers (Sales, Cost of Goods Sold and Average Inventory), we create six formulas: Gross Profit $, Gross Profit %, Inventory “turns” per period, Products as a % of Sales, Inventory (by product) as a % of total inventory, GMROI (Gross Margin Return on Investment)
As a bonus, I demonstrate several ways to quickly – and accurately enter your Excel formulas.
I invite you to visit my secure online shopping webiste – http://shop.thecompanyrocks.com – to preview all of the resources tht I offer to you.
Danny Rocks
The Company Rocks
Duration : 0:16:8
I am a proponent of creating Named Cell Ranges and then using them in your Excel Formulas. However, what if you have existing formulas that use cell references and NOW you wish to create and apply Named Cell Ranges?
In this tutorial, I first demonstrate two methods for creating Named Cell Ranges. Next, I walk you through the process of substituting a Named Cell Range for existing cell references in your formulas and functions.
I invite you to visit my secure, online shopping website – http://shop.thecompanyrocks.com – to preview all of the resources that I offer you.
Danny Rocks
The Company Rocks
Duration : 0:10:43
The Basics of Excel Charting: Part IV
This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we’d set up our Data Set, Created our Chart and made adjustments to our Chart Axis. Today, in Episode #1408, Bill shows us how to Change our Chart Title, set up a comprehensive Legend and adjust the colors of our charted data.
…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010″, by Bill Jelen a.k.a. MrExcel.
For more Excel 2010 knowledge, check out “Excel 2010 In Depth”, by Bill Jelen a.k.a. MrExcel.
For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.
Duration : 0:3:17
In my opinion, there are three main reasons to use Named Ranges in Excel Formulas:
1) They are easier to write – especially when range of cells is large
2) They are easier to remember – e.g. Gross Profit = Sales minus Costs
3) They are easier to explain to others – see example for point #2
In this lesson, I demonstrate two ways to create a Named Range. The first is to use the “Name Box” in all versions of Excel. The second is to Create a Named Range from Selection.
In my next lesson, I will show you how to modify named ranges and also how to apply named ranges to existing formulas.
Please visit my secure online shopping website – http://shop.thecompanyrocks.com – to preview all of the resources that I offer.
Danny Rocks
The Company Rocks
Duration : 0:13:8
John from New Zealand offers an improvement to Thursday’s podcast about creating a Data Entry form on a spreadsheet. Today, in Episode #1504, Bill applies the tip from John to improve the VBA code for this Database Form routine!
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Duration : 0:1:52
In this tutorial, I demonstrate how to use the “Logical Functions” of IF, AND, and OR in Excel. In order to return the answer TRUE with the AND Function, each logical test must answer TRUE.
I frequently “Nest” the AND Function inside an IF Function and I demonstrate how this works.
I also share my “Best Practice” tips for using the Advanced Filter tool in Excel. The key to success is know how to use AND criteria and OR criteria.
I invite you to visit my website – www.thecompanyrocks.com – to view all of my videos and to sample the many resources that I offer.
Danny Rocks
The Company Rocks
Duration : 0:11:13
How to open up a saveas dialog box
Excel VBA tutorial 30 Userforms Pictures and RGB Values