(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