Course

MS-OFFICE

Free Typing Training (30 to 75 WPM)

• Introduction to Computers
• Windows
• MS-Word
• Internet
• Power Point
• Outlook Express
• MS-Excel
• MS-Access 

ADVANCED EXCEL

With Al Tools & Power BI

• Introduction to Advanced Excel
• Entering data and calculation
• Working with Rows and Columns,
• Cell References
• Filling Series / Custom List
• Conditional Formatting
• Maths and Trigonometry Function
• Statistical Function / Date & Time Function
• Logical Function / IF Function
• Data Validation Function
• V/H Lookup Function / Text Function / Index & Match
• Function with Condition, Sumifs, Countifs, Averageifs
• Financial Function
• Scenario, Goal Seek & Solver
• Database Function -D Get
• Sorting, Sub Totaling, Auditing, Macro & Consolidate
• Filtering of Data / Pivot Table and Chart
• Split / Hyperlink to Database Freeze
• Tracking Workbook Charge
• Protecting / Page Setup / MIS Report

 Power BI

• Data Ingestion (Connecting to Excel/Sql),
• Transformation Using Power Query,
• Data Modeling (Relationships, Star Schema),
• DAX Calculations (Measures/Columns),
• And Visualization (Charts, Dashboards, Reports)

 

Advanced Tally

• Company Information
• Creation - Stock with
• Opening Balance
• Stock information - Manufacturing Date
• Accounting Voucher Entry
• Purchase / Purchase Order Entry
• Sales / Sales Order Entry
• Bill Wise Details for Customer / Supplier
• Voucher Class /Voucher Entry Type
• Accounting / Non-Accounting Voucher
• Activate Interest Calculation
• Allow Multi Currency
• Service Tax
• Payroll - A
• Payroll - B
• Excise Duty
• TDS Entry
• TCS Entry
• GST Entry

 

You can become an Accountant, Data Entry Operator, work as Asst. CA, Receptionist, Admin Job, In Banking sector, Accounting and Financial sector.

 

ALSO JOIN

*KLiC ADVANCED EXCEL 

*KLiC TALLY PRIME WITH GST

*KLiC ADVANCED TALLY PRO

 AND GET YCMOU UNIVERSITY MARKSHEET & MKCL CERTIFICATE.