Learn Visual Basic 6.0(VB6.0)|Tutorial and Source code samples - Experts Mag

Learn Visual Basic 6.0(VB6.0)|Tutorial and Source code samples - Experts Mag

Read More

75 Super Excel Magic

25 Very Useful Keyboard Shortcuts

1. To format any selected object, press ctrl+1
2. To insert current date, press ctrl+;
3. To insert current time, press ctrl+shift+;
4. To repeat last action, press F4
5. To edit a cell comment, press shift + F2
6. To autosum selected cells, press alt + =
7. To see the suggest drop-down in a cell, press alt + down arrow
8. To enter multiple lines in a cell, press alt+enter
9. To insert a new sheet, press shift + F11
10. To edit active cell, press F2 (places cursor in the end)
11. To hide current row, press ctrl+9
12. To hide current column, press ctrl+0
13. To unhide rows in selected range, press ctrl+shift+9
14. To unhide columns in selected range, press ctrl+shift+0
15. To recalculate formulas, press F9
16. To select data in current region, press ctrl+shift+8
17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)
18. While editing formulas to change the reference type from absolute to relative vice versa, press F4
19. To format a number as currency, press ctrl+shift+4 (ctrl+$)
20. To apply outline border around selected cells, press ctrl+shift+7
21. To open the macros dialog box, press alt+F8
22. To copy value from above cell, press ctrl+’
23. To format current cell with comma formats, press ctrl+shift+1
24. To go to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press ctrl+shift+pg up

20 Situations and How to Solve them using Excel Formulas

