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.