Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

Our Tutorials

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

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

Share Post @

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

Read More »

Microsoft Excel 5 Things You Must Know – Freeze or Unfreeze

Microsoft Excel 5 Things you must know

Share Post @

Microsoft Excel 5 Things you must know

Microsoft Excel 5 Things you must know. read more

Read More »

COUNTIF function to count the cells in Microsoft Excel

COUNTIF function to count the cells in Microsoft Excel

Share Post @

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

Read More »

How Rounding works in Microsoft Excel 2010

How Rounding works in Microsoft Excel 2010

Share Post @

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

Read More »

How to create Data Entry Form in Microsoft Excel 2010

How to create Data Entry Form in Microsoft Excel 2010

Share Post @

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.

Read More »

Mail Merging with Microsoft Excel and Word

Mail Merging with Microsoft Excel and Word

Share Post @

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

Read More »

How to Use VLOOKUP Function in Microsoft Excel 2010

How to Use VLOOKUP Function in Microsoft Excel 2010

Share Post @

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

Read More »
Show Buttons
Hide Buttons