Basic Computer course Expert level by BCIT WORLD

DCA (Diploma in Computer Application)

 Fundamental
• Introduction About Computer fundamental
• Difference between hardware and software
• Difference between input and output device
• Introduction About OS
• Introduction About Memory
• Introduction About Computer Generation
• Computer Assembling and dissembling
• Computer Windows Formatting
• Trouble Shooting

 Notepad
• Introduction About Notepad
• File
• Edit
• Menu
• All computer Shortcut Key
 M.S OFFICE
• M.S Word
• M.S EXCEL
• M.S Power Point
• M.S Access
• Typing
• HTML
• Internet

 Adv. Excel

Overview of Basic Excel

 Introduction About Excel
 How to Start excel
 All Excel Short cut key
 Home Tab
 Insert Tab
 Page Layout
 Formula Tab
 Data Tab
 Review Tab
 View Tab

Customizing Excel Ribbon

 Excel Ribbon Customizing
 Create default list
 Add Excel User Form
 Change Excel Default Option

Formatting and Number System

 Advance Conditional Formatting
 Number System
 Paste Special
 Go to Special

Formula

 Logical Formula
 Text Formula
 Date & Time Formula
 Financial Formula
 Lookup Formula
 Function Formula

Logical Formula

 If
 And
 Or
 Nested If
 If Error
 Is text
 Is Number
 Is Blank

Text Formula

 Upper
 Lower
 Proper
 Left
 Right
 Mid
 Len
 Trim
 Code
 Char
 Replace
 Substitute
 Concatenate

Date & Time Formula
 Now
 Date
 Time

 Hours
 Minute

 Second
 Year
 Month
 Day
 Eomonth
 Today
 Day 360
 Network days
 Dated if
 Week Day

Lookup Formula
 V Lookup
 V Lookup + List
 V Lookup + Search Box
 V Lookup + Match
 V Lookup+ Match + Search Box
 V Lookup+ Match + Conditional Formatting
 Offset
 H Lookup

 Match
 Index
 Rows
 Columns
 Reverse Lookup
 Transpose

Financial Formula
 PMT

 IPMT
 PPMT
 Rate
 PV
 NPER

Function Formula

 SUM

 SUM IF
 SUM IFS
 SUM PRODUCT
 SUM SQ
 COUNT
 COUNT A
 COUNT IF
 COUNT IFS
 AVERAGE
 Max
 Min
 Large
 Small
 Choose
 Rank

CHART

 Create Basic Chart
 Create 2D & 3D Chart
 Pie Chart
 Line Chart
 Column Chart
 Bar Chart
 Area Chart
 Basic Dashboard Chart

Pivot Table
 Intro Pivot Table
 Create Simple Pivot Table
 Basic & Advance Value Setting
 Project
 Power Pivot Table

Dashboard

 Intro Dashboard
 Create Simple Dashboard
 Adding Table & Chart to Dashboard
 Project work
 Create Dynamic Dashboard

Macro
 Intro Macro
 Basic Recording Macro
 Relative Macro Option
 Absolute Option
 Project work
 Basic Macro Coding

VBA
 Intro VBA
 What can you do with VBA?
 Basic VBA Coding
 Recording VBA code
 What Is Variable
 Data Type
 Massage Box
 Button
 If Else Statement
 Looping
 Macro Error
 Basic Macro Coding
 VBA formula Apply
 Create User Form
 Project Base Work

Tips & Trick

 Excel Sheet Password Break
 Excel Workbook Password Break
 Online Excel Work
 VBA Amazing Code
 Short Cut key
 Data Validation
 Number System
 Amazing tips and Trick
 Project Work

 TALLY ERP 9 with GST

Accounting

 Introduction About Accounting
 Basic term of Accounting
 Journal Entry
 Ledger Posting
 Final Report
 Trial Balance, Balance sheet, Profit & Loss, Trading Account
 Trial Balance Error
 Identify of Group
 Depreciation
 Adjustment Entry
 Debtor
 Cash & Bank Book
 Discount
 Bank Statement Entry
 BRS
 Project Work

