Free Advanced Excel Download

Sus and Bob at Excel seminarLast month, Bob MacLeod, our resident international finance, and spreadsheet, expert at Lake Hart, gave an entertaining presentation of Excel features for about fifty staff. (Who knew learning advanced Excel could be so much fun!)

Bob created a great handout for all of us to learn about:

  • Using Excel graphs in other software such as Word or PowerPoint
  • Keeping a history of changes (spreadsheets reflecting different time periods)
  • What to do about the default date setting (e.g., “6-Nov”)
  • Navigating Excel  more fluidly with keyboard keys
  • Lookups
  • SumIf and CountIf
  • Sorting and filtering (also by color)
  • If/Then statements
  • Text to columns
  • Group and Ungroup
  • Exporting and analyzing TntMPD data to Excel

Download Bob’s Excel handout on Google Docs.

What do you think?

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s