Learn Newest Techniques and Tricks for Microsoft Excel
Category

Excel

Category

Excel or commonly known as the spreadsheet is a powerful tool when one knows how to use it. It starts with the basic to advanced techniques for making tedious task an easy one. But, it’s a great loss for the ones who have them on their home screen but do not how to use it. Microsoft has made various innovations over the years in the spreadsheet but the basic has always been the cornerstone for…

If you thought, how to do password spreadsheet or protect excel worksheet for a long time. Then you are at the right place, here we will show you step by step methods to protect your excel sheet and their workbook. We know why it is more important cause excel mostly use for store numeric data or sales report and other companies information. Excel is most useful application for business because excel gives you many features…

The Quick Access Toolbar allows you to customizable toolbar. Where you can set of commands like Add calculator, printer, and spelling and grammar checking icon. When we are building spreadsheet sometime we need to do small calculations but we can’t do it. So that today I will show you how to add windows calculator into your excel program? I will guide you how to use windows calculator to perform quick calculation while in excel. Here…

Learn more about  tutorial excel and tricks which you never used. How to Transposing columns and rows in Microsoft Excel? If you want to work with the row or column of heading on your sheet with better the opposite way, here I am sharing easy way to transpose them with tutorial Excel. 1 – Select the cells in the row that contain the headings. 2 – Either right-click and select Copy or click the Copy button…