INTRODUCTION TO ADVANCE EXCEL

An Excel Expert is a person who collects, organizes, and analyzes data. S/He is also involved in finding, editing and analyzing data, creating databases and writing reports with conclusions. There are various techniques of data analysis, which an excel expert must understand in order to perform efficiently. Data analysis is important as it assist humans in getting the insight of patterns related to business, customer, revenue, etc. Therefore, doing the analysis helps to produce the best results for the decision making. The conclusions made by excel expert based on data are very helpful in every organization for forecasting the business speculations.

Why take Admission?

After completing the course, one can expect a suitable position as an Accounts Assistant-cum-ERP Assistant in Finance/ Accounts section in any organization.

Academic Approach

The Academic Approach of the course focuses on the “work centric” education i.e. begin with work (and not from a book !), derive knowledge from work and apply that knowledge to make the work more wholesome, useful and delightful. The ultimate objective is to empower the Learner to engage in socially useful and productive work. It aims at leading the learner to his/her rewarding career as well as development of the society.<

Learning methodology

Learners are given an overview of the course and its connection to life and work.
Learners are then exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
Learners are then acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
Learners are then acquainted with the architecture of the tool or Tool Map so as to appreciate various parts of the tool, their functions and their inter-relations.
Learners are then exposed to simple application development methodology by using the tool at the beginner’s level
Learners then perform the differential skills related to the use of the tool to improve the given ready-made outputs.
Learners are then engaged in appreciation of real-life case studies developed by the experts.
Learners are then encouraged to proceed from appreciation to imitation of the experts.
After imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression.

Syllabus

Skills: Apply Custom Data Formats, Use Advanced Fill Options, Apply Advanced Conditional Formatting and Filtering, Use Form Controls, Apply Custom Styles and Templates, Prepare Workbooks for Internationalization, Mathematical Functions, Look up data by using functions, Apply advanced date and time functions, Functions for Manipulating Text, Merge Scenarios, Create Scenarios, Use Area, Scatter & Stock Charts, Create Custom Chart Templates, Manage Workbook Versions, Copy Macros between Workbooks, Protect Workbooks for Sharing

Outputs: Event Expenses, Exam Record, Planner, to do List, Database, Monthly Budget, Agenda, Receipt, Inventory

Syllabus Mapping: The KLiC Advanced Excel Course is mapped to MBA elective subject “MS Excel and Advanced Excel Lab”. The 94% syllabus of the “MS Excel and Advanced Excel Lab” matches with KLiC Advanced Excel. Hence course is highly recommended to MBA students

Event Expense sheet

Database

Detailed Syllabus:

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 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

Use Scenarios

Use What-If Analysis Tools
Create Scenarios
Merge Scenarios
Create Scenario Summaries
Use Data Tables
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

PivotTables
Use Pivot Charts

Manage and Share Workbooks

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

Certification:

KLiC courses are recognised 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 (Jurisdiction: Maharashtra).

Page updated

Google Sites

Report abuse

INTRODUCTION TO ADVANCE EXCEL

Why take Admission?

Academic Approach

Learning methodology

Syllabus

Event Expense sheet

Database

Detailed Syllabus:

Apply Custom Formats and Layouts

Create advanced formulas

Use Scenarios

Pivot tables & charts

Manage and Share Workbooks

Certification:

COM-TECH COMPUTER CLASS

How Do I Get Started?

click on this link

select the required course

enter your pincode as 400042

choose COM-TECH COMPUTER CLASS

FOR MORE INFORMATION CONTACT US:

977341234/9664912344/8433712344 /8779272276 /8779276868/9321472312.....