Excel is software from Excel Microsoft, included in the Office package. With this program it is possible to format and develop spreadsheets, representing among others. The costs of implementing your projects, the spreading of expenses, the graphical analysis. Among the many functions available, the development of formulas to automate calculations is highly appreciated. All for organizing data and configuring different types of charts.

Excel is often used to prepare, in particular:

  • A budget, such as the creation of a marketing plan for example;
  • Accounting, with the manipulation of means of calculation and accounting statements, such as cash flows and profits;
  • Reporting, measuring project performance and analyzing the variance of results;
  • Invoices and sales. For the management of sales and invoicing data, it is possible to imagine forms adapted to specific needs;
  • Planning, for the creation of professional projects and plans, such as marketing research among others;

What are the basic operations of Excel:

  • The creation of tables,
  • The creation of workbooks,
  • Formatting a spreadsheet
  • Data entry and automatic calculations in a spreadsheet,
  • Printing a worksheet.

How to perform some basic operations in Excel?

  1. Creating a table:

Click on the New option and then select the available templates, which can be: a blank spreadsheet, default templates or new existing templates.

To create a workbook, press the File option (located in the top menu), followed by New. Select the Blank workbook option. You will notice that the document has 3 sheets, by clicking with the right mouse button, it is possible to remove or insert as many sheets as necessary.

  1. Apply borders:

First select the cell, click on the Select All option (located in the top menu), then select from the Home tab, the Font option and scroll down to the Borders option, now you just need select the desired style.

  1. To change color:

Select the desired cell and the text you want to edit. Go to Home option, Font sub-item, click Font Color and sequence in Theme Colors.

  1. To align text:

Select the cells with the text, click Home, then click Alignment.

  1. To apply shading:

Select the cell you want to change, go to the top menu and click Home, then to the Font subgroup, and click Fill Color. Open Theme Colors option and choose your favorite color.

  1. Data entry:

To enter data into the Excel spreadsheet, simply select a cell and type the information, then press ENTER or, if you prefer, select the TAB key to move to the next cell. To insert new data in another line, press the ALT+ENTER combination.

  1. To make an impression:

After entering all the information, formatting the spreadsheet and graphics in the desired way, let's proceed to print the document. To print a spreadsheet, select the cell to display. Click on the top menu "File" and then click on Print. If you prefer, use the keyboard shortcut, it's CTRL+P.

En conclusion

If you want to know more about the use of the Excel work program, do not hesitate to train yourself for free with professional videos on our site.