## 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)

#### 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

Network Analysis in Systems Biology Coursera Promo by Professor Avi Ma’ayan

Digital Signal Processing with Paolo Prandoni and Martin Vetterli

### 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

#### 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)

#### 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)

#### 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)

#### 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)

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

#### 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

#### 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)

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

#### 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

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

#### Syllabus covered

Hash table separate chaining

Hash table separate chaining source code

Hash table linear probing

Hash table double hashing

Fenwick Tree range queries

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)

#### 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

#### 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

#### 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)

#### 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!

View

## 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

#### 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!

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

#### 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

#### 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?

#### 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)

#### 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

#### 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

#### Syllabus covered

Excel VBA FIND Function (& how to handle if value NOT found)

Excel ActiveX Combo Box to Select Worksheets with 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 – 8 – Beginning Animation

Java Game Development – 9 – Changing Scenes

### Intermediate module

#### Syllabus covered

Java Game Development – 10 – Finishing the Animation Class

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

#### Syllabus covered

Java Game Development – 10 – Finishing the Animation Class

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

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 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

#### 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

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View

FreeEnglish

View