• Admissions
    • Partner With UsContact
    MENU
    Institution OverviewMission & VisionFounder’s MessageWhy NIPSAR
    Board of GovernorsBoard of Advisors
    COIL ProgramCourses & Certificates
    AdmissionsPartner With UsContact

    Courses & Certificates Offered

    Microsoft Excel

    Microsoft Excel

    01Unit 1: Formatting and Basic Operations
    +
    • Selecting cells, rows, and columns
    • Font formatting (size, color, bold, italic)
    • Number formatting (date, currency, percentage)
    • Alignment and borders
    • Adjusting row height & column width
    • Copy, Cut, Paste
    • AutoFill
    • Page setup & printing options
    02Unit 2: Basic Formulas and Functions
    +
    • Introduction to formulas
    • Arithmetic operators (+ − × ÷)
    • Cell references (Relative & Absolute)
    • SUM
    • AVERAGE
    • COUNT
    • MAX
    • MIN
    • AutoSum feature
    03Unit 3: Logical & Lookup Functions
    +
    • IF function
    • Nested IF
    • AND, OR functions
    • VLOOKUP
    • HLOOKUP
    • Introduction to XLOOKUP
    • IFERROR function
    04Unit 4: Conditional Formatting & Data Validation
    +
    • Highlight Cell Rules
    • Top/Bottom Rules
    • Data Bars
    • Color Scales
    • Icon Sets
    • Custom rules using formulas
    • Managing rules
    • Data Validation
    • Creating drop-down lists
    • Removing duplicates
    • Basic worksheet protection
    05Unit 5: Pivot Table & Data Analysis
    +
    • Introduction to Pivot Table
    • Creating Pivot Table
    • Adding Row, Column, Value fields
    • Filtering Pivot Table
    • Grouping data
    • Refreshing Pivot Table
    • Formatting Pivot Table
    • Pivot Charts
    • Real time scenario workbook creation
    Power BI

    Power BI

    01Unit 1: Introduction to Power BI
    +
    • Introduction to Power BI
    • Uses of Power BI in business
    • Installing Power BI Desktop
    • Reports, Dashboards, Datasets
    • Importing Excel and CSV
    • Saving and publishing reports
    02Unit 2: Data Transformation (Power Query)
    +
    • Power Query Editor
    • Removing columns
    • Removing duplicates
    • Changing data types
    • Splitting and merging columns
    • Filtering and sorting
    • Adding custom columns
    • Close & Apply
    03Unit 3: Data Modeling
    +
    • Tables and relationships
    • One-to-many relationship
    • Managing relationships
    • Star Schema
    • Calculated columns
    • Measures
    • Total sales measure
    04Unit 4: Visualization & DAX
    +
    • Bar, Column, Pie, Line charts
    • Table & Matrix
    • Card visual
    • Slicer
    • Titles and labels
    • Themes
    • Conditional formatting
    • SUM, AVERAGE, COUNT, IF
    05Unit 5: Dashboard & Advanced Features
    +
    • Creating dashboards
    • Sharing reports
    • Exporting PDF
    • Drill-through
    • Drill-down
    • Bookmarks
    • Row-Level Security
    Python Programming

    Python Programming

    01Unit 1: Introduction to Python
    +
    • What is Python
    • Features and uses
    • Installing Python
    • IDLE
    • First program
    • Syntax basics
    • Comments
    • Variables
    • Integer, Float, String, Boolean
    • Type casting
    • User input
    • Operators
    02Unit 2: Control Statements
    +
    • if else
    • Nested if
    • for loop
    • while loop
    • break and continue
    • Pattern programs
    03Unit 3: Functions and Strings
    +
    • Defining functions
    • Calling functions
    • Parameters
    • Return values
    • Built-in functions
    • String operations
    • Concatenation
    • Indexing
    • Slicing
    • String methods
    04Unit 4: Lists, Tuples, Dictionaries
    +
    • Lists
    • Append remove sort
    • Tuples
    • Difference between list & tuple
    • Dictionaries
    • Add update delete
    • Programs using collections
    05Unit 5: Practical Project
    +
    • Real-time multi scenario project
    • Structured analysis
    • Collaborative decision making