If you are not equipped with the necessary tools and techniques, it is quite hard to work on Microsoft Excel. This is especially true when you have a lot of recursive work to do or are using Excel’s advanced functionality. Excel itself is a world of spreadsheet. It’s quite difficult to master each and every […]
MS Excel helps you to maintain records in the form of large spreadsheets which may cover hundreds of pages when printed. It is easy to work on these spreadsheets using the Excel tool but printing such large sheets can easily put you into trouble. Today, we will explore some tweaking tips which will enable you to […]
Microsoft Excel is a powerful tool that is widely used by accountants and finance people to make spreadsheets, reports, sales record, summaries and etc. Regardless of the complexity of task, ‘Serial Number’ is a column which is included in almost all types of worksheets. Sequential serial numbers are usually incremented by 1. None of us […]
Microsoft Excel is used to create spreadsheets that contain massive amounts of data. It could be a thousand rows and a twenty-five column data or more than that. With such big data, it becomes very difficult to find a particular record on basis of some criteria. All the accountants could have scratched their heads off […]
While working with spreadsheets, we frequently need to retrieve a specific value from large data sets. Sometimes, we need to filter out values on the basis of some criterion. And at other times, we wish to perform a simple arithmetic operation which can be as simple as calculating sum or finding average of a particular […]
While working with spreadsheets, we frequently need to retrieve a specific value from large data sets. Sometimes, we need to filter out values on the basis of some criterion. And at other times, we wish to perform a simple arithmetic operation which can be as simple as calculating sum or finding average of a particular […]
Microsoft Excel is the most widely used spreadsheet program in the world and every professional who has to deal in numbers should be able to operate Excel. While Excel is very advanced, Microsoft has made it very easy for beginners to get started. Yesterday I was working with an Excel workbook where I had to […]
Microsoft Excel creates and opens three work sheets by default when you open an Excel workbook. For some people these three sheets are enough while others are used to working with a lot of sheets within Excel workbook. I like to work with only one work sheet per workbook. So I only want to open […]
In Microsoft excel 2010 name of default worksheet are Shee1, Sheet2, Sheet3, which is not appropriate to present and also its difficult to remember what that particular sheet contains, so Microsoft excel 2010 gives you option to rename the sheet as you want, but you should know that name cannot exceed 31 characters, as it’s […]
There may be certain instances when you have some sensitive information in your workbook and you want only appropriate or authorize person should see them, it means you need password to keep your workbook safe, this is how it can be done.