Microsoft Office Tricks: Become an expert with these secret tips and advice – List 2022

When we refer to microsoft-office we are referring to the office suite most popular and important in the world. It has a wide variety of well-known programs that will help you carry out different activities, either create spreadsheets, reports, slidesamong others.

Therefore, being able to know each of the tricks available in the suite is essential in order to be able to enjoy and get the most out of each of these programs. Keep in mind that this will help you work in a more fast and comfortable.

Taking into account the importance of these tricks, here we are going to explain which are the most important so that you can start to become a real expert and increase your productivity in each of the programs microsoft office suite.

Is Microsoft Office the best digital office suite? Main benefits

Today the office suite he is considered like the best digital office suite in the world, This is because it is made up of very popular and successful programs such as Word, Excel, PowerPoint, among others. Where each of them offers functions and tools very advanced and professionalideal to be used by both large companies, businesses, and for personal use.

In addition, it stands out for offering a large number of benefits and advantages to each of its users, which we show you below:

• It’s a pack of completely free programs and that help improve the productivity of a company.
• Each of these softwares have Automatic Updates to the latest version, which allows you to save time on maintenance and configurations.
• It’s a universal program which encompasses all or almost all of the industry when it comes to desktop publishing.
• Has a Easy to useeach of the programs have essential characteristics that make their operation the most optimal and simple. They are ideal for both personal and business use.
• Microsoft Office you It allows run and edit documents simultaneouslywhich helps you to have better performance and efficiency when creating various reports.
• Offers a auto save system for those occasions where the program is closed due to some error or system problem.
• It allows you insert content from PDF directly into Microsoft Word.
• It has a service cloud storage via OneDrive, where you can host all the information you want and then access it from any place and device. It stands out for offering a excellent security for your data.

List of the best tricks to get the most out of Microsoft Office programs

Taking into account the importance of this package and each of its benefits, it is important to know which are his main tricks in order to get the best possible performance and become an expert in each of these softwares.

In this way, here we explain what are the best tricks that you can start using in the Microsoft Office package:

Move items around in Word

In case you are using Microsoft Word and have one enumerated listbut realize that this is messy you can start order it move each of the elements without the need to use the options of copy and paste.

Therefore, a faster way to order all this data is by placing the cursor over element you want to move and pressing the keys “Alt + Shift” simultaneously, you can move the element up or down until you put it in its correct position.

Dictionary of Synonyms

Usually when you write a quite long text and is related to a constant theme, It can be a bit difficult to get the enough synonyms that allow enrich the text and this way avoid fillers and expressive monotony.

In the case of Word there is a very good trick that will help you get the necessary synonyms so you can make a very professional text. To do this you simply have to place the cursor over the word you want and right click, there will appear several options where we will select “Synonyms”, there you will see different words where you choose the most suitable for your text.

Restriction of entered data

In the case of microsoftexcel, the user has the possibility to set a restriction on the entered data. This allows you to work with a certain data formatpreventing these values ​​are infinite which makes the job more difficult.

In order to use this property, the user must select the cells the one he wants apply this restriction. Once selected, the next thing will be to enter the tab of “Data”, there we select the option of “Data validation”. By selecting this tool we can start set restrictions in each of the previously selected cells.

Mathematical equations

Another of the great advantages offered by programs of the office suite is that it gives you the possibility ofInsert mathematical equations into your spreadsheet or text document. Note that here you can insert basic and advanced formulas in a very simple way.

It is also important to mention that these software by default already include some basic formulas which are widely used in mathematical operations. In the case that you add a formula you can store it for the next time you need it.

To do this, you must click on the option What would you like to do? and there you write “Equation”, then the option will appear “Insert equation” which we select. Finally a window appears with the equations that come by defaultas well as the possibility of write yours.

Insert fonts into a PowerPoint file

One of the most common problems of users when using PowerPoint is at the time of insert fonts into a filesince sources are generally used that not available on all devices. Therefore, at the time of opening the file on another computer generates design errors that harm reader display.

However, there is a way to avoid this fault in PowerPointfor this the system includes a tool that allows embed the fonts used in the document within the file itself. This allows that when opening the document on another computer these can be displayed without problems.

To activate this tool you must go to “File” > “Options” > “Save”. There we select the checkbox “Embed fonts from file”this will include all the fonts that have been used in that project.

Use graphical forecasts

In the case of people and professionals who are constantly working with charts and data, Microsoft Office It has a function that allows you to forecasts based on historical data. In this case, use a exponential smoothing algorithm which is available at Excel. This allows you to work more comfortably and safely.

You can activate this option by clicking on “Data”, there we select the option of “Foresight sheet”. This way you can start making use of this functionality for what it is data analysis and processing.

Do smart searches

Another of the great advantages offered by Word is to be able to do smart searches and thus define a word within the document without the need to leave it. To do this, the application takes care of opening a window and in it launch the web browser window. This allows you to save time and work while creating your text document.

To be able to carry out this trick you simply have to right click on the word you want to search for. Among the options we select “Smart search” and on the right side of your work screen you will see a panel with said search.

Align PowerPoint elements automatically

There are different forms of power. add new elements to the PowerPoint work slide. However, the easiest and fastest is dragging said element and dropping it on top of the content where we want to insert it. But one of the drawbacks that we find is that these elements rarely are correctly aligned. Keeping in mind that if these do not line up they can give a bad impression to the reader.

