➤ Microsoft Excel

How to Create a Scatter Plot in Excel - Examples

If there is anything that should be essential during a person's complete training, it is knowing how manage Excel tools . And not just knowing how to make a graph, we are referring to all the possible functions that fall within the scope of learning possibilities. […]

Why does Excel stop responding, freeze, or stop working? - Solution (example)

Excel stops working while working on a spreadsheet? This failure is one of the historical problems of the application and finding the reason is difficult. But that is not why it is an eventuality that has no solution. That is, fixing it is easy, as long as […]

How to use and add picture ActiveX control and show a picture in an Excel workbook

Excel is one of the most powerful tools in Microsoft, it is undoubtedly one of the indispensable programs for any type of work. If you want to learn how to use and add image ActiveX control and display a picture in an Excel workbook , you should read the following […]

How to securely open Word, Excel and PowerPoint documents

Both Word, Excel and PowerPoint are now widely used by people at work or school. If you want to avoid errors when opening a document, you can do so by opening it in safe mode. Don't know how? Today we explain it to you in the topic: how to open word, excel and […]

How to extract numbers and data from an Excel cell in an easy way

Microsoft Excel is currently one of the most used programs in the world to create spreadsheets, in this sense this tool can be used to have control over various processes that require simple and complex calculations . So it will allow you to save time when using […]

How to protect or set an Excel file in a read-only state

The number of uses the Excel tool can be used is impressive. Although its main use as an office automation tool is in the area of calculations and finances. Documents of this type need a specific type of data security protection. As change the status of the […]

How to Use Pivot Table Timeline in Excel - Quick and Easy

Excellent performance The favorite program of many within the Office suite, has enormous versatility. It has truly extraordinary tools (especially when it comes to the formulas that can be applied in a spreadsheet), and an interface that, at first, is cumbersome, […]

How all Excel formulas are used in a spreadsheet

Excel formulas are a very important aspect within the program itself, since despite containing a large dynamism with respect to its functions, they represent the functional part of the tool. The Microsoft company has been improving its creation every day, expanding […]

How to create Dependent Dropdown Lists in Excel (example)

Excel is not only a useful tool for creating spreadsheets. The truth is that, thanks to its multiple functions, it is also useful for organizing lists of all kinds. The more options we master in Excel, the more practical the different activities become. As […]

How to automatically round decimals down in Excel

When it comes to statistics, Excel has become our best ally. And it is that this program, although it was founded years ago, has remained in the ranking of the best due to its easy management. That is why today you will learn to automatically round decimal places […]

How to Easily Convert Excel Spreadsheet to HTML Online for Free

In the business world, different tools are used to increase their investments to the point of allowing them to position themselves in the market, at the same time that they can minimize expenses or payments to creditors. Businesses need to keep accurate records […]

How to create an image catalog using ActiveX Image Control in Excel

The quality of programs like Microsoft Excel and Word is indisputable. These programs were the most used in computers around the world for many years and the first to be installed independently of operating systems. The versatility they have when it comes to […]

How to filter tables in Excel using the Range.Autofilter method

And let's continue with another interesting article on Microsoft Office Excel, this versatile program that allows you to create different projects , using graphs, tables and calculations and is also available online. On this occasion, we will try to explain […]

How to protect, lock or lock multiple cells and formulas in Excel at the same time

There are tons of users working with Microsoft programs, these programs are excellent for many office jobs. Excel, among its functions, helps work with numbers and information grouped in lines. This Microsoft program has several functions requested by users, […]

How to replace text using regular expressions in Excel

The programs that make up the Microsoft Office suite are really useful and are found on most computers. They have become present on mobile devices, being the main allies of those who use the mobile phone as a work tool . Each of these programs has unique functions […]

How to create and run an Anova table in an Excel spreadsheet step by step

Microsoft Excel was no doubt one of the most used tools by companies and commercial companies both national and international, becoming a fundamental ally when making sums and spreadsheets within the accounts of these companies. Allowing us to perform various […]

How to find values and find a number in a column in Excel (example)

Office isn't limited to just layout options for situations like changing the width of a column and the height of a row in Excel; In addition, it provides a number of functions to perform basic and complex tasks. In this article we want to explain how to find values […]

How to create my user form in Excel (example)

Forms greatly simplify your work in Excel. It allows you to create applications very efficient and intuitive within the Office environment . In addition to speeding up processes and avoiding errors when entering data and performing calculations. Creating your […]

