The transcript will follow that audio as the video plays. Scroll and click on the transcript to jump to that part of the video.
4,290
Plays
51
Likes
PLEASE NOTE - Due to changes in macOS 26, this video does NOT play in Safari. Please use a Chromium Browser, or watch through the SCO Video Tutorials App
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:
Hiding Cell Values
Show Links: Microsoft Excel - Home
Keyboard Shortcuts
Playback
Screen & position
This show
(7 comments posted)
Very helpful. Would find even more pivot table info very useful as it seems to be one of the "dark arts" of Excel! :0)
Ditto!
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 :)
Would definitely appreciate more like this one!
Would definitely appreciate more like this one!
Would definitely appreciate more like this one!
Would definitely appreciate more like this one!
Recent Full Tutorials
All Recent TutorialsWe pride ourselves in our responsiveness, but please allow up to 24 hours for us to get back in touch. We are based in UK so there may be a time difference!
Drop us an email
Posting comments is restricted to ScreenCastsONLINE members only.
Sign Up