[admission-open-date]
- Back to School Homepage
- Back to Department Homepage
Objectives -45 HrsThis 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.
Modules
UNIT 1
- 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
-
4 hours
UNIT 2
- Business data collection using Excel Web Query. Rearranging data using Data table and Pivot. Graphing business data using Excel
-
7 hours
UNIT 3
- Business data analysis using Excel functions &formulas: VLOOKUP, SUMIFS, AVERAGEIFS, IF…AND…OR, INDEX, MATCH, GOAL SEEK, Nested formulas, Mega formulas
-
10 hours
UNIT 4
- VBA Programming: Developer environment, Variables, Data types, Looping, Sub procedures, Function procedures, Add-Ins, Mini-Excel application project
-
24 hours
-
Recommended Readings
-
Jelen, B. (2010). Using Microsoft Office Excel. -
Hawley, D. and Hawley, R. (2009). Excel hacks. -
Walkenbach, J. (2000). Ms Excel Power Programming With VBA. -
Jelen, B. and Syrstad, T. (2008). VBA and Macros for Microsoft Excel
Lab Programs
-
Exercise 1: Design a Business card and Letter head for a given company -
Exercise 2: Design a Poster for an event -
Exercise 3: Design a Brochure for a new product -
Exercise 4: Design a CD Label / cover for Music company -
Exercise 5: Create a Packaging product for a given product -
Exercise 6: Design a web page for Restaurant -
Exercise 7: Create a Photo album -
Exercise 8: convert Black and white photo to color
Admission Queries
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
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
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)
Objectives -45 HrsThis 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.
Modules
UNIT 1
- 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
-
4 hours
UNIT 2
- Business data collection using Excel Web Query. Rearranging data using Data table and Pivot. Graphing business data using Excel
-
7 hours
UNIT 3
- Business data analysis using Excel functions &formulas: VLOOKUP, SUMIFS, AVERAGEIFS, IF…AND…OR, INDEX, MATCH, GOAL SEEK, Nested formulas, Mega formulas
-
10 hours
UNIT 4
- VBA Programming: Developer environment, Variables, Data types, Looping, Sub procedures, Function procedures, Add-Ins, Mini-Excel application project
-
24 hours
UNIT 1
- 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
-
4 hours
UNIT 2
- Business data collection using Excel Web Query. Rearranging data using Data table and Pivot. Graphing business data using Excel
-
7 hours
UNIT 3
- Business data analysis using Excel functions &formulas: VLOOKUP, SUMIFS, AVERAGEIFS, IF…AND…OR, INDEX, MATCH, GOAL SEEK, Nested formulas, Mega formulas
-
10 hours
UNIT 4
- VBA Programming: Developer environment, Variables, Data types, Looping, Sub procedures, Function procedures, Add-Ins, Mini-Excel application project
-
24 hours
-
Recommended Readings
-
Jelen, B. (2010). Using Microsoft Office Excel. -
Hawley, D. and Hawley, R. (2009). Excel hacks. -
Walkenbach, J. (2000). Ms Excel Power Programming With VBA. -
Jelen, B. and Syrstad, T. (2008). VBA and Macros for Microsoft Excel
Lab Programs
-
Exercise 1: Design a Business card and Letter head for a given company -
Exercise 2: Design a Poster for an event -
Exercise 3: Design a Brochure for a new product -
Exercise 4: Design a CD Label / cover for Music company -
Exercise 5: Create a Packaging product for a given product -
Exercise 6: Design a web page for Restaurant -
Exercise 7: Create a Photo album -
Exercise 8: convert Black and white photo to color
Admission Queries
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
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
The Office of Admissions,CHRIST (Deemed to be University), Hosur Road,Bengaluru – 560 029, Karnataka, INDIA
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Phone
+91 80 4012 9800,
+91 80 4012 9802
+91 80 4012 9820
Email
admissions.kengeri@christuniversity.in
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
Email
admission.ncr@christuniversity.in
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
1800-123-2009
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Phone
+91 97422 44407
+91 80 6989 6666
Email
admissions.yeshwanthpur@christuniversity.in
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
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)