How to Add a Column or several Cells automatically with Excel (example)

In any modern business, I employees with knowledge of excel will be evaluated. More if the job is related to accounting or calculation of some element. By focusing on more training in the area of office automation, you will pass a great opportunity to be promoted […]

How to calculate VAT total and subtotal step by step in Excel

Today, acquire a basic understanding of Excel it is essential for everyday life. We can associate it with the career you are doing, as technology advances every day. Over time, all programs help us solve problems more easily. This tool is currently the most […]

How to make financial statements in Excel step by step

Do financial statements in Excel is very easy and practical. Therefore, it is an activity that many users want to do. The Excel tool originates in the Microsoft Corporation company, to which the development and distribution processes are attributed. Excel is […]

What are the types of cell fill in Excel and how to apply them? (Example)

When it comes to office work and organization, we can be sure that we have tons of tools that greatly simplify our working time. And undoubtedly one of the most useful and used tools ever, is the famous Microsoft Excel. If you are a fan of it and want to learn […]

How to alphabetically sort first and last names in a document in Excel

Word processors have made life easier for many when they do writes a document or create a list. Whatever processor or program you use, they all have useful features and tools. In most cases it is really boring to have to order manually lists of products, people […]

How to Consolidate Excel Data from Multiple Sheets into One: Step by Step

Work has never been easier. With each new update of the different Microsoft Office programs, there is a new tool to learn how to use and that, regardless of the complexity that may present itself at the beginning, once you learn how to use it, everything becomes […]

How to consolidate row values or data into a spreadsheet in Excel

The Excel tool allows you to create tables and documents in a very simple way, which allows you to have adequate control over institutions, jobs and companies. If you are interested in creating a good Excel table, you better know how to consolidate the values […]

How to calculate depreciation with the AMORTIZ.PROGRE function in Excel (example)

Excel has multiple tools for managing and organizing data. From creating a daily agenda in Microsoft Excel to functions like AMORTIZ.PROGRE for financial calculations. That is why in this article we will teach you how to calculate depreciation with the AMORTIZ.PROGRE […]

How to make or create a DOUBLE AXIS chart in Excel step by step

Excel helps us through spreadsheets a create tables and act on them . We can also work in Excel from an iPhone or PC mobile, to create graphs with data we have previously created. In this way we will better see the data created in the graphs. In fact, using these […]

How to use form controls to create an order sheet in Excel

Computers, the Internet, and the large number of programs available to all people have been of great help when it comes to working. The programs that are part of Microsoft Office does not I am proof. Excel a favorite In addition to Microsoft Word, Excel is […]

How to avoid, or correct formula errors in Excel - # #DIV/0! # N / A # VALUE!

Microsoft Excel is one of the programs that belongs to Microsoft Office suite; It is characterized by the various functions it incorporates, which allow you to perform a large number of calculations. It also allows people to create an Excel spreadsheet to calculate […]

How to use the ActiveX numeric control in an Excel spreadsheet

When we talk about a spreadsheet, it usually comes to mind that we are able to keep a numerical record of a particular task or project. All of those projects o Jobs that involve keeping numerical records are always much easier when we use a spreadsheet like Excel. And […]

What is it, what is it for and how to activate Paste Special in Excel?

Office tools are widely used in the world, for example, using Microsoft Excel for accounting is excellent and practical. For example, here we will explain what is special pasta and what it is used for in Excel, and thus you can simplify your work faster. What […]

How to apply or insert borders and gradients in the cells of an Excel spreadsheet

IT tools have undoubtedly been of great benefit to all of us, allowing us to create various types of documents such as Excel, being a program linked to Microsoft Office , with a large variety of functions that we can use in a simple and precise way, such as the […]

How to import coordinates and directions to Google Earth from Excel?

Google Earth is the best program if you want to find an address that is not near you. This has such a powerful engine that it even allows its users to add their own GPS coordinates to the existing map (you can even open or create maps with Google Earth). Here because […]

What is the function and syntax of BDMAX and BDMIN formula in Excel?

The “Databases” functions in Excel allow you to apply calculations based on specific conditions. If you want to develop formulas in a database in Excel for BDMAX and BDMIN functions, we recommend that you read this article with which you will learn What is […]

How to Create or Insert a Hyperlink in Excel - Quick and Easy

Among the computer programs developed by Microsoft Office we have Excel, also known as a spreadsheet; These were formed for automate work with numbers and be able to analyze them in a better way. To leave the paper behind and create a custom table style with Excel, […]

