Using the Outlook quick reply (CTRL + R) and the need to change the language grammar checker? Such an option is only on the Review tab > Language, which is visible but only after the message is opened in a new window. There is a way around it, using the macro below. If this guide […]
In tables working with time values is sometimes necessary to calculate a period longer than 24 hours. If the result is not format correctly, you will not get the desired value, because by default, Excel does not calculate the time exceeding 24 hours. But just change the custom cell format and the correct number appears. See […]
You may know that Excel can subtract from each other not only numbers, but also dates. The fundamental difference between the two dates will be the number of days between them. But if we want to determine the precise number of months, years or just months indiscriminately years, it would be quite difficult. Fortunately, we […]
Another episode of tutorials Deal with Pivot Tables continues with the topic Calculated field. Without changing the source table we will create a new column with a formula. You will learn how a field is added to the table, or to influence the source data and then update the PivotTable. If this guide has helped you, become a fan […]
When creating presentations, we often use slides of previously created presentations. In this article you will find tips for easy inserting slides from another file, ie how to reuse images. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too. To paste slides from […]
Another episode of tutorials Deal with Pivot Tables continues with the topic Grouping of dates of intervals. You can simply view the summary according to time of year, for example total for each month or quarter. Also you can see the value in increments of thousands or in other units. If this guide has helped you, become a […]
Another episode of tutorials Deal with Pivot Tables continues with the topic Page field. It serves not only for filtering, this can produce several detailed Pivot tables according to the selected criteria. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too. Please note […]
