Pages: 132 (23713 words) Published: November 17, 2013
COMPUTER APPLICATION
BCOMP1101
STUDENT NOTES

FACULTY OF BUSINESS MANAGEMENT & GLOBALIZATION

INSTRUCTOR MANUAL

Inovasi 2-3, Jln Teknokrat 1/1
63000 Cyberjaya
Selangor Darul Ehsan, Malaysia
Phone 603.8317.8811 • Fax 603.8317.8338

ii

T
able of Contents
CHAPTER 1 ▬ INTRODUCTION TO
MICROSOFT EXCEL 2003

3.2.1 Relative, Absolute & Mixed Cell
References

2003

2

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

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

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

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
5.1 PMT Function
5.2 FV Function

51

5.3 Goal Seek

52

5.4 Statistical Functions

CHAPTER 3 ▬ ENHANCING
WORKSHEET WITH MORE
REFERENCE

49

53
55

3.1 Template

20

5.5 IF Function

3.1.1 Student Time Table Template

20

5.6 VLOOKUP & HLOOKUP Functions 57

3.2 Cell Reference

23

Summary

59

iii

CHAPTER 6 ▬ LIST AND DATA
MANAGEMENT & CONVERTING DATA
TO INFORMATION

8.2 Recording Macro

94

8.3 Running Macro

95

6.1 Database Concepts

61

8.4 Buttons

96

6.2 List and Data Management

61

Summary

99

6.3 Data Form

61

6.4 Text Import Wizard

63

6.5 Data Validation

66

6.6 Sort

69

6.7 Filter

70

6.7.1 AutoFilter

70

6.7.2 Custom Filter

73

74

6.8 Outline

75

6.9 Subtotal

76

6.10 Name Command

78

6.11 Freeze Panes

79

Summary

79

BIBLIOGRAPHY

CHAPTER 7 – DATA ANALYSIS
7.1 Data Analysis Techniques

81

7.1.1 Sorting

81

7.1.2 Calculating

81

7.1.3 Summarizing

81

7.1.4 Filtering

81

7.1.5 Formatting

81

7.1.6 Charting

82

7.2 COUNT, COUNTA, COUNTIF
Functions

82

7.3 IF Function