One of the basic functions, yet many people are not using. If they know it they could save much work in calculating basic summaries. We are talking about the SUM and AVERAGE – end of counting totals and averages manually. SUM description =SUM(value 1, value 2, … ,value 255) values 1 … 255 are cells with the numbers or values for […]
Did you get the foreign language version of Microsoft Office, and not familiar with it? Solutions exist, you must install specific language pack and simply switch the language settings. In this article we will show you how to do it. Language pack All Microsoft Office apps display its menu in language that we choose using so-called Language […]
Are you working with spreadsheets, where multiple users make changes? Then maybe I will agree that compare various changed tables between each other is a nightmare. Sure, there is Track Changes tool, but it is not omnipotent, and in addition, many people do not even know how it works. So what to do with the different tables that […]
It happened to you that you were used to save incoming messages or attachments in Outlook to PDF, but suddenly in the new version you do not know how to do it? Let’s take a look together at how to save mail to PDF in Outlook 2013. If this guide has helped you, become a fan […]
I often encounter questions as how to insert a video from YouTube to the new PowerPoint 2013, so we do not need to run a web browser. Inserting online video, although it seems like a simple thing, because on the Insert tab there is an icon Video > Online Video. But the redirects us to embed the […]
You need to have calculation in Excel always with current value of foreign currency or stocks? You do not need to constantly check the website and manually write data in Excel. There is a simple solution for you – connect online table directly to Excel spreadsheet. How to do this, you will learn precisely in this manual. […]
When completing tables we may offer some items to be selected from the list of options using the Data Validation. You can ensure that users always selects one of the values and no other, or perhaps let Excel to calculate a formula or format the cells in a table right by the selected option. Whether in […]
