Excel & VBA Video Tutorials
Excel Lesson 31 - Retrieve Data From MySQL Database Using MS Query
Learn how to retrieve data from MySQL Database using Microsoft Query, Join multiple tables & link the exported data to a drop down list to retrieve data dynamically based on the value of drop down list.
Excel Lesson 30 - Register MSCOMCT2.OCX File for Date Time Picker
Learn how to register MSCOMCT2.OCX file for Excel's Date Time Picker (Calendar Control) for 32 Bit & 64 Bit Microsoft Office Versions on Windows 7
Excel Lesson 29 - Worksheet Very Hidden
A Quick Excel Tip to learn how to hide worksheets in a way it gets difficult to unhide
Excel Lesson 28 - CountIf, Address and Match
Learn how to Count values based on certain criteria where the range column can be dynamic.
Excel Functions, CountIf, Address and Match are used in the solution.
Excel Lesson 27 - VBA Split Function
Learn how to use the VBA Split Function to Split an Input string into numerous sub strings based on a certain criteria.
The Video also demonstrates uses of VBA Functions like LBound(), UBound() & Trim.
Lesson 26 - Autofit Cell Content
A simple VBA statement that will help you Autofit Column width based on the content.
Lesson 25 - The Concatenate Function
Learn about the Concatenate Function. How to join 2 or more Text Strings, and also learn about using Concatenate with other Excel functions
Lesson 24 - Vlookup with Substitute and Choose
Vlookup with Substitute and Choose
Lesson 23 - Vlookup with Substitute
Vlookup used with Substitute to look up Prices
Lesson 22 - Financial Year Formula
Financial Year Excel Formula
Lesson 21 - Lookup Value To The Left Using Vlookup & Choose
Lookup Value To The Left Using The Choose Function.
Lesson 20 - Comparison Chart To Compare Monthly Sale Vs Average Monthly Sale
Comparison Chart To Compare Monthly Sale Vs Average Monthly Sale
Lesson 19 - Naming Ranges, Constants & Formulas
Learn How To Name Ranges, Constants & Formulas
Lesson 18 - Build Your Own Custom Lists
Learn How To Build Your Own Custom Lists Using The Custom Lists Feature
Lesson 17 - Excel Sheet For Arsenal Fans Using Web Query
Lean How To Make Excel Sheet To Keep Track Of League Tables Using Web Query Where A League Table Will Be Downloaded On Your Workbook Linked To The Arsenal Website & Will Refresh After Certain Time Intervals To Look For Updated Data
Lesson 16 - Sales Growth Chart For Sales Presentations
Learn How To Build Sales Growth Chart For Sales Presentations Using Form Controls
Lesson 15 - Self Updating Drop Down List
Build A Self Updating Drop Down List.
Lesson 14 - Basic Userform For Data Entry & Pivot Table Analysis
Create A Basic Userform For Data Entry & Pivot Table Analysis.
Lesson 13 - Zoom Headers Automatically When Workbook Is Opened
In this video I will teach you a simple code that will zoom headers automatically when workbook is opened.
Lesson 12 - Toggle Between Worksheets Using Macros
Record Simple Macros To Toggle Between Worksheets Using.
Lesson 11 - Add Colored Blank Row Below Every Changed Product Id
Add Blank Row Below Every Changed Product Id Using Sub Total Feature
Lesson 10 - Create Target Letters & Save Letters As PDF Files
Learn How To Create Target Letters & Save Letters As PDF Files Using VBA Coding
Lesson 9 - Copy Data On Respective Part Sheets Using VBA (Part 2)
Copy Data from Data Sheet On Respective Part Sheets Using VBA.
Lesson 9 - Copy Data On Respective Part Sheets Using VBA (Part 1)
Copy Data from Data Sheet On Respective Part Sheets Using VBA.
Lesson 8 - VLookup From Multiple Ranges
VLookup Where There Can Be More Than One Table Array
Lesson 7 - Conditional Formatting To Display Features Of Vehicles
Conditional Formatting To Display Features Of Vehicles
Lesson 6 - Product & Month Wise Sale Array Formula
Calculate Product Wise Monthly Sale Using Array Formula.
Lesson 5 - 6 Useful Charting Techniques
This Video Covers 6 Useful Chart Techniques that will come in handy while working with Charts, or building Dashboards etc.
Lesson 4 - Sum & If Array Formula
Sum Model Wise Sale Quantity using the Sum & If Array Formula. This is somewhat like using the =SUMIF Function.
Lesson 3 - Find & Replace Line Break Character
Find & Replace Line Break Character using Find & Replace.
Press Ctrl+H to go directly to the replace tab.
Type Ctrl+ J in the Find Section (You can also use Alt + 0010)
Lesson 2 - Slicers for Excel 2007
Join my course - Microsoft Excel - Macro Recorder To Automate Excel Tasks..
Making Slicers for the Excel 2007 Version of Excel using Macros!
Obviously this method does not give you all the options that a Slicer would provide, but it would still come in handy while making small reports or Dashboards etc.
Lesson 1 - Vlookup based on Dynamic Field Headers
Return a value based on 2 Lookup criteria using VlookUp & Match.