Programme Details

Excel Business Data Analysis and Automation

Objectives -45 Hrs
This paper is offered as a tool to obtain knowledge and skills for business data analysis and automation using Excel 2010. Upon completion of the course, students should be able to build efficient and dynamic models according to the modern business requirements and format data to enhance the quality of information presentation.
 
UNIT 1 -  04Hrs
Introduction: File types, Spreadsheet structure, Menu bar, Quick access toolbar, Mini toolbar, Excel options. Formatting: Format painter, Font, Alignment, Number, Styles, Cells, Clear, Page layout
 
UNIT 2 -  07Hrs
Business data collection using Excel Web Query. Rearranging data using Data table and Pivot. Graphing business data using Excel
 
UNIT 3 - 10Hrs
Business data analysis using Excel functions &formulas: VLOOKUP, SUMIFS, AVERAGEIFS, IF…AND…OR, INDEX, MATCH, GOAL SEEK, Nested formulas, Mega formulas
 
UNIT 4 - 24Hrs
VBA Programming: Developer environment, Variables, Data types, Looping, Sub procedures, Function procedures, Add-Ins, Mini-Excel application project
 
Recommended Readings
1. Jelen, B. (2010). Using Microsoft Office Excel.
2. Hawley, D. and Hawley, R. (2009). Excel hacks.
3. Walkenbach, J. (2000). Ms Excel Power Programming With VBA.
4. Jelen, B. and Syrstad, T. (2008). VBA and Macros for Microsoft Excel

For any queries at any given time during the application and admission process, you may contact us through the following Email ID’s:

Bangalore Central Campus

The Office of Admissions,

CHRIST (Deemed to be University), Hosur Road,

Bengaluru - 560 029, Karnataka, INDIA

 

Ph. No: +91 92430 80800

Email IDs

Indian candidates: admissions@christuniversity.in

NRI candidates: nri.admission@christuniversity.in

International: isc.admission@christuniversity.in

Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bangalore, Karnataka 560076

 

Ph. No:  080 4655 1306, 1307, 1308, 1309
Email:
 admissions.bgr@christuniversity.in

Bangalore Kengeri Campus

CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,

Bangalore - 560074


Ph. No:  080 4012 9800, 9802, 9820
Email:
 admissions.kengeri@christuniversity.in

Delhi NCR Campus

CHRIST (Deemed to be University),

Mariam Nagar, Meerut Road,

Delhi NCR Ghaziabad - 201003

 

Ph. No: 1800-123-3212

Email : admission.ncr@christuniversity.in

Pune Lavasa Campus

CHRIST (Deemed to be University),

Christ University Road, 30 Valor Court,

PO Dasve Lavasa, Mulshi, Pune - 412112, Maharashtra

 

Ph. No : 1800-123-2009,
Email :
 admission.lavasa@christuniversity.in

Between: Monday to Friday: 09:00 AM to 04:00 PM, Saturday: 09:00 AM to 12:00 PM
(Office remains closed on Sundays, Government Holidays and Any special events)

Access denied for user ''@'localhost' (using password: NO)