video
Excel: Case Sensitive VLOOK UP
In this Excel tutorial, we will be looking at an example where multiple formulas and functions are used to carry out the desired operations.
Microsoft Excel: Resources
116 available
video
Excel Examples: Separate Name And ID
In this Excel tutorial, we will be looking at an example where multiple formulas and functions are used to carry out the desired operations.
video
Excel Example: Find Days Of A Month
In this Excel tutorial, we will be looking at an example where multiple formulas and functions are used to carry out the desired operations.
video
Excel Examples: Advanced Index
In this Excel tutorial, we will be looking at an example where multiple formulas and functions are used to carry out the desired operations.
video
Excel Examples: Counting Words From Any Cell
In this Excel tutorial, we will be looking at an example where multiple formulas and functions are used to carry out the desired operations.
video
Excel Examples: Monthly Report
In this video tutorial, we are going to make a monthly report about the performance of sales persons.
video
Excel: Making of Dashboard (Part 3)
In this video tutorial, we are going to make a Dashboard with the help of Pivot Table. This is last part of a three part tutorial on this topic.
video
Excel: Making of Dashboard (Part 2)
In this video tutorial, we are going to make a Dashboard with the help of Pivot Table. This is part two of the three part tutorial on this topic.
video
Excel: Making of Dashboard (Part 1)
In this video tutorial, we are going to make a Dashboard with the help of Pivot Table. This is part one of the three part tutorial on this topic.
video
Excel Examples: Different Types of Serial Numbers
In this video tutorial, we have tried to create serial numbers in Excel in multiple ways usi ng fuctions like IF, MOD, ROWS, MAX, LEN, and TRIM.
video
Excel Examples: Serial Numbers (Cricket Overs)
In this video tutorial we are going to discuss a few functions like ROWS, INT, and lots of complex formulas.
video
Excel: Custom Number Format (Part 3)
In this video tutorial, we will discuss Custom Number Formats, which can control the display of different numerical values.
video
Excel: Custom Number Format (Part 2)
In this video tutorial, we will discuss Custom Number Formats, which can control the display of different numerical values.
video
Excel Examples: IF, NOT, EXACT, & INDEX Functions
In this video tutorial we are going to use functions like IF, NOT, EXACT, INDEX to fulfil the requirement.
video
Excel Examples: Product Code
In this video tutorial we are going to use a few functions to fulfil our requirements to arrange data set titled "Product Code".
video
Excel: SWITCH Function
SWITCH This function in Excel compares one value against a list of values, and returns a result corresponding to the first match found. When no match is found, SWITCH can return an optional default value. You can use the SWITCH function when you want to perform a “self-contained” exact match lookup with several possible results. When no match is found, SWITCH can return an optional default value. The first argument in SWITCH is called “expression” and can be a hard-coded constant, a cell reference, or a formula that returns a specific value to match against. Matching values and corresponding results are entered […]
video
Excel: IFS Function
This video tutorial talks about the IFS Function in Excel which can run multiple tests and return a value corresponding to the first TRUE result.
video
Excel: Text To Column Option
Text To Column option is used for separated text available in a cell or column to the columns by splitting them with different criteria.
video
Excel: PRODUCT, POWER & SQRT Functions
This video talks about three of the most advanced and important features in Excel. They are called PRODUCT, POWER AND SQRT functions.
video
Excel: Flash Fill Tool
Flash Fill is a tool in excel that automatically fills your data when it senses a pattern nearby row or column.