Ubuntu 11.10 automatically uses Unity as default session and fall back to 2D for the systems which do not have 3D graphic controllers. To use Ubuntu Classic Desktop(GNOME), you need do little tweaking.
Steps to be followed to use Ubuntu Classic Desktop(GNOME) in Ubuntu 11.10
Open the terminal. To open terminal, keyboard shortcut is Ctrl+Alt+T
In terminal, type sudo apt-get install gnome-session-fallback
Excel templates are very useful whenever we need to do repeated tasks. Excel VBA does it. But Excel VBA is a little hard to learn and implement.
Excel templates is nothing but pre defined format. For example if you want to get Agent productivity report in Excel. You have raw reports which has productive hours, non productive hours and other details. Instead of doing every day look up and sum function, create template. That create a new sheet. In that put all the fiormula or excel functions and required data. So now onwards whenever you need to do the report, just put the raw reports you will get output immediately.
Advantages of Excel Templates:
Saves lot of time
Accuracy of the reports increases as manual work is reduced
No need to know complicated VB codes.
Get time explore new things
Do more analysis on data.
Useful functions and tools to create Excel Templates: Below are minimum Excel formula you should know to create a simple and effective excel templates.
Pivot tables: This is one of the tool very useful. You can customize the data the way you want to. Create calculated fields in pivot table to enhance the look and get more data.
Vlookup and Hlookup functions: These lookup functions will be very handy while you need to map some fields based on some data criteria.
Conditional sum and count: Conditional sum function sumif and conditional count function countif are useful when you need to count or sum of the data for a particular data.
Multi conditional sum and count: There are many occasions we need to find sum or count based on multiple criteria. SUMIFS, COUNTIFS and sumproduct are the useful functions
Tips on Creating Excel Templates:
Always create a template such a way that, the output of the template matches with desired report format. Do not give a scope for manual work on template on regular basis. This will save time.
Use Conditional functions to get ride of error codes such as #n/a. For this IF function with iserror function will be very useful.
While selecting the range, select only the range you have data. Do not select complete sheet. Selecting whole sheet will slow down the template. Using Dynamic ranges will also helpful.
Have you ever came across a situation wherein you wanted to return a value which matches both row and column? VLOOKUP function in Excel returns the value which is matching the row only. In our previous tutorial, we have shown how to perform two column lookup. In this excel tips post, we will guide you on how to perform multi conditional lookup using match and index functions.
Limitations of Vlookup:
VLOOKUP can be used only if the lookup value is in left of the data which we need to extract from the Table or data.
VLOOKUP works with one criteria. That is, lookup value is maximum one.
Multi
Conditional lookup in Excel
To overcome above-mentioned limitations of VLOOKUP, we can use match and index function of excel to get a result like conditional VLOOKUP.
Using Match and Index function for conditional lookup
When Match and index functions of excel used together, we can extract the data from a table irrespective of the weather lookup value is left side or right side of the array. So first let us understand Match and Index functions. To perform conditional lookup, we should understand how match and index functions of excel work.
Excel Index Function
Excel Index function returns a value or reference from a table or range.
Syntax of Excel Index Functions:
=INDEX(array, row_num, [column_num])
Explanation of Index Function components
Array: Is a range or table where we need to extract the data.
row_num: In which row the required value is there.
[column_num]: In which column the lookup value is present.
=INDEX(A1:C5,2,3) returns 3. We are looking for a data which is 2nd row and 3rd column.
Excel Match Function
Match function returns relative position of the specified item is a range of cells.
Match Function Syntax
MATCH(lookup_value, lookup_array, [match_type])
Lookup_value: The value you need to look up.
Lookup_Array: The range where you need to search
[match_type]: Match_type can be -1, 0, or 1. It tells Excel how to match the lookup_value to values in the lookup_array.
1 — find the largest value less than or equal to lookup_value (the list must be in ascending order)
0 — find the first value exactly equal to lookup_value. Lookup_array (the list can be in any order)
-1 — find the smallest value greater than or equal to lookup_value. (the list must be in descending order)
Note: If match type is omitted, by default excel consider it as 1.
Example for Excel Match Function
Consider the same table as above.
=MATCH(“Sahadeva”,A1:A5,0) returns 5. That is the value “Sahadeva” is in 5th row.
Using Index and Match together as an alternative to vlookup
Using index match together will help us in finding 2 criteria lookup and values are present in left of the lookup value.
Here what we did is instead of finding row and column numbers we used Match function to find.
Example: =INDEX(A1:C5,MATCH(“Sahadeva”,A1:A5,0),MATCH(“Class”,A1:C1,0)) This returns 6.
How to MATCH and INDEX work as alternative to VLOOKUP
We are looking into
the table as the range: So, in Index, we used Table as the range. Using Match function,
we found rows number of our lookup value “Sahadeva”. For the column
number, we once again used Match function to find another criteria column
number. That is we are searching for Sahadeva’s Class. So, Class is in 3 row. So,
the function returns the value which is in the 5th row and 3rd Column.
Mozilla Firefox is one of the most popular browser today. It is very fast and safe for browsing. Earlier the default search in Firefox browser was Google. But recently it has changed to Bing by default. Some time even addons and some free software change the default search provider. To change the default search engine in your browser below are the steps given. Mozilla firefox supports address bar search also. So let us first look into change the default search engine for Mozilla Firefox address bar.
Steps for Changing default search engine for Mozilla Firefox address bar:
In Firefox we can search simply by typing the search keywords in the address bar to get result. So below is the step to update the search engine.
Open about:config in Firefox (if you doing it for the first time, you may have to promise you are going to be careful)
Search for keyword.url from the filter box.
Double click on this entry. It will open a dialog where you can edit the ‘keyword.url’ string.
The MS Word by default saves file in My document folder(In Windows 7 just ‘Document’). Whenever we save a file without choosing the destination folder, Word saves the file in Document. These Document folder has restrictions. Only from the user name it created under that user name ‘Document’ folder has the right to open it. So it is ideal to save a files in a common folder or drive by default if multiple users are using the file. Also if you are saving the documents in Documents folder, incase of OS reinstall you will lose the data. So it is highly recommended to save your documents in different drive. Unless the documents are confidential. Let us have a look into the same.
Steps to Change default File Saving path in MS Word
Go to ‘Tools’ Menu and select ‘Options’
In ‘Options’ dialog box, click ‘File Location’ Tab.
Select the ‘Documents’ option under the ‘File Type’ Section.
Select ‘Modify’ button
Choose the folder where you need to save your files always.
Once done save the changes and restart Word to take place the changes.
Steps to Change default File Saving path in MS Word in Word 2010:
Select ‘File’ menu from left top corner.
Choose ‘Options’
In newly opened dialog box select ‘Save’ Tab.
In ‘Default file location’ choose the folder where you need to save the files.
