01 – Excel Introduction (Preview)
02 – Basic Formulas
03 – IF Formula in Excel
04 – If and If or Formula
05 – Nested IF in Excel
01 – Nested if Calculate Discount
02 – Salary Sheet Basic Formula
03 – Salary Sheet Nested if
04 – Attendance Sheet
05 – Attendacne Sheet Countif Formula
06 – Sort, Custom Sort & Filter
07 – Conditional Formatting Basic
08 – Conditional Formatting Advance
09 – C F Higlight Alt Rows
10 – Advance Filter
01 – Advance filter Macro
02 – Auto Sort Macro
03 – Text to Columns
04 – Flash Fill in Excel
05 – Remove Duplicate and Consolidate
06 – 3D Formula
07 – Data Validation
08 – Scenario Managerl
09- Goal Seekl
10 – Data Table
01 – Home Tab 1
02 – Home Tab 2
03- Home Tab 3
04 – Home Tab 4
05 – Find and Replace
06 – Goto Special
07 – Paste Special
08 – Pivot Table Introduction
09 – Pivot Table Filter User
10 – Pivot Table Options
01 – Slicer and Timeline
02 – Pivot Chart in Excel
03 – Auto Refresh Pivot Table
04 – Table in Excel
05 – Insert Tab1
06 – Insert Tab2
07 – Excel Chart
08 – Excel Chart and Formatting
09 – Excel Sparkline Chart
10 – Hyperlink in Excel
01 – Insert Tab 3
02 – Watermark in Excel
03 – Pagelayout Tab Themes and Margins
04 – Pagelayout Tab Print Settings
05 – Pagelayout Tab 2
06 – Pagelayout Tab3
07- Formula Tab Name Manager
08 – Formula Tab Formula Auditing
09 – Data Tab Get External Data
10 – Data Tab Sub Total
01 – Data Tab Solver add ins
02 – Reveiw Tab
03 – View Tab
04 – Macro Recording
05 – Create your own Tab
06 – Vlookup 1 Intro
07 – Vlookup 2 Use of Range Lookup
08 – Vlookup 3 Double Vlookupl
09 – Vlookup 4 Nested Vlookup
10 – Vlookup 5 Vlookup Project
01 – Vlookup 6- Unique Example of Vlookup
02 – CountA and Count Blank Formula
03 – Countif Formula
04 – Countifs Formula
05 – Sumif and Sumifs
06 – Averageif and Averageifs
07 – Frequency Formula
08 – Index and Match
09 – Lookup Formula
10 – SumProduct , Left and Find formula
01 – Right and Find
02 – Mid and Find Formula
03 – Repeat and Substitute Formula
04 – PMT, PV, FV Formula
05 – IPMT AND PPMT
06 – V lookup with Match
07 – Text Formulas
08 – Date in Quarter
09 – Datedif Formula
10 – Date Formula
01 – Switch Date
02 – More Date Formulas
03 – Ranking Formula
04 – Concatenate and Vlookup
05 – Sheet Tips
06 – Excel To Powerpoint
07 – Change Excel Icon
08 – Number to Word
09 – Custom Cells Tips
10 – Picture Lookup
01 – Picture Game
02 – Data Entry form
03 – Fiel Menu
04 – Excel Settings
05 – Short formulas
06 – Database function DGET Formula of Excel
07 – DSUM Formula in Excel
08 – DAVERAGE Formula
09 – DCOUNT, DCOUNTA Formula
10 – DMAX Formula, DMIN Formula, DPRODUCT Formula
01 – Vlookup on Multiple Tables
02 – Offset Formula Introduction
03 – Offset Formula Calculate Sum of Last 6 Days
04 – Offset Formula Real Job Use
05 – Sumifs, Index, Match Real Job Use
06 – Practical use of Isblank and Istext Formula
07 – Counting Words in Excel Interview Question
08 – Build Login in Excel Formula
09 – Create Dynamic List Using Index, Match Formula
10 – Conditional Formatting with Text and Or Formula
01 – Unique Example of Conditional Formatting
02- Auto Sort data using Countif, Match and Index Formula
03 – Condition Inside Rank using CountIFS Formula
04 – Camera, Autofilter, Form 3 Hidden Features
05 – Max IF and Min IF Formula using Array
06- Choose Formula in Excel
07- Swap range in Excel
08 – Reverse Lookup Using Choose Formula
09 – Reverse Lookup using Match and Index
10 – Find & Vlookup Real Job Query
01 – Vlookup Duplicate Names Issue
02 – Vlookup with Chooze formula and array
03 – Text Join Formula in Excel 2019
04 – IFS Formula in Excel 2019
05 – MaxIFS and MinIFS in Excel 2019
06 – Filter Formula of Office 365
07 – Sort Formula of Office 365
08 – Real Job use of Aggregate Formula in Excel
01 – Xlookup in Office 365 1
02 – Xlookup in Office 365 2
03 – Xlooup Work Reverse 3
04 – Xlooup in Office 365 4
05 – Xlooup in Office 365 5
06 – Xlookup in Office 365 – 6
07 – Xlookup in Office 365 7
08 – Xlookup in Office 365
09 – Excel Xlookup in Office 365 9
10 – Excel Xlookup in Office 365 10
11 – XMATCH Formula office 365
12- Create Searchable Drop Down List In Office 365 1
01 – Analyze Data and Get IDEAS Office 365
02 – Map Chart in Office 365
03 – Dynamic Conditional Formatting
04 – EXCEL Unique Formula in Office 365
05 – EXCEL Sequence and Random Array Formula in Office 365
01 – Assignment 1 With Answer 365
02 – Assignment 2 With Answer 365
03 – Assignment 3 With Answer 365
04 – Assignment 4 With Answer 365
05 – Excel interview questions -1mp4
06 – Excel – Interview Questions
07 – Use your Brain – Interview Question
08 – Interview Question – Mode Function
09 – Interview Question – Goto and Conditional Formatting
Tally Prime Introduction: Module – 1
01 – Download and Install Tally Prime (Preview)
02 – Create Company in Tally
03 – Tally Prime Alter Company Data
04 – Tally Vault Password
05 – Tally Company Configuration
Tally Prime – Accounting | Group | Ledger : Module – 2
01 – Tally Create Users & Security
02 – View Tally Reports in Mobile / Browser
03 – What is Accounting
04 – What is Financial year
05 – Create and Alter and Delete Group
06 – Create Ledgers In Tally Prime 1
07 – Create Multiple Ledgers In Tally Prime 1
08 – Different Ledgers And Their Meanings In Tally 1
Tally Prime Voucher Part 1 : Module – 3
01 – Business First Voucher Entry In Tally 1
02 – Receipt Voucher Goods Sold On Cash 1
03 – Receipt Voucher Amount Received In Cheque Mp4
04 – Receipt Voucher Amount Received In Cash 1
05 – Contra Voucher 1
06 – Contra Voucher 2
07 – Payment Voucher 1
08 – Payment Voucher 2
09 – Purchase Voucher
10 – Sales Voucher
11 – After Puchase Sales
12 – After Sales
Tally Prime Voucher Part 2: Module – 4
01 – Adjustment Entries 1
02 – Adjustment Entries 2
03 – Purchase Return and Sales Return
04 – Assignment on Voucher Entries 1
05 – Assignment on Vouhcer Entries 2
06 – Assignment on Vouhcer Entries 3
07 – What Is Accounting Cycle 1
08 – What Is Balance Sheet 1
Tally Prime – Stock & Cost Centre: Module – 5
01 – Stock Entries 1
02 – Stock Entries 2
03 – Stock Entries 3
04 – Stock Entries 4
05 – Cost Centers Introduction 1
06 – Cost Centers Hide Details
07 – Cost Centers Example 1
08 – Cost Centers Example – 2
09 – Keyboard Shortcuts
10 – Multiple Stock Item Entries
11 – Stock Transfer Stock Journal Vouchers
12 – Physical Stock Voucher
Trading Organization Accounting in Tally Prime : Module – 6
01 – Organization Types
02 – Trading Organization Accounting
03 – Purchase Order
04 – Receipt Note Voucher
05 – Rejection Out Voucher
06 – Purchase Invoice
07 – Debit Note Purchase Return
08 – Sales Order
09 – Delivery Note
10 – Rejection In
11 – Create Sales Bill
12 – Credit Note Sales Return 1
TDS In Tally Prime : Module – 7
01 – Create Sales Bill 1
02 – Credit Note Sales Return 1
03 – TDS Introduction
04 – TDS Introduction
05 – TDS on Interest
06 – TDS Introduction
07 – TDS Entry in Tally
08 – TDS Adjustment
09 – What is TDS Certificate
10 – Before Practice on TDS Important Instruction
11 – TDS Related Questions
12 – TDS Entry as a Deductor 1
13 – TDS Entry as a Deductor 2
14 – TDS Entry as a Deductor 3
15 – TDS Entry as a Deductor 4
16 – TDS Payment
GST In Tally Prime : Module – 8
01 – GST Introduction
02 – SGST, CGST and IGST Terms
03 – GST What is HSN and SAC
04 – What is Regular Dealer and Composition
05 – Create Purchase Invoice Intrastate GST
06 – Create Purchase Invoice Interstate GST
07 – Check Stock and Purchase Register
08 – Create Sales Invoice Intrastate GST
09 – Create Sales Invoice Interstate GST
10 – Check Sales Register and Stock Summery
11 – GSTR1, GSTR2, GSTR3B
12 – What is E Way Bill
13 – Genterate JSON of E Way Bill
Manufacturing Company Accounting : Module – 9
01 – Purchase RAW Material
02 – Create BOM Bill of Material
03 – Create Manufacturing Journal
04 – Sold Finish Goods
Service Organization Accounting : Module – 10
01 – Introduction of Service Organization
02 – Introduce Capital in Service Sector
03 – Purchased Fixed Assets with GST Invoice
04 – Purchased Stationery with GST Invoice
05 – Puchased Computers GST Invoice
06 – Taken Advertisement Service
07 – Provide Service and Received Payment 1
08 – Provide Service and Received Payment 2
09 – Sales Services and Received Payment 3
10 – View Reports of Service Sectors
Tally Prime Features : Module – 11
01 – Tally Prime Features VS Tally ERP
02 – Customize Sales Invoice Number
03 – Compound Unit and Alternate Unit
04 – Backup and Restore DATA
05 – Import and Export
06 – Export data in Excel
Payroll In Tally Prime : Module – 12
01 – Payroll Introduction 1
02 – Create Employee Record 1
03 – Create Work Unit 1
04 – Create Earning Payhead 1
05 – Create Earning Payhead 2
06 – Create Deduction Payhead 1
07 – Define Salary Structure 1
08 – Create Payroll Voucher 1
Online GST Return Filing : Module – 13
1 – GST Filing – GST Registration Process
2 – GST Filing – Export Data in CSV from Tally
3 – GST Filing – Create JSON File with GST Offline tool
4 – GST Filing – Filing GSTR1 Sales on GST Portal
5 – GST Filing – Making Payment on GST Portal Filining GSTR3B
TCS In Tally Prime : Module – 14
1 – TCS – What is TCS?
2 – TCS – Practical Entry in Tally Prime
3 – TCS – Payment Entry’s
BRS In Tally Prime : Module – 15
1 – BRS In Tally Complete Video
Practice Assignment : Module – 16
Photoshop : Module – 1
01 – Photoshop Introduction (Preview)
02 – Eyes Effect – Elliptical Marquee Tool
03 – Change Lips Color Using Polygonal Lasso tool
04 – Mirror Effect – use of Transform Tool
05 – Selection Tools and Feather Effects
06 – Use Lasso Selection Tools
07 – Fit Image into Object using Transform
Photoshop : Module – 2
01 – Create Passport Size Photos
02 – Use of Quick Selection and Magic Wand tool
03 – Use of Pen Tool – Blur Image Background
04 – Change Image Background
05 – Use of Shapes
06 – Apply Effects on Shapes
07 – Text Fire Effects
08 – Text Tools and Options
09 – Download Design Fonts & Hindi Typing
10 – Text Effects
Photoshop : Module – 3
01 – Create PNG Image
02 – Create Pattern
03 – Clone Stamp Tool
04 – Remove Black spot from Face
05 – Create GIF Image
06 – Create Animated Advertise
07 – Layer Panel Options
08 – Advance Crop
09 – Create advertising Template
10 – Healing Brush Tool Content Aware Tool
Photoshop : Module – 4
01 – Brush Tools
02 – Pattern Stamp Tool
03 – Art History Brush tool
04 – Eraser Tools
05 – Gradient Tool
06 – Blur Tool, Smudge Tool
07 – Dodge, Burn, Sponge Tool
08 – Pen Tools in Details
09 – Create Your Custom Shape
10 – Create Layer Mask
Photoshop : Module – 5
Hardware : Module – 1
01 – Hardware – Computer Introduction (Preview)
02 – Input Devices
03 – 3 Connection With CPU
04 – Open Cabinet
05 – Remove Connection In Cabinet
Hardware : Module – 2
01 – Open Motherboard
02 – Remove CPU Fan
03 – Remove CPU
04 – Remove Ram
05 – Remove CPU Fan
06 – Assemble Front Panel
07 – Assemble Power connector
08 – Assemble Motherboard
09 – Assemble HardDisk Setup
10 – Assemble Complete CPU
11 – Open Harddisk Drive
12 – Troubleshoot SMPS
13 – Check SMPS Power with multimeter
14 – SMPS Internal Structure
15 – Insert and Remove Graphic Card
Hardware : Module – 3
01 – Motherboard All Parts in Dept
02 – North Bridge and South Bridge
03 – DVD Writer Attach and Detach
04 – Hardware Make Bootable Pendrive
05 – Install Windows 7
06 – Driver Installation
07 – Installing Windows 10
08 – Software Installation
09 – Create Multiple User Account
10 – Hardware – Create Partition
Hardware : Module – 4
Filmora : Module – 1
1 – Install Software & Record PC Screen (Preview)
2 – Trim or Split video
3 – Audio Settings
4 – Audio Settings
5 – Video Settings
Filmora : Module – 2
01 – Video Settings – 2
02 – Add and Animate Text
03 – Learn to Add Transitions
04 – Adding Effects
05 – Add Elements
06- Split Screen Effect
07 – Adding Logo in Video
08 – Keyframe Animation
09 – Pan and Zoom
10 – Create Your Green screen
Filmora : Module – 3
01 – Highlight Points
02 – Advance options
03 – Voice Over
04 – Filmora Essential Settings
05 – Export Video
OpenShot : Module – 4
CorelDRAW : Module – 1
01 – Introduction (Preview)
02 – Practical use of Knife Tool
03 – Practical Use of Shape Tool
04 – Practical use of Power clip
05 – Practical use of Envelope Tool and More
CorelDRAW : Module – 2
01 – Practical use of Eraser Tool
02 – Practical use of Star Shape
03 – Practical use of Weld option
04 – Practical use of Round corners option
05 – Use of Blend tool in Logo
06 – Import Image in Corel and Create Flim Strip
07 – Add Perspective Effect on Text
08 – Rotate Object and Create design
09 – Use of All Pick Tools and Shape tools
10 – Use of Eraser, Knife, Crop Tools
11 – Use of Pen Tool and Other Line Tools
CorelDRAW : Module – 3
01 – Use of Artistic Media Brush Tools
02 – Use of Rectangle and Ellipse tools with Weld Options
03 – Use of – Polygon, Star, Spiral, Graph Tools
04 – Use of Text tool and Hindi typing, Free Font Installation
05 – Draw Table, Use of Dimensions Tool
06 – Drop Shadow and Contour Tool
07- Use of Blend, Envelope, Extrude Tool
08 – Use of Transparency, Interactive Fill, Smart fill tool
09 – Create Alphabet Logo
10 – Create Professional Business Card
11 – Modern Business card
CorelDRAW : Module – 4
Google Sheets : Module – 1
01 – Introduction (Preview)
02 – Use of Functions
03 – Inserting and Deleting Sheets, Navigating Sheets
04 – Paint Format, Currency Format, % Age Formula
05 – Enable Keyboard Shortcuts, Format Sheet
Google Sheets : Module – 2
01 – Hyperlink and Insert Comment
02 – Share sheets with multiple people and word together
03 – Insert Chart & Format Chart -1
04 – Insert Chart & Format Chart – 2
05 – Sort and Filter Options
06 – Save Filter, Create Filter
07 – Filter formula
08 – File Menu – Save Version History, Open Excel file
09 – File Menu – Publish file to web
10 – Printing Tips
11 – Edit Menu – Paste Special
Google Sheets : Module – 3
01 – Edit Menu – Find and Replace
02 – View Menu – Freeze Panes
03 – Insert Menu – 1 – Image, Rows, Columns
04 – Insert Menu – 2 – Google Forms Link to Google Sheets
05 – Insert Menu – 3 – Check Boxes – Create To do List
06 – Format Tab – Conditional formatting, Number formatting
07 – Data Menu – Use of Slicers
08 – Data Menu – Data Validation
09 – Pivot Table – Create Summarize Reports
10 – Add Named Ranges and Apply Formula
11 – Google Protect Worksheet and Range
Google Sheets : Module – 4
01 – Split Text to Columns, Remove Duplicates
02 – Macro Recordings
03 – Accessibility Options
04 – Mail Merge – Send Bulk Emails
05 – IFS formula use
06 – Text Join and Concatenate formula
07 – Google Translate formula
08 – VLOOKUP and HLOOKUP in Google Sheet
09 – Countif, Countifs, Sumif, Sumifs
10 – Sumif, Sumifs Formula in Google sheet
11 – CountUniqueIFS new formula
Google Sheets : Module – 5
01 – Sparklines Formula Bar Column line Chart
02 – All IsFormula – Isemail, IsNumber, Istext
03 – Create QR Code using Formula
04 – All useful Text Formulas
05 – All useful Number Formulas
06 – Get Unique Record
07 – Use of Query Formula – Remove Blanks
08 – Import Data from Web
09 – Merge Sheets Data
10 – Merge Workbooks
11 – Remove Blank rows tricks
Google Sheets : Module – 6
MS-Word : Module – 1
01- Introduction of Word (Preview)
02 – Home Tab : Font Group
03 – Home Tab : Advance Font, Clipboard Group
04 – Word Paragraph group
MS-Word : Module – 2
01 – Create Page cover in Word
02 – Create and Design Table
03 – Insert and Format Picture
04 – Draw Shape, Insert Chart & Smart art
05 – Header and Footer in Word
06 – Insert Symbol and Object
07 – Design Tab in Word
08 – Page layout Tab in Word
09 – References Tab in Word
10 – Mailings Tab in Word
11 – Review Tab in Word
MS-Word : Module – 3
VBA : Module – 1
01 – Introduction (Preview)
02 – What is Variable and Data Type
03 -Sheets and Cell Selection
04 -Dynamic Copy Code of VBA
05 – Offset Command
VBA Basic and IF Condition : Module – 2
01 -Project on Copy paste
02 -Inputbox and Messagebox
03 – Variable Types
04 – Option Explicit
05 – IF Condition
06 – IF Condition with And
07 – IF Condition with OR
08 – NestedIF Condition
09 – Project on IF
Loops in VBA : Module – 3
01 – VBA For Next Loop
02 – For Loop Decrement Method
03- Do While Loop
04 – Do Until Loop
Project With Using Loops : Module – 4
01 – For Loop Project Remove Blank Rows
02 – For Loop Project Add Alternate Blank rows
03 -For Loop Project Insert Number of rows and Columns
04 -Error Handler
05 – Do While Loop with Nested if Project
06 – For Loop with Nested if Project
07 – Merge Sheets using For Loop
08 – Create Index Using for Loop
Message Box and Input Box In VBA : Module – 5
01 – Type of MsgBox
02 – Use of Yes, No Type MsgBox
03 – Select Range Using Input box
Project On Sheets : Module – 6
01 – For Each Loop
02 – Method of Adding worksheets
03 – Insert N Number of Sheets
04 – Method of Deleting Sheets
05- Using For Loop Delete Multiple Sheets
Object And Class : Module – 7
01 – What is Object and Class
Collection Loops : Module – 8
01 – Collection of Loop
02 – Delete Blank Sheets For Each Loop
03 – Collection Loop For Each Cell
04 – Collection Loop Interview Question
Workbook Command And its Projects : Module – 9
01- Workbook Commands
02 -Workbook Protection Command
03 – List of Worksheets from workbook
04 – Open All Workbook From Specific Folder
05 – Find Workbook
06 – Deleting Unwanted Workbook
07 – Protect All Sheets Using Loop
08- Protect UnProtect Set Custom Password
09 – Collection Loop For Workbook
Nested Loop : Module – 10
01 – Nested Loop
02 – Nested Loop Assignment
Array In VBA : Module – 11
01 – Array Introduction
02 – Array in Loop
03 – List of Arrays
04 – List of Arrays
05- Compairing 3 List using Arrays
06 – Start Point of Arrays
07 – Dynamic Array
08 – Array Project Rename Sheets
09 -Project Find and Delete Using Array
10 – Lbound and UBound in Array
11 – Array from Range
12 – Two Dimensional Array
13 – Dynamic Two Dimensional Array
14- Project on Array with Vlookup Function
Function In VBA : Module – 12
01 – Text Functions in VBA
02 – Find and Left Practical Use
03 – Find with Right and Mid Practical Use
04 – INSTR and Replace Function
05 – String comparison
06 – Change Case Functions
07 – IsNumeric Function Practical use
08 – SUMIF Function
09 – SUMIFS Function
10 – COUNTIF and COUNTIFS Function
11 – Vlookup Function
12 – Match Function
13 – Autorun Vlookup Event
14 – Date Functions
15 – DateDiff and DatePart Function
16 – Project on DateDiff Function
17 – All Date and Time Functions
18 – CASE Function
User Defined Function In VBA : Module – 13
01 – Introduction of UDF
02 – Create GetText Function
03 – Create Get Numbers Function
04 – Project on Separate Names
05 – M Vlookup for Multiple Values
06 – Combine Function Extract Text and Numbers
07 – Reverse Lookup
08 – Reverse Lookup Using Index Code
User Form In VBA : Module – 14
01 – Userform Introduction
02 – Userform Label and Text Box Properties
03 – Userform use of Command Button
04 – Submit Data to Excel using userform
05 – Userform Events and Text Box Events
06 – Userform Use of ComboBox
07 – Userform Listbox
08 – Userform CheckBox
09 – Userform use of Option Button
10 – Adding Image in Userform-1
11 – Adding Image in Userform – 2
12 – Adding Image in Userform-3
Excel To Outlook : Module – 15
1 – Outlook – Configure with gmail
2 – Outlook – Sending Email through Outlook
3 – Outlook Email with Attachment
4 – Outlook Send Bulk Email
5 – Outlook Send Bulk Email with attachments
Web Scrapping In VBA : Module – 16
01 – Web Scraping Introduction
02 – Web Scraping Loop until Ready state
03 – Web Scraping Get data from Website
04 – Web Scraping Get data from Website 2
05 – Web Scraping Get All Links
06 – Web Scraping Get Exact Data from Website
VBA Events : Module – 17
01 – Change Events
02 – Events Autofilter Using Macro
03 – Basic Events
Project In VBA : Module – 18
01 – Create Add-ins – Add picture in Comment Box
02 – Projects – Get Grace Marks Amazing Project
03 – Projects – Get Links of All Excel Files From any Folder
04 – Project – to Count Cells of Conditional Formatting (New Video)
VBA Assignment With Video Answer : Module – 19
01 – Assignment – For Loop and if assignment
02 – OMR Sheets Assignment
03 – Interview Question UDF of Reverse Text
04 – Project Lock Data once you type
VBA Interview Questions : Module – 20
MS-Access : Module – 1
01 – Introduction of MS Access (Preview)
02 – Creating Table in MS Access
03 – Delete & Add Columns in Access
04 – Create Lookup Wizard from List
05 – Break Lookup Relationship
MS-Access : Module – 2
01 – Calculation in Access
02 – IF Formula in Access
03 – IF AND, IF OR in Access
04 – Import Tables from Excel, Notepad in Access
05 – Filter and Sort in Access
06 – Advance Filter in Access
07 – Records Group in Access
08 – Find and Replace in Access
09 – Create Query using Query Wizard
10 – Design Query on Existing Query
MS-Access : Module -3
01 – Create Parameter Query
02 – Query with Relationship
03 – Query with Calculated Field
04 – Pivot Table in Access – Cross Tab Query
05 – Find Duplicate Query
06 – Unmatched Query
07 – Export Access data
08 – Hide Table and Query from Navigation
09 – Add Totals in Query
10 – SQL View of Query
MS-Access : Module – 4
Excel MIS & Dashboard : Module – 1
01 – Pivot Table Introduction (Preview)
02 – Pivot Table and Pivot Chart
03 – Design Tab of Pivot Chart
04 – Slicer in Pivot Table & Slicer Settings
05 – Time Line in Pivot Table
06 – Get Pivot Data in Excel
Excel MIS & Dashboard : Module – 2
01 – Pareto Chart in Excel
02 – Info Graphic Chart in Excel
03 – Trend Chart using SumIFS Formula
04 – Map Chart using XY Scatter Chart
05 – Key Performance Indicator in Excel
06 – Chart with Hyperlink
07 – Chart with Conditional Formatting
08 – Create Bar Charts with Pictures MIS Series
09 – Speedometer Chart in Excel
10 – See Saw Comparison Chart
11 – Hyperlink with Column and Pie-Chart
12 – Male, Female Comparison Chart
Excel MIS & Dashboard : Module – 3
Computer Fundamental : Module – 1
1 – Computer Parts Introduction (Preview)
2 – CPU Hardware Parts
3 – Desktop Icon Settings
4 – Keyboard and Mouse Information
5 – Software Installation
6 – Change Computer Password
MS-Word For Beginners : Module – 2
1- MS-Word Introduction
2 – Text Formatting in Word
3 – Clipboard Group in Word
4 – Paragraph Group in Word
5 – Insert Table and Picture in Word
6 – Page Color and Borders in Word
7 – Page Printing Settings in Word
8 – Check Spelling Mistakes in Word
9 – Mail Merge in Word
10 – Password Protection in Word
MS-Excel For Beginners : Module – 3
1- Excel Introduction & Basic Formulas
2 – Excel Formatting
3 – Excel Sort And Filter
4 – Excel Chart And Table
5 – Excel Pivot Table
6 – Excel VLOOKUP And Hookup
7 – Excel Creating Macros
8 – Excel Hyperlink
9 – Excel Printing Format
10 – Excel Number Highlight
PowerPoint For Beginners : Module – 4
1- PowerPoint For Beginners
2- Creating slides In PowerPoint
3- Sending Email
4- Transition In PowerPoint
5- Animation Effect In PowerPoint
6- Photo Album In PowerPoint
Internet And Email : Module – 5
Create YouTube Channel, Logo, Thumbnail on Desktop : Module – 1
1 – How to Create YouTube Channel? (preview)
2 – YouTube Guide – Create Logo
3 – YouTube Guide – Create Channel Banner
4 – YouTube Guide – Create Video Thumbnail
5 – YTG – How to Record Computer Screen With free Software
6 – Highlight Mouse Pointer on Screen
How To Shoot Video : Module – 2
1 – Mobile And Camera Stands For Video Shootings
2 – Mic For Recording Audio
3 – Lighting Setup IDEA
How to Edit Video on Filmora Editor : Module – 3
1 – Video Editing – Install Software & Record PC Screen
2 – Video Editing – Trim or Split video
3 – Video Editing – Audio Settings 1
4 – Video Editing – Audio Settings – 2
5 – Video Editing – Video Settings – 1
6 – Video Editing – Video Settings – 2
7 – Video Editing – Add and Animate Text
8 – Video Editing – Learn to Add Transitions
9 – Video Editing – Adding Effects
10 – Video Editing – Add Elements
11 – Video Editing – Split Screen Effect
12 – Video Editing – Adding Logo in Video
13 – Video Editing – Keyframe Animation
14 – Video Editing – Pan and Zoom
15 – Video Editing – Create Your Green screen
16 – Video Editing – Highlight Points
17 – Video Editing – Advance options
18 – Video Editing – Voice Over
19 – Video Editing – Filmora Essential Settings
20 – Video Editing – Export Video
How to Edit Videos (OpenShot Free Software) : Module – 4
1 – Download and Install Free Software Open shot
2 – Trim Video and SNC Audio
3 – Add Audio in Background
4 – Add and Animate Image in Video
5 – Add Lower Third text in Video
6 – Add Animated Title in Video
7 – Add Green Screen Video
8 – Crop and Zoom and Export Video
How to Upload Videos on YouTube : Module – 5
1 – YTG – Upload Videos on YouTube With SEO Friendly title
2 YTG Get SEO Friendly Tags for Videos
3 – YTG – Complete Setting Related to Video Uploading
4 – YTG – Other YT Studio Settings
5 – YTG – YT Studio Settings
6 – How to create shorts Video
7 – How to edit shorts / How to create Two channels on single E- mail
Create YouTube Channel, Logo, Thumbnail on Mobile : Module – 6
1 – Mobile – Create Youtube Channel On Mobile-1
2 – Mobile – Create Logo For Youtube Channel
3 – Mobile – Create YouTube Thumbnail On Mobile
4 – Mobile – How To Create Channel Arts
5- Mobile – How To Upload Video On YouTube
6 – Mobile – Use Of YouTube Studio Application
7 – Mobile – How to Record Mobile Screen
8 – Mobile – Download Free Content For YouTube
Edit Video on Mobile : Module – 7
1 – Video Editing on Mobile – Kine Master
2 – Video Editing on Mobile – Kine Master
3 – Video Editing on Mobile – Kine Master
4 – Video Editing on Mobile – Kine Master
5 – Video Editing on Mobile – Kine Master
6 – Video Editing on Mobile – Kine Master
7- Kinemaster – Use Green Screen – Create Your Green Screen
8- Kinemaster – Blending Modes And Export Video
YouTube Policies and Settings : Module – 8
1- Details about Copyright Strike and Copyright Claim
2 – What is RPM and CPM?
3 – How to Appeal Community Guideline Strike
YouTube Guide Course Final Exam Trial Paper
Power Query : Module – 1
01 – Introduction and Installation (Preview)
02 – Create Connections with Excel Table
03 – Create Connections with Text file and Access Database
04 – Reconnect Data in Power Query
05 – Create Pivot table on Text file data
Power Query : Module – 2
01 – Merge Multiple sheets using M Language
02 – Create Pivot table on Multiple Sheets
03 – Close and Load to Explain Home tab Query Group
04 – Home Tab – Manage Column and Rows Group
05 – Home Tab – Split Column into rows and columns
06 – Power Query – Home Tab – Group by using Basic and Advance Option
07 – Home Tab – Data type & Replace Values
08 – Transform data Dynamically
09 – Combine 1000+Tables with 1 Function
10 – Alter options of VLOOKUP inside Power query
11 – Multiple columns lookup
Power Query : Module – 3
HTML : Module – 1
01 – HTML Introduction (Preview)
02 – Write first Program in HTML
03 – Heading Tag in HTML
04 – Indent and Comment
05 – Element and Attribute
HTML : Module – 2
01 – Formatting Tag
02 – Paragraph and Premarmatted Tag
03 – Font Tag
04 – Quatotation and Citation
05 – External Hyperlink
06 – Internal Hyperlink
07 – Image Tag
08 – Hyperlink on Images
09 – List Tag in HTML
10 – Nested List Tag
HTML : Module – 3
01 – Marquee Tag
02 – Marquee on Image
03 – Colour Code
04 – Table Tag 1
05 – Table Tag 2
06 – Video and Audio Tag
07 – Google Map, YouTube Video Tag
08 – iFrame Tag
09 – Add PDF Code
10 – DIV and Span Tag
HTML : Module – 4
01 – Use of Code Editor
02 – Entities, Symbol and Emojis
03 – Semantic and Non Semantic
04 – Responsive
05 – Learn Image Map In HTML
06 – Form In HTML
07 – Forms – 2
08 – Radio Button – Checkbox
09 – Create Data list in Forms
10 – Output Elements in Forms
HTML : Module – 5
MS – Outlook : Module – 1
01 – Introduciton Configure (Preview)
02 – Email 1
03 – Email 2
04 – Create Appoinment
05 – Set Meeting
MS – Outlook : Module – 2
Illustrator : Module – 1
01 – Illustrator Introduction (Preview)
02 – Direction Selection Tool
03 – Group Selection, Magic Wand, Align and Group
04 – Use of Pen Tool
05 – Trace Object Using Pen Tool
06 – Use of Transform Option
illustrator : Module – 2
01 – Text Tools
02 – Line, Arc, Sipral Tools
03 – Create Flower Pot
04 – Stroke Panel
05 – Shaper Tool, Smooth Tool
06 – Eraser, Knife Tool
07 – Create Object Using Tools
illustrator : Module – 3
01- Draw Shapes
02 – Create Clock Using Rotate Tool
03 – Scale, Shear, Reshape
04 – Width Tool
05 – WARP Tool
06 – Twirl tool
07 – Puppet Warp Tool
08 – Shape Builder Tool
09 – Live Paint Bucket Tool – 1
illustrator : Module – 4
01 – Image Tracing
02 – Perspective Effect
03 – Perspective Effect On Text
04 – Mesh Fill Tool
05 – Create Live Mirror Drawing 1
06 – Blend Tool 1
07 – Symbol Tool 1
08 – Custom Symbol 1
05:01 Min
09 – Graph Tool 1
10 – Artboard Tools 1
11 – Slice Tool 1
12 – Create Custom Brushes 1
illustrator : Module – 5
MS-PowerPoint : Module – 1
01 – Introduction of PowerPoint (Preview)
02 – Creating Slides in PowerPoint
03 – Design Tab in PowerPoint
04 – Transitions Tab in PowerPoint
05 – Loop Slide in PowerPoint
MS -PowerPoint : Module – 2
MS-Publisher
01 – Introduction (Preview)
02 – Insert Text Box
03 -Insert Picture
04 – Insert Catalog Pages and Table
05 – Insert Calendar and Page Parts
06 – Create Advertisements
07 – Insert file from word
08 – Header and Footer
09 – Page Design Tab
10 – Mail Merge
Module 1 – Introduction
1 – What is Google Data Studio and Understanding of Data (Preview)
2 – Import data in Goolge Data Studio
3 – Google Data Studio Overview
Module 2 – All About Tables
1 – Insert Table, Learning About Dimensions and Metrics
2 – Sorting Table Data
3 – Date Range and Date Period Comparison
4 – Drill Down and Drill Up in Table
5 – Optional Metric and Metric Slider
6 – Conditional Formatting in Table
7 – All about Table Style
8 – Add Filter in Table
Module 3 – Calculations
01 – All about Aggregation
02 – Comparison Calculation
03 – Running Calculation
Module 4 – All About Pivot Table
1 – Adding and Setup of Pivot Table
2 – Style Option Pivot Table
Module 5 – All About Scorecard
01 – Add, Setup and style of Scorecard
Module 6 – All About Controls
1 – Drop down and Fixed size controls
2 – Input box, Advance Filter and Slider
3 – Date Range Controls
Module 7 – Custom Field
1 – Create Total Sales Field
2 – Create Profit Margin Field
3 – Add Custom Date field
Module 8 – Calculated Filed Using Formulas
1 – Upper Formula, Concat Formula
2 – Regex Match Formula
3 – Case Formula
Module 9 – All About Charts
1 – Creating Time Series Chart
2 – Style options of Time Series Chart
3 – Bar Chart or Column Chart
4 – Pie Chart and Donut Chart
5 – Combo, Area, Scatter, Bullet Treemap
Module 10 – Complete Dashboard
01 – Dashboard – Part -1
02 – Dashboard – Part -2
03 – Dashboard – Part -3
Module 11 – Blending data and Sharing Reports
01 – Excel Introduction (Preview)
02 – Basic Formulas
03 – IF Formula in Excel
04 – If and If or Formula
05 – Nested IF in Excel
01 – Nested if Calculate Discount
02 – Salary Sheet Basic Formula
03 – Salary Sheet Nested if
04 – Attendance Sheet
05 – Attendacne Sheet Countif Formula
06 – Sort, Custom Sort & Filter
07 – Conditional Formatting Basic
08 – Conditional Formatting Advance
09 – C F Higlight Alt Rows
10 – Advance Filter
01 – Advance filter Macro
02 – Auto Sort Macro
03 – Text to Columns
04 – Flash Fill in Excel
05 – Remove Duplicate and Consolidate
06 – 3D Formula
07 – Data Validation
08 – Scenario Managerl
09- Goal Seekl
10 – Data Table
01 – Home Tab 1
02 – Home Tab 2
03- Home Tab 3
04 – Home Tab 4
05 – Find and Replace
06 – Goto Special
07 – Paste Special
08 – Pivot Table Introduction
09 – Pivot Table Filter User
10 – Pivot Table Options
01 – Slicer and Timeline
02 – Pivot Chart in Excel
03 – Auto Refresh Pivot Table
04 – Table in Excel
05 – Insert Tab1
06 – Insert Tab2
07 – Excel Chart
08 – Excel Chart and Formatting
09 – Excel Sparkline Chart
10 – Hyperlink in Excel
01 – Insert Tab 3
02 – Watermark in Excel
03 – Pagelayout Tab Themes and Margins
04 – Pagelayout Tab Print Settings
05 – Pagelayout Tab 2
06 – Pagelayout Tab3
07- Formula Tab Name Manager
08 – Formula Tab Formula Auditing
09 – Data Tab Get External Data
10 – Data Tab Sub Total
01 – Data Tab Solver add ins
02 – Reveiw Tab
03 – View Tab
04 – Macro Recording
05 – Create your own Tab
06 – Vlookup 1 Intro
07 – Vlookup 2 Use of Range Lookup
08 – Vlookup 3 Double Vlookupl
09 – Vlookup 4 Nested Vlookup
10 – Vlookup 5 Vlookup Project
01 – Vlookup 6- Unique Example of Vlookup
02 – CountA and Count Blank Formula
03 – Countif Formula
04 – Countifs Formula
05 – Sumif and Sumifs
06 – Averageif and Averageifs
07 – Frequency Formula
08 – Index and Match
09 – Lookup Formula
10 – SumProduct , Left and Find formula
01 – Right and Find
02 – Mid and Find Formula
03 – Repeat and Substitute Formula
04 – PMT, PV, FV Formula
05 – IPMT AND PPMT
06 – V lookup with Match
07 – Text Formulas
08 – Date in Quarter
09 – Datedif Formula
10 – Date Formula
01 – Switch Date
02 – More Date Formulas
03 – Ranking Formula
04 – Concatenate and Vlookup
05 – Sheet Tips
06 – Excel To Powerpoint
07 – Change Excel Icon
08 – Number to Word
09 – Custom Cells Tips
10 – Picture Lookup
01 – Picture Game
02 – Data Entry form
03 – Fiel Menu
04 – Excel Settings
05 – Short formulas
06 – Database function DGET Formula of Excel
07 – DSUM Formula in Excel
08 – DAVERAGE Formula
09 – DCOUNT, DCOUNTA Formula
10 – DMAX Formula, DMIN Formula, DPRODUCT Formula
01 – Vlookup on Multiple Tables
02 – Offset Formula Introduction
03 – Offset Formula Calculate Sum of Last 6 Days
04 – Offset Formula Real Job Use
05 – Sumifs, Index, Match Real Job Use
06 – Practical use of Isblank and Istext Formula
07 – Counting Words in Excel Interview Question
08 – Build Login in Excel Formula
09 – Create Dynamic List Using Index, Match Formula
10 – Conditional Formatting with Text and Or Formula
01 – Unique Example of Conditional Formatting
02- Auto Sort data using Countif, Match and Index Formula
03 – Condition Inside Rank using CountIFS Formula
04 – Camera, Autofilter, Form 3 Hidden Features
05 – Max IF and Min IF Formula using Array
06- Choose Formula in Excel
07- Swap range in Excel
08 – Reverse Lookup Using Choose Formula
09 – Reverse Lookup using Match and Index
10 – Find & Vlookup Real Job Query
01 – Vlookup Duplicate Names Issue
02 – Vlookup with Chooze formula and array
03 – Text Join Formula in Excel 2019
04 – IFS Formula in Excel 2019
05 – MaxIFS and MinIFS in Excel 2019
06 – Filter Formula of Office 365
07 – Sort Formula of Office 365
08 – Real Job use of Aggregate Formula in Excel
01 – Xlookup in Office 365 1
02 – Xlookup in Office 365 2
03 – Xlooup Work Reverse 3
04 – Xlooup in Office 365 4
05 – Xlooup in Office 365 5
06 – Xlookup in Office 365 – 6
07 – Xlookup in Office 365 7
08 – Xlookup in Office 365
09 – Excel Xlookup in Office 365 9
10 – Excel Xlookup in Office 365 10
11 – XMATCH Formula office 365
12- Create Searchable Drop Down List In Office 365 1
01 – Analyze Data and Get IDEAS Office 365
02 – Map Chart in Office 365
03 – Dynamic Conditional Formatting
04 – EXCEL Unique Formula in Office 365
05 – EXCEL Sequence and Random Array Formula in Office 365
01 – Assignment 1 With Answer 365
02 – Assignment 2 With Answer 365
03 – Assignment 3 With Answer 365
04 – Assignment 4 With Answer 365
05 – Excel interview questions -1mp4
06 – Excel – Interview Questions
07 – Use your Brain – Interview Question
08 – Interview Question – Mode Function
09 – Interview Question – Goto and Conditional Formatting
Tally Prime Introduction: Module – 1
01 – Download and Install Tally Prime (Preview)
02 – Create Company in Tally
03 – Tally Prime Alter Company Data
04 – Tally Vault Password
05 – Tally Company Configuration
Tally Prime – Accounting | Group | Ledger : Module – 2
01 – Tally Create Users & Security
02 – View Tally Reports in Mobile / Browser
03 – What is Accounting
04 – What is Financial year
05 – Create and Alter and Delete Group
06 – Create Ledgers In Tally Prime 1
07 – Create Multiple Ledgers In Tally Prime 1
08 – Different Ledgers And Their Meanings In Tally 1
Tally Prime Voucher Part 1 : Module – 3
01 – Business First Voucher Entry In Tally 1
02 – Receipt Voucher Goods Sold On Cash 1
03 – Receipt Voucher Amount Received In Cheque Mp4
04 – Receipt Voucher Amount Received In Cash 1
05 – Contra Voucher 1
06 – Contra Voucher 2
07 – Payment Voucher 1
08 – Payment Voucher 2
09 – Purchase Voucher
10 – Sales Voucher
11 – After Puchase Sales
12 – After Sales
Tally Prime Voucher Part 2: Module – 4
01 – Adjustment Entries 1
02 – Adjustment Entries 2
03 – Purchase Return and Sales Return
04 – Assignment on Voucher Entries 1
05 – Assignment on Vouhcer Entries 2
06 – Assignment on Vouhcer Entries 3
07 – What Is Accounting Cycle 1
08 – What Is Balance Sheet 1
Tally Prime – Stock & Cost Centre: Module – 5
01 – Stock Entries 1
02 – Stock Entries 2
03 – Stock Entries 3
04 – Stock Entries 4
05 – Cost Centers Introduction 1
06 – Cost Centers Hide Details
07 – Cost Centers Example 1
08 – Cost Centers Example – 2
09 – Keyboard Shortcuts
10 – Multiple Stock Item Entries
11 – Stock Transfer Stock Journal Vouchers
12 – Physical Stock Voucher
Trading Organization Accounting in Tally Prime : Module – 6
01 – Organization Types
02 – Trading Organization Accounting
03 – Purchase Order
04 – Receipt Note Voucher
05 – Rejection Out Voucher
06 – Purchase Invoice
07 – Debit Note Purchase Return
08 – Sales Order
09 – Delivery Note
10 – Rejection In
11 – Create Sales Bill
12 – Credit Note Sales Return 1
TDS In Tally Prime : Module – 7
01 – Create Sales Bill 1
02 – Credit Note Sales Return 1
03 – TDS Introduction
04 – TDS Introduction
05 – TDS on Interest
06 – TDS Introduction
07 – TDS Entry in Tally
08 – TDS Adjustment
09 – What is TDS Certificate
10 – Before Practice on TDS Important Instruction
11 – TDS Related Questions
12 – TDS Entry as a Deductor 1
13 – TDS Entry as a Deductor 2
14 – TDS Entry as a Deductor 3
15 – TDS Entry as a Deductor 4
16 – TDS Payment
GST In Tally Prime : Module – 8
01 – GST Introduction
02 – SGST, CGST and IGST Terms
03 – GST What is HSN and SAC
04 – What is Regular Dealer and Composition
05 – Create Purchase Invoice Intrastate GST
06 – Create Purchase Invoice Interstate GST
07 – Check Stock and Purchase Register
08 – Create Sales Invoice Intrastate GST
09 – Create Sales Invoice Interstate GST
10 – Check Sales Register and Stock Summery
11 – GSTR1, GSTR2, GSTR3B
12 – What is E Way Bill
13 – Genterate JSON of E Way Bill
Manufacturing Company Accounting : Module – 9
01 – Purchase RAW Material
02 – Create BOM Bill of Material
03 – Create Manufacturing Journal
04 – Sold Finish Goods
Service Organization Accounting : Module – 10
01 – Introduction of Service Organization
02 – Introduce Capital in Service Sector
03 – Purchased Fixed Assets with GST Invoice
04 – Purchased Stationery with GST Invoice
05 – Puchased Computers GST Invoice
06 – Taken Advertisement Service
07 – Provide Service and Received Payment 1
08 – Provide Service and Received Payment 2
09 – Sales Services and Received Payment 3
10 – View Reports of Service Sectors
Tally Prime Features : Module – 11
01 – Tally Prime Features VS Tally ERP
02 – Customize Sales Invoice Number
03 – Compound Unit and Alternate Unit
04 – Backup and Restore DATA
05 – Import and Export
06 – Export data in Excel
Payroll In Tally Prime : Module – 12
01 – Payroll Introduction 1
02 – Create Employee Record 1
03 – Create Work Unit 1
04 – Create Earning Payhead 1
05 – Create Earning Payhead 2
06 – Create Deduction Payhead 1
07 – Define Salary Structure 1
08 – Create Payroll Voucher 1
Online GST Return Filing : Module – 13
1 – GST Filing – GST Registration Process
2 – GST Filing – Export Data in CSV from Tally
3 – GST Filing – Create JSON File with GST Offline tool
4 – GST Filing – Filing GSTR1 Sales on GST Portal
5 – GST Filing – Making Payment on GST Portal Filining GSTR3B
TCS In Tally Prime : Module – 14
1 – TCS – What is TCS?
2 – TCS – Practical Entry in Tally Prime
3 – TCS – Payment Entry’s
BRS In Tally Prime : Module – 15
1 – BRS In Tally Complete Video
Practice Assignment : Module – 16
Photoshop : Module – 1
01 – Photoshop Introduction (Preview)
02 – Eyes Effect – Elliptical Marquee Tool
03 – Change Lips Color Using Polygonal Lasso tool
04 – Mirror Effect – use of Transform Tool
05 – Selection Tools and Feather Effects
06 – Use Lasso Selection Tools
07 – Fit Image into Object using Transform
Photoshop : Module – 2
01 – Create Passport Size Photos
02 – Use of Quick Selection and Magic Wand tool
03 – Use of Pen Tool – Blur Image Background
04 – Change Image Background
05 – Use of Shapes
06 – Apply Effects on Shapes
07 – Text Fire Effects
08 – Text Tools and Options
09 – Download Design Fonts & Hindi Typing
10 – Text Effects
Photoshop : Module – 3
01 – Create PNG Image
02 – Create Pattern
03 – Clone Stamp Tool
04 – Remove Black spot from Face
05 – Create GIF Image
06 – Create Animated Advertise
07 – Layer Panel Options
08 – Advance Crop
09 – Create advertising Template
10 – Healing Brush Tool Content Aware Tool
Photoshop : Module – 4
01 – Brush Tools
02 – Pattern Stamp Tool
03 – Art History Brush tool
04 – Eraser Tools
05 – Gradient Tool
06 – Blur Tool, Smudge Tool
07 – Dodge, Burn, Sponge Tool
08 – Pen Tools in Details
09 – Create Your Custom Shape
10 – Create Layer Mask
Photoshop : Module – 5
Hardware : Module – 1
01 – Hardware – Computer Introduction (Preview)
02 – Input Devices
03 – 3 Connection With CPU
04 – Open Cabinet
05 – Remove Connection In Cabinet
Hardware : Module – 2
01 – Open Motherboard
02 – Remove CPU Fan
03 – Remove CPU
04 – Remove Ram
05 – Remove CPU Fan
06 – Assemble Front Panel
07 – Assemble Power connector
08 – Assemble Motherboard
09 – Assemble HardDisk Setup
10 – Assemble Complete CPU
11 – Open Harddisk Drive
12 – Troubleshoot SMPS
13 – Check SMPS Power with multimeter
14 – SMPS Internal Structure
15 – Insert and Remove Graphic Card
Hardware : Module – 3
01 – Motherboard All Parts in Dept
02 – North Bridge and South Bridge
03 – DVD Writer Attach and Detach
04 – Hardware Make Bootable Pendrive
05 – Install Windows 7
06 – Driver Installation
07 – Installing Windows 10
08 – Software Installation
09 – Create Multiple User Account
10 – Hardware – Create Partition
Hardware : Module – 4
Filmora : Module – 1
1 – Install Software & Record PC Screen (Preview)
2 – Trim or Split video
3 – Audio Settings
4 – Audio Settings
5 – Video Settings
Filmora : Module – 2
01 – Video Settings – 2
02 – Add and Animate Text
03 – Learn to Add Transitions
04 – Adding Effects
05 – Add Elements
06- Split Screen Effect
07 – Adding Logo in Video
08 – Keyframe Animation
09 – Pan and Zoom
10 – Create Your Green screen
Filmora : Module – 3
01 – Highlight Points
02 – Advance options
03 – Voice Over
04 – Filmora Essential Settings
05 – Export Video
OpenShot : Module – 4
CorelDRAW : Module – 1
01 – Introduction (Preview)
02 – Practical use of Knife Tool
03 – Practical Use of Shape Tool
04 – Practical use of Power clip
05 – Practical use of Envelope Tool and More
CorelDRAW : Module – 2
01 – Practical use of Eraser Tool
02 – Practical use of Star Shape
03 – Practical use of Weld option
04 – Practical use of Round corners option
05 – Use of Blend tool in Logo
06 – Import Image in Corel and Create Flim Strip
07 – Add Perspective Effect on Text
08 – Rotate Object and Create design
09 – Use of All Pick Tools and Shape tools
10 – Use of Eraser, Knife, Crop Tools
11 – Use of Pen Tool and Other Line Tools
CorelDRAW : Module – 3
01 – Use of Artistic Media Brush Tools
02 – Use of Rectangle and Ellipse tools with Weld Options
03 – Use of – Polygon, Star, Spiral, Graph Tools
04 – Use of Text tool and Hindi typing, Free Font Installation
05 – Draw Table, Use of Dimensions Tool
06 – Drop Shadow and Contour Tool
07- Use of Blend, Envelope, Extrude Tool
08 – Use of Transparency, Interactive Fill, Smart fill tool
09 – Create Alphabet Logo
10 – Create Professional Business Card
11 – Modern Business card
CorelDRAW : Module – 4
Google Sheets : Module – 1
01 – Introduction (Preview)
02 – Use of Functions
03 – Inserting and Deleting Sheets, Navigating Sheets
04 – Paint Format, Currency Format, % Age Formula
05 – Enable Keyboard Shortcuts, Format Sheet
Google Sheets : Module – 2
01 – Hyperlink and Insert Comment
02 – Share sheets with multiple people and word together
03 – Insert Chart & Format Chart -1
04 – Insert Chart & Format Chart – 2
05 – Sort and Filter Options
06 – Save Filter, Create Filter
07 – Filter formula
08 – File Menu – Save Version History, Open Excel file
09 – File Menu – Publish file to web
10 – Printing Tips
11 – Edit Menu – Paste Special
Google Sheets : Module – 3
01 – Edit Menu – Find and Replace
02 – View Menu – Freeze Panes
03 – Insert Menu – 1 – Image, Rows, Columns
04 – Insert Menu – 2 – Google Forms Link to Google Sheets
05 – Insert Menu – 3 – Check Boxes – Create To do List
06 – Format Tab – Conditional formatting, Number formatting
07 – Data Menu – Use of Slicers
08 – Data Menu – Data Validation
09 – Pivot Table – Create Summarize Reports
10 – Add Named Ranges and Apply Formula
11 – Google Protect Worksheet and Range
Google Sheets : Module – 4
01 – Split Text to Columns, Remove Duplicates
02 – Macro Recordings
03 – Accessibility Options
04 – Mail Merge – Send Bulk Emails
05 – IFS formula use
06 – Text Join and Concatenate formula
07 – Google Translate formula
08 – VLOOKUP and HLOOKUP in Google Sheet
09 – Countif, Countifs, Sumif, Sumifs
10 – Sumif, Sumifs Formula in Google sheet
11 – CountUniqueIFS new formula
Google Sheets : Module – 5
01 – Sparklines Formula Bar Column line Chart
02 – All IsFormula – Isemail, IsNumber, Istext
03 – Create QR Code using Formula
04 – All useful Text Formulas
05 – All useful Number Formulas
06 – Get Unique Record
07 – Use of Query Formula – Remove Blanks
08 – Import Data from Web
09 – Merge Sheets Data
10 – Merge Workbooks
11 – Remove Blank rows tricks
Google Sheets : Module – 6
MS-Word : Module – 1
01- Introduction of Word (Preview)
02 – Home Tab : Font Group
03 – Home Tab : Advance Font, Clipboard Group
04 – Word Paragraph group
MS-Word : Module – 2
01 – Create Page cover in Word
02 – Create and Design Table
03 – Insert and Format Picture
04 – Draw Shape, Insert Chart & Smart art
05 – Header and Footer in Word
06 – Insert Symbol and Object
07 – Design Tab in Word
08 – Page layout Tab in Word
09 – References Tab in Word
10 – Mailings Tab in Word
11 – Review Tab in Word
MS-Word : Module – 3
VBA : Module – 1
01 – Introduction (Preview)
02 – What is Variable and Data Type
03 -Sheets and Cell Selection
04 -Dynamic Copy Code of VBA
05 – Offset Command
VBA Basic and IF Condition : Module – 2
01 -Project on Copy paste
02 -Inputbox and Messagebox
03 – Variable Types
04 – Option Explicit
05 – IF Condition
06 – IF Condition with And
07 – IF Condition with OR
08 – NestedIF Condition
09 – Project on IF
Loops in VBA : Module – 3
01 – VBA For Next Loop
02 – For Loop Decrement Method
03- Do While Loop
04 – Do Until Loop
Project With Using Loops : Module – 4
01 – For Loop Project Remove Blank Rows
02 – For Loop Project Add Alternate Blank rows
03 -For Loop Project Insert Number of rows and Columns
04 -Error Handler
05 – Do While Loop with Nested if Project
06 – For Loop with Nested if Project
07 – Merge Sheets using For Loop
08 – Create Index Using for Loop
Message Box and Input Box In VBA : Module – 5
01 – Type of MsgBox
02 – Use of Yes, No Type MsgBox
03 – Select Range Using Input box
Project On Sheets : Module – 6
01 – For Each Loop
02 – Method of Adding worksheets
03 – Insert N Number of Sheets
04 – Method of Deleting Sheets
05- Using For Loop Delete Multiple Sheets
Object And Class : Module – 7
01 – What is Object and Class
Collection Loops : Module – 8
01 – Collection of Loop
02 – Delete Blank Sheets For Each Loop
03 – Collection Loop For Each Cell
04 – Collection Loop Interview Question
Workbook Command And its Projects : Module – 9
01- Workbook Commands
02 -Workbook Protection Command
03 – List of Worksheets from workbook
04 – Open All Workbook From Specific Folder
05 – Find Workbook
06 – Deleting Unwanted Workbook
07 – Protect All Sheets Using Loop
08- Protect UnProtect Set Custom Password
09 – Collection Loop For Workbook
Nested Loop : Module – 10
01 – Nested Loop
02 – Nested Loop Assignment
Array In VBA : Module – 11
01 – Array Introduction
02 – Array in Loop
03 – List of Arrays
04 – List of Arrays
05- Compairing 3 List using Arrays
06 – Start Point of Arrays
07 – Dynamic Array
08 – Array Project Rename Sheets
09 -Project Find and Delete Using Array
10 – Lbound and UBound in Array
11 – Array from Range
12 – Two Dimensional Array
13 – Dynamic Two Dimensional Array
14- Project on Array with Vlookup Function
Function In VBA : Module – 12
01 – Text Functions in VBA
02 – Find and Left Practical Use
03 – Find with Right and Mid Practical Use
04 – INSTR and Replace Function
05 – String comparison
06 – Change Case Functions
07 – IsNumeric Function Practical use
08 – SUMIF Function
09 – SUMIFS Function
10 – COUNTIF and COUNTIFS Function
11 – Vlookup Function
12 – Match Function
13 – Autorun Vlookup Event
14 – Date Functions
15 – DateDiff and DatePart Function
16 – Project on DateDiff Function
17 – All Date and Time Functions
18 – CASE Function
User Defined Function In VBA : Module – 13
01 – Introduction of UDF
02 – Create GetText Function
03 – Create Get Numbers Function
04 – Project on Separate Names
05 – M Vlookup for Multiple Values
06 – Combine Function Extract Text and Numbers
07 – Reverse Lookup
08 – Reverse Lookup Using Index Code
User Form In VBA : Module – 14
01 – Userform Introduction
02 – Userform Label and Text Box Properties
03 – Userform use of Command Button
04 – Submit Data to Excel using userform
05 – Userform Events and Text Box Events
06 – Userform Use of ComboBox
07 – Userform Listbox
08 – Userform CheckBox
09 – Userform use of Option Button
10 – Adding Image in Userform-1
11 – Adding Image in Userform – 2
12 – Adding Image in Userform-3
Excel To Outlook : Module – 15
1 – Outlook – Configure with gmail
2 – Outlook – Sending Email through Outlook
3 – Outlook Email with Attachment
4 – Outlook Send Bulk Email
5 – Outlook Send Bulk Email with attachments
Web Scrapping In VBA : Module – 16
01 – Web Scraping Introduction
02 – Web Scraping Loop until Ready state
03 – Web Scraping Get data from Website
04 – Web Scraping Get data from Website 2
05 – Web Scraping Get All Links
06 – Web Scraping Get Exact Data from Website
VBA Events : Module – 17
01 – Change Events
02 – Events Autofilter Using Macro
03 – Basic Events
Project In VBA : Module – 18
01 – Create Add-ins – Add picture in Comment Box
02 – Projects – Get Grace Marks Amazing Project
03 – Projects – Get Links of All Excel Files From any Folder
04 – Project – to Count Cells of Conditional Formatting (New Video)
VBA Assignment With Video Answer : Module – 19
01 – Assignment – For Loop and if assignment
02 – OMR Sheets Assignment
03 – Interview Question UDF of Reverse Text
04 – Project Lock Data once you type
VBA Interview Questions : Module – 20
MS-Access : Module – 1
01 – Introduction of MS Access (Preview)
02 – Creating Table in MS Access
03 – Delete & Add Columns in Access
04 – Create Lookup Wizard from List
05 – Break Lookup Relationship
MS-Access : Module – 2
01 – Calculation in Access
02 – IF Formula in Access
03 – IF AND, IF OR in Access
04 – Import Tables from Excel, Notepad in Access
05 – Filter and Sort in Access
06 – Advance Filter in Access
07 – Records Group in Access
08 – Find and Replace in Access
09 – Create Query using Query Wizard
10 – Design Query on Existing Query
MS-Access : Module -3
01 – Create Parameter Query
02 – Query with Relationship
03 – Query with Calculated Field
04 – Pivot Table in Access – Cross Tab Query
05 – Find Duplicate Query
06 – Unmatched Query
07 – Export Access data
08 – Hide Table and Query from Navigation
09 – Add Totals in Query
10 – SQL View of Query
MS-Access : Module – 4
Excel MIS & Dashboard : Module – 1
01 – Pivot Table Introduction (Preview)
02 – Pivot Table and Pivot Chart
03 – Design Tab of Pivot Chart
04 – Slicer in Pivot Table & Slicer Settings
05 – Time Line in Pivot Table
06 – Get Pivot Data in Excel
Excel MIS & Dashboard : Module – 2
01 – Pareto Chart in Excel
02 – Info Graphic Chart in Excel
03 – Trend Chart using SumIFS Formula
04 – Map Chart using XY Scatter Chart
05 – Key Performance Indicator in Excel
06 – Chart with Hyperlink
07 – Chart with Conditional Formatting
08 – Create Bar Charts with Pictures MIS Series
09 – Speedometer Chart in Excel
10 – See Saw Comparison Chart
11 – Hyperlink with Column and Pie-Chart
12 – Male, Female Comparison Chart
Excel MIS & Dashboard : Module – 3
Computer Fundamental : Module – 1
1 – Computer Parts Introduction (Preview)
2 – CPU Hardware Parts
3 – Desktop Icon Settings
4 – Keyboard and Mouse Information
5 – Software Installation
6 – Change Computer Password
MS-Word For Beginners : Module – 2
1- MS-Word Introduction
2 – Text Formatting in Word
3 – Clipboard Group in Word
4 – Paragraph Group in Word
5 – Insert Table and Picture in Word
6 – Page Color and Borders in Word
7 – Page Printing Settings in Word
8 – Check Spelling Mistakes in Word
9 – Mail Merge in Word
10 – Password Protection in Word
MS-Excel For Beginners : Module – 3
1- Excel Introduction & Basic Formulas
2 – Excel Formatting
3 – Excel Sort And Filter
4 – Excel Chart And Table
5 – Excel Pivot Table
6 – Excel VLOOKUP And Hookup
7 – Excel Creating Macros
8 – Excel Hyperlink
9 – Excel Printing Format
10 – Excel Number Highlight
PowerPoint For Beginners : Module – 4
1- PowerPoint For Beginners
2- Creating slides In PowerPoint
3- Sending Email
4- Transition In PowerPoint
5- Animation Effect In PowerPoint
6- Photo Album In PowerPoint
Internet And Email : Module – 5
Create YouTube Channel, Logo, Thumbnail on Desktop : Module – 1
1 – How to Create YouTube Channel? (preview)
2 – YouTube Guide – Create Logo
3 – YouTube Guide – Create Channel Banner
4 – YouTube Guide – Create Video Thumbnail
5 – YTG – How to Record Computer Screen With free Software
6 – Highlight Mouse Pointer on Screen
How To Shoot Video : Module – 2
1 – Mobile And Camera Stands For Video Shootings
2 – Mic For Recording Audio
3 – Lighting Setup IDEA
How to Edit Video on Filmora Editor : Module – 3
1 – Video Editing – Install Software & Record PC Screen
2 – Video Editing – Trim or Split video
3 – Video Editing – Audio Settings 1
4 – Video Editing – Audio Settings – 2
5 – Video Editing – Video Settings – 1
6 – Video Editing – Video Settings – 2
7 – Video Editing – Add and Animate Text
8 – Video Editing – Learn to Add Transitions
9 – Video Editing – Adding Effects
10 – Video Editing – Add Elements
11 – Video Editing – Split Screen Effect
12 – Video Editing – Adding Logo in Video
13 – Video Editing – Keyframe Animation
14 – Video Editing – Pan and Zoom
15 – Video Editing – Create Your Green screen
16 – Video Editing – Highlight Points
17 – Video Editing – Advance options
18 – Video Editing – Voice Over
19 – Video Editing – Filmora Essential Settings
20 – Video Editing – Export Video
How to Edit Videos (OpenShot Free Software) : Module – 4
1 – Download and Install Free Software Open shot
2 – Trim Video and SNC Audio
3 – Add Audio in Background
4 – Add and Animate Image in Video
5 – Add Lower Third text in Video
6 – Add Animated Title in Video
7 – Add Green Screen Video
8 – Crop and Zoom and Export Video
How to Upload Videos on YouTube : Module – 5
1 – YTG – Upload Videos on YouTube With SEO Friendly title
2 YTG Get SEO Friendly Tags for Videos
3 – YTG – Complete Setting Related to Video Uploading
4 – YTG – Other YT Studio Settings
5 – YTG – YT Studio Settings
6 – How to create shorts Video
7 – How to edit shorts / How to create Two channels on single E- mail
Create YouTube Channel, Logo, Thumbnail on Mobile : Module – 6
1 – Mobile – Create Youtube Channel On Mobile-1
2 – Mobile – Create Logo For Youtube Channel
3 – Mobile – Create YouTube Thumbnail On Mobile
4 – Mobile – How To Create Channel Arts
5- Mobile – How To Upload Video On YouTube
6 – Mobile – Use Of YouTube Studio Application
7 – Mobile – How to Record Mobile Screen
8 – Mobile – Download Free Content For YouTube
Edit Video on Mobile : Module – 7
1 – Video Editing on Mobile – Kine Master
2 – Video Editing on Mobile – Kine Master
3 – Video Editing on Mobile – Kine Master
4 – Video Editing on Mobile – Kine Master
5 – Video Editing on Mobile – Kine Master
6 – Video Editing on Mobile – Kine Master
7- Kinemaster – Use Green Screen – Create Your Green Screen
8- Kinemaster – Blending Modes And Export Video
YouTube Policies and Settings : Module – 8
1- Details about Copyright Strike and Copyright Claim
2 – What is RPM and CPM?
3 – How to Appeal Community Guideline Strike
YouTube Guide Course Final Exam Trial Paper
Power Query : Module – 1
01 – Introduction and Installation (Preview)
02 – Create Connections with Excel Table
03 – Create Connections with Text file and Access Database
04 – Reconnect Data in Power Query
05 – Create Pivot table on Text file data
Power Query : Module – 2
01 – Merge Multiple sheets using M Language
02 – Create Pivot table on Multiple Sheets
03 – Close and Load to Explain Home tab Query Group
04 – Home Tab – Manage Column and Rows Group
05 – Home Tab – Split Column into rows and columns
06 – Power Query – Home Tab – Group by using Basic and Advance Option
07 – Home Tab – Data type & Replace Values
08 – Transform data Dynamically
09 – Combine 1000+Tables with 1 Function
10 – Alter options of VLOOKUP inside Power query
11 – Multiple columns lookup
Power Query : Module – 3
HTML : Module – 1
01 – HTML Introduction (Preview)
02 – Write first Program in HTML
03 – Heading Tag in HTML
04 – Indent and Comment
05 – Element and Attribute
HTML : Module – 2
01 – Formatting Tag
02 – Paragraph and Premarmatted Tag
03 – Font Tag
04 – Quatotation and Citation
05 – External Hyperlink
06 – Internal Hyperlink
07 – Image Tag
08 – Hyperlink on Images
09 – List Tag in HTML
10 – Nested List Tag
HTML : Module – 3
01 – Marquee Tag
02 – Marquee on Image
03 – Colour Code
04 – Table Tag 1
05 – Table Tag 2
06 – Video and Audio Tag
07 – Google Map, YouTube Video Tag
08 – iFrame Tag
09 – Add PDF Code
10 – DIV and Span Tag
HTML : Module – 4
01 – Use of Code Editor
02 – Entities, Symbol and Emojis
03 – Semantic and Non Semantic
04 – Responsive
05 – Learn Image Map In HTML
06 – Form In HTML
07 – Forms – 2
08 – Radio Button – Checkbox
09 – Create Data list in Forms
10 – Output Elements in Forms
HTML : Module – 5
MS – Outlook : Module – 1
01 – Introduciton Configure (Preview)
02 – Email 1
03 – Email 2
04 – Create Appoinment
05 – Set Meeting
MS – Outlook : Module – 2
Illustrator : Module – 1
01 – Illustrator Introduction (Preview)
02 – Direction Selection Tool
03 – Group Selection, Magic Wand, Align and Group
04 – Use of Pen Tool
05 – Trace Object Using Pen Tool
06 – Use of Transform Option
illustrator : Module – 2
01 – Text Tools
02 – Line, Arc, Sipral Tools
03 – Create Flower Pot
04 – Stroke Panel
05 – Shaper Tool, Smooth Tool
06 – Eraser, Knife Tool
07 – Create Object Using Tools
illustrator : Module – 3
01- Draw Shapes
02 – Create Clock Using Rotate Tool
03 – Scale, Shear, Reshape
04 – Width Tool
05 – WARP Tool
06 – Twirl tool
07 – Puppet Warp Tool
08 – Shape Builder Tool
09 – Live Paint Bucket Tool – 1
illustrator : Module – 4
01 – Image Tracing
02 – Perspective Effect
03 – Perspective Effect On Text
04 – Mesh Fill Tool
05 – Create Live Mirror Drawing 1
06 – Blend Tool 1
07 – Symbol Tool 1
08 – Custom Symbol 1
05:01 Min
09 – Graph Tool 1
10 – Artboard Tools 1
11 – Slice Tool 1
12 – Create Custom Brushes 1
illustrator : Module – 5
MS-PowerPoint : Module – 1
01 – Introduction of PowerPoint (Preview)
02 – Creating Slides in PowerPoint
03 – Design Tab in PowerPoint
04 – Transitions Tab in PowerPoint
05 – Loop Slide in PowerPoint
MS -PowerPoint : Module – 2
MS-Publisher
01 – Introduction (Preview)
02 – Insert Text Box
03 -Insert Picture
04 – Insert Catalog Pages and Table
05 – Insert Calendar and Page Parts
06 – Create Advertisements
07 – Insert file from word
08 – Header and Footer
09 – Page Design Tab
10 – Mail Merge
Module 1 – Introduction
1 – What is Google Data Studio and Understanding of Data (Preview)
2 – Import data in Goolge Data Studio
3 – Google Data Studio Overview
Module 2 – All About Tables
1 – Insert Table, Learning About Dimensions and Metrics
2 – Sorting Table Data
3 – Date Range and Date Period Comparison
4 – Drill Down and Drill Up in Table
5 – Optional Metric and Metric Slider
6 – Conditional Formatting in Table
7 – All about Table Style
8 – Add Filter in Table
Module 3 – Calculations
01 – All about Aggregation
02 – Comparison Calculation
03 – Running Calculation
Module 4 – All About Pivot Table
1 – Adding and Setup of Pivot Table
2 – Style Option Pivot Table
Module 5 – All About Scorecard
01 – Add, Setup and style of Scorecard
Module 6 – All About Controls
1 – Drop down and Fixed size controls
2 – Input box, Advance Filter and Slider
3 – Date Range Controls
Module 7 – Custom Field
1 – Create Total Sales Field
2 – Create Profit Margin Field
3 – Add Custom Date field
Module 8 – Calculated Filed Using Formulas
1 – Upper Formula, Concat Formula
2 – Regex Match Formula
3 – Case Formula
Module 9 – All About Charts
1 – Creating Time Series Chart
2 – Style options of Time Series Chart
3 – Bar Chart or Column Chart
4 – Pie Chart and Donut Chart
5 – Combo, Area, Scatter, Bullet Treemap
Module 10 – Complete Dashboard
01 – Dashboard – Part -1
02 – Dashboard – Part -2
03 – Dashboard – Part -3
Module 11 – Blending data and Sharing Reports