26. To get the first name of a person, use =left(name,find(” “,name)-1)
27. To calculate mortgage payments, use =PMT(interest-rate,number-of-payments,how-much-loan)
28. To get nth largest number in a range, use =large(range,n)
29. To get nth smallest number in a range, use = small(range,n)
30. To generate a random phone number, use =randbetween(1000000000,9999999999), needs analysis toolpak if you are using excel 2003 or earlier
31. To count number of words in a cell, use =len(trim(text))-len(SUBSTITUTE(trim(text),” “,”"))
32. To count positive values in a range, use =countif(range,”>0″)
33. To calculate weighted average, use SUMPRODUCT() function
34. To remove unnecessary spaces, use =trim(text)
35. To format a number as SSN using formulas, use =text(ssn-text,”000-00-0000″)
36. To find age of a person based on DOB, use =TEXT((NOW()-birth_date)&”",”yy “”years”" m “”months”" dd “”days”"”), output will be like 27 years 7 months 29 days
37. To get name from initials from a name, use IF(), FIND(), LEN() and SUBSTITUTE() formulas
38. To get proper fraction from a number (for eg 1/3 from 6/18), use =text(fraction, “?/?”)
39. To get partial matches in vlookup, use * operator like this: =vlookup(“abc*”,lookup_range,return_column)
40. To simulate averageif() in earlier versions of excel, use =sumif(range, criteria)/countif(range, criteria)
41. To debug your formulas, select the portions of formula and press F9 to see the result of that portion
42. To get the file extension from a file name, use =right(filename,3) (doesn’t work for files that have weird extensions like .docx, .htaccess etc.)
43. To quickly insert an in cell micro-chart, use REPT() function
44. COUNT() only counts number of cells with numbers in them, if you want to count number of cells with anything in them, use COUNTA()
45. Using named ranges in formulas saves you a lot of time. To define one, just select some cells, and go to menu > insert > named ranges > define

15 Excel Tips on Improving Productivity Using Excel

46. To format a number as SSN, use the custom format code “000-00-0000″
47. To format a phone number, use the custom format code “000-000-0000″
48. To show values after decimal point only when number is less than one, use [<1]_($#,##0.00_);_($#,##0_) as formatting code
49. To remove grid lines from excel worksheet, go to menu > tools > options > and un-check grid lines option. (Excel 2007: office button > excel option > advanced)
50. To hide a worksheet, go to menu > format > sheet > hide
51. To align multiple objects, like charts, drawings, pictures use drawing toolbar > align and select alignment option
52. To freeze rows on top, select the a row and use menu > window > freeze panes
53. To disable annoying formula errors, go to menu > tools > options > error checking tab and disable errors you don’t want to see
54. To change the shape of cell comments from rectangle to some other symbol, select the comment, go to drawing tool bar and change the shape from there 55. To transpose a range of cells, copy the cells, go to empty area, and press alt+e+s+e
56. To save data filter settings so that you can reuse them again, use custom views
57. To select all formulas, press CTRL+G, select “special” and check “formulas”
58. To select all constants, press CTRL+G, select “special” and check “constants”
59. To clear formats from a range, select menu > edit > clear > “formats”
60. To move a chart and align it with cells, hold down ALT key while moving the chart

9 Charting Tips for Everyone

61. To create an instant micro-chart from your normal chart, use camera tool
62. Understand data to ink ratio to reduce chart junk, using even a pixel more of ink than what is needed can reduce your chart’s effectiveness
63. Combine two different types of charts when one is not enough, to use, add another series of data to your sheet and then right click on it and change the chart type
64. To reverse the order of items in a bar / column chart, just click on y-axis, press ctrl+1, and check “categories in reverse order” and “x-axis crosses at maximum category” options
65. To change the marker symbol or bubble in a chart to your own favorite shape, just draw any shape in worksheet using drawing toolbar, then copy it by pressing ctrl+c, now go to the chart and select markers (or bubbles) and press ctrl+v
66. To create partially overlapped column / bar charts, just use overlap and gap settings in the format data series area. A overlap of 100 will completely overlap one series on another, while 0 separates them completely
67. To increase the contrast of your chart, just remove grayish background color that excel adds to the chart (in versions excel 2003 and prior)
68. To save yourself some trouble, always try to avoid charts like – 3D area charts (unstacked), radar charts, 3D Lines, 3D Columns with multiple series of data, Donut charts with more than 2 series of data
69. To improve comparison, replace your radar charts with tables

6 simple steps for better chart formats

70. Remove any vertical grid-lines
71. Change horizontal grid-line color from black to a very light shade of gray
72. Adjust chart series colors to get better contrast
73. Adjust font scaling (for versions excel 2003 and prior)
74. Add data labels and remove any axis (axis labels) if needed
75. Remove chart background colors

Read More

Boot Windows XP Fast

Follow the following steps

1. Open notepad.exe, type "del c:\windows\prefetch\ntosboot-*.* /q" (without the quotes) & save as "ntosboot.bat" in c:\
2. From the Start menu, select "Run..." & type "gpedit.msc".
3. Double click "Windows Settings" under "Computer Configuration" and double click again on "Shutdown" in the right window.
4. In the new window, click "add", "Browse", locate your "ntosboot.bat" file & click "Open".
5. Click "OK", "Apply" & "OK" once again to exit.
6. From the Start menu, select "Run..." & type "devmgmt.msc".
7. Double click on "IDE ATA/ATAPI controllers"
8. Right click on "Primary IDE Channel" and select "Properties".
9. Select the "Advanced Settings" tab then on the device or 1 that doesn't have 'device type' greyed out select 'none' instead of 'autodetect' & click "OK".
10. Right click on "Secondary IDE channel", select "Properties" and repeat step 9.
11. Reboot your computer.

Read More

Learn Visual Basic 6.0(VB6.0)|Tutorial and Source code samples

Do you want to learn Visual Basic 6.0 from starting......

Visit on

www.vb6.us

Read More

Disable CD Autorun

1) Click Start, Run and enter GPEDIT.MSC

2) Go to Computer Configuration, Administrative Templates, System.

3) Locate the entry for Turn autoplay off and modify it as you desire.

Read More

