MS Excel - Offset Command
 
DID YOU KNOW...  that you can easily expand a named range of data automatically when you add a value to the range?   If you add rows inside a range then the named range will extend to include these new entries. However, if you add a row at the bottom of the range the name will ignore it - here's how to get round that problem.
 
Click on a link below to find out how.  
 

Learn more about MS Excel to make your life easier with a Bite Size subscription to our Microsoft Office learning library. Keep learning.
 
Introducing Bite Size Life Skills
 
MS Excel and Budgeting Basics - the perfect combination 
  
 
Budgeting is something you will be involved in at some point to varying extents.
 
Imagine spending 15 minutes to understand the importance of budgeting. Learning these skills can open your eyes when using Excel.
 
This course explores the reasons for budgeting, how organisations budget, key budgeting terms and the steps involved in the budgeting process.
   
Why not combine these courses?  Courses start from just £5.99 for three months access.  Visit our  online shop today .
 
For more than 50 licences, please contact us for company discounts. 
STAY CONNECTED:
You are receiving this newsletter because you requested our Tip of the Week or are a subscriber to the Bite Size Lesson Library. Our Weekly Tips are FREE and provide useful hints and tips on how to get the most out of your computer. You can unsubscribe anytime by using the SafeUnsubscribe link below.