top of page

5 excel tips



Microsoft Office is a program that brings together a series of office tools. The purpose of these tools is to perform and process all office-related tasks. Available in several versions, the facilitating nature of these tools means that they are practically used by everyone. Office has several parts, the first part of these software are basic software. They include the following software: Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft Outlook. The second part is complementary software.


Indeed, the importance of training in digital tools is no longer in question. Having basic knowledge in digitalization is a prerequisite for any position.

More precisely, nowadays, 99% of companies use the Excel spreadsheet, so its usefulness is no longer to be demonstrated. Thanks to its reliability and performance, both individuals and employees have a use for it. Very easy to handle when you know its features, Excel allows you to sort and associate data to obtain tables or charts. This software has therefore become essential for any type of professional activity because of its versatility and its usefulness on many occasions. From programming to graphing to data analysis, Excel offers all the essential features that make daily life easier. It also allows you to perform more or less complex calculations.


We have put together 5 tips to use in Excel.


1. The keyboard shortcuts


Anyone who uses Microsoft Excel often knows how useful keyboard shortcuts are. Here are the 13 shortcuts we use the most:

  • F2: Edit a cell.

  • ALT + Enter: Return to the line in a cell.

  • CTRL + an arrow: Go from one end of the table to the other.

  • CTRL + Y: Repeat the last action performed.

  • CTRL + Enter : Copy the same value in several cells.

  • CTRL + "; " : Insert the current date.

  • CTRL + SHIFT + L : Create filters.

  • CTRL + F : Find a value in a table.

  • CTRL + % : Put a cell in percentage format.

  • CTRL + G : Put a cell in bold.

  • CTRL + N : Create a blank workbook.

  • CTRL + S: Save the active workbook under the name and format in which it is located.

  • F12: Save as.


2. Pivot tables


Pivot tables are used to reorganize raw data in a new spreadsheet. This allows you to avoid the headache of sorting the data yourself.


To make a pivot table, click on :

Insert > Pivot Table > Select Data Range > Choose Pivot Table Location.


3. Insert a row or column


  • Select a cell that is placed in the row or column to be added.

  • Right click on it and click on Insert.

  • On the dialog box, you have several insertion options:

> Shift cells to the right

> Shift cells down

> Entire row

> Full column

  • Select the insertion option of your choice and then click the OK button to perform the desired insertion.


4. Manage multiple Excel sheets on a workbook


An Excel document can contain several tabs. It is therefore easy to add sheets with the dedicated button at the bottom left of the window or with (Shift+F11).


5. Create a chart from Excel data


To create charts, it is best to select your data and then select the chart type of your choice. Indeed, in Excel, it is possible to create a histogram of a single cell: this chart is called a Sparkline chart.


  • Select the Sparkline chart data range.

  • On the Insert tab, click on Sparkline, then on the type of sparkline you want.

  • On the sheet, select the cell or range of cells in which you want to place the sparkline graphs.

  • Click on OK.


It is therefore necessary to master this tool perfectly, whatever your situation: employee, freelancer, private individual or job seeker.





2 views0 comments

Comentários


ÉVO Formation & Consulting

ÉVO FORMATION & CONSULTING

qualiopi_edited.png
Our contact details

Address: 32 Rue Francine Fromont 69120 Vaulx-en-Velin

E-mail:  contact@evo-formation.com

Phone:  09 87 14 69 53

Mobile:  06 60 77 34 97

 

Click here to find us

  • Blanc Facebook Icône
  • Blanc Icône Instagram
  • Blanc LinkedIn Icône
bottom of page