Access Training

MS Access

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