Excel Business Data Analysis and Automation

  • Bangalore Central Campus
  • Open From :
  • Open Until :
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
Ph. No:  +91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru - 560 076, Karnataka, INDIA
Ph. No:  080 4655 1306
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru - 560 074, Karnataka, INDIA

Ph. No:  +91 80 4012 9800, 9802, 9820
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA

Ph. No:  +91 97422 44407
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad - 201003
Ph. No: 1800-123-3212
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,
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

Email: mail@christuniversity.in

Web: http://www. christuniversity.in




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