Welcome to VISHWA COMPUTER CENTER

विश्व कॉम्प्युटर मध्ये आपले स्वागत आहे . मराठा समाजासाठी सारथी तर्फे कम्प्युटर चे ४ कोर्सेस पूर्ण पणे मोफत आहेत थोड्याच जागा शिल्लक राहिलेल्या आहे . लवकरत लवकर आपला प्रवेश घ्या . 

 
MKCL IN KLIC ADVANCED EXCEL ( S-003 )

BASIC INFORMATION

  • Course Fees : 4400.00 5000.00/-
  • Course Duration : 3 MONTH
  • Minimum Amount To Pay : Rs.1500.00
  • Introduction to Data Management
  • How do professionals organize their data?
  • Meta Data and Big Data
  • Freelance Data Entry Jobs
  • Using different types of keys and symbols in typing
  • Google Docs – Voice Typing
  • Lipikaar App
  • Text Formulas
  • Text Manipulation Functions
  • 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
  • Basic Excel Charts
  • Use Area, Scatter & Stock Charts
  • Use Surface, Radar & Combination Charts
  • Create Custom Chart Templates
  • Work with Sparkline’s
  • Pivot Tables
  • Use Pivot Charts
  • Create Dashboard using Pivot Table
  • Using Power Query
  • Use of Macros
  • Using Data Tables
  • Create Dashboard using Pivot Table
  • Using Power Query
  • Use What-If Analysis Tools
  • Create Scenarios
  • Merge Scenarios
  • Create Scenario Summaries
  • Use Data Tables
  • 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
  • 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
  • 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
  • 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
  • Using Komprehend
  • Excel Shortcuts
  • Mail Merge in MS Word
  • Compare Docs using MS Word
  • What is a DBMS and its purpose?
  • Types of DBMS
  • Examples of DBMS - MySQL, Oracle, etc.
  • Learner should preferably a std. 10th Pass student (Not Compulsory) It is desirable that Learner should have done MS-CIT Course (Not Compulsory)