computer application in business
COMPUTER APPLICATION
FOR BUSINESS
BCOMP1101
STUDENT NOTES
FACULTY OF BUSINESS MANAGEMENT & GLOBALIZATION
COMPUTER APPLICATION FOR BUSINESS
INSTRUCTOR MANUAL
Limkokwing Executive Leadership College
Inovasi 2-3, Jln Teknokrat 1/1
63000 Cyberjaya
Selangor Darul Ehsan, Malaysia
Phone 603.8317.8811 • Fax 603.8317.8338
© Microsoft Corporations
ii
T able of Contents
CHAPTER 1 ▬ INTRODUCTION TO
MICROSOFT EXCEL 2003
3.2.1 Relative, Absolute & Mixed Cell
References
2003
2
1.2 What is a Spreadsheet?
2
1.3 Microsoft Excel 2003 User
Interface
3
1.4 Starting Microsoft Excel 2003
4
1.5 Types of Cell Entries
5
1.6 Identifying Toolbars and Buttons
6
1.7 Identifying Menus and Commands
8
1.8 Opening Excel Files
9
1.9 Saving Excel Files
10
1.10 Closing Excel Files
10
Summary
11
24
3.2.2 3-D Cell Reference
27
3.2.3 Consolidating Cell Reference
27
3.3 Advance Formatting Cells
1.1 Introduction to Microsoft Excel
28
3.3.1 Conditional Formatting
34
3.4 Navigating In Excel
35
Summary
35
CHAPTER 4 ▬ GRAPHS AND CHARTS
4.1 What is a Chart?
37
4.2 Chart Types
37
4.3 Creating a Chart using Chart
41
4.4 Choose Chart Type
43
4.5 Check Data Series
43
4.6 Complete Chart Option
45
4.7 Chart Location
45
4.8 Modifying Chart
46
4.9 Enhancing Chart
46
4.10 Moving and Resizing Chart
46
4.11 Multiple Data Series
47
4.12 Object Linking and Embedding
47
Summary
CHAPTER 2 ▬ DEVELOPING A
PROFESSIONAL LOOKING
WORKSHEET
Wizards
48
2.1 Create Workbook and Multiple
Worksheet
12
2.2 Enter Text and Numbers
13
2.3 Use Simple Functions (Sum) and
Formulas
14
2.4 Simple Formatting
15
2.5 Page Setup and Orientation
17
2.6 Printing Workbook
18
Summary
18
CHAPTER 5 – DECISION MAKING IN
SPREADSHEETS
5.1 PMT Function
5.2 FV Function
51
5.3 Goal
FOR BUSINESS
BCOMP1101
STUDENT NOTES
FACULTY OF BUSINESS MANAGEMENT & GLOBALIZATION
COMPUTER APPLICATION FOR BUSINESS
INSTRUCTOR MANUAL
Limkokwing Executive Leadership College
Inovasi 2-3, Jln Teknokrat 1/1
63000 Cyberjaya
Selangor Darul Ehsan, Malaysia
Phone 603.8317.8811 • Fax 603.8317.8338
© Microsoft Corporations
ii
T able of Contents
CHAPTER 1 ▬ INTRODUCTION TO
MICROSOFT EXCEL 2003
3.2.1 Relative, Absolute & Mixed Cell
References
2003
2
1.2 What is a Spreadsheet?
2
1.3 Microsoft Excel 2003 User
Interface
3
1.4 Starting Microsoft Excel 2003
4
1.5 Types of Cell Entries
5
1.6 Identifying Toolbars and Buttons
6
1.7 Identifying Menus and Commands
8
1.8 Opening Excel Files
9
1.9 Saving Excel Files
10
1.10 Closing Excel Files
10
Summary
11
24
3.2.2 3-D Cell Reference
27
3.2.3 Consolidating Cell Reference
27
3.3 Advance Formatting Cells
1.1 Introduction to Microsoft Excel
28
3.3.1 Conditional Formatting
34
3.4 Navigating In Excel
35
Summary
35
CHAPTER 4 ▬ GRAPHS AND CHARTS
4.1 What is a Chart?
37
4.2 Chart Types
37
4.3 Creating a Chart using Chart
41
4.4 Choose Chart Type
43
4.5 Check Data Series
43
4.6 Complete Chart Option
45
4.7 Chart Location
45
4.8 Modifying Chart
46
4.9 Enhancing Chart
46
4.10 Moving and Resizing Chart
46
4.11 Multiple Data Series
47
4.12 Object Linking and Embedding
47
Summary
CHAPTER 2 ▬ DEVELOPING A
PROFESSIONAL LOOKING
WORKSHEET
Wizards
48
2.1 Create Workbook and Multiple
Worksheet
12
2.2 Enter Text and Numbers
13
2.3 Use Simple Functions (Sum) and
Formulas
14
2.4 Simple Formatting
15
2.5 Page Setup and Orientation
17
2.6 Printing Workbook
18
Summary
18
CHAPTER 5 – DECISION MAKING IN
SPREADSHEETS
5.1 PMT Function
5.2 FV Function
51
5.3 Goal