Excel 2010/2013: Functions and Macros Prerequisites
Wed 4 Mar 2015
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: 1
| # | Date | Time | Venue | Trainers | |
|---|---|---|---|---|---|
| 1 | Wed 4 Mar 2015 09:30 - 13:00 | 09:30 - 13:00 | Titan Teaching Room 2, New Museums Site | map | Monica Gonzalez, 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
Related courses
Booking / availability