Search Contextures Sites
Excel Weekly News from Contextures Apr 9, 2012Copy code, use data entry shortcuts, play Excel Tic Tac Toe, and other tips, in this week's Excel news from Contextures.- Debra firstname.lastname@example.org
Copy Code to an Excel WorkbookIf 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 WorkbookTo 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 NumbersThese 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 ExcelIn 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 HumourOnce 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
Contextures Inc., Copyright ©2017
All rights reserved.