Delete Locked Files

Let's Start Some times we delete files in computer but we can not delete because of these files already in use or we want to rename but also we can not but there is a solution for this....... Download Unloker 1.8 and install this.............. Download Unlocker

Read More

Samsung Secret Codes

Software version: *#9999# IMEI number: *#06# Serial number: *#0001# Battery status- Memory capacity : *#9998*246# Debug screen: *#9998*324# - *#8999*324# LCD kontrast: *#9998*523# Vibration test: *#9998*842# - *#8999*842# Alarm beeper - Ringtone test : *#9998*289# - *#8999*289# Smiley: *#9125# Software version: *#0837# Display contrast: *#0523# - *#8999*523# Battery info: *#0228# or *#8999*228# Display storage capacity: *#8999*636# Display SIM card information: *#8999*778# Show date and alarm clock: *#8999*782# The display during warning: *#8999*786# Samsung hardware version: *#8999*837# Show network information: *#8999*638# Display received channel number and received intensity: *#8999*9266# *#1111# S/W Version *#1234# Firmware Version *#2222# H/W Version *#8999*8376263# All Versions Together *#8999*8378# Test Menu *#4777*8665# GPSR Tool *#8999*523# LCD Brightness *#8999*377# Error LOG Menu *#8999*327# EEP Menu *#8999*667# Debug Mode *#92782# PhoneModel (Wap) #*5737425# JAVA Mode *#2255# Call List *#232337# Bluetooth MAC Adress *#5282837# Java Version Type in *#0000# on a Samsung A300 to reset the language Master reset(unlock) #*7337# (for the new samsungs E700 x600 but not E710) Samsung E700 type *#2255# to show secret call log (not tested) Samsung A300, A800 phone unlock enter this *2767*637# Samsung V200, S100, S300 phone unlock : *2767*782257378# #*4773# Incremental Redundancy #*7785# Reset wakeup & RTK timer cariables/variables #*7200# Tone Generator Mute #*3888# BLUETOOTH Test mode #*7828# Task screen #*#8377466# S/W Version & H/W Version #*2562# Restarts Phone #*2565# No Blocking? General Defense. #*3353# General Defense, Code Erased. #*3837# Phone Hangs on White screen. #*3849# Restarts Phone #*7337# Restarts Phone (Resets Wap Settings) #*2886# AutoAnswer ON/OFF #*7288# GPRS Detached/Attached #*7287# GPRS Attached #*7666# White Screen #*7693# Sleep Deactivate/Activate #*2286# Databattery #*2527# GPRS switching set to (Class 4, 8, 9, 10) #*2679# Copycat feature Activa/Deactivate #*3940# External looptest 9600 bps #*4263# Handsfree mode Activate/Deactivate #*2558# Time ON #*3941# External looptest 115200 bps #*5176# L1 Sleep #*7462# SIM Phase #*7983# Voltage/Freq #*7986# Voltage #*8466# Old Time #*2255# Call Failed #*5376# DELETE ALL SMS!!!! #*6837# Official Software Version: (0003000016000702) #*2337# Permanent Registration Beep #*2474# Charging Duration #*2834# Audio Path (Handsfree) #*3270# DCS Support Activate/Deactivate #*3282# Data Activate/Deactivate #*3476# EGSM Activate/Deactivate #*3676# FORMAT FLASH VOLUME!!! #*4760# GSM Activate/Deactivate #*4864# White Screen #*7326# Accessory #*7683# Sleep variable #*3797# Blinks 3D030300 in RED #*7372# Resetting the time to DPB variables #*3273# EGPRS multislot (Class 4, 8, 9, 10) #*7722# RLC bitmap compression Activate/Deactivate #*2351# Blinks 1347E201 in RED #*2775# Switch to 2 inner speaker #*7878# FirstStartup (0=NO, 1=YES) #*3838# Blinks 3D030300 in RED #*2077# GPRS Switch #*2027# GPRS Switch #*0227# GPRS Switch #*0277# GPRS Switch #*22671# AMR REC START #*22672# Stop AMR REC (File name: /a/multimedia/sounds/voice list/ENGMODE.amr) #*22673# Pause REC #*22674# Resume REC #*22675# AMR Playback #*22676# AMR Stop Play #*22677# Pause Play #*22678# Resume Play #*77261# PCM Rec Req #*77262# Stop PCM Rec #*77263# PCM Playback #*77264# PCM Stop Play #*22679# AMR Get Time *#8999*364# Watchdog ON/OFF *#8999*427# WATCHDOG signal route setup *2767*3855# = Full Reset (Caution every stored data will be deleted.) *2767*2878# = Custom Reset *2767*927# = Wap Reset *2767*226372# = Camera Reset (deletes photos) *2767*688# Reset Mobile TV #7263867# = RAM Dump (On or Off) *2767*49927# = Germany WAP Settings *2767*44927# = UK WAP Settings *2767*31927# = Netherlands WAP Settings *2767*420927# = Czech WAP Settings *2767*43927# = Austria WAP Settings *2767*39927# = Italy WAP Settings *2767*33927# = France WAP Settings *2767*351927# = Portugal WAP Settings *2767*34927# = Spain WAP Settings *2767*46927# = Sweden WAP Settings *2767*380927# = Ukraine WAP Settings *2767*7927# = Russia WAP Settings *2767*30927# = GREECE WAP Settings *2767*73738927# = WAP Settings Reset *2767*49667# = Germany MMS Settings *2767*44667# = UK MMS Settings *2767*31667# = Netherlands MMS Settings *2767*420667# = Czech MMS Settings *2767*43667# = Austria MMS Settings *2767*39667# = Italy MMS Settings *2767*33667# = France MMS Settings *2767*351667# = Portugal MMS Settings *2767*34667# = Spain MMS Settings *2767*46667# = Sweden MMS Settings *2767*380667# = Ukraine MMS Settings *2767*7667#. = Russia MMS Settings *2767*30667# = GREECE MMS Settings *#7465625# = Check the phone lock status *7465625*638*Code# = Enables Network lock #7465625*638*Code# = Disables Network lock *7465625*782*Code# = Enables Subset lock #7465625*782*Code# = Disables Subset lock *7465625*77*Code# = Enables SP lock #7465625*77*Code# = Disables SP lock *7465625*27*Code# = Enables CP lock #7465625*27*Code# = Disables CP lock *7465625*746*Code# = Enables SIM lock #7465625*746*Code# = Disables SIM lock *7465625*228# = Activa lock ON #7465625*228# = Activa lock OFF *7465625*28638# = Auto Network lock ON #7465625*28638# = Auto Network lock OFF *7465625*28782# = Auto subset lock ON #7465625*28782# = Auto subset lock OFF *7465625*2877# = Auto SP lock ON #7465625*2877# = Auto SP lock OFF *7465625*2827# = Auto CP lock ON #7465625*2827# = Auto CP lock OFF *7465625*28746# = Auto SIM lock ON #7465625*28746# = Auto SIM lock OFF Type *#9998*627837793# Go to the 'my parameters' and there you will find new menu where you can unlock phone.(not tested-for samsung C100) To unlock a Samsung turn the phone off take the sim card and type the following code *#pw+15853649247w# . Java status code: #*53696# (Samsung X600) If you want to unlock your phone put a sim from another company then type *#9998*3323# it will reset your phone. Push exit and then push 7, it will reset again. Put your other sim in and it will say sim lock, type in 00000000 then it should be unlocked. Type in *0141# then the green call batton and it's unlocked to all networks. This code may not work on the older phones and some of the newer phones. If it doesn't work you will have to reset your phone without a sim in it by typing *#2767*2878# or *#9998*3855# (not tested)

