Prevent Duplicates in a column in Excel

How to prevent Duplicates in a column in Excel with Data Validation!

Hey Data Validation Users, There are N number of stuff you can do with Data Validation based on your creativity. Today I am going to show you how to prevent Duplicates in a column in Excel with the help of Data Validation. Steps to Implement to prevent Duplicates in a column in Excel: Select the Entire […]

Share
Dynamic Drop Down Excel

Dynamic Drop Down List Excel

Hey Excel Dynamic User, I am going to show you one very important technique to create a Dynamic Drop Down List Excelin cells (of course with data validation but with addition to function “INDIRECT”) with n number of dependency you can create. I have tried to make it shortest and easy to understand with 5 […]

Share
outsourcing work for Chartered Accountants in India

Why Outsourcing/Freelancing = Work at Metro City or Bluechip Companies

Hello Professionals out there, I am sharing my own experience about outsourcing work for Chartered Accountants in India since I left Mumbai in 2012 after almost 8 years of stay there for study and job. I moved to my hometown Rajkot to setup my professional practice and concentrated on Outsourcing/Freelancing. In the first year itself I […]

Share
Google Analytics First Week

Google Analytics Statistics – First Week

Hello my Blog visitors, Today I have complete almost 1 week in my run for content marketing for my blog which I am going to run throughout 2015. (View my 2015 plan) I am happy to share with you the results of the first week. I started writing blog articles from 16 December 2014 (Tuesday) […]

Share
Excel 2003 keyboard shortcuts

Excel 2003 keyboard shortcuts – you should never forget

Hey Excel Shortcut lovers, I am sharing with you some of the important Excel 2003 keyboard shortcuts which are still applicable in Excel latest releases.   You can add to this list with your favorite excel 2003 keyboard shortcut in comments. If you want to get knowing such fruitful and upcoming techniques subscribe to my course […]

Share
Productivity Tools

Productivity Tools for Professionals

Hey Professionals out there, Today I am going to show you how to effectively use Productivity Tools for yourself and your team. Many professionals suffer from a disease called “Pretending to work”. No I am not questioning your professionalism but just to pause and think yourself: Are you utilizing your time properly on productive activities […]

Share
Camera Tool Excel

Camera Tool Excel or Paste linked picture

Hey Excel Tricky presenters, I am glad that you are here to unlock the hidden feature in your Excel i.e. Camera Tool Excel. However in recent update there is similar command available which performs the same function as Camera Tool Excel, i.e. Paste as Linked Picture. We will cover both of this command with GIF […]

Share
Streak for Gmail

Read Receipts in Gmail !!

Hello Business people out there, Have you ever missed the “Read Receipt” notification from Outlook?! The Streak extension in Google Chrome will serve the purpose, actually it will give MUCH MORE insights than “Read Receipt”. To download “Streak for gmail” to chrome click here When you install Streak from Chrome Web store, every message you send from […]

Share

Subscribe for Newsletter