Excel

  • Buffer
  • Sharebar
  • Buffer
jethro's picture

The future revealed - on PsyJournal

JETHRO_spy_journalb2b-125Just kidding I don't have a crystal ball, and it should be SpyJournal - but I thought the accidental typo made a cool pun!

However what this post is about is revealing a plan to write a number of Back To Basics series. These will be written from two points of views, mine and Amanda's.

 

The reasons for the series.

jethro's picture

Microsoft Excel Hack Security Issue

Microsoft is investigating new public reports of a vulnerability in Microsoft
Office Excel 2003 Service Pack 2, Microsoft Office Excel Viewer 2003, Microsoft
Office Excel 2002, Microsoft Office Excel 2000, and Microsoft Excel 2004 for
Mac. At this time, our initial investigation indicates that customers who are
using Microsoft Office Excel 2007 or Microsoft Excel 2008 for Mac, or who have
installed Microsoft Office Excel 2003 Service Pack 3 are not affected by this
vulnerability.

This vulnerability cannot be exploited on Microsoft Office Excel 2003 Service
Pack 3, Microsoft Office Excel 2007, Microsoft Office Excel 2007 Service Pack 1,
or Microsoft Excel 2008 for Mac.

Full details Microsoft Security Advisory (947563)

jethro's picture

Intraday Charts and Pattern Fills in Excel 2007

David Gainer writes an Excel blog for Microsoft. He often has guest posts written by insiders from Microsoft exposing cool excel secrets.

Two in particular I have noticed recently are these.

Scott Ruble, a lead program manager on the Excel team who focuses on the area of data visualization discusses how to create an intraday time series chart.

Periodically, users need to create a chart where the data occurs within a single day such as by the minute or hour. This is actually fairly easy to do but unfortunately isn’t very obvious. A typical scenario is you own a restaurant that takes phone orders and you want to reduce the wait time for customers placing an order. This is influenced by a number of factors but a big one is the number of people calling at the same time. As such, you would want to staff your phone lines with more people during the busy times. The key here is to determine when the busy times are and by how much.

jethro's picture

Permutations in Excel

I posted an article about Permutations in Excel once before, back in 2005. I actually made a mistake in my example, and was corrected by a reader in a comment- thanks MathBoss.

I have since had another reader, Dam ask a question that I am not sure of the answer of. So I am opening it up to you Excel experts out there.

Here is the question as Dan wrote it.

How in Excel can I create ALL permutations of a given data set. for example, imagine 5 columns. Each column has a differnet (sic) number of unique entries. Column 1 can be A, B. Column 2 could be A, B, C, D, E and so on. I want to combine 1 item of each 5 columns and keep doing it until I create all possible combinations. The number of permutations (PERMUT) may be very large so I need to automate this. I'd like to avoid building a macro since I am sick of building them and I like the static spreadsheet challenge more.

Add your answers in the comments.

Share this post: