Google Chrome Extensions
OnChrome Extension Tutorial 1: Introduction Chrome Extension Tutorial 2: manifest.json Chrome Extension Tutorial 3: Script Environments Chrome Extension Tutorial 4: Message Passing API Chrome Extension Tutorial 5: Introduction to popup.html Chrome Extension Tutorial 6: Overriding Chrome Pages Chrome Extension Tutorial 7: Creating…
Game Development
OnJava Game Development – 1 – Threads Java Game Development – 2 – Starting Threads Java Game Development – 3 – Creating a Screen for Games Java Game Development – 4 – Restoring Screen Size Java Game Development – 5 – Creating…
Excel VBA & Macros Tutorials
OnFreeEnglish Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording) Excel VBA tutorial for beginners: The Visual Basic Editor (VBE) Excel VBA tutorial for beginners: Object Properties & Methods Excel VBA: Referring to Ranges & Writing to…
Excel Lookup Formulas & Infographic Chart Templates
OnExcel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples How to use Excel Index Match (the right way) Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria) Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX Excel…
Excel Hacks – Tips & Tricks
OnFreeEnglish Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples How to use Excel Index Match (the right way) Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria) Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX…
Excel Dynamic Arrays
OnExcel Dynamic Arrays (How they will change EVERYTHING!) Searchable Drop Down List in Excel (Very Easy with FILTER Function) LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) ARE YOU READY for the NEW Excel?…
Excel Dashboards & Reports
On5 Design Tips for Better Excel Reports & Dashboards Excel Combo Box without VBA – How to create a drop-down list (Promo) Visually Effective Excel Dashboards Online Course – Now available! Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards…
Excel basics & Dropdown list in excel
OnBeginner module Syllabus covered Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) Excel Cell Reference: Absolute, Relative or Mixed? Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples Excel Hack: Copy Formula Without Changing Cell References…
Excel Advanced Charts & Visualization Techniques
OnImprove readability of Excel Line Charts: Dynamic Legends in Excel Excel Advanced Charts: Comparison to Budget, Previous Year and Forecast or Outlook 3 Tips for Impressive Excel Charts Microsoft Excel: How to Improve your Charts & Tables for Better Communication – Udemy…