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 »
HTML Formatting Elements Formatting elements were designed to display special types of text: <b> – Bold text <strong> – Important text <i> – Italic text <em> – Emphasized text <mark> – Marked text <small> – Smaller text <del> – Deleted text <ins> – Inserted text <sub> – Subscript text <sup> – Superscript text HTML <b> and <strong> Elements The HTML <b> element defines bold text, without any… 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 »
The HTML style attribute is used to add styles to an element, such as color, font, size, and more. <html><body><p>I am normal</p><p style=”color:red;”>I am red</p><p style=”color:blue;”>I am blue </p><p style=”font-size:50px;”>I am big</p></body></html> Result: I am normal I am red I am blue I am big The HTML Style Attribute Setting the style of an HTML element, can… 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 »
A paragraph always starts on a new line, and is usually a block of text. HTML Paragraphs The HTML <p> element defines a paragraph. A paragraph always starts on a new line, and browsers automatically add some white space (a margin) before and after a paragraph. <html><body></p>This is a paragraph.</p><p>This is a paragraph.</p><p>This is a paragraph.</p></body></html> Result:… Read More »
HTML headings are titles or subtitles that you want to display on a webpage. HTML Headings HTML headings are defined with the <h1> to <h6> tags. <h1> defines the most important heading. <h6> defines the least important heading. <html><body><h1>Heading 1</h1><h2>Heading 2 </h2><h3>Heading 3 </h3><h4>Heading 4 </h4><h5>Heading 5 </h5><h6>Heading 6 </h6></body></html> Result: Heading 1 Heading 2 Heading 3 Heading 4 Heading 5 Heading… 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 »