Excel Tips: Detecting Duplicates Across Sheets and

Discover powerful methods to find and compare duplicates in Excel—across sheets, rows, and columns. This guide breaks down practical formulas like CONCAT and conditional formatting, helping you clean data and spot inconsistencies with ease.

Find duplicates in excel

Duplicate sheets, duplicate rows or duplicates in some selective columns? lets explore

Create diagrams, flowcharts or gantt from text

Draw your diagrams, flowcharts or Gantt by writing simple texts similar to markdown or Graphviz

How to use advanced filter in excel

Let us demystify Excel Advance Filter and learn how to apply criteria in advanced filter. You should be able to apply fairly complex criteria to Excel Advanced Filter in 15 minutes. Once created, same criteria can be reused on similar data

Getting started with Outlook Macro

If you are wondering to automate some of the tasks in Outlook, but not sure where to start.. you came to right place

Network micro-segmentation

Birds eye view of micro segmentation and its features and benefits

How to start with Selenium IDE

Get started with Selenium IDE in 30 minutes. Install plugin, record web-page interactions and and playback

Write your diagrams instead of drawing

You’ve got a brilliant idea, and you want to bring it to life with visuals. But here’s the catch: you’re not looking to spend hours…

Open csv in excel – Date format

You may jump to : Why excel do not recognize all the dates in CSV: How do I understand if excel could open my csv?…

Writing graph with GraphViz

GraphViz – Graph visualization Software GraphViz is an open source graph visualization software. It is used for representing structural information as a graph. Writing structural…

Popular Articles

Top Categories

Tags

DeepsOnline – Page 2 – Home for tech tips and tricks