Skip to content

Technotrait

  • Home
  • Archives
  • About
  • Contact Me
  • Write For Us
  • Privacy Policy
  • Disclaimer

excel

How to Find Duplicate Values in Excel using VLOOKUP Formula

September 30, 2019September 28, 2019 by Rafaqat
Find duplicate in Excel using VLookup Formula

Have you ever tried to find duplicate values in excel by comparing two columns? If no, then this guideline is for you. Especially if you are working in an organization, school or even in the shop, you can easily sort out the repeated values and filter them accordingly. First, let’s see in how many ways … Read more

Categories COMPUTER Tags excel, vlookup formula Leave a comment

Two Ways to Autofit Column Width in Microsoft Excel

June 30, 2019 by Rafaqat
Autofit Column Width in Excel

Microsoft Excel provides a neat and handy way to autofit column width with different ways including, its keyboard shortcut, manually as well as by using a short VB code. In today’s tutorial, we will discuss all possible way to autofit the column width while working in Microsoft Excel. Before proceeding, let’s see why we need … Read more

Categories COMPUTER Tags computer, excel Leave a comment

How to add a drop-down list to a Cell in Microsoft Excel

February 6, 2019April 29, 2017 by Rafaqat
create drop-down list in excel

Learn to create a drop-down list to a cell in Excel. To add list, we use the function of data validation method to the given cell. We can edit, remove list to single and multiple selections. In Microsoft Access you can limit a user to choose from the entries in the given set of data, … Read more

Categories COMPUTER Tags computer, excel 1 Comment

How to Calculate Range in Excel of Numbers using Excel Range Function

October 31, 2018April 3, 2017 by Rafaqat
how to calculate range in excel of given numbers

Microsoft Excel has very useful functions and we will discuss one of them, which will help to calculate range in excel for the given data set. In order to find out the smallest and largest values in a range of numbers manually is typically not a handy work, especially when numbers are in contiguous form with … Read more

Categories COMPUTER Tags computer, excel Leave a comment

Convert Numbers into words in Excel in Indian and Pak Rupees

September 28, 2019October 19, 2016 by Rafaqat
convert-numbers-into-words-in-indian-rupees-in-excel

Most of the computer users know about Microsoft Excel and its importance in office work. Especially the ones who are linked with accounts and they often faced the situation where they have to convert numbers into words for the ease of their account holder and for other persons. Let’s say we have a daily routine … Read more

Categories COMPUTER Tags computer, excel, windows 23 Comments

Recommended Posts

  • How to Stop Page Redirects to other Websites
  • How to Lock Keyboard and Mouse In Windows 10 quickly
  • How to Update JavaScript in Windows 10
  • Convert Numbers into words in Excel in Indian and Pak Rupees
  • How to deactivate or delete Facebook account on Computer
  • How to Update Windows Photo Viewer Software in Windows 7
  • 10 Best Random Video Chat Apps for Android and iOS
  • How to View Full Size Instagram Photos and Profile Picture
  • Top 10 Advantages and Disadvantages of Social Media for Society
  • How to add a drop-down list to a Cell in Microsoft Excel




© 2021 Technotrait • Built with GeneratePress