Excel 2013 - Advanced Level

Excel 2013 - Advanced Level

(The Basics of writing code programming)

Please be sure to read carefully the requirements and outline before you register to this level

Duration:

3 Days
12 hours
6th, 7th and 8th of July 2017
From 10 AM : 2 PM

Requirements before you study this program:

1- Excellent knowledge for the Excel features, tools.. etc.
2- Know correctly how to work with Excel cell references.
3- Working good with the most used functions (if function, right, left … etc….)
4- Using forms (Basic skills, object names and usage)
5- Please bring your laptop at the time of the training, and be sure to install Excel 2013.

Program outcomes:

By the end of the program, the participants will be able to:
•    Know how to work with macros.
•    Run macro from a command button.
•    Using VBA code to control the excel sheets & cells.

Outline:

Basics to Macros & VBA Code
•    Create a Macro
•    MsgBox
•    Workbook and Worksheet Object
•    Range Object
•    Variables
•    If Then Statement
•    Loop
•    Macro Errors
•    String Manipulation
•    Date and Time
•    Events
•    Array
•    Function and Sub
•    Application Object
•    Final Project

Where:

Egyptian Council, Dokki

Registration fee:

600 LE instead of 1000 until 2nd of July 2017

Registration fee including:

Attending the workshop.
Coffee break.
Attendance certificate.

For registration:

37 Mosadak St, Floor# 6
Dokki - Giza, Egypt.
Tel/Fax: +2 (02) 3748 7742
Mob:+2 (010) 2048 3878
This email address is being protected from spambots. You need JavaScript enabled to view it.
www.egyptiancouncil.com
https://www.facebook.com/ECTD.EG

JoomShaper