(Click Category to List Courses)

36 - ITC - Information Technology - Miscellaneous


ITC 185A - Microsoft Excel Beginner Training

Code Start Date Duration Venue Fees
ITC 185A 19 December 2020 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 09 January 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 06 February 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 06 March 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 03 April 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 01 May 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 26 June 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 24 July 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 21 August 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 18 September 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 16 October 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 13 November 2021 5 Days Istanbul $ 3950 Registration Form Link
ITC 185A 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 will attend this course will learn all the details of Excel, which enhances their overall skills. It starts with the basics of excel moving on more specific details and secrets of this program. This program is an inevitable step towards career growth. 

Course Objectives

  • Understanding the basic terminology used in Excel 
  • Creating spreadsheets and formatting them 
  • Dealing with formulas
  • Performing swift calculations in one click 
  • Supporting findings with charts 

Who Should Attend?

  • Accountants 
  • Bankers 
  • Financial consultants 
  • Finance managers 

Course Details/Schedule

Day 1

  • Introduction to interface 
  • Introduction to basic terminology 
  • Creating a new spreadsheet
  • Writing and formatting
  • Excel's auto-fill features
  • Keyboard shortcuts
  • Merge cells
  • Wrap text in excel

Day 2

  • Excel data input
  • Basic computations
  • Excel formulas
  • Popular functions in Excel 
  • Subtotals
  • Creating reports

Day 3

  • Create a drop-down list 
  • Freeze rows and columns 
  • Headers and footers in a worksheet
  • Excel dates and times
  • Named range
  • Accounting in Excel

Day 4

  • Cell references
  • Circular reference
  • Errors checking 
  • Filters
  • Removing duplicates
  • Transpose
  • Text to columns
  • VLOOKUP function

Day 5

  • Hyperlinks
  • Password protection
  • Add or remove add-ins
  • Using the Analysis ToolPak to perform complex data analysis
  • Common excel errors