Read More

Nokia Secret Codes

              On the main screen type
*#06# for checking the IMEI (International Equipment Identity).
*#7780# reset to factory settings.
*#67705646# This will clear the LCD display (operator logo).
*#0000# To view software version.
*#2820# Bluetooth device address.
*#746025625# Sim clock allowed status.
*#62209526# - Display the MAC address of the WLAN adapter. This is available only in the newer devices that support WLAN
#pw+1234567890+1# Shows if sim have restrictions.
 
*#92702689# - takes you to a secret menu where you may find some of the information below:
1. Displays Serial Number.
2. Displays the Month and Year of Manufacture
3. Displays (if there) the date where the phone was purchased (MMYY)
4. Displays the date of the last repair - if found (0000)
5. Shows life timer of phone (time passes since last start)

*#3370# - Enhanced Full Rate Codec (EFR) activation. Increase signal strength, better signal reception. It also help if u want to use GPRS and the service is not responding or too slow. Phone battery will drain faster though.
*#3370* - (EFR) deactivation. Phone will automatically restart. Increase battery life by 30% because phone receives less signal from network.
*#4720# - Half Rate Codec activation.
*#4720* - Half Rate Codec deactivation. The phone will automatically restart
 
If you forgot wallet code for Nokia S60 phone, use this code reset: *#7370925538#
Note, your data in the wallet will be erased. Phone will ask you the lock code. Default lock code is: 12345