TALLY ERP 9

 Introduction About Tally ERP 9
 Tally version
 Tally Mode
 Tally install & Startup
 Company Info
 Gate way of Tally
 Accounts Info
 Group & Ledger
 Inventory Info
 Stock item, Stock Group,Unit,Go downs
 Ledger Configuration
 Short Cut Key & Hot Key
 Voucher
 Accounting Voucher
 Purchase Voucher
 Sale Voucher
 Payment Voucher
 Contra Voucher
 Debit Note
 Credit note
 Contra Voucher
 Optional Voucher
 Memo Voucher
 Reversing Journal Voucher
 Receipt Voucher
 Journal Voucher
 Voucher Configuration
 Inventory Voucher
 Purchase Order Processing
 Sale Order Processing
 Discount Allowed
 Zero value Entry
 Additional Cost of Purchase
 Backup & Restore
 Import & Export
 Report Generate
 Adjustment Entry
 Bank Statement Entry
 Debtor Entry
 Fixed Asset on Deprecation
 Discount Allowed Entry
 BOM
 Price List
 Standard Rate
 Payroll
 Audit
 See The All type of report

GST(Goods &Service Tax)

 Introduction About GST
 Gst Registration
 Difference Between Regular & Composition Delar
 GST Party Type
 Gst Rate of Percentage
 HSN code & SAC code
 ITC
 RCM
 GST NO
 Introduction About GST Return Filing
 Live GST Return Filing
 Regular Party GST Return Filing
 Composition Party GST Return Filing
 Nil Return
 GST Payment
 Late Fee, Penalty
 New GST Return Filing
 Create GST Excel Format Data
 Live Project

TALLY ERP 9 WITH GST

 Activation of GST in Tally ERP 9
 Single GST Rate of Percentage Entry
 Multiple GST Rate of Percentage Entry
 GST Adjustment Entry
 GST Entry for Goods
 GST Entry for Service
 Round off GST Invoice
 Purchase & Sale Order Processing Under GST
 Standard Rate
 Import GST Entry in EXCEL
 GST Entry for RCM on Purchase
 GST Expenses Entry
 Tally – GST Advance Payment & Receipt
 Nil Rated Invoice Under GST
 Offline GST Return Filing
 Live Online GST Return Filing
 New GST Return Filing
 Live Tally with GST Company Level Project

PAYROLL
 Introduction About Payroll
 Activation Payroll
 Payroll Info
 Payroll Units Attendance and Production Type
 Earning Pay Heads
 Employee Deduction Pay Heads
 Employee Contribution Pay Heads
 Payroll Salary Structure
 Payroll Income Tax
 Payroll Voucher Entry
 Payroll Report

TDS with GST
 Introduction About Payroll
 TDS Registration
 TDS Activation in Tally ERP 9
 TDS Journal Entry with GST
 TDS Rate Chart
 Full TDS Accounting Work
 Income Tax Rule
 TDS on Salary Calculation
 TDS on Rent Calculation
 ITR Return Filing
 TDS Payment
 TDS Report
 Project Work

PROJECT WORK
 Company Work Accounting
 Hotel Accounting
 Institute Work Accounting
 Soap Accounting

 DTP
Adobe Photoshop CC
• Introduction About Photoshop
• Photoshop Version
• Tools hide and unhide
• How to use all Photoshop tools
• Background change
• Hair Selection
• Dress Color change
• Hair color change
• Eye and lips color change
• Skin Retouching
• Layer Masking
• Manipulations
• Shortcut key
• Design Passport Size Photo
• Design Visiting card
• Design Poster and Banner
• Design small Video in Photoshop
• Background Design
• 3D Effect
• Logo Design
• Live Project Work

Corel Draw X8 2019
• Introduction About Corel Draw
• Corel draw Version
• Tools hide and unhide
• How to use all Corel draw tools
• Background change
• Design Visiting card
• Design Poster and Banner
• Background Design
• 3D Effect
• Logo Design
• Live Project Work