(Click Category to List Courses)
37 - ITC - Information Technology - Miscellaneous
ITC 185B - Advanced Excel Course
| Code | Start Date | Duration | Venue | |
|---|---|---|---|---|
| ITC 185B | 23 October 2023 | 5 Days | Istanbul | Registration Form Link |
| ITC 185B | 18 December 2023 | 5 Days | Istanbul | Registration Form Link |
Please contact us for fees
Course Description
Microsoft Excel is a spreadsheet program that performs calculations, graphic tools, pivot tables, and a macro programming language. Participants who are already familiar with Microsoft excel programs and aims at getting a closer look at one of them, Excel, will find this course as the best way to do so. This program is an inevitable step towards career growth.
Course Objectives
- Learning how to validate data
- Performing swift calculations in one click
- Supporting findings with charts
- Learning how to use the pivots
Who Should Attend?
- Accountants
- Bankers
- Financial consultants
- Finance managers
Course Details/Schedule
Day 1
- Templates
- Efficiency and Risk
- Data Validation
- Data Validation Lists
- Comments
- Styles
Day 2
- Functions and Superpowers
- Array Formulae
- Tables
- Advanced Range Names
- What If?
- Problem Solving
Day 3
- Form Controls
- Visual Basic and Macros
- Scenario
- Auditing and Troubleshooting Formulas
Day 4
- Practical Interactivity with VBA
- Conditional Formatting
- Charts that Inspire
- Sparklines
- Graphics Tricks and Techniques
- Working with External Data
Day 5
- Advanced Uses of PivotTables
- PowerPivot
- Reporting with PowerPivot
