Course fees

Fee Per Delegate: £0.00 + VAT

Book places

Select a date from the calendar to view the events on that day. Only dates with a border have an event.

Disclaimer

Non Attendance, without withdrawal at least 24 hours before course start date, will result in a £100 fine to your department.

Reviews

N.C. said...
I thought the course was very good especially for beginners at excel. However, it would be best to have courses based on excel ability as I had more advanced knowledge than the rest of the group. It would also be helpful to hold the course in a computer...
Course:
Excel at Excel, Beginners (am) OR Intermediate (pm)
Rating:
4.3 stars out of 5
79 reviews
Tutor(s):
Core Skills Training Department
Tutor Profile:
Department:
Learning and Development | Imperial
Provider:
Learning and Development
Administrator:
Shirley McDowell
Description:

Being able to interrogate, manipulate and present data is a key skill for all administrators.  This course assumes you already have the basics.  It is a master class for those who want to work smarter and faster: how to format, how to view and link more than one spreadsheet, how to create charts, and use pivot tables.

 

Topics covered

·        Hot keys – work smarter and quicker

·        Layout tips

·        Calculation tips

·        Smarter ways to format spreadsheet

·        Viewing more than one sheet and linking sheets

·        Auto sub-totalling

·        Creating automatic personal lists

·        Charting tips

·        OLE

·        Manipulate databases easily and quickly

·        View the power behind Pivot Tables

 

Duration:
4 hours
Mode of Delivery:
Classroom
Targeted Audience:
Bands
Prerequisites:

You will need to be compliant in your mandatory core skills training prior to applying for this programme.

Learning Outcomes:
•Use pivot tables to manipulate and interrogate data •Create tables •Use automatic functions to work more efficiently
Certification:
Other Certification:
Accreditation:
Assessment Method:
National Standards:
No
Any Further Information:
Web Link: