Excel 2010/2013: Functions and Macros Prerequisites
Tue 8 Jul 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.
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 8 Jul 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 8 Jul 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
- Recorded macros (please note: not VBA programming)
- Labels and names
- Logical functions
- Statistical functions
- Financial functions
- Text functions
- Date and time functions
- Formula auditing
- Info functions
- Lookup functions
- Formula techniques (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
Booking / availability