|
BAR > Course Details (AER)
Course Content
- Overview Of Excel
- Excel as a database
- Excel as a programming tool
- Using Functions To Lookup And References To Database
- Hlookup/Vlookup
- Indirect
- Choose
- Offset
- Index
- Placing Controls On A Worksheet
- Introduction
- Creating Interactivity using Combo Box, Spinner and Scroll Bar
- Making choices using Check Box or Option Box on a Worksheet
- Linking a Control to Worksheet Data
- Create, define and delete Range Names
- Using Functions To Manage Data
- Using the LOGICAL Functions like IF, ISERROR, AND, OR, NOT
- Interpret Data using MATHEMATICAL Functions like COUNTIF, COUNT, COUNTA, SUMIF, ROUND, SUMPRODUCT.
- Extract relevant text using TEXT functions like LEFT, RIGHT, MID, PROPER, UPPER, LOWER, CONCATENATE
Intended For
This course is intended for accountants and financial professionals who wish to learn the Excel tools to automate their monthly reporting process. This course will provide case studies to apply these functions in a real-world environment.
Course Instructor
You will be trained by one trainer from our team of dedicated trainers. Our qualified trainers hold Bachelor degrees in the field of Information Technology and Certifications in Microsoft Office Specialist.
They have many years of working experience in the IT industry and have specialised in conducting Microsoft Office Specialist - Excel Expert courses in major IT training centres and government schools.
|