(Click Category to List Courses)

36 - ITC - Information Technology - Miscellaneous


ITC 185B - Advanced Excel Course

Code Start Date Duration Venue Fees
ITC 185B 28 November 2020 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 26 December 2020 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 09 January 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 06 February 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 06 March 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 03 April 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 01 May 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 26 June 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 24 July 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 21 August 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 18 September 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 16 October 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 13 November 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185B 11 December 2021 5 Days Istanbul $ 3950 Registration Form Link
DOWNLOAD PDF

 

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