Microsoft Excel Course
5.0 /5- Offered byEFA
Microsoft Excel Course at EFA Overview
Duration | 6 hours |
Total fee | ₹2,499 |
Mode of learning | Online |
Difficulty level | Advanced |
Credential | Certificate |
Microsoft Excel Course at EFA Highlights
- Full time access
- Access on mobile, Tablet and tv
- 30 days money back guarantee
- Get Certification on Course Completion
Microsoft Excel Course at EFA Course details
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Learning to use Excel for Professional & Personal Life
- This course is in hindi language
- Aspirants will learn about the microsoft Excel in Hindi
- it will enhance the knowledge about microsoft excel and it will also help in their respective career field
Microsoft Excel Course at EFA Curriculum
Getting Started
Course Overview
Introduction
Basic Introduction
Customizing the Ribbon
Basic Options and Data Formatting
Cell Addressing and Referencing
Comments
Copy and Fill
Worksheet Customization
Worksheet Views
Introduction to excel logics and functions
IF and Nested IF
And, Not and IF Error Functions
Text Functions
Date Functions
Creating Formulas
Calculation Formulas
Count Functions
Statistical Functions
Math Functions
VLookup Functions
Lookup Functions
Digging deeper into excel
Privacy and Protection
Hyperlinks
Page Layout
Sorting and Filtering
Conditional Formatting
Data Validating
Tables and charts
Understanding Tables
Getting Familiar with Charts
Pivot Tables
Macros
Introduction to Macros
Conditional Formatting using Macros
GST
What Will We Create
Creating the GST Template
Automating the GST Template
Bonus
Drop-down List
Shortcuts in Excel
Microsoft Excel Course at EFA Faculty details
Microsoft Excel Course at EFA Entry Requirements
- Basic Computer Knowledge
- Not mentioned
Other courses offered by EFA
Student Forum
Anything you would want to ask experts?