Category

Office

Category

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…

Possibly you already know how check the orthography with the mouse on Word, but we also want to teach you how to do with shortcuts from keyboard. Sometimes it will be more comfortable for us to do it with keyboard shortcuts than to be with the mouse jumping from error to error. This comes in handy when we are used to disabling the spell checker in Word. Use the spell checker with the keyboard shortcut…

Apple has its own productivity suite called iWork, which also has an app for creating spreadsheets called Numbers. Obviously, it has its own format when saving the files generated in it, this format is compatible with CSV. By having its own proprietary format, it means that opening or editing it in other apps is not exactly easy if you don’t have a Mac. That’s why we’re going to see How to open a file Numbers…

When we organize a meeting it is very likely that we will have to take a note or two. Either because we want to share them or because we need to have certain references to important topics that have been covered in it. That is why we are going to teach you in this simple guide how to add notes from meeting in a document of Google Docs It is extremely simple! How to add…

The spell checker built into Microsoft Word can be a very useful tool for finding those hard-to-miss mistakes. If you turn it on, Word checks your spelling as you type and provides an indicator of misspelled words. However, that red, checkered line can be distracting. You may see her and correct the word immediately, or you may decide to let her stare at you as you continue. In either case, the misspelling indicator can cause…

If you usually work with office suites, such as Office, you are probably used to discovering new functionalities in each of its programs. At the same time, it is evident that word processors play a fundamental role in these packages, and that they are among the most used on a daily basis. Therefore, if you want to enrich your documents or facilitate access to other content, you must learn how to embed a file in…

Something that is very important when writing a document is the class or type of font that we use. That is why we are going to teach you how to add fonts in Microsoft Word and all Windows and Mac programs. It is much more blown and faster than you imagine. Download fonts for Microsoft Word Obviously, before adding a font to Word, the first thing we have to do is download the font. Luckily,…

When you collaborate with others on a Microsoft Word document, you will likely use the change tracking feature. This feature is great for collaborating on a document, as you can see all edits from co-authors. However, when you print your document, you usually don’t want to see all the marks and comments, especially if they are confidential. There are two easy ways to print the Word document without comments or marks. You can adjust the…

Headers and footers allow you to include specific information in a Word document. For example, if you need to add your name or the title of the document on each page, the header allows it. You can add the same information to the footer, where page numbers and references can also appear. We will show you how to insert a custom header and footer in Microsoft Word. So you can customize it with the information…

When you edit any data in an Excel workbook, any Excel formula that uses that data will be updated immediately. This is because Excel is constantly updating its formulas, checking for changes that may affect its calculations. However, as the workbook grows, Excel requires more time and memory to perform the calculations. Instead of watching Excel slow down and become unusable, you can substitute the formulas you are using with their results. This will speed…

If you are trying to impress your audience with an exciting PowerPoint presentation, you will have to do your best. Attractive images and a captivating color scheme are one thing, but you may have to go a step further by applying PowerPoint transitions to your slides. These are the visual effects you will see when you go from one slide to the next. Using the appropriate slide transitions can help create a professional and generally…

A table of contents provides the reader with a quick and easy way to navigate through the document. If you create a table of contents in Microsoft Word, for example, you will see different sections listed with page numbers, which you can click to navigate to other parts of your document. However, after creating a table of contents in Word, you may need to make some changes. You may want to change the style or…