COUNTIF in Excel – Naukri Learning
Learn how to use the COUNTIF function in Excel using different criteria via different examples.
Tag: Excel functions
TRANSPOSE in Excel – Naukri Learning
by Rashmi Karan
LAST UPDATED: June 29, 2022, 17:13 IST
Learn how to transpose data in Excel and quickly change the orientation of columns and rows in a spreadsheet.
Mail Merge in Excel – Naukri Learning
by Rashmi Karan
LAST UPDATED: June 28, 2022, 17:58 IST
Mail Merge in Excel is widely used to simultaneously generate large amounts of documents while sticking to an agreed-upon or required format. Read the blog to learn more about mail...
Absolute Reference in Excel – Naukri Learning
by Rashmi Karan
LAST UPDATED: June 24, 2022, 13:04 IST
The article covers what is absolute referencing in Excel, how to create an absolute reference, and examples of absolute referencing.
Relative Referencing in Excel – Naukri Learning
by Rashmi Karan
LAST UPDATED: June 27, 2022, 11:09 IST
The article covers the Relative Referencing in Excel, how to create a relative reference, and examples of relative referencing.
What is Conditional Formatting in Excel
by Rashmi Karan
LAST UPDATED: June 29, 2022, 17:53 IST
Learn what is Conditional Formatting in Excel and explore different presets of Conditional Formatting to analyze and present your data in the most effective and powerful way.
Find & Replace in Excel – Naukri Learning
by Rashmi Karan
LAST UPDATED: June 21, 2022, 17:14 IST
Find & Replace in Excel are crucial and frequently used functions. Learn how to use these functions using both formula and advanced options.
Difference Between Formula and Function in Excel
by Rashmi Karan
LAST UPDATED: June 18, 2022, 15:25 IST
Formula and Function in Excel sound similar and are often confusing. The article tries to differentiate between Formula and Function.
Flash Fill in Excel – Naukri Learning
by Rashmi Karan
LAST UPDATED: June 29, 2022, 17:53 IST
The article highlights the use of flash fill in cleaning and managing huge data sets. Learn how to use flash fill in Excel through examples.
SUBSTITUTE in Excel – Naukri Learning
by Rashmi Karan
LAST UPDATED: June 14, 2022, 10:06 IST
The article covers the SUBSTITUTE function in Excel. Learn how to implement the SUBSTITUTE formula through examples.