Microsoft Excel is a spreadsheet programme which allows you to store lists of text and numerical information, and make calculations and projections.
Book this Course
To run this course for your team, email excel@WilliamCampbell.info, or call +49 30 2247 6097. See more information about training here.
Suggested Uses
- Creating Macros
- Correctin large amounts of data
- Separating data into different worksheets
- Collecting information through forms
- Creating custom functions for Excel
Training Course Outline
- Built-in Functions
- Record and Running Macros
- Introduction to VBA
- Proper Selection Techniques
- Procedures
- Objects, Properties and Methods
- Variable & Constants
- Message & Input boxes
- Performing Multiple Actions on an Object
- Workbooks and Sheets
- Reading and Writing from worksheets
- Data Types
- IF Statements
- Loops
- Controls
- User Forms
- Functions
- Debugging and Error Trapping
After the Course
You will be able to write complex macros that can read and write data from worksheets, process that data and write it to other locations.