MICROSOFT EXCEL LESSON OUTLINE



1.         INTRODUCTION TO MS EXCEL SPREADSHEET
2.         MEANING OF MS EXCEL
3.         ADVANTAGES OF S EXCEL
4.         COMPARISON BETWEEN LOWER VERSION AND HIGHER VERSION
5.         LOADING MS EXCEL
6.         FEATURES OF MS EXCEL
7.         GETTING STARTED WITH MS EXCEL
8.         CALCULATING MINIMUM VALUES
9.         CALCULATING MAXIMUM VALUES
10.       COUNT
11.       COUNT BLANK
12.       ROMAN
13.       COMPUTATION OF WORKERS PAYROLL
14.       COMPUTATION OF MARKET SUPPLY
15.       LOGIC FUNCTION
16.       SQUARE FUNCTION
17.       TAN FUNCTION
18.       SIN FUNCTION
19.       DRAW CHARTS
20.       KNOWING SOME CHARTS TERMINOLOGIES
21.       EXCEL CONCEPTS
22.       CREATING INVOICE
23.       RENAMING A SHEET
24.       FILTERING YOUR WORK
25.       TYPES OF FILTER
26.       USING PERCENTAGE VALUES
27.       TYPES OF PERCENTAGE VALUES
28.       PROFIT AND LOSS ACCOUNT
29.       APPLYING VALIDATION
30.       PROTECTING A WORKSHEET
31.       TO UNPROTECTED A WORKSHEET
32.       PROTECTING A WORKBOOK
33.       TO UNPROTECTED A WORKBOOK
34.       ADDING FORMS
35.       FORMULA EDITING
36.       TYPES OF FORMULA EDITING
37.       APPLYING FORMULA EDITING
38.       TO REMOVE TRACES
39.       APPLYING PASTE SPECIAL
40.       ADJUSTING A SHEET
41.       PRINTING COLUMN OF ROWS IN EXCEL
42.       APPLYING PAGE BREAK PREVIEW
43.       TO HIDE AND UNHIDE A SHEET
44.       ARITHMETIC FORMULAS
45.       APPLYING A BORDER STYLES IN EXCEL
46.       APPLYING HEADER AND FOOTER IN EXCEL
47.       RUNNING MACROS

Want to upgrade your skill in Microsoft Excel or learn how to use MS-Excel from scratch? Our step by step free daily lessons will help you get started and take you to perfection. Click Here to Join us today

No comments:

Post a Comment