Downloadable Excel Supporting Files – Archived 1
Downloadable Supporting Files - Archived 1
These are the old downloadable practice files archived from our previous website
(Use SEARCH BOX for more practice files)
- VLOOKUP Part 1 (Download)
- VLOOKUP Part 2 (Download)
- VLOOKUP Part 3 (Download)
- Create Waterfall Chart in One Minute – Datasheet (Download)
- How to create Waterfall Chart in a Minute in Older Versions (Excel 2007, Excel 2010, Excel 2013, Excel 2016) – Template for Positive ups and downs (Download)
- 3D Models with Morph Transition – PowerPoint – Awesome Latest Feature (Download)
- Issue with Excel Sorting Dates | Excel Problem Solving Tips & Tricks Datasheet (Download)
- Hlookup (Download)
- How to sort data automatically in Excel – Part 1 (Download)
- Number format in excel | How effectively control and format numbers in Excel
- Find Missing Data using Vlookup and Conditional Formatting – Tamil (Download)
- Transpose – Rotate Row and Column in Excel (Download)
- How to Get Stock Market Live Data Feed / Market Analysis in Excel in Tamil (Download)
- Quick Analysis in Excel | A complete overview about this new feature in Tamil (Download)
- How to Combine or Consolidate Multiple Excel Files in a Single Workbook Using Power Query – Tamil (Download)
- Consolidate Excel Worksheets or Tabs Using Power Query – Part 2 – Tamil (Download)
- Pareto Chart in Tamil – Quick and manual methods to create Pareto Chart in Excel (Download)
- The top Powerful and Basic Keyboard Shortcut in Excel – Ctrl + 0 to 9 in Tamil (Download)
- The top Powerful and Basic Keyboard Shortcut in Excel – Ctrl + A to Z in Tamil (Download)
- Tips & Tricks to handle Find & Search options in Excel – Tamil (Download)
- Excel Column Chart and Combo Chart – Step by Step Guide for Beginner in Tamil (Download)
- How to Resize the date source quickly for a Pivot Table using Excel Table – Tamil (Download)
- How to use SumIF Excel Formula in Tamil – An alternative of Pivot Table (Download)
- How to use Hyperlink and GoTo in Excel – Tamil (Download)
- How to use Index and Match Functions (Download)
- Offset Function – Part 1 & 2 (Download)
- Waterfall Chart (Download)
- Pivot Table and Chart, How to use formulas in Pivot Table (Download)
- How to use Conditional Formatting in excel using Manual method and Macro with FOR EACH LOOP (Download)
- Unity of SumProduct, Sumifs, Countifs and PivotTable | SumProduct – Part 1-2 in Tamil (Download)
- Problem solving using SumProduct | Excel formula in Tamil (Download)
- Excel VBA Macro Basic for Beginners | How to Select a Cell or Range Using Simple VBA Coding (Download)
- How to extract Last Name from a full name in Excel – Part 1 (Download)
- How to extract Last Name from a full name in Excel – Part 2 (Download)
- Absolute and Relative Cell Reference – Cell Reference Part 1 (Download)
- Mixed Cell Reference – Cell Reference Part 2 (Download)
- Unity of IF, Index, Match and VLOOKUP | Advanced Excel Formula in Tamil | Which formula Should I Use (Download)
- Excel Formula Related Tips & Tricks in Tamil | 14 Secrets you should know while entering any formula (Download)
- Power Query – Part 3 – Merge Multiple Tables within Excel (Download)
- Secret Tips and Tricks to Control Slowness of an Excel File | Excel Problem Solving | in Tamil (Download)
- Excel VBA Basics | How to Create Message in Excel Using VBA Code | Excel VBA MsgBox in Tamil (Download)
- Advanced Excel Formula in Tamil | EOMONTH | Quickly Find Last Day or any Particular Day of a Month (Download)
- Fill Formulas only in the Blank Cells (Download)
- Power Query – Part 4 – Create Pivot Report from Multiple Unstructured Excel Tables (Download)
- PDF to Excel (Download)
- INDIRECT – Advanced Excel Formula in Tamil – Level 1- Convert Text into Proper Cell Reference (Download)
- INDIRECT – Advanced Excel Formula in Tamil – Level 2 – Consolidate Values from Multiple Tabs – Tamil (Download)
- Pivot Table and Chart – Learn it Using IPL Statistics – Pivot Table Part 1 in Tamil (Download)
- SORT Excel Formula in Tamil | New Calculation Engine with Dynamic Array (Download)
- Quick Pivot Table from Multiple Structured Data Sources (Download)
- Excel Tips and Tricks – Advanced Lookup in Conditional Formatting in Tamil (Download)
- Excel Advanced Filter – A Complete Tutorial in Tamil (Download)
- INDIRECT – Advanced Excel Formula in Tamil – Level 3 (Download)
- Excel Left Vlookup using Advanced Excel Formula | Index Match Multi Lookup | Prabas MS Office Tamil (Download)
- Mail Merge in Tamil – Send Bulk Email, Create Bulk Printouts using Mail Merge (Download)
- Excel VBA Basics | InputBox (Download)
- XLookup – Part 2 (Download)
- Excel Picture Lookup (Download)
- SubTotal (Download)
- Goal Seek (Download)
- VLOOKUP Extract 1st 2nd 3rd Matches (Download)
- Excel Paste Special – 20 Tips & Tricks (Download)
- How to Calculate Percentage in Excel (Download)
- Error – Type of ERRORS in Excel (Download)
- How to Create and Print Mailing Labels in Word using Excel (Download)
- Excel Count Formulas (Download)
- Excel VBA – For Each Loop (Download)
- Excel Table (Download)
- Artificial Intelligence (AI) on Microsoft Office (Download)
- Pivot Table – Summary & Year Manual Grouping (Download)
- Fill Blank Cells with Value Below or Above in Excel (Download)
- IF ERROR Formula (Download)
- Print Excel File with Page Wise Dynamic Total (Download)
- CONCAT vs CONCATENATE vs TEXTJOIN (Download)
- Format Painter (Download)
- Pull Data from Multiple Workbooks using VLOOKUP and IFERROR (Download)
- Excel Heat Map (Download)
- Excel Scenario Manager (Download)
- Excel Unique Formula (Download)
- Import CSV into Excel (Download)
- Excel Forecast Function (Download)
- Excel to Trigger or Highlight Expiry or Due date (Download)
- Excel Shortcuts to Make Quick Data Entry (Download)