Video Tutorial

Excel Video Tutorials

Here is the fully compiled listing of the Excel Tutorials,Click on any of the following to view the relevant training video.Dont forget to subscribe to my youtube channel for new weekly videos: www.youtube.com/c/ajaykumarparmar

Advance Format Cells

  • AutoSum
  • Awesome Filter
  • Duplicates removed
  • Color cells based on values
  • filter by Color
  • Advance Find function
  • Cool Paint Brush
  • Must know Functions
  • Elegant SubTotal function
  • Extract text from alpha-numeric
  • How to Track changes made in your sheet
  • Excel Training Discussion
  • Join Mutiple texts in style
  • Color cells based Values using Format Cells
  • Text to column,paste special
  • Go to Special feature
  • Wonderful Tip for Viewing Comments
  • Amazing Transpose feature/Formula
  • How to sort data Row Wise
  • Data Sorting By Color
  • Find Replace Magic
  • How to Format cells in Zip Codes
  • Format dates using Custom
  • File Option -Must know feature
  • Format cells removing trailing ZEROs
  • Insert new line after each word within cell
  • Charts

  • Give style to your Chart
  • Amazing technique to Create Chart
  • Amazing Drop Down Charts
  • Classy Waterfall Charts-Part 1
  • Combination Of Charts
  • Super Classy Waterfall Charts -Part 2
  • Conditional Formatting

  • Give Movie/Project reviews in a Unique style
  • Using two cells
  • How to compare your Table Entries Conditional Formating Part 4
  • Learn Conditional formating-Mutiple criterias
  • Advance Conditional Formatting
  • Date Error Check
  • Count & Sum Family

  • Introduction to CountIF & CountIFS
  • Advance Filter – Filter Unique Values
  • Advance Filter- Simply awesome
  • Dealing with a Puzzle using Countif & sumif
  • Art of Making Dashboard- Using SUMIF & COUNT Family
  • Basic and Must know Functions
  • Data Validation Using CountIF
  • Dashboard Making

  • Art of Making Dasboard – Series 6
  • Meeting planner-Calendar view
  • Preparing summary sheet
  • Art of Making Dashboard – Series 5
  • Art of Making Dashboard- Series 4
  • Art of Making Dashboard Series 3
  • Art of Making Dashboard- Using SUMIF & COUNT Family- Series 1
  • Art of Making Dashboard Using Date -Series 2
  • Data Validation examples

  • Preparing summary sheet
  • Dynamic Drop down – Method 2
  • Dynamic Drop Down – Method 1
  • Restricting user to enter specific values
  • Data Validation Using CountIF
  • Data Validation -Restrict user for entering dates
  • Date and Time Examples

  • Format dates using Custom
  • Events

  • VBA Macro editor & Events
  • Workbook Event-Selection Change
  • Explore your ShortCut Keys

  • Part 3
  • Part2
  • Part1
  • Goal Seek

  • Scenario
  • What If Analysis goal Seek -Series 4
  • What IF Analysis Goal Seek- Series 3
  • What IF Analysis- Goal Seek -Series 2
  • What IF Analysis- Goal Seek -Series 1
  • INDEX

  • Solution to real office project
  • Solving a great puzzle-part 2
  • Solving a great puzzle
  • Indirect

  • Meeting planner-Calendar view
  • Discussing Real project of MIS
  • Solving interview question
  • Preparing summary sheet
  • Dynamic Drop Down – Method 1
  • Powerful Indirect using name range
  • Example of INDIRECT Function
  • Learn Excel USING POWERFUL INDIRECT
  • Know your D functions

  • Dealing with a Puzzle using Countif & sumif
  • D Family Series-1 -DCOUNT
  • D Family Series 2- DMAX
  • D Family Series-3- Dcount with wild Character
  • D Family Series-4 -Dcount & Wild Characters
  • MOD

  • Amazing use of MOD
  • Nested Ifs

  • Wonderful exercise -real MIS Question
  • Dealing with a Puzzle using Countif & sumif
  • Date Example using IF
  • Offset

  • Dynamic Drop down – Method 2
  • Online Classes Demo Videos

  • Demo Video – Index with Data validation
  • Vlookup error handling discussion
  • Super Cool Training for you- Must Watch
  • Stylish Go To
  • Paste Special with GoTo
  • know your TEXT Family
  • Classy Paste Special
  • Discussion on Mid,Right,Left,Vlookup
  • Fix the long value issue
  • Fill Series feature
  • Find and Replace
  • Protection discussed like never before!
  • Pivots

  • Vlookup with pivot and IF -Fantastic
  • Handling Pivot Drawback
  • How to combine two sheets and make one Pivot
  • Know your powerful Pivot today
  • Super Strong Arrays

  • Dealing with a Puzzle using Countif & sumif
  • Combining Vlook,if,row,error handling-Cannot get better than this
  • If table values decreasing regularly?
  • Using Mid,Offset,Row,Large
  • Find Position of special character and Extract Text From Cell using Arrays
  • Exercise on Powerful Arrays
  • Using Arrays-Check Table Sorted OR Not
  • How to find Unique values in BIG Tables
  • How to Sum the lower half
  • Arrays-Longest Formula ever- Extract number from alphanumeric cell
  • TEXT FUNCTIONS

  • Using Mid,row and if function- Awesome exercise
  • Get sheet names in a cell- 3 formula combination
  • Substitute
  • Powerful Find acting like loop
  • WOW! – Mid,right,subsitute,Trim,Rept all in 1 exercise
  • Find in Find
  • Using Mid left right find
  • Extract Text from alphanumeric value
  • Using Named Range

  • Dynamic Drop Down – Method 1
  • Vlookup (Basic+Advance)

  • Sort the data using Large and Small functions- Awesome
  • Vlookup with pivot and IF -Fantastic
  • So powerful exercise on Vlookup
  • Wonderful exercise -real MIS Question
  • Vlookup and Error handling
  • Exercise on Dates with vlookup
  • UNLEASH VLOOKUP Power
  • How to use Vlookup, IF,Row,IfError & Small
  • Surprising Vlookup to find the same Value
  • Magical Vlookup with IF condtion
  • Data Validation Using CountIF