Who Should Join
- Accounting and Finance Students – To gain practical skills in managing data, preparing reports, and performing financial analysis.
- Business and Management Students – Essential for understanding data-driven decision-making, budgeting, and inventory management.
- Data Analysts and Aspiring Data Professionals – Offers foundational tools like pivot tables, formulas, and scenario analysis for handling large datasets.
- Retail Store Managers and Logistics Staff – Useful for inventory tracking, sales analysis, and reporting.
- Human Resources (HR) Professionals – Beneficial for managing employee data, attendance records, and performance analysis.
- Project Managers – Enables tracking project progress, managing resources, and scenario planning for effective project outcomes.
- Entrepreneurs and Small Business Owners – Essential for budgeting, sales analysis, and performance reporting to optimize business decisions.
What you’ll learn ?
After completion of the course, you can get a suitable position in any organization as an Accounts Assistant, Finance Analyst, Retail Store Manager and Data Analyst in any organization.
Syllabus
The syllabus covers the following skills:
- Apply custom formats and layouts
- Create advanced formulas
- Use of Scenario
- Pivot tables and charts
- Manage and share workbooks
Basic 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 and Data Entry
- Introduction to Typing
- Keyboarding
- Ergonomic Typing
Introduction to various Typing Method
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
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 Charts
- Basic Excel Charts
- Use Area, Scatter & Stock Charts
- Use Surface, Radar & Combination Charts
- Create Custom Chart Templates
- Work with Sparkline’s
Pivot Tables and Charts
- Basic Excel Charts
- Use Area, Scatter & Stock Charts
- Use Surface, Radar & Combination Charts
- Create Custom Chart Templates
- Work with Sparkline’s
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 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
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 Data Cleaning
- 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.
