Blog Index

Index

Excel VBA/Macro to fetch consecutive Duplicate wor...

MS Excel Trick: Copy-Paste in Filtered/Visible Cel...

Excel VBA: save a macro-enabled Excel file as a no...

Number Guessing Game, Using Excel VBA

Analysis ToolPak; Excel Add In for Statistical Ana...

SQL Query in Excel using Power Query

Spell Check VBA Code/Macro

Excel: Bus/Transport Seat Booking/Ticketing System...

Payroll/Salary System in Excel, Complete/Automated...

Advance Formatting Techniques in Excel; Urdu/Hindi

Learn Excel with Solved Test Urdu/Hindi

Count Words Frequency in Excel using VBA; Code ava...

Journal, Ledger, Trial Balance in Excel; Fully Aut...

Excel formula range changed/reference error after ...

Matching and Displaying a RegEx Pattern in a Strin...

Gantt Chart in MS Excel; Urdu/Hindi, just two minutes

MS Excel Pivot & Power Pivot Table in Urdu/Hindi;...

Excel VLOOKUP function defined in an Image

Excel - Data Analysis - Regression- Analysis ToolPak

Excel Pivot Table- Tips & Techniques

Excel VBA - Last Column or Last Row

Excel Format Painter > formatting to an entire col...

Merging multiple worksheets into one

VBA: SQL Connection String and Some Data Formatting

VBA Code to Combine multiple workbooks in one work...

Automatic emails outlook- Excel VBA

Pull Unique Values with Advanced Filter

Using What-If Analysis – Goal Seek- for finding a ...

Extracting Date from a Date Time - in Excel

Autocomplete when typing in Excel drop down list

Macro to add hyperlink for a list (Excel VBA)

Excel MROUND Function

Check if list of Emails Valid or not (VBA Regex)

One Drop down List Dependent on Other (Excel 2010)

Gantt Chart in MS Excel 2010

Use Mid, Find & Len function to extract substring

Use of Excel SIGN Function

Data Validation – Dynamic (Excel 2010) – From Table

Excel Fill Series

Pictograph in Excel

Using “Playbill” font & Excel formula for incell c...

Excel formula: COUNTIFS() with date range in cell ...

Power Pivot Table (Excel 2010)

Using CountIf function along RANK.EQ for unique ra...

Compare 2 lists, Easy Way (Excel2010) & a VB Macro

Excel 2010: Fuzzy Lookup Add-In (Approximate Data ...

Excel Macro: Highlight Every Other Row

Unhide the very first column or row of a sheet

Lock Specified Area of a Protected Sheet

Viewing two sheets of the same workbook side by side

Interactive Image in Excel

Deleting Blank rows, a simple technique

Excel VBA?

Highlight Row of Selected Cell using VBA

Stop Duplicate Data Entry through Data Validation

Extract Data by Advanced Filter & VBA

Roman & Datedif function

VB Code to highlight modified cells

Using Index Function & Scroll Bar Button to Make a...

Using COUNTIFS (Array function)

Some General but Useful Excel Learning