Excel Advanced - duration 1 day


This course is for confident users. Again you will be given lots of tips and shortcuts.
Delegates are also invited to bring along their own work to make the course more pertinent.

- Formatting and Converting Time Values
- Concatenation
- Using INT and MOD
- LOOKUP and VLOOKUP functions
- Workbook Templates
- Using Excels’ Built-in Styles
- Creating a User-defined Style
- Auditing your workbook
- Full Access Passwords
- Modification Passwords
- Hiding Worksheets
- Sharing a Workbook
- Scenarios
- Custom Views



Home ¦ Training ¦ Database Development ¦ Website Design ¦ Network Installs ¦ Site Menu