| 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 |