How to easily create charts in Excel with various data

Everyone at some point in our life has seen the need to do some sort of graph, but we haven't been able to do it, because we don't have the knowledge to make it and that's why we're here. We needed these graphs both in our work environment and in students, as […]

How to get the TOTAL and SUBTOTAL in EXCEL - Complete guide (example)

In any office they will evaluate those employees who have knowledge of Excel. Especially if the job is to keep the accounts of the place or make repeated calculations of any kind. The more you deepen your knowledge of office automation, the greater the chances […]

How to insert or copy Excel table in Word without moving or modifying it

Le Excel tables are currently widely used , as they will allow and simplify many activities or tasks of the day. In addition, this Microsoft Office program is versatile and will allow you to get the general average in Excel quickly and easily. However, sometimes […]

How to use and configure the ActiveX button and text control in Excel

Hospitality! In case you are new to Excel and would like to know a little more about all the functions it offers us, then you have reached the appropriate post. In this new opportunity we will show you everything you need to know to learn how to use and configure […]

How to easily remove or delete duplicate data in Excel with formula

If you use constantly Excel , it is possible that as you fill the cells with information, some rows are duplicated. And if you haven't downloaded it yet, we recommend installing Microsoft Office. And if you have duplicate cells, you might be wondering, how can […]

How to reduce negative values or numbers in Excel quickly and easily

Now it is the turn of the Excel sheet, which belongs to the Microsoft Office suite and we can only say that it is a real marvel. Of course, when you know how to use its different functions and macros. Since we know that there is still a great lack of knowledge […]

How to calculate annual growth rate in Excel

Excel offers us multiple configuration options. As an office automation tool, it allows you to perform thousands of calculations in minutes and simplifies daily work tasks. Thanks to Excel, activities like the Calculating the annual growth rate are very easy to […]

How to use the ActiveX scroll bar in Excel to scroll to a table

Excel surprises with every tool or trick that is discovered as the handling of this incredible program is perfected. The amount of things you can do is truly extraordinary. To learn how to manipulate these amazing tools, you need to do your part to study the […]

How to quickly add only negative values or amounts in Excel

Technological tools facilitate solving complex mathematical problems in a spreadsheet, which allows the user to increase their power of organization and data analysis in their ability to perform calculations. For example one sum of negative values in Excel. Excel […]

How to Easily Create Spreadsheets in Microsoft Excel Online for Free

Excel is a computer program with which we intend to develop calculation activities, it is part of a computer suite created by the Microsoft company; which together with other programs assert themselves as primary means in the development of office activities . This […]

How to import Excel files and sheets into Google Docs step by step

It is possible that you are working or creating a spreadsheet in Excel and that after obtaining it you want to pass it to Google Docs for backup. However, in order to do this, a series of previous actions must be taken before making it happen. Passing data from […]

How to use form controls to create a budget sheet in Excel

You should know that to make a budget it is not necessary to buy any programs or download an application, since in the packages of Microsoft Windows, which our PC has, comes a powerful tool - Excel. This will help us create forms to enter data in an easy and practical […]

How to force user to enable macros easily in Excel (example)

Sometimes users wonder if they can record a macro in an Excel sheet or What is a macro and its usefulness? However, if you are an advanced user and have already created macros in Excel, we recommend that you read this article with which you will learn how to force […]

How to create an interactive donut chart in an Excel sheet

Graphs are undoubtedly an essential element to be included in Excel tables and documents, because through them it is easier to understand the information which are present in our document. It is for this reason that we want to teach how to create an interactive […]

How to convert an XML file into a Word, Excel or TXT text document

With so many programs to digitally simplify and improve our lives, we can sometimes feel a little overwhelmed. There are many formats that appear to do the same thing, but you need to use one for a particular activity. Therefore, today we show you how to convert […]

How to Create a Simple Web Page Using Excel Is It Possible?

Over the years, more and more tools and platforms have emerged for the creation of online web pages, each with different systems and operations, but it should be noted that most of them have been extremely excellent in terms of quality and options they offer users […]

How to use AMOUNT RECEIVED function syntax in Excel (example)

Using the syntax of the AMOUNT.RECEIVED function allows the manipulation of certain parameters such as the acquisition date of a security, the amount of the investment, and a method or basis for counting days. In that sense, we recommend that you read this article […]

Microsoft Excel