Excel 2010/2013: Functions and Macros Prerequisites
Tue 2 Dec 2014
Description
This course covers some of the more challenging functions such as IF and VLOOKUP. The macro section uses automated steps and does not teach VBA programming.
Target audience
- All current Cambridge University members (departments and colleges)
- Further details regarding eligibility criteria are available
Prerequisites
- Good competency in Excel will be assumed
- Attendance of Excel: Introduction or equivalent knowledge
Sessions
Number of sessions: 2
# | Date | Time | Venue | Trainers | |
---|---|---|---|---|---|
1 | Tue 2 Dec 2014 09:30 - 13:00 | 09:30 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Sheena MacRae, Somsri Parker |
2 | Tue 2 Dec 2014 09:30 - 13:00 | 09:30 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 2 | map | Sheena MacRae, Somsri Parker |
Topics covered
- Recording macros (please note: not VBA programming)
- Labels and names
- Logical functions
- Statistical functions
- Financial functions (optional)
- Text functions (optional)
- Date and time functions
- Lookup functions
- Formula techniques - nested functions (optional)
Taught using
Excel 2010 on MCS Windows
Notes
- The course will be taught using Excel 2010 on PCs but will also be suitable for Excel 2007/2013 users. Macintosh users of Excel 2011 should also find it useful.
- Anyone wishing to copy the course exercise files should bring a USB memory stick they can be downloaded
Duration
One half day session
Frequency
Termly
Related courses
Booking / availability