Advanced Excel- Tips & Formulas to Work Smarter
Free English
Beginner module
syllabus covered
Advanced Excel: Top 10 Tips & Formulas to Work Smarter
Excel: Inspecting Excel Spreadsheets for hidden information
Master Excel’s SUMPRODUCT Formula
Excel: How to debug your Excel formulas and keep your eyes on certain cells
Excel: How to Best Import External Data into Excel & Import data from the Web to Excel
Excel OFFSET Function for Dynamic Calculations – Explained in Simple Steps
Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUM
Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)
Intermediate module
Syllabus covered
Excel SUMIFS: Sum Alternate Columns based on Criteria and Header
Excel Workday function: Find end date – exclude weekends & holidays
Excel NETWORKDAYS function: Calculate the number of working days between two dates
Excel Conditional Formatting with Symbols and Icons (for better reports)
Excel Goal Seek Explained in Simple Steps
Excel Solver example and step-by-step explanation
Excel Reset Week Number Every Month – (WeekDay & WeekNum Functions Explained)
Excel Conditional Formatting the Lookup result in data table (Index Match)
Advanced module
Syllabus covered
Excel MOD Function – Easy Explanation & Practical Examples of MOD for Work
Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells
Excel Sum(ifs) between dates, sum month & sum with multiple criteria
Return Multiple Match Results in Excel (2 methods)
VLOOKUP EXPLAINED – 2 Practical Excel Lookup Examples
How to Change the Number Format of a Cell Based on a Condition in Excel
Excel SUM based on Partial Text Match (SUMIFS with wildcards)
Count Day of Week Between Dates in Excel (How many Fridays?)
Expert module
Syllabus covered
Quick Excel Trick to Unstack Data from one Column to Multiple Columns
VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)
Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)
Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed)
Convert NUMBERS to WORDS (NO VBA) in Excel
Excel IF Function with PARTIAL Text Match (IF with Wildcards)
Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)
Artificial Intelligence
Free English
Beginner module
Syllabus covered
Social Network Analysis with Lada Adamic
Network Analysis in Systems Biology Coursera Promo by Professor Avi Ma’ayan
Digital Signal Processing with Paolo Prandoni and Martin Vetterli
Machine Learning: About the class
Intermediate module
Syllabus covered
Game Theory
Discrete Inference and Learning in Artificial Vision with Nikos Paragios and Paw
Computational Neuroscience with Rajesh P. N. Rao and Adrienne Fairhall
Artificial Intelligence Planning with Gerhard Wickler and Austin Tate
Advanced module
Syllabus covered
Image and video processing: From Mars to Hollywood with a stop at the hospital with Guillermo Sapiro
Making Better Group Decisions: Voting, Judgement Aggregation and Fair Division
Discrete Optimization with Pascal Van Hentenryck
Neural Networks for Machine Learning with Geoffrey Hinton
Expert module
Syllabus covered
Probabilistic Graphical Models with Daphne Koller
Web Intelligence and Big Data with Gautam Shroff
Computational Investing, Part I with Tucker Balch
Networked Life with Michael Kearns
Binary Tree Traversal
FreeEnglish
Beginner module
Syllabus covered
Binary Tree Traversal(Data Structures and Algorithms #10)
Level Order Traversal(Data Structures and Algorithms #11)
Inorder Traversal Iterative (Data Structures and Algorithms #12)
Preorder Traversal Iterative (Data Structures and Algorithms #13)
Intermediate module
Syllabus covered
Postorder Traversal Iterative Using Two Stacks (Data Structures and Algorithms #14)
Vertical Order Traversal (Data Structures and Algorithms #15)
Top View Of Binary Tree (Data Structures and Algorithms #16)
Left And Right View Of Binary Tree (Data Structures and Algorithms #18)
Advanced module
Syllabus covered
Diagonal Traversal Of Binary Tree (Data Structures and Algorithms #19)(Binary Tree #10)
Bottom View of Binary Tree (Data Structures and Algorithms #17)(Binary Tree #8)
Height Of Binary Tree (Data Structures and Algorithms #20)(Binary Tree #11)
Number Of Nodes In Binary Tree (Data Structures and Algorithms #21)(Binary Tree #12)
Expert module
Syllabus covered
Number of Leaf nodes In Binary Tree (Data Structures and Algorithms #22)(Binary Tree #13)
Boundary Traversal Of Binary Tree (Data Structures and Algorithms #23)(Binary Tree #14)
Convert a Binary Tree to It’s Mirror (Data Structures and Algorithms #25)(Binary Tree #15)
Spiral Level Order Traversal (Data Structures and Algorithms #26)(Binary Tree #16)
Binary Tree Traversal For Beginners
Free English
Beginner module
Syllabus covered
Binary Tree Traversal (Data Structures and Algorithms #10)
Level Order Traversal (Data Structures and Algorithms #11)
Intermediate module
Syllabus covered
Inorder Traversal Iterative (Data Structures and Algorithms #12)
Preorder Traversal Iterative (Data Structures and Algorithms #13)
Postorder Traversal Iterative Using Two Stacks (Data Structures and Algorithms #14)
Advanced module
Syllabus covered
Height Of Binary Tree (Data Structures and Algorithms #20)
Number Of Nodes In Binary Tree (Data Structures and Algorithms #21)
Expert module
Syllabus covered
Number of Leaf nodes In Binary Tree (Data Structures and Algorithms #22)
Spiral Level Order Traversal (Data Structures and Algorithms #23)
C Program
Free English
Beginner module
Syllabus covered
C Programming Tutorial: Input Output
C programming: Data Types:Lesson 1
C Programming Tutorial: Operator and Expressions (Arithmetic, Logical, Relational )
C Programming Tutorial: Operator and Expressions (Arithmetic, Logical, Relational )
C Programming Tutorial: Decision Making and Looping (if else for while)
C Programming Tutorial: Decision Making and Looping (if else for while) Lesson1
Intermediate module
Syllabus covered
C Programming Tutorial: Conditional Statements (IF, ELSE, ELSE IF)
C Programming Tutorial: Switch statements
C Programming Tutorial: While, do While Loop, Continue, Break
C Programming Tutorial :For Loops in C
C Programming: Looping (Break, Continue, Goto)
C Programming Tutorial:Functions (return , arguments, name)
C Programming Tutorial: Functions (Call By Value, Reference,passing Arrays to function)
Advanced module
Syllabus covered
C Programming Tutorial: Storage Class
C Programming: C Preprocessor
C Programming: C Preprocessor (Macros with Arguments, Nested Macros)
C Programming: Pointers (Memory Layout, Need of Pointers)
C Programming: Pointers (Referencing Dereferencing, Single, Double Pointer)
C Programming: Pointers (Pointer Arithmetic)
C Programming: Pointers (Pointer and Arrays, Memory Layout)
Expert module
Syllabus covered
C Programming: Pointers (Argument to Function, Pointers as Return Type)
C Programming :Pointers (Pointers Two Dimensional Array)
C Programming: Function Pointers and Call back functions
C Programming: Structures: (Copying, Comparing, Accessing, Array)
C Programming: Structures (Declaration, Access, Initialization, Pointers)
C Programming: File Handling (fopen,fclose,fputc,fgetc)
C advanced
Free English
Beginner module
Syllabus covered
C Programming Tutorial – 1 – Hello World
C Programming Tutorial – 2 – Intro to Variables
C Programming Tutorial – 3 – Comments and Math Functions C Programming Tutorial – 4 – If Statement Decision
C Programming Tutorial – 5 – If, Else If, Else Statements
C Programming Tutorial – 6 – While Loops
C Programming Tutorial – 7 – More on Loops
C Programming Tutorial – 8 – Switch Statement
Advanced module
Syllabus covered
C Programming Tutorial – 9 – Do While Loops
C Programming Tutorial – 10 – Logical Operators
C Programming Tutorial – 11 – Into to Functions
C Programming Tutorial – 12 – Random Number Function
Expert module
Syllabus covered
C Programming Tutorial – 13 – Seeding Random Numbers
C Programming Tutorial – 14 – Intro to Arrays
C Programming Tutorial – 15 – Simple Array Program
CSS Animations English
Free English
Beginner module
Syllabus covered
Introduction to Web Animations
CSS Animations
CSS Transitions
CSS Animations vs. Transitions
Intermediate module
Syllabus covered
Easing Functions in CSS
Meet the Actual Easing Functions
CSS Animation Events
Animation Loops in JavaScript using request Animation Frame
Advanced module
Syllabus covered
Creating Buttery Smooth Animations in CSS
DOM vs. Canvas
Slide an Image on Hover Using a CSS Transition
CSS Transition Event
Expert module
Syllabus covered
The Ken Burns Effect in CSS
Getting Jittery on Hover (Using a CSS Animation)
Recreating the Blink Tag
Move Element to Mouse Click Position
CSS Grid and Flexbox
Free English
Beginner module
Syllabus covered
CSS Layouts – Flexbox vs Grid vs Float
Getting Started with Flexbox
Replacing Float with Flex box in Nav Menus
Intermediate module
Syllabus covered
Responsive Forms with Flexbox and Media Queries
Intro to CSS Grid
CSS Grids – Named Grid Areas
Advanced module
Syllabus covered
CSS Grids with Unequal Columns
CSS Grid and Positioning Elements
Overlapping CSS Grid Elements
Expert module
Syllabus covered
Centering Anything with CSS
CSS Grid and grid auto flow
Data Structures 101
Free English
Beginner module
Syllabus covered
Data structures introduction
Abstract data types
Introduction to Big-O
Dynamic and Static Arrays
Dynamic Array Code
Linked Lists Introduction
Doubly Linked List Code
Stack Introduction
Stack Implementation
Stack Code
Queue Introduction
Queue Implementation
Queue Code
Priority Queue Introduction
Intermediate module
Syllabus covered
Priority Queue Min Heaps and Max Heaps
Priority Queue Inserting Elements
Priority Queue Removing Elements
Priority Queue Code
Union Find Introduction
Union Find Kruskal’s Algorithm
Union Find – Union and Find Operations
Union Find Path Compression
Union Find Code
Binary Search Tree Introduction
Binary Search Tree Insertion
Binary Search Tree Removal
Binary Search Tree Traversals
Binary Search Tree Code
Hash table hash function
Advanced module
Syllabus covered
Hash table separate chaining
Hash table separate chaining source code
Hash table open addressing
Hash table linear probing
Hash table quadratic probing
Hash table double hashing
Hash table open addressing removing
Hash table open addressing code
Fenwick Tree range queries
Fenwick Tree point updates
Fenwick Tree construction
Fenwick tree source code
Suffix Array introduction
Longest Common Prefix (LCP) array
Suffix array finding unique substrings
Expert module
Syllabus covered
Longest common substring problem suffix array
Longest common substring problem suffix array part 2
Longest Repeated Substring suffix array
Balanced binary search tree rotations
AVL tree insertion
AVL tree removals
AVL tree source code
Indexed Priority Queue | Data Structure
Indexed Priority Queue | Data Structure | Source Code
Design Patterns
Free English
Beginner module
Syllabus covered
Strategy Pattern – Design Patterns (ep 1)
Observer Pattern – Design Patterns (ep 2)
Decorator Pattern – Design Patterns (ep 3)
Factory Method Pattern – Design Patterns (ep 4)
Abstract Factory Pattern – Design Patterns (ep 5)
Intermediate module
Syllabus covered
Singleton Pattern – Design Patterns (ep 6)
Command Pattern – Design Patterns (ep 7)
Adapter Pattern – Design Patterns (ep 8)
Facade Pattern – Design Patterns (ep 9)
Proxy Pattern – Design Patterns (ep 10)
Bridge Pattern – Design Patterns (ep 11)
Advanced module
Syllabus covered
Structural Patterns (comparison) – Design Patterns (ep 12)
Template Method Pattern – Design Patterns (ep 13)
Composite Pattern – Design Patterns (ep 14)
Difference Between Composite and Decorator Pattern – Design Patterns (ep 15)
Iterator Pattern – Design Patterns (ep 16)
State Pattern – Design Patterns (ep 17)
Expert module
Syllabus covered
Null Object Pattern – Design Patterns (ep 18)
Dynamic Programming
FreeEnglish
Beginner module
Syllabus covered
Dynamic Programming for Interviews
Interview Question: Smallest Change
Intermediate module
Syllabus covered
Interview Question: Longest Common Substring
Interview Question: Fibonacci Number
Interview Question: Square Submatrix
Advanced module
Syllabus covered
Interview Question: Matrix Product
Interview Question: 0-1 Knapsack
Electron Framework
Free English
Beginner module
Syllabus covered
Learn Electron Framework [Beginner]: Tutorial 1
Electron Tutorial 2: Installing Electron
Electron Tutorial 3: Hello World
Electron Tutorial 4: Electron Processes
Electron Tutorial 5: Hello World Explained
Intermediate module
Syllabus covered
Electron Tutorial 6: BrowserWindow
Electron Tutorial 7: Frameless Window
Electron Tutorial 8: remote
Electron Tutorial 9: globalShortcuts and Accelerators
Electron Tutorial 10: Crazy Images Part 1
Advanced module
Syllabus covered
Electron Tutorial 11: Electron + AngularJS (Crazy Images Part 2)
Electron Tutorial 12: dialog (Crazy Images Part 3)
Electron Tutorial 13: Crazy Images Part 4
Electron Tutorial 14: Crazy Images Part 5 – File Picker
Electron Tutorial 15: Crazy Images Part 6 – Adding Image Effects
Expert module
Syllabus covered
Electron Tutorial 16: Crazy Images Part 7 – Adding Image Effects
Electron Tutorial 17: Crazy Images Part 8
Electron Tutorial 18: Crazy Images Part 9
Electron Tutorial 19: Crazy Images Part 10 – Saving Images
Electron Tutorial 20: Crazy Images Part 11 – Saving Images
Excel Advanced Charts & Visualization Techniques
Free English
Beginner module
Syllabus covered
Improve 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 Promo
Excel Charts: Visualize your KPI on a map in ANY version of Excel
Excel Charts: Sorted Bar Chart as Alternative to the Pie Chart
Excel Charts: Matrix or Excel Panel Charts – Showing many variables at once
Excel Tables: Best Practice to Create Tables for Financial Reporting in Excel
How to Conditionally Format Symbol colors in Excel Tables (without Conditional Formatting)
Excel Tables: Use Smart Conditional Formatting for great table layout
Intermediate module
Syllabus covered
Excel Variance Charts: Actual to Previous Year or Budget Comparisons
Better Excel Variance Charts to show percentage change (Simple & uncommon technique)
Excel Arrow Variance Chart: Dynamic Arrows in Chart to Show Change to Previous Year / Budget
Excel Charts: Total Values for Stacked Charts in Excel
Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability
Excel Charts: How To Show Percentages in Stacked Charts (in addition to values)
Quick Gantt Chart in Excel (Unusual technique)
Fully Featured Excel Gantt Chart – actual, planned & percentage completed
How to add series lines / connectors to stacked column charts in Excel
Skip Dates in Excel Charts (ignore gaps in Excel horizontal chart axis)
Advanced module
Syllabus covered
Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)
Excel Charts & Graphs: Learn the Basics for a Quick Start
Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioning
Excel Dynamic Chart with Drop down List (column graph with average line)
Excel Dynamic Chart with Drop down List (column graph with average line)
Excel Column Chart – Stacked and Clustered combination graph
How to create a Step Chart in Excel (that is fully dynamic & easy to read)
How to create a dynamic map chart with drop-down (works with ANY Excel version)
Dynamic WordArt in Excel with Bar in Bar Chart (Info-chart that shows % completion)
Excel VBA: Adjust Fill Color of WordArt with a Macro
Expert module
Syllabus covered
Build Impressive Charts: It’s NOT your usual Bar Chart (Infographics in Excel)
Easiest Step Chart in Excel (this trick will surprise you!)
3 Handy Excel Chart Tips You Might Have Missed
Excel Conditional Bar Chart with Drop-down & Icons (This Chick’s Trouble for Excel Hash)
How to Create a Sales Funnel Chart in Excel (Not the ‘usual’ Funnel)
Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)
Charting Survey Results in Excel (Visualize Employee Satisfaction results)
Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)
GUESS what’s HIDDEN in Excel? (Cool Trick)
Progress Circle Chart in Excel as NEVER seen before!
Excel basics & Dropdown list in excel
FreeEnglish
Beginner 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 (or Without File References)
How to set Default Workbook Theme in Excel and how this could help you save time
Excel Filter Basics (for quick data analysis)
Advanced Excel Filter (And, Or, Between conditions for criteria range)
Data Validation in Excel – should you include these in your files?
Excel Custom Data Validation (Use formulas to check for text, numbers & length)
Intermediate module
Syllabus covered
3 Handy Excel Chart Tips You Might Have Missed
Excel Header & Footer (& Quickly Copy to other Sheets)
Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort
3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)
3 Methods to Unhide All Sheets in Excel (& how to hide)
Excel’s Find and Replace (surprising features)
All about Excel Comments (Notes) in 8 Minutes! Shortcut Keys, Customize Background & More
Calculate Percentages the Right Way in Excel (% Change & Amount after % increase)
Better Excel Presentations: Increase Font Size of Formula Bar
Advanced module
Syllabus covered
Change CASE of text in Excel (3 ways including NO Formulas)
Why you SHOULD be USING Custom Number Formatting in Excel
Lock Cells & Protect Excel Worksheet – EVEN by Cell Color!
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)
The QUICKEST & EASIEST Way to Work with TEXT in Excel
Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT
Excel Simple Dependent Drop down List based on numbers (Index without match)
Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List
Excel Dependent Drop Down List with Tabular Data without Named Ranges
Expert module
Syllabus covered
Excel: Extract unique items for dynamic data validation drop down list
Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)
Data Validation in Excel – should you include these in your files?
Excel Custom Data Validation (Use formulas to check for text, numbers & length)
Smart Dep. Drop-Down Lists in Excel: Expandable & Exclude Blank Cells
Excel Dynamic Arrays (How they will change EVERYTHING!)
This Excel Dependent Combo Box Solves an Annoying Problem (you’ve probably had this)
Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
Excel Dashboards & Reports
FreeEnglish
Beginner module
Syllabus covered
5 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 Pivot Chart with Slicers for Months to Show Values by Weekday Names
Intermediate module
Syllabus covered
4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel – Part 1
Unusual use of Excel’s Custom Number Formatting with Conditions & Symbols (Part 2)
Excel Slicer Trick – Use Symbols instead of Text in Pivot Slicers
Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List
Excel Dependent Drop Down List with Tabular Data without Named Ranges
Advanced module
Syllabus covered
Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT
Excel: Extract unique items for dynamic data validation drop down list
Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)
Excel Picture Lookup: 5 easy steps for dynamic images
Excel Custom Formatting with Thresholds & Icons: Quick & easy
Advanced module
Syllabus covered
Excel Conditional Bar Chart with Drop-down & Icons (This Chick’s Trouble for Excel Hash)
How to Change the Number Format of a Cell Based on a Condition in Excel
Excel Dynamic Arrays
FreeEnglish
Beginner module
Syllabus covered
Excel Dynamic Arrays (How they will change EVERYTHING!)
Searchable Drop Down List in Excel (Very Easy with FILTER Function)
Intermediate module
Syllabus covered
LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)
ARE YOU READY for the NEW Excel?
Advanced module
Syllabus covered
Excel Array Formula: Count Rows with OR condition – SUMPRODUCT & FREQUENCY Functions (Part 1/3)
Excel Array Formula: Count Rows with OR Condition – Excel MMULT Function (Part 2/3)
Expert module
Syllabus covered
Excel Array Formula: Count Rows based on OR condition – Excel MMULT, INDIRECT Functions (Part 3/3)
Excel Hacks – Tips & Tricks
FreeEnglish
Beginner module
Syllabus covered
Quick Excel Trick to Unstack Data from one Column to Multiple Columns
Excel Custom Formatting with Thresholds & Icons: Quick & easy
3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)
Intermediate module
Syllabus covered
How to Create a Sales Funnel Chart in Excel (Not the ‘usual’ Funnel)
Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
3 Methods to Unhide All Sheets in Excel (& how to hide)
Advanced module
Syllabus covered
VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)
Better Excel Presentations: Increase Font Size of Formula Bar Convert NUMBERS to WORDS (NO VBA) in Excel
Expert module
Syllabus covered
Why you SHOULD be USING Custom Number Formatting in Excel
The QUICKEST & EASIEST Way to Work with TEXT in Excel
Excel Lookup Formulas & Infographic Chart Templates
FreeEnglish
Beginner module
Syllabus covered
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 INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs
Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header
Intermediate module
Syllabus covered
Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT
Excel Formula Lookup Multiple Results: Return headers based on matrix values
TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin
Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel
Return Multiple Match Results in Excel (2 methods)
VLOOKUP EXPLAINED – 2 Practical Excel Lookup Examples
Advanced module
Syllabus covered
Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)
LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)
Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)
This Excel Chart will grab your attention (Infographic template included)
How to create a dynamic map chart with drop-down (works with ANY Excel version)
Build Impressive Charts: It’s NOT your usual Bar Chart (Infographics in Excel)
Expert module
Syllabus covered
Creative infographics in Excel (Male, Female icons)
How to Create a Sales Funnel Chart in Excel (Not the ‘usual’ Funnel)
GUESS what’s HIDDEN in Excel? (Cool Trick)
Progress Circle Chart in Excel as NEVER seen before!
Excel VBA & Macros Tutorials
FreeEnglish
Beginner module
Syllabus covered
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 Cells (Range, Cells, Offset, Names)
Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)
Intermediate module
Syllabus covered
Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)
Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)
Excel VBA: Loop through cells inside the used range (For Each Collection Loop)
How to use the Message Box in Excel VBA (syntax you’ll need for msgbox)
Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook
Advanced module
Syllabus covered
Excel VBA FIND Function (& how to handle if value NOT found)
Excel ActiveX Combo Box to Select Worksheets with VBA
Link Page Header to Cell Value with Excel VBA
Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder
Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
Expert module
Syllabus covered
3 Methods to Unhide All Sheets in Excel (& how to hide)
Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)
Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA
How to SUM Cells by Color in Excel (Get it to update automatically)
Game Development
FreeEnglish
Beginner module
Syllabus covered
Java 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 a Full Screen Display
Java Game Development – 6 – Making Text Smooth
Java Game Development – 7 – Loading Images
Java Game Development – 8 – Beginning Animation
Java Game Development – 9 – Changing Scenes
Intermediate module
Syllabus covered
Java Game Development – 10 – Finishing the Animation Class
Java Game Development – 11 – Loading Pictures for the Movie
Java Game Development – 12 – Main Movie Loop
Java Game Development – 13 – Completing the Animation
Java Game Development – 14 – Making a Better Screen Class
Java Game Development – 15 – Finding Compatible Modes
Java Game Development – 16 – Comparing Display Modes
Java Game Development – 17 – Full Screen with Buffer Strategy
Java Game Development – 18 – Updating Display and Restore Screen
Advanced module
Syllabus covered
Java Game Development – 10 – Finishing the Animation Class
Java Game Development – 11 – Loading Pictures for the Movie
Java Game Development – 12 – Main Movie Loop
Java Game Development – 13 – Completing the Animation
Java Game Development – 14 – Making a Better Screen Class
Java Game Development – 15 – Finding Compatible Modes
Java Game Development – 16 – Comparing Display Modes
Java Game Development – 17 – Full Screen with Buffer Strategy
Java Game Development – 18 – Updating Display and Restore Screen
Expert module
Syllabus covered
Java Game Development – 28 – Intro to Keyboard Input
Java Game Development – 29 – Handling Key Events
Java Game Development – 30 – Final Keyboard Input
Java Game Development – 31 – User Mouse Input
Java Game Development – 32 – Final Mouse Input
Java Game Development – 33 – Intro to Mouselook
Java Game Development – 34 – Mouselooks draw Method
Java Game Development – 35 – Using the Robot
Java Game Development – 36 – Final Mouselook Program
Google Chrome Extensions
FreeEnglish
Beginner module
Syllabus covered
Chrome 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 Custom Toolbar
Chrome Extension Tutorial 8: Twitter Social Toolkit – Part 1
Chrome Extension Tutorial 9: Twitter Social Toolkit – Part 2
Chrome Extension Tutorial 10: Twitter Social Toolkit – Part 3
Intermediate module
Syllabus covered
Chrome Extension Tutorial 11: Twitter Social Toolkit – Part 4
Chrome Extension Tutorial 12: Twitter Social Toolkit – Part 5
Chrome Extension Tutorial 13: Publishing Chrome Extension!
Chrome Extension Tutorial 14: Download .crx Chrome Extension
Chrome Extension Tutorial 15: Rich Notifications (Part 1)
Chrome Extension Tutorial 16: Rich Notifications (Part 2)
Chrome Extension Tutorial 17: Rich Tweet Notification Plugin – Part 1
Chrome Extension Tutorial 18: Rich Tweet Notification – Part 2
Chrome Extension Tutorial 19: Rich Tweet Notification – Part 3
Chrome Extension Tutorial 20: Rich Tweet Notification – Part 4
Advanced module
Syllabus covered
Chrome Extension Tutorial 21: Rich Tweet Notification – Part 5
Chrome Extension Tutorial 22: Rich Tweet Notifier Plugin Explained
Chrome Extension Tutorial 23: Introduction To chrome.storage
Chrome Extension Tutorial 24: More On chrome.storage
Chrome Extension Tutorial 25: Developing Extension On chrome.storage – Part 1
Chrome Extension Tutorial 26: Developing Extension On chrome.storage – Part 2
Chrome App Tutorial 27: desktopCapture API – Part 1
Chrome App Tutorial 28: desktopCapture API – Part 2
Google Chrome App Tutoriual 29: desktopCapture API – Part 3
Google Chrome App Tutoriual 30: desktopCapture API – Part 4
Expert module
Syllabus covered
Chrome Extension Tutorial 31: desktopCapture API – Part 5
Chrome Extension Tutorial 32: chrome.tabs.create – Part 1
Chrome Extension Tutorial 33: chrome.tabs.create – Part 2
Chrome Extension Tutorial 34: chrome.tabs.executeScript – Part 1
Chrome Extension Tutorial 35: chrome tabs executeScript – Part 2
Chrome Extension Tutorial 36: chrome tabs executeScript – Part 3
Chrome Extension Tutorial 37: Connecting To Database – Part 1
Chrome Extension Tutorial 38: Connecting To Database – Part 2
Chrome Extension Tutorial 39: Connecting To Database – Part 3
Chrome Extension Tutorial 40: Connecting To Database – Part 4
HCI
FreeEnglish
HTML5 API’S
FreeEnglish
HTML5 Canvas
FreeEnglish
Introduction to HTML
FreeEnglish
IOT 101
FreeEnglish
Javascript
FreeEnglish
JavaScript AJAX
FreeEnglish
LINQ
FreeEnglish
MAC Os
FreeEnglish
Master Recursion Backtracking
FreeEnglish
Photoshop
FreeEnglish
Programming Methodology
FreeEnglish
Recursion – Data Structures & Algorithms
FreeEnglish
RestfulServices WCF English
FreeEnglish
RUST Programming
FreeEnglish
System Design Interview Questions
FreeEnglish
Technical Talks
FreeEnglish
TypeScript
FreeEnglish
Websockets
FreeEnglish
Xamarin 101
FreeEnglish