UCL Learning Portfolio

 

DSD: Excel tips and tricks
Course Description:

This one hour demonstration session will cover lots of tips and tricks for working with Excel. There will be something here for everyone. Users of all Excel for Windows and Macintosh versions are welcome.

Once you have booked on the course you will be able to access all of the online materials in our Digital Skills Development Moodle course.

IMPORTANT: Please ensure you are using Desktop@UCL or the UCL VPN when booking because you need to be on the UCL network to use the system.

Once you have enrolled, you will need to click on the play button under 'My current enrolments' in My Learning to join at the time of the live session. You will also receive an email from ISD containing the direct joining link a day before the session. Please check your junk folder as these emails are occasionally tagged as spam.

We would encourage those who are new to Microsoft Teams to join within the first 15 minutes of the advertised start time in order to test out their connection/audio. The actual session will start on the hour.
Objectives:
Tips covered include:
  • useful keyboard shortcuts
  • ways to select large areas, block of data
  • inserting a line break into a cell
  • autofill,
  • autocalculate,
  • naming cells and ranges and why,
  • data bars conditional formatting,
  • easy headers and footers,
  • splitting windows,
  • creating custom views,
  • freezing rows / columns,
  • hiding rows / columns,
  • adding your favourite commands to the
  • quick access toolbar,
  • the repeat command (helps with formatting).
Intended Audience:
This course is aimed at those wishing to become more efficient and productive Excel users.
Target Audience: All
Register Interest in future dates Register Interest

Back to MyLearning Catalogue