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 |