Category

Office

Category

Office is one of the products that we could consider essential on any Windows computer, and yet, during the installation process, it is possible that we run into some obstacle In those cases, there are a series of solutions that we must consider to get out of trouble, which we are going to review below, in strict order, to see if you can get out of this big mess Beyond the fact that it has…

Create a dynamic table on Microsoft Excel It is not something too complex, the ideal is to start with the basics, this way it will be much easier. Thanks to pivot tables we find an interactive way to organize, group, calculate and analyze data. It is possible to manipulate this data in different ways to visualize exactly what we need. Create recommended pivot table in Microsoft Excel In the same way that we can insert…

Create slicers in Microsoft Excel It is something very simple that will allow us to filter data and always see what is filtered in our spreadsheets. We can even customize them and this is something that we will show you a little further down. Create slicers in Excel The first thing we will have to do is open our spreadsheet in Microsoft Excel. After this we will have to click on the table in which…

As you may know, Excel spreadsheets are a great way to store and analyze data. Generally, spreadsheets are made up of cells with a combination of numbers and text. To better understand your data, you need to know how to differentiate cells with text. So in this article you are going to learn how to count cells containing text in Excel. Is easier than it looks like. How to count cells with text in Excel…

Edit a PDF with Microsoft Word or Edge It is very simple and convenient. Especially since Edge is already pre-installed on the computer and Word is one of the most used office programs. Each one has its limitations and depending on what we want to add to the PDF, we will have to use one or the other. In this case we will focus on Windows, previously we have already shown you the best option…

Nothing more comfortable, practical and that will help us save time than autofill sequential data in Google Sheets. Many of us fill in the cells of a Google Sheets spreadsheet manually, but we can do it automatically when it is sequential data and getting it is much easier than you imagine. Automatically fill sequential data in Google Sheets The guide that we will see a little further down is very simple and serves to give…

Microsoft Excel facilitates many basic mathematical operations, including the ability to divide numbers. It is possible to divide them in a single cell, in several or even in different columns. We have already talked about Microsoft Excel on several occasions and we have helped you with a large number of very useful, simple and quick guides. Thanks to this interesting program we will be able to count cells with text, create segmentations, dynamic tables, combine…

In all areas of project organization, diagrams are vitally important Whether physical or virtual, with them we can classify all the information we have, obtaining detailed conclusions, with the necessary details to use them. In Excel there are different diagrams that we can execute. One of the most interesting is the Gantt Diagrams are essential for the organization of any initiative, and not only when making mental maps on paper, but also when we take…

We all make mistakes, luckily thanks to the Excel and Google Sheets error checking, it will help us quickly find them in our spreadsheet and solve them; It is one of those basic functions of Excel or Google Sheets that we need to know. A little further down we will see all the steps that we will have to follow to be able to use this interesting and useful function. Background error checking in Excel…

Knowing how to calculate the percentage of a number is absolutely necessary in many aspects of life. Obviously, percentage calculations are very important in business and are often used a lot in work environments. In the next article we will see how to calculate percentagealthough we will also see several examples on the percentage change and percentage difference. Trying to simplify it as much as possible so that it is understood in the simplest way.…

One of the basic and most useful tasks is knowing how to count how many cells have numbers. Microsoft Excel gives us the opportunity to use the COUNT function which will help us avoid having to do this manually. Microsoft Excel offers us a wide variety of free tools, functions, features and templates to save us a lot of time. It even helps us check for errors so we don’t have to do it manually.…

Although to protect with password a file of Excel it is too easy, if we want to share this, we must find a safe way to send the excel sheet. It is an extra layer of protection for when we need to send files which should only be accessed by specific people. Even if we share it in a OneDrive folder to which several people have access, only those who have the specific password will…

On many occasions we will have values ​​in a single cell that we want divide in different cells in Microsoft Excel How can we do it? It is not complicated at all and, luckily, we have two methods to carry it out. How to split cells in Microsoft Excel with Flash Fill The fastest way to divide the values ​​into several traps is using the “Flash Fill” function. With this we will be able to…

If you have multiple CSV files and we wish to combine these in a single book of Excel, it is possible to do so, it will even end up being more efficient than editing each file separately. It does not matter if we have opened them in any other application, we can do this method to join them and it is very easy. Let’s pretend that a person sent us three CSV files that have…

The COUNTIF or COUNTIF formula in Microsoft Excel is one of those that you should know how to use With it, as a user you can count the number of cells that meet certain criteria or conditions, which will make it easier for you to obtain a count, avoiding having to do it manually There are certain formulas in Excel that you should learn to use, especially if you are taking your first steps with…