Thanks to antville.org |
Recover a Deleted Word Document
shantanuo
03:39h
In Word, go to Tools, then Options. Under the File Locations tab, double-click AutoRecover files and make a note of that path location. Click Cancel and Close. Open up that folder in My Computer or Windows Explorer and search for any .ASD files. ... Link (0 comments) ... Comment
Saving Filtering Criteria
shantanuo
15:07h
To save filtering criteria, use Custom Views: Step 1: Add the Custom Views icon to the toolbar 1. Place the mouse over one of the toolbars, right click, and select Customize from the shortcut menu. Step 2: Save the filtering criteria 1. Select a cell from the column containing the criteria you want to Filter with. http://www.exceltip.com/st/TipofTheDay/254.html ... Link (0 comments) ... Comment
Returning the Smallest Non-Zero Value
shantanuo
12:11h
I don't remember if I have mentioned this before, but if you want to return the Smallest Non-Zero Value, use array. (entered by pressing Ctrl+Shift+Enter) You can make the formula even shorter by turning it around in this manner: ... Link (0 comments) ... Comment
Another old Excel bug
shantanuo
15:34h
I have noticed an odd thing when it comes to creating CSV files with Excel: the files are not always consistent in how they end each row in the output data. When I create a CSV file that has, perhaps, 70 field (columns) of data and then views the CSV file in a text editor, I noticed that the records all contain carriage returns, but in different places. How do I get the CSV files to contain a consistent number of output fields. This is actually a problem that has been known to Microsoft for quite some time. The Microsoft Knowledge Base includes an article on this topic as early as Excel 97: http://support.microsoft.com/?kbid=77295 http://tinyurl.com/a4gyb ... Link (0 comments) ... Comment
Disable Paste Options
shantanuo
03:18h
Excel include a feature that really annoys some people: Paste Options. When you paste some tidbit of information in your worksheet, Excel displays a small, floating "button" right near the end of the pasted information. Follow these steps to turn it off: 1. Choose Options from the Tools menu. Excel displays the Options dialog box. ... Link (0 comments) ... Comment
Finding a line break
shantanuo
14:32h
how to search for a line break (Alt+Enter) in a cell? http://tinyurl.com/2copgb ... Link (0 comments) ... Comment
Printing a Multi-Line Footer
shantanuo
16:34h
You can create a multi-line header or footer in Excel. The trick is to remember that you cannot press Enter while typing your footer. Instead, to start a new line you should hold down the Alt key as you type 0010 on the numeric keypad. This inserts a line-break character in the footer text. The total length of a header or footer cannot exceed 255 characters. ... Link (0 comments) ... Comment
Picking Up in the Last Document Edited
shantanuo
05:28h
you can jump to the last place that you edited in a document by pressing the Shift+F5 key. In other words, open the document, press the shortcut, and the insertion point jumps directly to the last edit point in the document. ... Link (0 comments) ... Comment
Excel formula tip
shantanuo
04:16h
While you enter a formula in a cell, press CTRL+SHIFT+A to see the arguments in a formula. If you type =RATE, and then press CTRL+SHIFT+A, you can see all the arguments for that function--for example, =RATE(nper,pmt,pv,fv,type,guess). ... Link (0 comments) ... Comment
Excel Tips
shantanuo
09:14h
Quickly Typing Dates into Cells Typing a large amount of data into cells can be tiring, especially if it includes a series of dates. Type the day (serial number only) into cell A1 and add the following formula to insert the month and year into cell B1: =DATE (YEAR(TODAY()), MONTH(TODAY()), A1) Type a full number in the cell and change it to a date by using the following formula: =DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/" &RIGHT(A1,2)) For example, type 122203, the result is 12/22/03. _____ Counting number of unique entries in a specified range By using SUMPRODUCT along with COUNT to count only the number of unique entries in a specified range. The range can be all in one column or row, or may span multiple (adjoining) columns/rows. The formula would be written as: =SUMPRODUCT((1/COUNTIF(A1:C5,A1:C5&""))) where A1:C5 is replaced with the range you want to apply the count to. _____ Retrieving an Item from a List that Meets Multiple Criteria Problem: Solution: _____ Color numbers based on the value result in Microsoft Excel There are two ways to color numbers according to criteria: * Custom formatting for a number with criteria Using custom formats for numbers with criteria Example: [BLUE] #,##0 ;[RED](#,##0) A positive number is displayed in blue; a negative number is displayed in red; and 0 is displayed in blue (since there is no third section, 0 receives the format of the positive number by default). Add a condition to the formatting, and have each section be displayed in a different color: [BLUE] [>5000]#,##0 ;[RED](#,##0); #,##0 _____ Indicators for the maximal and minimal values Solution: ... Link (0 comments) ... Comment |
Online for 7297 days
Last modified: 7/16/22, 4:46 AM Status
Youre not logged in ... Login
Menu
Search
Calendar
Recent updates
Card issuing banks CITI
Standard Chartered HSBC American Express HDFC ICICI AXIS INDUS IND Kotak...
by shantanuo (7/16/22, 4:46 AM)
Activate IAM Access To activate
the Activate IAM Access setting, you must log in to...
by shantanuo (7/12/22, 5:52 AM)
use cheat instead of man
wget https://github.com/cheat/cheat/releases/download/4.2.3/cheat-linux-arm64.gz gunzip cheat-linux-arm64.gz chmod 770 cheat-linux-arm64 ./cheat-linux-arm64 mv cheat-linux-arm64...
by shantanuo (7/4/22, 8:53 AM)
python module itertools list of
useful methods of itertools module. permutations combinations combinations_with_replacement zip_longest count...
by shantanuo (9/8/21, 7:50 AM)
wikipedia tools 1) Collection of
useful utilities https://wikipediatools.appspot.com/ 2) all history of a user https://xtools.wmflabs.org/ec/mr.wikisource.org/Shantanuo...
by shantanuo (8/20/21, 6:36 AM)
Duration/Term of Copyright In the
case of original literary, dramatic, musical and artistic works, the...
by shantanuo (8/20/21, 6:26 AM)
Preserve seeds 6 types of
seeds to be preserved for next season. 1) laal Mula...
by shantanuo (5/7/21, 5:46 AM)
Why do I care for
Linux? I don't care that much for other software. Linux...
by shantanuo (12/17/20, 9:27 AM)
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math. (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20, 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20, 11:24 AM)
Standard out to a file
This code will change the standard out to a file...
by shantanuo (4/11/20, 11:18 AM)
Create config file for AWS
command line tool While creating amazon config file in a...
by shantanuo (2/20/20, 6:00 AM)
setting colors in pandas This
is how to set the colors in pandas mapper =...
by shantanuo (2/20/20, 5:53 AM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20, 10:33 AM)
access AWS API gateway using
python Amazon API gateway allows us to host serverless API's...
by shantanuo (2/16/20, 9:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20, 10:28 AM)
backup mysql users 3
steps to install percona utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20, 1:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20, 1:30 PM)
apply colors to pandas Here
is how to change the color of negative values to...
by shantanuo (2/12/20, 8:57 AM)
Holidays in India These are
the common holidays celebrated in India (Mumbai) during 2016 -...
by shantanuo (2/11/20, 1:53 PM)
change log file size in
MySQL Here are the steps to be followed while changing...
by shantanuo (2/11/20, 10:38 AM)
MySQL common error messages 1146
Table does not exist 1054 column does not exist 1062...
by shantanuo (2/11/20, 10:13 AM)
ipython parallel demo First start
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
by shantanuo (2/9/20, 9:02 AM)
djanog settings You may see
this message if you have DEBUG = True in your...
by shantanuo (2/9/20, 4:07 AM)
clear tmp folder Here is
following commands to clear unwanted stuff from the /tmp partition...
by shantanuo (2/8/20, 2:41 PM)
|