Master Excel with Expert Guidance
Advanced Excel Course

-
Course Features:
-
-
- Language: English, Marathi, Hindi
- Duration: 120 hours (2 months)
- Learning Mode: Center
- Jurisdiction: Nationwide
- Certificate of Completion
-
Eligibility
-
- Learner should preferably a std. 10th Pass student (Not Compulsory)
- It is desirable that Learner should have done MS-CIT Course (Not Compulsory)
Certification
-
- KLiC English course is recognized by Yashwantrao Chavan Maharashtra Open University (YCMOU).
- MKCL provides certificate to the KLiC learner after his/her successful course completion.
- Yashwantrao Chavan Maharashtra Open University (YCMOU) provides mark sheet to successfully passed KLiC learners from Maharashtra jurisdiction.
Course Syllabus
Basics of Data Management
- Introduction to Data Management
- How do professionals organize their data?
- Meta Data and Big Data
- Freelance Data Entry Jobs
Introduction to Computer Typing & Data Entry
- Introduction to Typing
- Keyboarding
- Ergonomic Typing
Introduction to verious Typing Methods
Using different types of keys and symbols in typing Google Docs – Voice Typing Lipikaar App
Introduction to Data Anaylsis
- Using different types of keys and symbols in typing
- Google Docs – Voice Typing
- Lipikaar App
- Text Formulas
- Text Manipulation Functions
Apply Custom Formats And Layouts
- Apply Custom Data Formats
- Use Advanced Fill Options
- Apply Advanced Conditional Formatting and Filtering
- Apply Custom Styles and Templates
- Use Form Controls
- Prepare Workbooks for Internationalization
- Use Outlines
- Use Custom Views
Create Advance Chart
- Basic Excel Charts
- Use Area, Scatter & Stock Charts
- Use Surface, Radar & Combination Charts
- Create Custom Chart Templates
- Work with Sparkline’s
Pivot Table And Chart
- Pivot Tables
- Use Pivot Charts
- Create Dashboard using Pivot Table
- Using Power Query
Data Visualisation And Data Analysis
- Use of Macros
- Using Data Tables
- Create Dashboard using Pivot Table
- Using Power Query
Use Scenarios
- Use What-If Analysis Tools
- Create Scenarios
- Merge Scenarios
- Create Scenario Summaries
- Use Data Tables
Manage and Share Workbook
- Manage Workbook Versions
- Copy Styles between Workbooks
- Copy Macros between Workbooks
- Use Track Changes and Comments
- Merge Workbooks
- Protect Workbooks for Sharing
- Connect To External Data
Typical Data Entry Project
- File Conversion from PDF to Word
Create Advance Formulas
- Functions
- Apply functions in formulas
- Mathematical Functions
- Financial functions
- Useful Data Functions
- Some Other Useful Functions
- Look up data by using functions
- Apply advanced date and time functions
- Functions for Manipulating Text
- Arrays
Free and Open-Source Tools for Data Management
- Working with Google Sheets
- Working with Google Forms
- Working with Google Keep
- Using OpenOffice.org Writer
- Using OpenOffice.org Calc
- Using Komprehend
- Using Google Data Studio
Different Data Entry Methods
- Using Komprehend
- Excel Shortcuts
- Mail Merge in MS Word
- Compare Docs using MS Word
Introduction to DBMS
- What is a DBMS and its purpose?
- Types of DBMS
- Examples of DBMS – MySQL, Oracle, etc.