TRAINING CATEGORIES
(Click Category to List Courses)

37 - ITC - Information Technology - Miscellaneous


ITC 185C - Microsoft Excel Comprehensive Training (10 Days)

Code Start Date Duration Venue
ITC 185C 18 November 2024 10 Days Istanbul Registration Form Link
ITC 185C 23 December 2024 10 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 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
  • 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

  • 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

Day 6

  • Templates
  • Efficiency and Risk
  • Data Validation
  • Data Validation Lists
  • Comments
  • Styles

Day 7

  • Functions and Superpowers
  • Array Formulae
  • Tables
  • Advanced Range Names
  • What If?
  • Problem Solving

Day 8

  • Form Controls
  • Visual Basic and Macros
  • Scenario
  • Auditing and Troubleshooting Formulas

Day 9

  • Conditional Formatting
  • Practical Interactivity with VBA
  • Charts that Inspire
  • Sparklines
  • Graphics Tricks and Techniques
  • Working with External Data

Day 10

  • Advanced Uses of PivotTables
  • PowerPivot
  • Reporting with PowerPivot

 

ETABS and SAFE. Training 24 CCE 210 5 SAP 2000. Training 25 CCE 305 5 Quality Assurance in Pavement Construction 26 CCE 401 5 Construction Project Management 27 CCE 402 10 Construction Project Management (10 Days) 28 CCE 403 5 Construction Project Management-Intensive 29 CCE 405 5 Principles of Construction Project Management 30 CCE 406 10 Principles of Construction Project Management (10 Days) 31 CCE 410 10 Construction Project and Risk Management (10 days) 32 CCE 411 5 Project & Contract Management for Marine Construction 33 CCE 412 5 Application of GIS in Construction Management 34 CCE 415 4 Sustainable Water Management Techniques, Innovation and Solution (4 Days) 35 CCE 419 5 Construction Management of Hydraulic Projects 36 CCE 420 5 Water Project Management 37 CCE 421 10 Modern Technologies in the Supervision and Quality Control of Irrigation Projects and Dealing with Contractors (10 Days) 38 CCE 422 5 Rapid Earthquake Hazard Evaluation of Buildings 39 CCE 425 10 Practical Application of Computers in Structural Engineering (10 Days) 40 CCE 428 5 Survey & Profile Using Total Station 41 CCE 430 5 Bridge Construction and Maintenance 42 CCE 435 5 Bridge Inspection and Maintenance 43 CCE-A 410 10 إدارة المشاريع الهندسية -10 أيام
21 - TTC - Transportation and Traffic Control
22 - ADV - Architectural Design and Visualization
23 - SRM - Safety and Occupational Health
24 - CSM - Public Relations, Communication Skills & Office Management
25 - TEM - Training and Education Management
26 - CMR - Customer Relations