Track
Service Management
Duration
30 hours
Skill Level
Beginner
Language
English
About this Course
Explore techniques for data collection, processing, and creating effective business reports.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- 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
- 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
- Details of using Macros
- Record a Macro
- Method of Using Macros
- Creating Program VBA
- Visual Basic Editor (VBA)
- Macros
- Visual Basic Editor
- Remove Formatting
- IF Statement
- For Loop Function
- Introduction
- Input Box
- DoWhile or DoUntil
- Do While
- Do Until
- Transpose Headers
- Transpose Customer Order
- Adding Loop 1
- Adding Loop 2
- Introduction of Pivot Table
- Recommended Pivot Table
- Pivot Table 1
- Pivot Table 2
- Graphs and Charts
- Understand Pivot Table
- SUMPRODUCT Function
- Steps to Compute Net Sales
- SUMIF Function
- COUNTIF Function
- COUNTIFS Function
- AVERAGEIF Function
- Data Validation
- TRUE function
- LOOKUP function
- VLOOKUP function
- HLOOKUP function
- INDEX MATCH function
- What is Goggle Analytics
- Benefits of Goggle Analytics
- How to Setup Goggle Analytics Account
- Hierarchy of the Google Analytic
- Basics of Google Analytic
- Pros and Cons of Google Analytic
- Google Analytics
- Audience report
- Bounce Rate / Audience–Active Users
- Demographics
- Behaviour Overview
- 6 benefits of using Google analytics
- History of Data
- How to Tell A Story With Data & Analytics
- Introduction to Google Data Studio
- Google Data Studio-1
- Google Ads
- Google Analytics-1
- Google Analytics-2
- YouTube Analytics-1
- YouTube Analytics-2
- Creating Tables
- Formatting and Sorting Tables
- Multiple Measures
- Conditional Formatting
- Advantages of using Tables in Google Data Studio
- Practical Activity Completed Tables
- Average value - highest and lowest value
- Completed practical activity
- Comparison calculations
- Running total calculation
- Drill down
- Working with dates
- Create Pivot Table
- Scorecard Visualization
- Practical Activity
- Slicers and Visualisation-1
- Text filter visualization
- Numeric visualization filters
- Date visualization filters
- Custom calculations
- Year month and day
- Case Statement
- Comparisons
- Into to time series graphs
- Create time series graphs1
- Create time series graphs 2
- Create time series graphs 3
- Changing time perolods
- Style and formatting
- Time series chart options
- Area graph
- Introduction to Slicers and visualization filters
- Scorecard visualizations
- Text Slicers
- Numeric slicers
- Date slicers
- Text visualisation filters
- Numeric visualisation filters
- Date visualisation filters
- Column and bar graphs
- Pie graphs
- Custom visualisation
- Analysing Data
- Practical Activity
- Google Data Studio
- Add Visits
- Using Google Data 1
- Using Google Data 2
- Using Google Data 3
- Sharing Dashboards
- Sharing Dashboards 1
- Data studio function for calculated fields
- Concat formula
- “RegExp Extract”
- “RegExp Match”
- “Case” formula
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: 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, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: 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, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
Ready to start Data Processing and Reporting?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
Other MKCL Courses
-
Accounting as information system
30 hours -
Advanced Service Operations: From…
120 hours -
BFSI
120 hours