How to Compare Two Excel Files Without Writing a Script.At a certain point, most excel users will come across the challenge to compare two excel files for differences, and to merge or update these differences. You can either sort and compare two excel spreadsheets for differences manually or you can write a script that shows the differences. Both ways will be time-consuming … [Read more...] about How to Compare Two Excel Files Without Writing a Script
Microsoft Excel
Microsoft Excel 5 Things You Must Know – Freeze or Unfreeze
Microsoft Excel 5 Things you must know.Microsoft Excel 5 Things you must knowThe list of things will be covered in this video, below showing chronologically,Use the SUM function to add up a column or row of cells in Excel Scale your spreadsheet to fit on one page when printing from Excel Freeze or Unfreeze rows and columns in an Excel worksheet How to use … [Read more...] about Microsoft Excel 5 Things You Must Know – Freeze or Unfreeze
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. For example, to trace the number of times a particular designation in a customer list.COUNTIF function to … [Read more...] about COUNTIF function to count the cells in Microsoft Excel
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.How Rounding works in Microsoft Excel 2010To see what I … [Read more...] about How Rounding works in Microsoft Excel 2010
How to create Data Entry Form in Microsoft Excel 2010
How to create Data Entry Form in Microsoft Excel 2010It’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 to create Data Entry Form in Microsoft Excel 2010How it Works A data form is a dialog box … [Read more...] about How to create Data Entry Form in Microsoft Excel 2010
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.Mail Merging with Microsoft Excel and WordThis Video provides an overview … [Read more...] about Mail Merging with Microsoft Excel and Word
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.How to Use VLOOKUP Function in Microsoft Excel 2010How it worksWhile you have a high volume of information in the excel sheet, definitely you might be falling into a situation for finding a specific list of … [Read more...] about How to Use VLOOKUP Function in Microsoft Excel 2010