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:

NRI candidates:


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


Ph. No:  080 4655 1306, 1307, 1308, 1309

Bangalore Kengeri Campus

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

Bangalore - 560074

Ph. No:  080 4012 9800, 9802, 9820

Delhi NCR Campus

CHRIST (Deemed to be University),

Mariam Nagar, Meerut Road,

Delhi NCR Ghaziabad - 201003


Ph. No: 1800-123-3212

Email :

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 :

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)


(Deemed to be University)

Dharmaram College Post, Hosur Road, Bengaluru - 560029,
Karnataka, India

Tel: +91 804012 9100 / 9600

Fax: 40129000


Web: http://www.




CHRIST (Deemed to be University) is a nurturing ground for an individual's holistic development to make effective contribution to the society in a dynamic environment.

Copyright © CHRIST (Deemed to be University) 2020