Excel Module 4
Objective:
The aim of this session is to provide the Excel user with a more in-depth knowledge of the software and to open up possibilities for its use. We can also provide a pre training assessment of current users to determine their current level of knowledge.
Please note that existing users are invited to bring to the session any files which are or have been problematic and our trainer will be happy to have a look and advise.
Topics:
Review of the Basics
Data Cleansing / Creating Uniformity
TRIM /UPPER / LOWER / PROPER / CONCATENATE / LEFT / RIGHT / MID /
EN
Data Handling
Working with External Data Sources / Introduction to MSQuery
Text to Columns / Fixed Width Entries / Delimited
External Links and Connections
Using AutoFilter / Advanced Filter
Introduction to Macros
Security Settings
Macro Types
Naming your Macros
Shortcut Keys
Using the Macro Recorder
Using Relative Reference Macros
Macro Button / Embedded Buttons
Viewing and editing the VB Code
QUESTIONS & ANSWERS
Special Features and Facilities
The course is devoted to practical use of the software and is therefore primarily hands-on. An absolute maximum of 1 student per machine will be maintained. The session is fully documented, and each person attending will have unlimited access to our after training back up service.
Existing users are invited to bring questions, problematic spreadsheets, and also to ask for design advice on upcoming projects.
This specification can be tailored for onsite training sessions
