TEXT SLOPE
If you want to skew text or numbers inside spreadsheet cells, you have to select the cell that contains the text you want to rotate and, in the tab Home, in the group Alignment, click on the button Orienteering (the one with the letters ab over a slanted arrow) and automatically choose one of the six available options. Directions can be clockwise, counterclockwise, vertical, etc. You can click on Format Cell Alignment so you can get more tweaking options.
DEADLINE
Through a few small simple steps, you can configure Excel to monitor the development of your projects, monitor service delivery deadlines and display, just to give you an example, accounts payable. The operation that allows this consists in establishing dates for the program to monitor them and inform if they are within the deadline or if they have already expired. Below we show the tutorial that serves only as a recommendation, to allow you to adapt it according to your needs. In our example, we show four ongoing projects with their respective deadlines for completion, where the objective is to create a formula that allows informing whether such projects are on schedule or if they have already expired.
First, you have to create a spreadsheet like the one in the example, detailing the projects and their respective deadlines. Don't forget to reserve the fields so that Excel displays the status regarding the completion date of the projects. Then, in front of the first project, select the cell in which you want to display the deadline status and enter the following formula: =IF(TODAY()🇧🇷 In this formula, we use a conditional SE and, within it, the argument TODAY(), which causes Excel to check the current date and compare it with the one established under the heading Term🇧🇷 In the same case, if the current date is less than the established date (in our example, in cell B2), the cell containing the formula will result in the text On deadline and, if it is greater, the phrase Expired deadline. Then just recreate the formula in the other projects, using the corresponding cell reference.
EXPORT GRAPHICS TO POWERPOINT
By default, when we import a PowerPoint chart from Excel, it incorporates original data from the worksheet. So, if you happen to update the spreadsheet afterwards, the graph in PowerPoint will also update automatically. This option is very useful in many circumstances, but unfortunately there will be times when you don't want the other person compiling the presentation to have access to the original data. To avoid this, you can always import a graphic in the form of an image, without the need for it (the graphic) to be linked to the original Excel data. With this, the chart in PowerPoint remains static no matter what someone does with the workbook in Excel.
Open Excel, select the chart and click the button Copy, in the tab Home (or you can use the command Ctrl + C🇧🇷 Now switch to PowerPoint and paste the graphic into a placeholder on your slide via the option Strain on the ribbon (or the shortcut Ctrl + V🇧🇷 Once the graphic is pasted, you will see a button in its lower right portion. Click on it to view the icons of Collage Options🇧🇷 You can always make the graph more than one image, so that it doesn't change when the Excel data is updated, by choosing the far right icon Paste As Picture.
LINK THE CHART
If you want your chart to be updated when it is changed in Excel, then when pasting the chart in PowerPoint, you have to choose the option Keep Original Formatting and Link Data (you have to click on the penultimate icon). Once you've done that, you can update the chart or data in Excel, and the changes will be reflected in PowerPoint. But be warned that you should be aware that changes to an Excel spreadsheet by another user could change your slides.
COMMENTS ON THE SPREADSHEETS
Excel allows you to attach comments (short snippets of text) to cells, so that you can explain certain contents or even enter any information. These comments can be visible, hidden or even printed on spreadsheets. They are very useful if you are sharing your worksheets with other people, as this way you can explain certain specific contents or add relevant information. To do this, just click on the cell where you want to insert the comment, access the tab Review and click on New Comment, where the comment insertion area will be opened. Type the desired text and when you finish typing the text, click outside the cell area.
You can always temporarily view the content of the comment by placing the mouse cursor over the triangle-shaped comment sign. Now, if you want the comments to be visible, go to the tab Review, click on the button Show/Hide Comments.
To delete a comment, select the cell or group of cells in question and click the button Delete, in the tab Review.
If there are many comments in the worksheet, you can browse them one by one by clicking Next or Previous, as appropriate.
Although it may not be necessary, we inform you that from the Font group, you can format the comments, changing the font, body size, etc.
COLLABORATIVE WORK
Do you want to invite other people to view and/or work with you on the same spreadsheet? Then enter the guide Archives, click on Share and, under the item Share with People, click on E-mail🇧🇷 Choose in Send as Attachment or Send as PDF🇧🇷 To inform you that you can always save the file on OneDrive, where you can click on Cloud Save and, for the next step, click on OneDrive🇧🇷 Then, press the button Send, which you will have to enter your Microsoft account data.
Here are previous episodes:
_____________________________________________________________________
that was the episode Tek MenosFios: X-ray to Excel this week, where we hope it will be useful for anyone and everyone who wants to be an expert when using the program. Now, we ask our readers to comment on it and to contribute with additional information they deem necessary on this same topic.
Any and all questions you would like to see answered here should be posted on the exclusive communication channel dedicated to Tek Menos Fios.
We talk about the email created for this purpose: [email protected]🇧🇷 This is the only reception point for questions you send us. Use it to send us your questions, doubts or problems. Your answer will come very soon.
