Search And Replace

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 all the data written before terminal.3- Now in find what field of Search and Replace dialogue box type Terminal and put asterisk<*> symbol before Terminal <*Terminal> and in Replace with field...

Read More

Vlookup Function

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, table_array, index_number, [not_exact_match])VLOOKUP is used when your comparison values are located in a column to the left of the data that you want to find. (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle...

Read More

Navigating the options with keyboard

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 key:The KeyTips are displayed over each option that is available.2. Press the letter shown in the KeyTip over the feature that you want to use.3. After pressing the letter which you want, you may be shown...

Read More

Macros / How to Record Macros in Excel

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 language.Macro function records your actions or commands. Recorded macros can be run whenever you want, automatically repeating your recorded actions and saving your time and effort. (adsbygoogle = window.adsbygoogle...

Read More

Introduction to MS Excel

MS Excel IntroIMPORTANCE OF EXCELExcel 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 used as an end-user computing tool.Outside the workplace, Excel is also use for everyday problem solving.Calculation in excel is very easy and effective. With the help of excel, you can calculate the...

Read More

Function Wizard & Cell Reference

THE FUNCTION WIZARD There are two ways to insert a function in excel spreadsheet: (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); 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 FUNCTION dialog box:1-Go to formulas menu and click on INSERT FUNCTION option.2-Just click on INSERT FUNCTION(fx)...

Read More

Numeric/Mathematical Function

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 =COUNT(argument1, argument2, ....argument_n)*argument1, argument2..argument_n can be the ranges or cells or values. To count the number of cells in a given criteria.  COUNTIF =COUNTIF(range, criteria) To count the number of cells in single or multiple criteria. COUNTIFS =COUNTIFS(critaria1_range,...

Read More

Formulas: String Functions

STRING FUNCTIONS: (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); To remove all nonprintable characters.CLEAN=CLEAN(text) To combine two ormore strings. CONCATENATE =CONCATENATE(text1, text2) to combine any specificword use "" (invertedcommas) like "excel". To extract a substring froma string starting from theleft-most character. LEFT =LEFT(text, no of characters) To find the length of anyspecified string. LEN =LEN(text) To ...

Read More

Excel Charts And Graphs

ChartsCharts and Graphs  Microsoft Excel lets you turn your raw data into a variety of charts and graphs. Using this feature, you can visuallysummarize numerical information and display any trends orpatterns that are present. Charts and graphs can help make your data more meaningful and easier to understand.When you create a chart or graph, you will have a number of types and styles to choose from. Make sure to choose the chart type that...

Read More