Do you want to add a skill to your resume that will attract job interviewers to prefer you when hiring?
Do you want to be able to efficiently manage your own tasks as well as your organisation’s data?
Do you want to produce impressive analytical reports that will blow the minds away of your colleagues & supervisors?
BECOME A MAHARASHTRA KNOWLEDGE CORPORATION LIMITED (MKCL) CERTIFIED ADVANCED EXCEL EXPERT
Learn to collect, edit, analyse data and create databases with analytical reports.
NO-Excel to KNOW-EXCEL can get you better-paying jobs.
Advanced Microsoft Excel is one of the most important skills considered for better career prospects & promotions eligibility.
Having better Microsoft Excel Knowledge helps you become a Valuable Asset for your organisation.
Analytical Reports generated using Advanced Excel Skills allows better decision-making & forecasts.
What will You Learn...
- Master Microsoft Excel from Beginner to Advanced
- Build a solid understanding on the Basics of Microsoft Excel
- Learn the most common Excel functions used in the Office
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros
- Maintain large sets of Excel data in a list or table
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Access to a World-Class Course Contents designed by highly experienced professionals at MKCL.
After competing the course, You...
- Will get a Government Recognised Certificate from MKCL and a score marksheet validated by YCMOU
- Will become an Advanced Excel Pro & would be able to complete all major Microsoft Excel tasks swiftly & efficiently
- Can get a suitable position as an Accounts Assistant, Finance Analyst, Retail Store Manager or Data Analyst in any reputed organization
- Will learn about available career opportunities, roles to be performed at the workplace
- Will be able to save a lot of time as you can automate repeated tasks
- Can create beautiful analytical reports & dashboards that will not just visually look awesome but also enable better decision-making
- Can use online business intelligence tools to share real-time reports with larger team members irrespective of their work location… and do a lot much more…
The contents covered in this course such as...
Using Custom Layouts & Formats
Conditional Formatting
Using Advanced Formulas
Using Scenarios
Creating Advanced-level Pivot Tables & Charts
Managing & Sharing Workbooks for Team Collaboration
Data Visualisation with Analysis & more...
... are usually packaged in a course value of ₹15,000.
With these major Advanced Excel Course Contents, we provide you with the following
FREE BONUS MODULES
COMPUTER TYPING & DATA ENTRY WITH BASICS OF DATA MANAGEMENT
- Introduction to Typing
- Keyboarding
- Ergonomic Typing
- Introduction to Data Management
- How do professionals organize their data?
- Meta Data and Big Data
- Freelance Data Entry Jobs
WORTH ₹5,000 VALUE
DATA AUTOMATION WITH MACROS
- Use of Macros
- Using Data Tables
Create Dashboard using Pivot Table - Using Power Query
WORTH ₹8,000 VALUE
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
- Using Komprehend
- What is a DBMS and its purpose?
- Types of DBMS
- Examples of DBMS – MySQL, Oracle, etc.
WORTH ₹15,000 VALUE
Advanced Excel contents + COMPUTER TYPING & DATA ENTRY WITH BASICS OF DATA MANAGEMENT + DATA AUTOMATION WITH MACROS + OPEN-SOURCE TOOLS FOR DATA MANAGEMENT that is collectively
WORTH ₹43,000 VALUE
WE OFFER YOU THIS COURSE BUNDLE AT
₹6,000 ONLY
🎁 FREE BONUS GIFTS
1️⃣ FREE BONUS
Vocational Soft-Skills Course
Course Fees: ₹5,000
You Pay: ₹5,000 ₹0
This course has been designed especially for young individuals who want to acquire Soft Skills including Communication Skills; leading to or resulting into personal effectiveness at the globally accepted beginner/basic level.
Ensuring job readiness or workplace readiness for an effective and successful professional, social and personal life!
- Our lives are driven by Technology. Be it any field, technology is inevitable. As the technology advances, it creates demand in every field. We need special skill set for professional as well as personal life.
- Soft Skills are needed to survive in the changing times. If practiced, could make you an efficient individual.
- The course promotes vital skills like personal competence, interpersonal relations, understanding, communication skills and self-help tools. Also has Professional skills like presentation skills, time management, decision making, workplace ethics, conflict management, stress management and customer relationship management.
This course will make you job-ready and the best choice for employers
2️⃣ FREE BONUS
8-in-1 Digital Marketing Course
Course Fees: ₹10,000
You Pay: ₹10,000 ₹0
Digital Marketing is a branch of marketing that involves technologies like internet, computers, and mobile phones for online promotions of the products and services. It is a well-targeted, conversion-oriented, and interactive marketing approach to reach the potential customers and transform them into clients. The purpose of digital marketing is to promote your business in the online world to reach the right audience.
Recent studies show that Digital Marketing is the fastest growing sector in the tech industry. This course is designed to make you a digital marketing pro.
Become a Digital Marketing Expert with this course bundle that has 8 courses with easy-to-understand 95+ video lessons in Hindi language.
> Instant Access to the Course that includes pre-recorded video course bundle with 95+ lessons on:
3️⃣ FREE BONUS
Digital Business Setup Guide
Value Worth: ₹5,000
You Pay: ₹5,000 ₹0
Get guidance & references to complete step-by-step tutorials to create more than 15 different types of complex websites including:
- Business Listing or Directory Website like JustDial or IndiaMart
- Job Posting Website like Naukri or LinkedIn
- Affiliate Marketing or Blogging Website
- Freelancing or Micro Jobs Website like Fiverr or Freelancer
- Matrimonial Website like Shaadi.com
- School Management Website with Attendance, Fees, Timetable and More Features
- Tours & Travels and Hotel Booking Website
- Social Media Network & Community Website like Facebook
- Money-making Blog with AdSense, Affiliate & Email Marketing
- Online Course, LMS (Learning Management System), Educational Website like Udemy
- eCommerce Online Store like Flipkart or Amazon
- Business & Services Review Website like TrustPilot
- Website for Church, Masjid, Religious Organization
- Multi-Vendor eCommerce Marketplace Website like Amazon & FlipKart
- Questions & Answers Q&A, Forum Website like Quora
- Classified Ads Listing Website like OLX & JustDial
- Digital Downloadable Products Selling Multi-Vendor eCommerce
- Real Estate Listing & Directory Website
- Food Delivery & Restaurant Booking Website
- Appointment booking Website for Doctors, Lawyers, Spa & Beauty Parlors, Restaurants, Barber etc.
You also get ready guidance on:
- How to setup custom or personalised professional email absolutely FREE
- How to design a logo
- Websites to get FREE stock images for commercial business use
- Setup social media profile page for business on Facebook
- Setup social media profile page for business on Instagram
- Setup social media profile page for business on LinkedIn
- Setup social media profile page for business on Twitter
- Setup YouTube channel for a business
- Setup & verify business profile on Google My Business
- Our lives are driven by Technology. Be it any field, technology is inevitable. As the technology advances, it creates demand in every field. We need special skill set for professional as well as personal life.
- Soft Skills are needed to survive in the changing times. If practiced, could make you an efficient individual.
- The course promotes vital skills like personal competence, interpersonal relations, understanding, communication skills and self-help tools. Also has Professional skills like presentation skills, time management, decision making, workplace ethics, conflict management, stress management and customer relationship management.
Know Your Mentor
The course video lessons are designed by industry experts from Maharashtra Knowledge Corporation Limited (MKCL).
MKCL is the pioneer in computer education with its flagship course running since 20+ years now and created more than 1 crore 40 lakh IT literates.
Highly experienced teams considered the market trends and current industry requirements while they created this course structure. MKCL is a benchmark brand in the IT Industry and trusted by the Maharashtra Govt. for all IT Management Projects.
In case you have any queries during your course, please send an email to connect@dgcti.com OR WhatsApp message us on 9082304917. All your queries will be resolved to your satisfaction.
Excel skills are as important as the subject knowledge. Those who know Excel can find a better paying job. An Excel Expert collects, edits, analyses data, creates data bases and reports. The conclusions made by the data expert are helpful for organizations to forecast the business speculations.
After completion of the course, you can get a suitable position in any organization as an Accounts Assistant, Finance Analyst, Retail Store Manager or Data Analyst, etc.
COURSE HIGHLIGHTS
Highly recommended to MBA students as it covers 94% syllabus of MBA Subject ‘MS Excel and Advanced Excel Lab’
GOVERNMENT RECOGNISED CERTIFICATE ON COURSE COMPLETION
LEARN FROM ANYWHERE USING YOUR LAPTOP, COMPUTER, TABLET OR SMARTPHONE
Course explainer videos available in English, Hindi & Marathi Languages.
The course focuses on practical knowledge and application. The aim is to make the learner efficient and to offer him or her rewarding career.
Once you pay the fees, you receive a call from us to request a few details required for Government Recognised Certification.
Using these details, we generate your login credentials and share with you.
You will need the MKCL ERA Live App to learn this course that needs to be installed on your computer/laptop or smartphone.
WATCH THIS VIDEO to know more details about the MKCL ERA Live App
Sure!
Please fill & submit this form and we will share your login details to the demo course app.
You can access the demo application on a smartphone or computer/laptop with MKCL Live ERA app.
Not required. We share with you a short basic Excel course absolutely FREE that helps you to get started.
HERE'S A RECAP
WITH GOVERNMENT RECOGNISED CERTIFICATION WHAT ALL YOU GET AT A NOMINAL FEES OF ₹4,997 ONLY
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 Various Typing Methods
- Using different types of keys and symbols in typing
- Google Docs
- Voice Typing
- Lipikaar App
Introduction to Data Analysis
- Using different types of keys and symbols in typing
- Google Docs – Voice Typing
- Lipikaar App
- Text Formulas
- Text Manipulation Functions
Applying Custom Formats & 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 Advanced Charts
- Basic Excel Charts
- Use Area, Scatter & Stock Charts
- Use Surface, Radar & Combination Charts
- Create Custom Chart Templates
- Work with Sparkline’s
Pivot Tables & Charts
- Pivot Tables
- Use Pivot Charts
- Create Dashboard using Pivot Table
- Using Power Query
Data Visualisation & Data Analysis
- Use of Macros
- Using Data Tables
Using Scenarios
- Use What-If Analysis Tools
- Create Scenarios
- Merge Scenarios
- Create Scenario Summaries
- Use Data Tables
Manage and Share Workbooks
- Manage Workbook Versions
- Copy Styles within Workbooks
- Copy Macros within Workbooks
- Use Track Changes and Comments
- Merge Workbooks
- Protect Workbooks for Sharing
- Connect To External Data
Advanced 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
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
Introduction to DBMS
- What is a DBMS and its purpose?
- Types of DBMS
- Examples of DBMS – MySQL, Oracle, etc.
1 Comment.