Certificate Course in MS Excel - Level 1
INTRODUCTION
MS Excel is a revolutionary application of Microsoft is the life and blood of small and large organisations and professionals in storing, retrieve data from basic to complex information. However, advanced software is used in running organisations still MS Excel runs parallely because of its simplicity, utility and power. It has become basic and compulsory skills for any new entrant to the corporate world.
COURSE BENEFITS
- Understand all the features and placement of MS Excel.
- Able to enter different types of data in cells of rows and columns.
- Print in different paper and printing formats.
- Manage rows and columns.
- Use features like Filter
- Page Setup
- Basic Date & Time Functions.
METHODOLOGY
Self-Paced Learning
Learn-Anywhere-Anyway
Step by Step LearningNo Jumping of Chapters
Self-Study
Industry Experienced & Expert Faculty-Guidance.
Course Completion Certificates
EVALUATION
In Chapter Quizzes
Case Studies
Chapter-end Assignments
Self-Study
TARGET AUDIENCE
- All Working Professionals who work on MS Excel for recording retrieving and reporting Data.
- All Graduates and Post Graduate Students who want to be the first choice of their Employers.
COURSE CONTENTS
- CHAPTER 1 :
Exploring MS Excel 2013
-
1.1
-
1.2
-
1.3
-
1.4
-
1.5
- CHAPTER 2 :
Customizing Excel 2013
-
2.1
-
2.2
-
2.3
-
2.4
-
2.5
- CHAPTER 3 :
Spreadsheet Layout
-
3.1
-
3.2
-
3.3
-
3.4
- CHAPTER 4 :
Page Setup,Print Preview
-
4.1
-
4.2
-
4.3
-
4.4
- CHAPTER 5 :
Entering Data
-
5.1
-
5.2
-
5.3
-
5.4
-
5.5
-
5.6
-
5.7
-
5.8
-
5.9
- CHAPTER 6 :
Formatting Worksheet
-
6.1
-
6.2
-
6.3
-
6.4
-
6.5
-
6.6
-
6.7
-
6.8
-
6.9
-
6.10
- CHAPTER 7 :
Working with Windows
- CHAPTER 8 :
Using Illustrations
-
8.1
-
8.2
-
8.3
-
8.4
-
8.5
-
8.6
-
8.7
-
8.8
- CHAPTER 9 :
Hyperlink
- CHAPTER 10 :
Text Functions
- CHAPTER 11 :
Basic Numeric Functions
- CHAPTER 12 :
Working with Chart
-
12.1
-
12.2
-
12.3
-
12.4
-
12.5
-
12.6
- CHAPTER 13 :
Understanding References
-
13.1
-
13.2
-
13.3
-
13.4
- CHAPTER 14 :
Protection Data in Excel
- CHAPTER 15 :
Formula Auditing
-
15.1
-
15.2
-
15.3
-
15.4
-
15.5
-
15.6
- CHAPTER 16 :
Working with Styles
-
16.1
-
16.2
-
16.3
- CHAPTER 17 :
Working with Excel…
- CHAPTER 18 :
Managing Data
- CHAPTER 19 :
Review Data
FACULTY PROFILE
Masih Uzzamma
Masih Uzzamma is a professional MS Office Trainer who has trained more than 15000+ participants in the 10+ years to various corporates and working professionals across the country and abroad. He specialises in MS Excel - Basic and Intermediate Levels along with MS Excel VBA, MS Access and MS Excel Power. Apart from MS Office he also delivers programs on .NET, HTML, Libre Office and JAVA.