25 Tips for Mastering Excel

Microsoft Excel is arguably the most complex software in the Microsoft Office suite. It is quite easy to get started with to create tables. But tricks exist to take advantage of the many, many features of the software. They are based on Microsoft Excel 2010. Slight variations may appear, especially for versions prior to 2007. If you use other tips on a daily basis, you can share them! In the same way, Ghana WhatsApp Number List do not hesitate to comment on the article if you are having difficulty performing this or that action on Excel, we will try to answer it quickly.

If you want to go further, you can also train to become an Excel expert . Keyboard shortcuts in Microsoft Excel Like many software, some very useful shortcuts allow you to be more productive on Excel. To insert a function, just click on the Fx icon present under the ribbon. All cells that contain a function begin with the = character.

Keyboard Shortcuts in Microsoft Excel

 

If you are familiar with certain functions, you can access them directly by typing = then the name of the function within a cell. To better understand the potential of Excel functions, we advise you to consult our list of Excel functions to know . Name a table in Excel In some cases, it may be useful to name an array. Select the range to name (example: from cell B2 to cell E7). Then click on the Ghana WhatsApp Number List field on the left, under the ribbon, then enter the name of your choice.

In this example, our array is named Data . Once named, you can use the data from your table very easily: to know the sum of the data present in our table, a simple =SUM(Data) is enough. You can access the name manager via the Formulas tab of the ribbon. Copy paste Excel functions Very often, the functions of an array follow and resemble each other. For this reason, Excel uses certain rules when you copy and paste a function to maintain the logic of your calculations. In the example below, the SUM column is the sum of the row values.

Copy Paste Excel Functions

Ghana WhatsApp Number List
Ghana WhatsApp Number List

 

Just copy function D2 and paste it into D3 to get the sum of the data in the third row. Create a logical sequence using click and drag Instead of copying and pasting the formulas, you can duplicate them by clicking and dragging. All you have to do is select the source cell(s), then place your cursor at the bottom right of the cell. A small cross will appear, making it easy to copy paste the formula (or a series of formulas) to the side or to the bottom. Some values, such as ranges of cells, will be replaced automatically Ghana WhatsApp Number List to maintain the logic of your functions.

You can also create a logical sequence with this trick, but you must select several cells. Example: if two adjacent cells contain two consecutive dates (October 16 and October 17, for example), you can select them, click on the small cross at the bottom right of the cell and drag your cursor over several cells to display October 18, October 19, October 20 and so on. This also works for sequences of numbers. Freeze row, column or cell in an Excel function In some cases, you want to “freeze” a line, a column or a cell in a sequence of functions.

Leave a comment

Your email address will not be published.