computer application in business

Topics: Spreadsheet, Microsoft Office, Microsoft Excel Pages: 132 (23713 words) Published: November 17, 2013
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 Seek

52

5.4 Statistical Functions

CHAPTER 3 ▬ ENHANCING
WORKSHEET WITH MORE
FORMATTING AND ADDING CELL
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

6.7.3 Advanced Filter

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
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Computer Application Essay
  • computer application Essay
  • Application of Computer in Any Area of Business Essay
  • Essay about CGS 2167 Computer Applications syllabus
  • Essay on Computer Application
  • Computer and its application Essay
  • Essay about Computer Application In Business
  • Computer Applications Study Guide Essay

Become a StudyMode Member

Sign Up - It's Free