Excel Business Data Analysis and Automation

Bangalore Central Campus
Open From :
Open Until :

Course Details
Admission Queries

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 NRI candidates: nri.admission@christuniversity.in International: isc.admission@christuniversity.in	Bangalore Bannerghatta Road Campus CHRIST (Deemed to be University) Hulimavu, Bannerghatta Road, Bengaluru - 560 076, Karnataka, INDIA Ph. No: 080 4655 1306 Email: admissions.bgr@christuniversity.in
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 Email: admissions.kengeri@christuniversity.in	Bangalore Yeshwanthpur Campus CHRIST (Deemed to be University) Nagasandra, Near Tumkur Road, Bengaluru 560 073, Karnataka, INDIA Ph. No: +91 97422 44407 Email: admissions.yeshwanthpur@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)

CHRIST UNIVERSITY

(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

Vision

EXCELLENCE AND SERVICE

Mission

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.

Website Developed by Cloud Business Pages from INI Technologies Pvt Ltd., Kochi, India