One of the ways to solve this problem is activating the auto-align option, this will prevent you from wasting time aligning objects or elements manually. To do this you must enter “Format” > “Align” > “Align selected objects”, after this the software will do everything for you.

Activate autosave

One of the most common problems for users when working with some of the programs in this package is the savedsince on many occasions we are forget to save the information that we carry from time to time, taking into account that they can be cause software crashes and lose information.

Therefore, there is an option for the program to save for you every so often. To activate the tool “Autosave”, you have to enter “File” > “Options” > “Save”, there check the box “Save AutoRecover information” in this way the system will save the information for you.

Edit a PDF file in Word

As usual, files saved in PDF are not editable, especially since these are located write protected. Although this is no longer such a problem thanks to the large number of programs that currently exist that allow you to skip this step. Nevertheless, Word is not a program created or specialized to carry out this activityso this will depend on the person who has created the PDF document.

If the person creating the document allows editing authorizationthen you have the possibility to edit it with Word in a very easy and fast way. To do this, you must go to “File, Archive” and select “Open”, in the “file explorer” Search the PDF you want to edit and click on “Open”. This way you can start editing it from this office-software.

Recover an unsaved PowerPoint presentation

There are many reasons why you can close the software and lose all the information that had been createdthis can be somewhat tedious and difficult to accept, especially if it is about slides that have taken a lot of work to put together. But luckily, in the case of Microsoft Office software has a tool default backups.

Therefore, thanks to this tool you have the opportunity to recover your file and continue working on it. For this you must open PowerPoint and enter “File, Archive” > “Open”. There you will see an option to “Recover unsaved presentations”, we select it and then we choose the presentation that we want to recover.

Dictate a text to Microsoft Word

It is possible that on many occasions you have wondered if there is a way to add text to the document without the need to write it in it, since it is worth mentioning that this is possible. This is how this program has the option of dictate text which will help you save time.

This is about a add-in for office, and which works in Spanish. To activate it, you simply have to install it and in the upper bar of options, the tab of “Dictate”, you just have to click on it and start speaking while Word copies everything you say.

Add the current date to one of the Excel boxes

keyboard shortcuts in excel They can help you work much faster and thus save time and many more hours of work. Therefore, at the time of edit the different cells of the spreadsheet, you can work with them more comfortably, that is why you can includeadd the current date to the selected cell in a very fast way. You just have to press “Ctrl + ;” for the date to appear automatically.

Schedule emails in Outlook for delivery

This is one of the best tricks that we can find in office suite, especially if you are one of the people who is constantly using the email. This is how you will have the possibility of schedule emails in Outlook through a simple trick.

In the case of gmailin order to do this it is necessary install an extension in the browser, but this does not happen with Outlook. In this case you just have to enter to the message you want to sendselect the section “Options”, and then click on “Delay delivery”. Here a new window will open where you have to enter both the date as the time in which you want to schedule the shipment and finally select “Send”.

Remove all formatting from text in Word

When we use this program and we copy fonts from one website and anotheras a result we get a clutter in text formatting. Therefore, it is best to remove formatting from all text and in this way to be able set a new one and that is the same for all. This will allow you to have a single font and a neater project.

To do this, simply enter “Format” > “Clear format”. Note that here everything will be deleted automaticallywhether they are italics, bold, bullets, links, and any other elements that have been added previously.

Sync notes across your Android and iOS devices

One of the most recent products to be incorporated into the microsoft office suite has been OneNote, a program that allows you to take notes very quickly and easily on the subject you want. At first this program was created only for The computersHowever, it is currently also used in Android and iOS mobile devices.

This way you can start install its application on the smartphone and log in with your Outlook account, there you will have to sync your account manually or automatically with all the notes between your devices.

Remove background from an image

This is one of the most unknown tricks by office usersand at the same time one of the most attractive and interesting. On many occasions an image is inserted PowerPointbut the background of it does not match the rest of the slide, which makes this look bad.

Generally, users go to advanced design software What Photoshop or GIMP to remove background from image and that way only leave what really matters. But, this is something that can be done directly from Office interface.

To do this you just have to enter “Format” > “Settings” > “Remove background”. In this way the program by itself crop the image removing the background of it.

Sum all cells in a column

On many occasions when we work in a spreadsheet you usually have a column with a lot of numerical values. You may need to know the sum of all of it. For this there is a shortcut that you can do directly with The mouse and which will not take you more than 10 seconds.

It consists of select the entire column with the numeric values what do you want to add Once this is done, in the lower right part of the screen will appear the sum of the column.

Protect the document with a password

In case you have to share your computer with your family or just find yourself working in the team of your university or companywhich is also used by other people, it is best to put a password so that you can keep your files safe.

This will allow you to have greater protection in your document and thus prevent third parties from coming to modify some information in it. You can do this trick in almost all the programs in the package.

To do this you must enter “File, Archive” and then in “Save as”, In the lower area you will see an option that says “Tool”, click on it and select “General Options”, at this point you should write a password which will be requested when you want to enter the document again.

Select an entire column of your spreadsheet

Excel It is mainly characterized by offering a large number of shortcuts that we can do with the keyboard, they are intended to provide a greater comfort and speed when working for the user. That is why you have the option to select an entire column simply pressing two keys simultaneously.

As we already know, this selection process is commonly carried out with The mouse, which we click on the beginning of the column and drag it to the end of the column, which can end up taking a lot of time. In this case just select the first cell of the column and press the keys “Ctrl + space bar” and all will automatically be selected.