Topics

CERTIFICATE COURSE IN IT AND ADVANCED EXCEL WITH DBMS (SEMESTER - I)

OFFICE AUTOMATION

• Fundamentals of computer systems, hardware, software, and input/output devices.
• Basic file and folder management, including creating, organizing, deleting, and restoring files.
• Internet and email operations, such as downloading images, creating Gmail accounts, and managing emails with attachments.
• Screenshot capture and file conversions.
• Document creation and formatting using Microsoft Word, including tables, pictures, mail merge, and printing.
• Presentation development using Microsoft PowerPoint with text, images, designs, transitions, animations, and slide shows.
• Protecting documents using password.
• Practical computer skills for day-to-day office work and personal productivity tasks.

ADVANCED EXCEL WITH VBA

• Data Entry and Worksheet Management
• Formatting Documents and Text Formatting
• Basic Formulas, Chart Creation, and Workbook Protection
• Sorting, Filtering, Conditional Formatting, and Data Validation
• IF, Nested IF, AND, OR Functions, and Text & Date Functions
• SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, and MINIFS
• VLOOKUP, XLOOKUP, INDEX & MATCH, and Database Functions
• Financial Functions, CONCATENATE, SUBSTITUTE, DATEDIF, and more
• Pivot Tables, Pivot Charts, Advanced Charts, and Dashboards
• What-If Analysis, Goal Seek, Forecasting, and Trend Analysis
• Data Import, Transformation, Cleaning, and Query Merging
• VBA Editor, Programming Basics, Variables, Data Types, Loops, and Macros
• Working with Worksheets and Ranges
• Creating User Forms and Form Controls with Validation

DBMS

• Database Creation
• Table Design
• Queries
• Forms
• Reports
• Relationships
• Database Management Using Access

CERTIFICATE COURSE IN BUSINESS INTELLIGENCE (SEMESTER - II)

POWER BI FOR DATA ANALYSIS

• Introduction to Power BI Desktop
• Power BI Desktop Installation
• Connecting Data Sources (Excel, CSV, Web, SQL)
• Data Transformation Basics
• Power Query Editor
• Filtering, Sorting, and Removing Duplicates
• Merging Queries and Appending Queries
• Column Splitting and Data Formatting
• Creating Custom Columns
• Relationships Between Tables
• Primary Keys and Foreign Keys
• Star Schema and Snowflake Schema
• Creating Data Models
• Calculated Columns and Measures
• Introduction to DAX and DAX Functions
• Time Intelligence Functions
• Building Dashboards
• Charts, Maps, Tables, and Slicers
• Conditional Formatting and Filters
• Drill Throughs
• Custom Visuals from Marketplace
• Sales Data Analysis
• Financial KPIs
• HR & Employee Data Insights
• HR Analytics Dashboard
• Sales Dashboard Creation

DATABASE MANAGEMENT USING MYSQL

• Introduction to Database
• Access and MySQL
• Data Types and Constraints
• Primary Key and Foreign Key
• Creating Tables and Modifying Tables
• Inserting Data into Tables
• Updating Records and Deleting Records
• Selecting Records Using WHERE Clause
• Comparison and Logical Operators
• Wildcard Searching Using LIKE Operator
• Aggregate Functions (SUM, AVG, MIN, MAX, COUNT)
• GROUP BY Clause and HAVING Clause
• Subqueries
• Table Joins
• INNER JOIN, OUTER JOIN, LEFT JOIN, and RIGHT JOIN
• UNION Operator
• String Functions
• SUBSTR, LEN, UPPER, LOWER, and CONCAT Functions

BUSINESS CONCEPTS

• Report Making
• Understanding MIS Fundamentals
• MIS-Manage and Analyse Business Data