Search Contextures Sites


Newsletter Index


Excel news
by email




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Apr 9, 2012

Copy code, use data entry shortcuts, play Excel Tic Tac Toe, and other tips, in this week's Excel news from Contextures.
 -  Debra

Copy Code to an Excel Workbook

If you find sample Excel VBA code on the Contextures Blog or website, or another trusted site, you can copy that into your own workbooks. This video shows you the steps: Copy Excel Code

There are also written instructions on the Contextures website

Copy PivotTable Style to Different Workbook

To make it easy to format a pivot table, you can use the built-in PivotTable Styles, or create your own custom PivotTable Styles. Learn how in this article.

After you make your own style, you can copy it to a different workbook, and this video shows you how.

Data Entry Shortcuts for Dates and Numbers

These short videos show you tips for quickly creating a series of numbers or dates on an Excel worksheet, such as a list of even numbers or a list of dates by week.

You can find more Excel Data Entry tips on the Contextures web site.

How to Excel without Excel

In the Excel for Educators blog, The Science Goddess shows examples of dashboards from a 1922 magazine article on graphics for school administrators.

It's interesting to see all the chart types that were all drawn by hand, using tools like a ruler and protractor. The author of that 1922 article even warns about pie charts, "Hence the circle charts, though often used, are likely to be misleading."

Noughts and Crosses (Tic Tac Toe)

On the Daily Dose of Excel blog, Michael posted his Excel version of Tic Tac Toe. You can have a bit of fun with it, and learn a few programming tricks.

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.
  • I think I need to host a "how to use excel" seminar for folks at work. With emphasis on "how not to overwrite formula cells"
  • my excel spreadsheet looks an easter egg coloring pack exploded
  • I made fun of Excel before and now it's deleted all my work. Well played, Excel. #sigh

Recommended Excel Tools

Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright 2014
All rights reserved.