How to View Wifi Passwords: The Complete Step-by-step Guide to View your Wifi Passwords. Disclaimer: Information is only to gain and improve upon the existing knowledge.
Human Anatomy and Physiology: Know all about it. While anatomy is about structure, physiology is about function. Human physiology works closely with the scientific study of the chemistry and physics of body structures and ways to support life funct…
Realme Smartwatch: Reviews, Specifications, Price and Buy Link. Realme S Pro This new feature is the first thing which one will notice is that it has GPS in it. The Realme Watch S Pro has many specifications - more than 100 hours to choose from, 15 …
How to Add Signature in Microsoft Outlook Email: Step-by-step Guide. Microsoft Outlook is a powerful tool to add your officials or private mails that sync using a respective mail server such as Gmail or office server. You can add an Outlook signatu…
Charts Charts and Graphs Microsoft Excel lets you turn your raw data into a variety of charts and graphs. Using this feature, you can visually summarize numerical information and display any trends or patterns that are present. Charts and graphs …
STRING FUNCTIONS: To remove all non printable characters. CLEAN =CLEAN(text) To combine two or more strings. CONCATENATE =CONCATENATE(text1, text2) to combine any specific word use "" (invert…
Numeric/Mathematic Function- To know the average value of numbers provided. Average called also arithmetic mean AVERAGE =AVERAGE(Number1, Number2, ...Number_n) To count the number of cell that contains numbers. COUNT …
THE FUNCTION WIZARD There are two ways to insert a function in excel spreadsheet: 1-By typing directly into the cell or in fourmula bar. 2-By using the INSERT FUNCTION option. There are many ways to accessing the INSERT …
MS Excel Intro IMPORTANCE OF EXCEL Excel is the most important computer software program used in workplace today. This one is the main reason to learn excel in order to enter or remain in the workplace. In the field of information systems excel is …
MACROS: Macros is one of the best function in Excel. With the help of Macros you can automate your work. Macro is a set of instructions that tells excel what to do. Macros commands are written in Visual Basic for Applications(VBA) programming langua…
For every option there is an access key. Anyone can quickly use a command by pressing a few keys. Every command can be accessed by using an access key. You can get the most commands by using two to five keystrokes. To use an access key: 1. Press ALT…
VLOOKUP Function: The VLOOKUP function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. The V in VLOOKUP means "Vertical". Syntax:- =VLOOKUP(value, tabl…
Search And Replace: If you want to replace all the words before or after a particular word, string, symbol etc. 1- Press CTRL+H, there is a Find and Replace dialogue box will show. 2- Now we have a data of bus terminal names and we want to replace a…
How to find duplicate words in a cell in excel with example? To find a duplicate value or word in a cell in excel we can use IF function with SUBSTITUTE function. Now suppose a data contains addresses and we want to know either that data contains du…
Match: Supposedly one is in a real hurry ( i think this needs not to be "supposed" as we have already been made to swallow that time = money), one needs to find the relative position of specific item in a speific range in excel. In such ca…
If: "Ifs" and "Buts" only call the satan and by using If, you can think of all satanically conditional work that can be done in excel. It is simple and easy to use and the output is all the more pleasing. So let me hurry up with …
Index: One propensitates towards complacency after learning the lookups, match, Sumif, Countif etc. because all these are day to day functions and one feels good about himself especially after he/she is tending towards being a rising star in the ey…
Offset: If the hlookup and vlookup belong to one family then one can say Match and Offset belong to the other one. Offset is a pretty simple formula to be used in excel. However, as a suggestion from my end, one needs to use it in small data workboo…
Hlookup Formula with example: An advice - if one asserts to be an excel user and is sincere in his claims, then you just can't get without saying - "i don't know the lookup family in excel". Vlookup and hlookup are the lynchpins of…
Pivot Table: Pivot Table is one of the most powerful tools of excel. Infact, justice to pivot tables cannot be done by using more words however, it is one of "the more you sink yourself, the more you challenge yourself" kind of a tool. It …
