Estb. 1882

University of the Punjab

News Archives

Workshops

One day Training Program on Hands on Practice on Microsoft Excel from beginning to advance, with tips and tricks on Sunday, 17th January, 2016
One day Training Program on Hands on Practice on Microsoft Excel from beginning to advance, with tips and tricks on Sunday, 17th January, 2016


Training Title
Hands on practice on Microsoft Excel from beginning to advance, with tips and tricks
ORIC - A PIONEER IN RESEARCH INNOVATION & COMMERCIALIZATION
The Office of Research Innovation & Commercialization announces 1 day (Sunday) Training program on “Hands on practice on Microsoft Excel from beginning to advance, with tips and tricks”
TRAINING CONTENTS
The goal of this training is to educate participants aboutMicrosoft Excel toStore, organize, analyze, and r epresent data using its features. By attending this training, you will gain valuable insight into the Microsoft Excel, options and functions.This training is structured to help you to understand and acquire knowledge in the following main areas.
Advance Excel
Basics of MS Excel
Introduction of Advanced Excel Features
Analyzing Data with Excel
Excel Dashboards and Reports
VBA in MS Excel
Macros
Microsoft Excel
Microsoft Excel is a general-purpose electronic spreadsheet2 used to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, analyzing data for engineering purposes, preparing a purchase order, create an elaborate 3-D chart, or managing a complex accounting ledger for a medium size business.The Windows version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of Visual Basic. Programming with VBA allows spreadsheet manipulation that is awkward or impossible with standard spreadsheet techniques. Programmers may write code directly using the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization environment. The user can implement numerical methods as well as automating tasks such as formatting or data organization in VBA and guide the calculation using any desired intermediate results reported back to the spreadsheet.
WHO SHOULD ATTEND
Industry Professionals, Quality Managers, Middle Management, Engineering Students, Business Management Students, QualityManagement students and those who want to add values to their profile for their careers.
Duration of the Course: 01 Day (9:30 a.m – 04:30 p.m), Sunday
Date of the Course: 17th January, 2016
Training Fee: Rs. 2,500/-
Venue: Centre for Undergraduate Studies, University of the Punjab Lahore.
 
Certificates will be awarded to the participants
REGISTRATION PROCESS AND PAYMENT METHOD
Transfer Rs. 2,500/- to HBL Account # 01820028543703
To Acquire Registration Form, Click/Copy paste following link in browser
Email filled registration file and transaction number/evidence of transaction to (info.5emm@gmail.com) with subject “Excel Training Registration” before 08th January, 2016. (Note: Registration will be closed when all available seats will be occupied).
For Manual registration, acquire Forms & Deposit slips from Undergraduate Department Computer Lab, University of the Punjab
Contact person:
Mr. Amir Siraj (0322-4285458)
For Further Information Contact
For Information
5emm Consultants (0336-7279563)
For Registration
Mr. Amir Siraj (0322-4285458)
Prof. Dr. Amir Ijaz
Director ORIC, Centre of Undergraduate Studies, University of the Punjab, Lahore
Ph. No.  +92-42-99237015