Tutorial Topics

Search for Tutorials Show All Tutorials Pricing About Us

Tutorial Description

Continuing the theme of looking at the Office 365 suite of applications in more detail, Lee takes you through some tips and tricks that he has picked up whilst trying to master Excel.

Whilst lots of people know the basic functionality the app provides, some of the more complex functions can be overwhelming. In this screencast, Lee covers Pivot Tables, and Data Validation, as well as other useful tips that will make your life in Excel Land more joyful.

The full tutorial covers:

  • Pivot Tables
  • Pivot Table Slicing
  • Data Validation
  • Adding Multiple Columns
  • Copy Formatting
  • Freezing Panes
  • Multiple Windows
  • Hiding Cell Values

    Show Links: Microsoft Excel - Home

Video Tutorial Comments

(7 comments posted)

Martin Turner

Very helpful. Would find even more pivot table info very useful as it seems to be one of the "dark arts" of Excel! :0)

Reply

Robert Davis

Ditto!

Lee Garrett

Glad you enjoyed it! It was a bit of a different one for me so pleased it’s come across OK. There is so much that can be done with Pivot Tables, I may very well look at a mid-week tip video for this in the future :)

Tom Roper

Would definitely appreciate more like this one!

Tom Roper

Would definitely appreciate more like this one!

Tom Roper

Would definitely appreciate more like this one!

Tom Roper

Would definitely appreciate more like this one!

Posting comments is restricted to ScreenCastsOnline members only.

Sign Up