Provider web pages

 

UCL Learning Portfolio

 

DSD: Excel tips and tricks (ISEXCTT) 
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 Blackboard Collaborate/Microsoft Teams to join 15 minutes early in order to test out their connection/audio and help will be offered to sort out any problems. Participants are welcome to join any time within the first 15 minutes of the advertised start time. 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
25/11/2021 - 25/11/2021  (Enrol between 01/10/2021 and 23/11/2021) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue