Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Mar 5, 2012

This week's highlights include sample code for time tracking, shortcuts and code for selecting part of an Excel sheet, and a new book from a client of mine.

 -  Debra ddalgleish@contextures.com
 

Select the Actual Used Range in Excel

On the Contextures Blog, we looked at keyboard shortcuts for selecting specific parts of an Excel worksheet.

There is also a sample macro that you can use, to select only the range that contains data, not the empty columns or rows that might surround it.

Keep Track of Time with Excel VBA

Last week, we saw how to manually enter start and stop times in Excel, and calculate the total time spent on tasks.

This week, we look at ways to automatically enter the current time, including seconds, by using Excel VBA.

misLeading Indicators

One of my clients, Philip Green, is co-author of a new book, misLeading Indicators: How to Reliably Measure Your Business, that was published this week.

The book covers the 4 key principles for reliable measurements:

  1. Sufficient background information
  2. Accuracy and precision
  3. Reasonable inferences
  4. Reality checks in different situations.
 
The authors show how to apply and interpret measurements in specific areas, including business performance, risk management, process, control, finance, and economics.

I've worked with Phil for more than 20 years, and hold his work in very high regard. I look forward to reading misLeading Indicators -- as soon as Amazon is ready to ship it!

Excel Humour

Once again, I read the Excel tweets, so you don't have to! Here are a few favourites from this week. You can read the rest of the tweet collection here.
 
  • +50 nerd points: I just added my first macro to an Excel file. -100 nerd points: I got the code from a forum
  • My Excel sheets are like a piece of modern art, really confusing but you know someone put a lot of work into them
  • Excel for Mac tends to work better when Numbers is open. Gets the competitive juices flowing, maybe?

Recommended Excel Tools

__

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.