Microsoft Excel Archives

How to hide columns rows with plus and minus button in Excel

September 13, 2017

How to hide columns rows with plus and minus button in Excel

How to hide columns rows with plus and minus button in Excel. To Hide rows and columns are common process in excel spreadsheets. Excel spreadsheet ‘s feature can make the way easier and make it more visible when rows or columns hidden. Grouping inserts small icons around the Microsoft Excel grid to allow us to hide and unhide rows and columns frequently. These icons also identify that rows/column have been, or could be, hidden. The Group icon is on the Data Ribbon tab. read more

Microsoft Excel 5 Things You Must Know – Freeze or Unfreeze

August 1, 2017

Microsoft Excel 5 Things you must know

Microsoft Excel 5 Things you must know. read more

COUNTIF function to count the cells in Microsoft Excel

July 13, 2017

COUNTIF function to count the cells in Microsoft Excel

COUNTIF function to count the cells in Microsoft Excel. BY using COUNTIF functions we can trace the values in a range . Basically, the COUNTIF functions in Microsoft Excel is one of the statistical functions , to trace or count the numbers of cells that meet a criterion. As for example , to trace the number of times a particular designation in a customer list. read more

How Rounding works in Microsoft Excel 2010

June 9, 2017

How Rounding works in Microsoft Excel 2010

How Rounding works in Microsoft Excel 2010. Rounding in Excel refers to reducing the number of digits in a number to make it easier to work with. Even seasoned Excel professionals get caught out by this one, and end up scratching their head while they try to figure out why their calculations don’t work out as expected. To see what I mean, check out these examples. read more

How to create Data Entry Form in Microsoft Excel 2010

March 3, 2017

How to create Data Entry Form in Microsoft Excel 2010

How to create Data Entry Form in Microsoft Excel 2010. It’s a great way when the records span across many cells in excel. Almost we all hate data entry. Excel data entry form will make it very easy. Entering data into Excel isn’t difficult. You type in one cell and move to the next.
How it Works
A data form is a dialog box with the fields for one record. The form sits on top of your Excel spreadsheet and allows us to enter up to 32 fields per record.

Mail Merging with Microsoft Excel and Word

December 28, 2016

Mail Merging with Microsoft Excel and Word

Mail Merging with Microsoft Excel and Word. Mail Merge from Microsoft Excel to MS Word is a great time-saver when it comes to sending large / huge mailings. It lets us quickly create custom letters, emails or mailing labels in Word by merging the information that already have in our Excel spreadsheet. read more

How to Use VLOOKUP Function in Microsoft Excel 2010

December 26, 2016

How to Use VLOOKUP Function in Microsoft Excel 2010

How to Use VLOOKUP Function in Microsoft Excel 2010. Basically , vlookup is a very strong and useful function that we found in Microsoft excel as well in 2010. read more