Free Excel Training and Courses
Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements



Learn By Doing

Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements



Learn By Doing

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.



Make Practice

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.



Make Practice

Practice: Understanding Absolute References-II

Practice: Understanding Absolute References-II

Using basic functions with more practices.



Make Practice

Practice: Understanding Absolute References-II

Practice: Understanding Absolute References-II

Using basic functions with more practices.



Make Practice

Most Popular Movies

Most Popular Movies

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...



Learn By Doing

Most Popular Movies

Most Popular Movies

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...



Learn By Doing

World Internet Users Statistics

World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.



Learn By Doing

World Internet Users Statistics

World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.



Learn By Doing

Practice: Basic functions-III

Practice: Basic functions-III

Using basic functions with more practices.



Make Practice

Practice: Basic functions-III

Practice: Basic functions-III

Using basic functions with more practices.



Make Practice

Practice: Basic functions-I

Practice: Basic functions-I

Using basic functions with more practices.



Make Practice

Practice: Basic functions-I

Practice: Basic functions-I

Using basic functions with more practices.



Make Practice

Calculate Data with MAXIFS() and MINIFS()

Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.



Learn By Doing

Calculate Data with MAXIFS() and MINIFS()

Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.



Learn By Doing

Expense Sheet

Expense Sheet

Using Nested IF.



Learn By Doing

Expense Sheet

Expense Sheet

Using Nested IF.



Learn By Doing

Profitability of a Theater

Profitability of a Theater

Using four operations and statistical functions over a scenario about play tickets status of a theater.



Learn By Doing

Practice: Basic functions-II

Practice: Basic functions-II

Using basic functions with more practices.



Make Practice

Practice: Basic functions-II

Practice: Basic functions-II

Using basic functions with more practices.



Make Practice

Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements



Learn By Doing

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.



Make Practice

Practice: Understanding Absolute References-II

Practice: Understanding Absolute References-II

Using basic functions with more practices.



Make Practice

Most Popular Movies

Most Popular Movies

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...



Learn By Doing

Practice: Basic functions-III

Practice: Basic functions-III

Using basic functions with more practices.



Make Practice

Practice: Basic functions-I

Practice: Basic functions-I

Using basic functions with more practices.



Make Practice

Practice: Basic functions-II

Practice: Basic functions-II

Using basic functions with more practices.



Make Practice

World Internet Users Statistics

World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.


Pro

Learn By Doing

Calculate Data with MAXIFS() and MINIFS()

Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.


Pro

Learn By Doing

Expense Sheet

Expense Sheet

Using Nested IF.


Pro

Learn By Doing