Press *#3925538# to delete the contents and code of wallet.

Unlock service provider: Insert sim, turn phone on and press vol up-arrow keys) for 3 seconds, should say pin code. Press C, then press * message should flash, press * again and 04*pin*pin*pin#

*#7328748263373738# resets security code.
Default code is 12345

Read More

TOP HACKING SITES

1. How To Hack - Hacking and Security Tips Go Hacking

Learn How To Hack! Know more about Computer/Internet Security and Programming. Get Real Hacking Tips from Experts.www.gohacking.com/ Hack an Email Account , a Yahoo Password , Create a Fake Log in Page , Creating a Virus to Block Websites , a MySpace Account,Send Fake Email , Passwords Using USB Drive , Common Email Hacking Methods, How to Hack an Email Account Go Hacking Email Hacking Secrets Revealed! Learn the Real Ways of Hacking Email. A Detailed Tutorials on Email Hacking. One of the Best Email Hacking Tutorial.

2. Hackingalert.com

Expert Tips to Deal with Hacking Password Hacking , Mobile Phone Hacking , Basics of Hacking , WIFI Hacking , Hacking Tutorial What is hacker software , What are network hacking tools , Hacking Tools hackingalert.com »Hacker Tricks And Prevention Techniques This article gives to the reader an overview of the different techniques used by hackers to hack into computers, and ways to avoid these attacks. www.hackingalert.com/hacking-articles/

3. Gmail Account Hacking Tool Hacking Truths

A tool that automatically steals IDs of non-encrypted sessions and breaks into Google Mail accounts has been presented at the Def con hackers' conference in.www.hungry-hackers.com/.../gmail-account-hacking-tool.html Hacking Truths Hacking is fun, If you are a HACKER! ... But before that I would like to thank all of you for supporting Hungry Hacker and giving us so much love. ...www.hungry-hackers.com/

4. Hack This Site!

Hack This Site! is a legal and safe network security resource where users test their hacking skills on various challenges and learn about hacking and network ... www.hackthissite.org/ Hack This Site!The coolest tool to hack all sorts of games, with powerful commands and ... This site offers a collection of tutorials, articles, and programs useful for ...

www.hackthissite.org/

5. insecure.in

Hacking Tips and Tricks Vodafone Hack For Free GPRS · Airtel Hack For Free Internet Access · Access Free Air tel GPRS Using TeaShark Browser. Hot Tricks :- ...
www.insecure.in/hacking_tips_tricks.asp

Read More