(Click Category to List Courses)
37 - ITC - Information Technology - Miscellaneous
ITC 185A - Microsoft Excel Beginner Training
| Code | Start Date | Duration | Venue | |
|---|---|---|---|---|
| ITC 185A | 06 May 2024 | 5 Days | Istanbul | Registration Form Link |
| ITC 185A | 10 June 2024 | 5 Days | Istanbul | Registration Form Link |
| ITC 185A | 15 July 2024 | 5 Days | Istanbul | Registration Form Link |
| ITC 185A | 19 August 2024 | 5 Days | Istanbul | Registration Form Link |
| ITC 185A | 23 September 2024 | 5 Days | Istanbul | Registration Form Link |
| ITC 185A | 28 October 2024 | 5 Days | Istanbul | Registration Form Link |
| ITC 185A | 02 December 2024 | 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 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
