Formula in MS Excel What is a Function? Formulas in Excel are useful in performing various mathematical, statistical, and logical operations. You can type in a formula (though you have to be sure it’s exactly right) or you can use Excel’s preset formulas called functions. If you type in the formula, you must start with an… Read More »
Steps to create a fully automated attendance sheet in Excel Let’s get started with creating our first automated turnout sheet in Excel. The first step is to create a Month menu in the sheet. You will choose a month from the drop-down menu and start marking the attendance. Here are the steps to create the Month menu.… Read More »
A salary slip, also known as a pay slip, is a document containing an employee’s salary details, including basic pay, bonuses, deductions, etc., given to the employee by the employer each month. The recipients are either given hard or soft copies and sometimes both. All organizations do not give salary slips out. Smaller size companies… Read More »
How to Make Mark sheet in Excel Format? Suppose we have the following data for marks scored in various subjects by 120 students. We want to find the total marks scored, an average of marks (this will also help us to give students grades), and a result that whether the student is passed or failed.… Read More »
If you use accounting software like QuickBooks, Peachtree or the like, the program will generate a P&L statement for you after you enter your sales and expense figures, but you can easily create your own using a basic spreadsheet and easy calculations, following the steps below. Step 1 – Track Your Revenue Revenue is the money you… Read More »
Insert Tab Tables PivotTable – Button with Drop-Down. Displays the “PivotTable from table or range” dialog box. The drop-down contained the commands: PivotTable and PivotChart. The PivotTable displayed the “Create PivotTable” dialog box and the PivotChart displayed the “Create PivotTable and PivotChart” dialog box.Recommended PivotTables – Displays the “Recommended PivotTables” dialog box. This shows a list of… Read More »
Microsoft Excel Starter 2010 is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to-do items. Excel Starter is part of Microsoft Office Starter 2010, and comes pre-loaded on your computer. Excel Starter 2010 is very similar to Microsoft Excel… Read More »
Using the View Tab of Microsoft Office Word 2007 The view tab will be most-used when your document is complete, especially to see what it will look like. These tools are important and you will keep using them from time to time depending on your needs. There are other important commands like the documents view… Read More »
How to Use Mail Merge in Microsoft Word Mail Merge is most often used to print or email form letters to multiple recipients. Using Mail Merge, you can easily customize form letters for individual recipients. Mail merge is also used to create envelopes or labels in bulk. This feature works the same in all modern… Read More »
With Word on your PC, Mac, or mobile device, you can: Create documents from scratch, or a template. Add text, images, art, and videos. Research a topic and find credible sources. Access your documents from a computer, tablet, or phone with OneDrive. Share your documents and work with others. Track and review changes. Create a document… Read More »