Page 193 - DCAP101_BASIC_COMPUTER_SKILLS

Basic Computer Skills Anuj Sharma, Lovely Professional University

Notes

Unit 10: Microsoft Excel

CONTENTS

Objectives
Introduction
10.1 Starting Excel
10.1.1 Excel 2003
10.1.2 The microsoft Excel 2007 Window
10.2 Exploring the Excel Window
10.2.1 An Excel worksheet

10.2.2 Using Office Assistant
10.3 Creating an Excel Workbook
10.3.1 Saving Our Work
10.3.2 Saving for the First Time
10.3.3 Opening an Excel Workbook
10.3.4 Opening a Workbook from Inside Excel
10.3.5 Entering and Manipulating Data
10.3.6 Entering and Formatting Titles
10.3.7 Arranging Text with the Copy, Paste, and Cut Commands
10.4 Entering Data
10.4.1 Doing Simple Calculations
10.5 Exploring Number Format
10.5.1 Entering Dates
10.5.2 Sorting Functions of Data

10.5.3 Using Formulae and Different Standard Functions
10.5.4 Copying Formulas
10.5.5 Analyzing Data
10.5.6 Sample Example Using Functions to ‘Calculating Grades
10.6 Range of Cells
10.7 Formatting Cells
10.8 Excel Function
10.8.1 Date and Time Function
10.8.2 Financial functions
10.8.3 Logical Functions
10.8.4 Mathematical and Trigonometric Function

186 LOVELY PROFESSIONAL UNIVERSITY