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.
Tag Archives: Excel
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.
GETPIVOTDATA function in Excel
Hello all. Another short section regarding getpivotdata function in excel. Getpivotdata function uses / queries the existing Pivot table and returns data based on specified conditions as arguments. Syntax =getpivotdata(data_field, pivot_table, [field1,item1],..) Here, data_field is the name of the value field to be queried. Pivot_table is the reference to any cell in the pivot table.Continue reading “GETPIVOTDATA function in Excel”
FormulaText function in Excel
Hello all. In this short section, let’s cover the formulatext function in excel. Formulatext field would return the formula used in the reference cell as a text value. Syntax =Formulatext(ref) Here, ref is any cell reference. Working Example In the below example, I have used an offset function to return the ops metrics for FebContinue reading “FormulaText function in Excel”