11May/19

How to Use Data Table Effectively in Excel

May 11, 2019Advance Excel Functionall about data table, Data Table, data table with one variable, data table with two variable, how to use data tableSachin chetnani

Hello Friends Its Sachin Here with another wonderful blog on Data Table in Excel The need of This blog arise when i was working with a business model where there were soRead More…

05May/19

How To Count Unique Values From Table in Excel :-)

May 5, 2019UncategorizedArray formulas, Counting unique values formula, finding count of unique invoices, unique values countSachin chetnani

Hello Friends Its Sachin Here with another wonderful blog on counting unique value with the help of an array formula. the need of this blog arise when i was working with oneRead More…

10Apr/19

Here are your free excel tips my friend

April 10, 2019Free Weekly Tipsarrange worksheet, Data Sort, Excelwala.com, Free Tips, Short cut key to auto adjust column, Substract % in excel, Weekly tipsSachin chetnani

1.) How to Filter data on the basis of color – In excel u must have heard about Filter option which is used to filter the data on the basis of ourRead More…

26Mar/19

Here are your Free Excel Tips My friend :-)

March 26, 2019Free Weekly TipsWeekly Tips for ExcelSachin chetnani

1.) How To Convert Positive numbers into Negative – Part 1 Sometime While working with negative numbers we do forgot to add Minus in the start of number and its a bitRead More…

06Mar/19

INDEX + MATCH Function and Why you should use it Over VLOOKUP

March 6, 2019Advance Excel FunctionSachin chetnani

Hello Friends its Sachin here with another blog on Index + Match Function. The need for this blog arise when i was working on an data set where i wanted to extractRead More…

06Mar/19

Wildcard Character – In Excel and Their Best use

March 6, 2019Excel BasicsFind something with one word in excel, How to find name starting with in excel, What are wildcard Characters, Wildcard in excelSachin chetnani

Hello friends its Sachin here with new blog on Wildcard character in excel. In this blog we are the going to learn the following: 1.) What are Wildcard character 2.) How canRead More…

06Mar/19

Difference between Relative and Absolute reference in Excel

March 6, 2019Excel BasicsAbsolute reference in excel, Difference between relative and absolute reference in excel, Relative reference in excel, What is cell refereneceSachin chetnani

Hello friends its Sachin here with another blog on Absolute and relative reference in excel. In this blog we are going to learn the following. 1.) What are cell references 1.) WhatRead More…

05Mar/19

Basic rules of Excel

March 5, 2019Excel BasicsExcel baics, Excel baiscs, Golden rules for excel, what are basic rule of excelSachin chetnani

Hello friends its Sachin here with another blog on basic rules for Excel. The need for this blog Arise when i saw some of spreadsheets of my friends. After Analyzing their spreadsheetsRead More…

04Mar/19

Count Ifs and its use in Excel

March 4, 2019Excel functionsCountifs example in excel, how to use countifs function, Mistakes of countifs function in exce, Syntax of countifs functionSachin chetnani

Hello friends its Sachin here with another blog on Count Ifs function of excel. In this blog we going to learn the following things about Count ifs function 1.) Syntax and insightRead More…

03Mar/19

SUM IFS Formula in Excel and its uses

March 3, 2019Excel functionsHow Sumifs work, How to use Sumifs function in excel, Mistake in Sumifs function in excel, Practical uses of Sumifs function, Sumifs in excelSachin chetnani

Hello friends its Sachin here with another blog on Sum Ifs formula of excel. In this blog we will learn the following things about this formula Sum Ifs function short and sweetRead More…