When it comes to spreadsheets, tables, forms and diagrams, the main program we think of is Microsoft Excel, software used both within the educational area, as in the professional; those experts in it really know how to harness its full potential, as most of us only know the tip of the iceberg.
The program can be purchased on disk for installation together with the entire Microsoft Office package , although it is also possible to download Excel from its official site , previously purchasing the license or if you have an Outlook (or Hotmail) account, you can use it online.
Index( )
- What are the ways to search within a form in Excel?
- Are there advantages of doing a smart search over a normal search?
- What is the description of Macro within Excel?
- How do I make a Macro in this program?
- Is it necessary to do a smart search in a form?
What are the ways to search within a form in Excel?
Among the great vastness of functions that the software has, we have the option of doing specific searches , by group, intelligent searches and others. All this makes it easier for us to see some data or a group of them in a spreadsheet with endless information, instead of doing it manually. As the program has been updated, Microsoft has added more variety of search types.
The secret of these searches is done through the formulas , which if we manage to learn or have them written down, we can use them according to the situation. Next, we will proceed to briefly explain each of them:
- The value filter is the most common type of search and the one that most people use, although not precisely to search for data; Well, we can use this function to search for similar values within Excel .
- VLOOKUP formula: if you want to search for a specific value or data, the VLOOKUP formula will do this task, but for a data located in the column, that is, vertically.
- HLOOKUP formula: The variant of the previous search, but instead of searching vertically, it will search horizontally, some data in a row.
- SEARCH formula: Another variant of the previous formulas, but without specifying the horizontal or vertical direction of the search.
- VLOOKUP + Match: This is a combination of two formulas, in which we will first use the Match formula and then VLOOKUP.
- Index + Match: another combination of formulas, in which we will obtain values or results that are a little broader and not so specific.
Other formulas that can be used for searches are IF, IF.ERROR, COUNT.IF; in which we will get results of similar values or values within a specific range in the spreadsheet.
Are there advantages of doing a smart search over a normal search?
The intelligent search is available from the version of Microsoft Excel 2007 and its later versions, it is normally used when the Macros are created within the program, but even so it is possible to use them at any time we need them. Also, if we want, we can also produce our own intelligent search form in which the creation of Macros also enter.
The intelligent search within Excel is at a glance and does not require the use of a formula as in the previous cases; Another advantage of smart search is that we can obtain additional information, not only from numerical data, but also from words, images, videos and others. Well, Excel is not only limited to the inclusion of mathematical values, but it goes much further.
Finally, we will have two types of data if we want more additional information related to the data already mentioned, definitions and/or explorations through internet pages. It should also be noted that it is possible to move columns in Excel to organize .
What is the description of Macro within Excel?
Macros are a set of functions, or better said, of algorithms that we create within the Excel program itself, in which by pressing a key or a command, we can execute a specific action . As we said at the beginning, it is necessary to configure these shortcuts in the first instance, so that Excel can execute the algorithm correctly.
The Macros function in Excel is quite advantageous for those tasks that we carry out very frequently within the program and even more so if they are long, since we will save a great deal of time, instead of doing the function manually.
How do I make a Macro in this program?
To create a Macro within Excel it is simple, in the task bar we select the “View” tab and right at the end we will see the “Macro” option, when we click, a small menu will be displayed with two alternatives “See Macros ” and “Record Macro”; in case you already have one created, select the first option, otherwise, you will have to select the second.
When the program starts recording, Excel will copy all your actions into it and so, when playing it, it will execute the same mouse movements, clicks you make and keys you have touched; when finished, stop the recording, put the name of the Macro and assign a keyboard shortcut to activate it automatically.
Is it necessary to do a smart search in a form?
For a continuous search within a form, although it is possible to use any of the formulas mentioned above, it is better to use an intelligent search for these cases.
