Certificate Course in MS Excel - Level 2
INTRODUCTION
“Working Smarter not Harder” is the key to success. Make use the power of MS Excel to get all the required information to make Quick and Right DECISIONS. Everyone in the organization from accountants to administrative assistants, from MIS Executives, Finance professionals to Sales & Marketing teams, Production teams to Supply Chain teams uses MS Excel spreadsheets and reporting tool to gain insights. MS Excel is a must-have skill and knowledge for everyone who wants to accelerate their careers. This advanced course is aimed at learners who have a good grounding in Excel either from experience or from attending our level 01 Microsoft Excel training course. If your job involves manipulating and analyzing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in the gaps in your knowledge. This advanced Excel course focuses on the vast array of the functionality of Microsoft Excel and will allow students to enhance their skills.
COURSE BENEFITS
- Students would learn How to create dashboards How to create simple reports from complex data using VLOOKUP and HLOOKUP Different formulae's and functions How to manage complex data. Advanced Security features.
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
- 1. Professionals who have basic knowledge of MS Excel.
- 2. Professionals who work with huge data.
- 3. Professionals who need to present information in various graphs and formats.
COURSE CONTENTS
- CHAPTER 1 :
Working with Range
-
1.1
-
1.2
-
1.3
-
1.4
- CHAPTER 2 :
Understanding References
-
2.1
-
2.2
-
2.3
- CHAPTER 3 :
Numeric/Statistical…
- CHAPTER 4 :
Logical Functions
- CHAPTER 5 :
Conditional Formatting
-
5.1
-
5.2
-
5.3
-
5.4
- CHAPTER 6 :
Sorting And Filtering data
-
6.1
-
6.2
-
6.3
-
6.4
-
6.5
-
6.6
-
6.7
- CHAPTER 7 :
Data Validations
-
7.1
-
7.2
-
7.3
-
7.4
- CHAPTER 8 :
Working with Table
- CHAPTER 9 :
Date and Time Functions
-
9.1
-
9.2
-
9.3
-
9.4
-
9.5
-
9.6
-
9.7
-
9.8
-
9.9
- CHAPTER 10 :
Working with Sparklines
-
10.1
-
10.2
- CHAPTER 11 :
What if analysis Tools
- CHAPTER 12 :
Error types and Error…
- CHAPTER 13 :
Working with Lookup…
-
13.1
-
13.2
-
13.3
-
13.4
-
13.5
-
13.6
-
13.7
-
13.8
-
13.9
- CHAPTER 14 :
Array Formulas
-
14.1
-
14.2
-
14.3
-
14.4
- CHAPTER 15 :
Working with Subtotal
-
15.1
-
15.2
- CHAPTER 16 :
Data Analysis Report with…
-
16.1
-
16.2
-
16.3
-
16.4
-
16.5
-
16.6
-
16.7
- CHAPTER 17 :
Collaborating with other…
-
17.1
-
17.2
-
17.3
- CHAPTER 18 :
Protection in Excel
-
18.1
-
18.2
-
18.3
-
18.4
- CHAPTER 19 :
New features of Excel 2013
-
19.1
-
19.2
-
19.3
-
19.4
-
19.5
-
19.6
-
19.7
-
19.8
-
19.9
- CHAPTER 20 :
Understanding Macros
-
20.1
-
20.2
-
20.3
-
20.4
-
20.5
-
20.6
-
20.7
-
20.8
- CHAPTER 21 :
Creating User defined…
- CHAPTER 22 :
Creating User defined…
- CHAPTER 23 :
Consolidate data from…
-
23.1
-
23.2
-
23.3
-
23.4
- CHAPTER 24 :
Shortcuts for Excel 2013
-
24.1
-
24.2
-
24.3
-
24.4
-
24.5
-
24.6
-
24.7
-
24.8
-
24.9
-
24.10
-
24.11
-
24.12
-
24.13
-
24.14
-
24.15
-
24.16
-
24.17
-
24.18
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.