## Video – Conditional Formatting in Excel

Hello all. Here is the video tutorial about conditional formatting in excel. I hope you like this video. Please help in sharing the content. Thanks for watching.

## Video – Lookup functions in Excel covering Vlookup, Hlookup and Xlookup

Hello all. In this video tutorial, we will see the lookup functions in excel. Thanks for watching. Please help by subscribing and sharing the content.

## 25 shortcuts in Excel that are not commonly used

Hello all. Here is the video on 25 shortcuts on Excel. Please help by sharing the content.

## Video – how to create dynamic graphs in excel

Hello all. In this video, we are looking at how to create dynamic graphs in excel. I hope you like this video. Please help by sharing our content. Thanks for watching.

## Video – How to import & interpret .CSV file with Power Query

Hello all. In this video, we shall see the use of power query to import and interpret a .csv file. I hope you like this video. Please help by sharing our content. Thanks for watching!

## Video – All about Pivot table in Excel

Hello all. In this video tutorial, we are covering everything about pivot table in excel. I hope you like this video. Please help us by sharing our content. Thanks for watching.

## Video – Count function in Excel

Hello all. In this video tutorial, we will be looking at the count function. We will be covering count, counta, countblank, countif and countifs functions. I hope you liked this video. Please help by sharing our content. Thanks for watching.

## Video – SUM function in Excel

Hello all. This is a video tutorial covering the sum function in excel. We will cover sum, sumif, sumifs and sumproduct function. I hope you like this video. Please help us by sharing the content. Thanks for watching.

## Conditional Formatting – an introduction

Hello all. Let’s look at an introduction to conditional formatting. Conditional formatting is an excellent way to visualize data set in Excel. There are some pre-defined rules that Excel provides to visualize. However you can manually create rules, using formulas, to visualize data. Pre-Defined Rules Let’s look at the below data set – we need … Read more

## Random Name / text picker – with Index function

Hello all. We have already seen random name picker here – there we used the CHOOSE function. Let’s see how to use generate random name (text) using the INDEX function. Index function returns the value of the cell at an intersection of specified row and column. With Index as the base, we shall see how … Read more