Your Ad Here

Wednesday, April 8, 2009

Excel Shortcuts and Tips you should know

I am not very good at using MS Excel, recently when I was working on an Excel sheet, I learnt a couple of keyboard shortcuts with the help of a friend, I though sharing it with you all, I have tried to put together the ones which I thought are not very usual, hope you find them useful.

General Shortcuts to make you more productive with MS Excel -

Operation Shortcut

  • Multiselect Cells Alt+Left Click
  • Del Row/Col Ctrl+K
  • Select Range Ctrl+*
  • Go to Corner Ctrl+.
  • Edit Selected Ctrl+Enter
  • Fill Down Ctrl+D
  • Fill Right Ctrl+R
  • Copy Prev Formula Ctrl+’
  • Copy Above Val Ctrl+”
  • Sum Alt+=
  • Go to First Cell Ctrl+Home Go to Last Cell
  • Ctrl+End Start of Row Home
  • Next Sheet Ctrl+Page Down
  • Next Workbook Ctrl+F6
  • Prev Workbook Ctrl+Shift+F6
  • Prev Sheet Ctrl+Page Up
  • Go to F5
  • Set Currency Shift+Ctrl+$
  • Set Percent Shift+Ctrl+%
  • Set Number Ctrl+Shift+~
  • Set Date Ctrl+Shift+#
  • Insert Line Br Alt+Enter
  • Repeat Action F4
  • Format Cell Ctrl+1
  • Insert Date Ctrl+; Insert Time Ctrl+:
  • Remove Border Ctrl+Shift+_ Border Cells Ctrl+Shift+&
  • Select Cell Group Shift+Cursors

Some Functions and their Results

  • FUNCTION RESULT
  1. today() Today’s date
  2. now() Date and Time
  3. sum() Total of values
  4. average() Average of values
  5. min() Lowest value
  6. max() Highest value
  7. count() Number of values
  8. counta() Count non-blank
  9. countif() Count matches
  10. if(this,then,else)and() / or() Return value if condition met
  11. rand() Random number
  12. round() Round the value
  13. ceiling() Round up
  14. floor() Round down
  15. sqrt() Square root
Hope you found them useful, if yes, feel free to print it out and keep it on the wall at you workplace

Monday, April 6, 2009

Airtel 2009 Ringtones

2009 Ringtones

Airtel Ringtones

Download

Thursday, April 2, 2009

How to use Eclipse

Eclipse

Eclipse is a Java-based, extensible open source development platform. It is simply a framework and a set of services for building a development environment from plug-in components. Fortunately, Eclipse comes with a standard set of plug-ins, including the Java Development Tools (JDT). Eclipse also includes the Plug-in Development Environment (PDE), which is mainly of interest to developers who want to extend Eclipse, since it allows them to build tools that integrate seamlessly with the Eclipse environment. Because everything in Eclipse is a plug-in, all tool developers have a level playing field for offering extensions to Eclipse and providing a consistent, unified integrated development environment for users.

Although Eclipse is written in the Java language, its use isn't limited to the Java language. For example, plug-ins are available or planned that include support for programming languages like C/C++ and COBOL. The Eclipse framework can also be used as the basis for other types of applications unrelated to software development, such as content management systems.

The Eclipse Workbench

Eclipse
The Eclipse Workbench consists of several panels known as views, such as the Navigator view at the top left. A collection of panels is called a perspective. The default perspective is the Resource Perspective, which is a basic, generic set of views for managing projects and viewing and editing files in a project.

The Navigator view lets you create, select, and delete projects. The panel to the right of the Navigator is the editor area. Depending on the type of document selected in the Navigator, an appropriate editor window opens here. If Eclipse does not have an appropriate editor registered for a particular document type (for example, a .doc file on a Windows® system), Eclipse will try to open the document using an external editor.

The Outline view, below the Navigator, presents an outline of the document in the editor. The precise nature of this outline depends on the editor and the type of document; for a Java source file, the outline displays any declared classes, attributes, and methods.

The Tasks view gathers information about the project you are working on. This can be information generated by Eclipse, such as compilation errors, or it can be tasks that you add manually.

Now, we'll create a project in the Navigator. Right click in the Navigator view, and then select New > Project. When the New Project dialog box appears, select Java on the left. Standard Eclipse has only one type of Java project, named Java Project. If there were a plug-in installed to supply support for JSPs and servlets, we would see an additional option here for Web applications. For now, select Java Project, enter "Hello" when prompted for the project name, then click Finish.

Next, we'll take a look at the Java perspective. Depending on how you like to manage your screen, you can either change the perspective in the current window by selecting Window > Open Perspective > Java or you can open a new window by selecting Window > New Window and selecting the new perspective.

The Java perspective, as you might expect, has a set of views that are better suited for Java development. One of these includes, as the top left view, a hierarchy containing various Java packages, classes, JARs, and miscellaneous files. This view is the called the Package Explorer. Also notice that the main menu has expanded to include two new menu items: Source and Refactor.

Creating a new class in the Java perspective

Eclipse
Using the Java perspective, right-click on the Hello project, and select New > Class, as shown in Figure. In the dialog box that appears, type "Hello" as the class name. Under "Which method stubs would you like to create?" check "public static void main(String[] args)," then Finish. This will create a .java file with a Hello class and an empty main() method in the editor area as shown in Figure.

The Hello class in the Java editor

Eclipse
Additionally, you can invoke code completion by using Ctrl+Space. Code completion provides a context-sensitive list of suggestions selectable by keyboard or mouse. The suggestions can be a list of methods specific to a particular object, or a code snippet to expand, based on various keywords like for or while.

Syntax checking depends on incremental compilation. As you save your code, it is compiled in the background and checked for syntax errors. By default, syntax errors are underlined in red, and a red dot with a white X appears in the left margin. Other errors are indicated with a light bulb in the editor's left margin; these are problems that the editor might be able to fix for you -- a feature called Quick Fix.

The code above has a light bulb next to the for statement because the declaration for i has been omitted. Double-clicking on the light bulb will bring up a list of suggested fixes. In this case, it will offer to create a class field i, a local variable i, or a method parameter i; clicking on each of these suggestions will display the code that would be generated. Figure shows the list of suggestions and the code it suggests for a local variable.

Quick Fix suggestions

Ecilpse
Double-clicking on the suggestion inserts the code in the proper location in the code. Once the code compiles without error, you can execute the program by selecting Run from the Eclipse menu. A Launch Configurations dialog box appears, with appropriate defaults; click Run at the bottom right. A new tabbed panel appears in the lower panel (the Console), displaying the program's output as shown in Figure.

Eclipse
Java debugger

Eclipse
You can also run the program in the Java debugger. First, set a breakpoint in main() System.out.println() by double-clicking in the gray margin on the left side of the editor view, next to the call to System.out.println(). A blue dot will appear. From the Run menu, select Debug. As described above, a Launch Configurations dialog will appear. Select Run. The perspective will automatically change to the Debug perspective, with a number of interesting new views as shown in Figure.

First, notice the Debug view at the top left of the perspective. This view shows the call stack and has a toolbar in the title bar that allows you to control the execution of the program, including buttons to resume, suspend, or terminate the program, step into the next statement, step over the next statement or return from a method.

The panel at the top right contains a number of tabbed views, including Variables, Breakpoints, Expressions, and Display. I've clicked Variables so we can see the current value of i.

You can obtain more information about any of the views with the context-sensitive help: click on the title of the view and press F1.

Sunday, March 29, 2009

Apple rolling out new iPhone and iPod Touch devices

iphone-3rd-generationThis isn't the first time anyone is hearing rumors about a new iPhone in the works. We too had shared the rumors in the past, several times. But this time, the source of the rumors seems to be authentic, if not official.

According to Boy Genius, the latest iPhone OS 3.0 beta launched by Apple contains identifier strings about 6 upcoming devices in the firmware, including two iPhones and two iPods along with two unknown devices.

The rumors seem to be authentic because the evidence was discovered in Apple's own firmware that was recently released to the developers. This raises a lot of questions, with the most important being the fact that if the new devices would make it in time with the official iPhone OS 3.0 launch, which is scheduled for this summer.

According to the hardware strings, there would be two new iPhones, one identified as iPhone 2,1 and iPhone 3,1. As AppleInsider notes, the first generation iPhone is identified as iPhone 1,1 and iPhone 3G has the the numbers 1,2 in the ID. Apple's version scheme suggests that the first number is a major revision while the second number indicates minor changes to the device. This essentially means that iPhone 3G was a minor update to the original iPhone while the new devices would be major design revisions. It isn't clear at the time if there are going to be two simultaneous releases or Apple is only testing two devices, and would release only one among them. Or it may be possible that one is the long rumored iPhone Nano.

As for the iPods, the versions are iPod 2,2 and iPod 3,1, meaning that one of them is a revision to the current iPod Touch 2G and the other is a new design. The remaining devices are currently a mystery, with one called iProd 0,1 and the other only known as iFPGA. These two are pretty much early development prototypes, but what confuses me is that why is Apple planning to launch iPhone OS for FPGAs.

Strong to the tradition, Apple is tight lipped about these new devices right now, but they won't be under wraps for long. We would keep you updated as more information pours, but would like to hear your thoughts on the two new mystery devices via comments

How to upgrade to iPhone 3.0 beta on iPhone or iPod?

A couple of days ago we shared links to download the iPhone 3.0 beta Firmware and as promised, we are back with an exclusive article on how to update your iPhone or iPod Touch device to iPhone 3.0 beta firmware.

Before I continue with the procedure, let me remind you folks that it is an advanced level hack so only proceed if you have a clever understanding of what you are doing. I strongly recommend users with unlocked iPhones to wait till the iPhone Dev team releases a patch for the new firmware.

Following procedure is applicable for those with a AT&T locked iPhone and all iPod Touch users.

Installing iPhone 3.0 beta on the iPhone

  1. Make sure to have downloaded the iPhone 3.0 beta firmware that relates to your iPhone (2G or 3G).
  2. Extract the firmware IPSW to a folder.
  3. Connect the iPhone to your computer.
  4. Get the UDID registered on the iPhone Developer program. (How to?)
  5. Open iTunes and click Restore while holding the Shift key (for Windows) or Option key (for Mac).
  6. Locate or browse to the firmware IPSW.
  7. Wait for iTunes to unpackage and install the firmware.

Note: Attempting to do this upgrade on a unlocked iPhone can make it useless forever. Even the AT&T locked iPhone users will need to get their UDID registered before trying to upgrade.

Installing iPhone 3.0 beta on iPod Touch

iPod Touch users are pretty safe in this case as there is no question of baseband like iPhone but their is still a catch which I shall be mentioning further below.

  1. Once the firmware has been downloaded, extract the IPSW to a folder.
  2. Connect the iPod Touch to your computer.
  3. Get the UDID registered on the iPhone Developer program. (How to?)
  4. Make sure to disconnect from Internet such that iTunes cannot communicate with the web.
  5. Only then, open iTunes and click Restore while holding the Shift key (for Windows) or Option key (for Mac).
  6. Locate or browse to the firmware IPSW.
  7. Wait for iTunes to unpackage and install the firmware.

Note: Step-3 is optional for iPod Touch users but in case you decide not to get your UDID registered, you won't be able to Sync with iTunes. The upgrade method is valid for both iPod Touch 1st Gen and 2nd Gen.

Please note that after upgrading to iPhone 3.0 beta, you might not be able to downgrade to firmware 2.2.1 later on so it is always a good choice to wait for the official release which is due in summer. iPod Touch users are always safe but I have already clearly warned the iPhone users to proceed at their own risk.

Keep checking back for more hacks and tips related to the iPhone, I shall be publishing more of it soon.

How to activate the iPhone 3.0 beta firmware?

Although the iPhone 3.0 beta firmware doesn't quite neccessarily require you to activate it but if you want to use it on a device without any problems, we recommend you to follow the procedure.

Activating the iPhone 3.0 firmware for your iPhone or iPod Touch is equivalent to getting the UDID of your device registered in the iPhone developer program so you are legally able to test the new firmware on your device without any syncing problems with iTunes.

How to get the UDID registered?

One way is to simply pay $100 and enroll yourself into the iPhone developer program but perhaps this solution is just too expensive and useless when you are not a developer yourself. So just do the following.

  1. Connect your device (iPhone or iPod Touch) to the computer.
  2. Open iTunes and click on the Summary for the device.
  3. Hover the mouse over to where it says 'Serial Number' and click on it to make it toggle into UDID.
  4. Note the UDID carefully.
  5. Head over to this page to purchase a registration of the UDID for just $5.

Unfortunately! there is no other way of bypassing this.

iPod Touch users have the liberty to even not purchase the UDID registration but in that case, they won't be able to Sync with iTunes. Once UDID registration has been purchased, follow our article on how to upgrade to iPhone 3.0 beta and you should be good to go.

Tuesday, March 24, 2009

Dynamic Duo: SnagIt and PowerPoint

snagit pc screen capture toolAmazing but true—once upon a time screenshots on the PC were made with the PrtScn key, which just takes a picture of whatever is on the monitor at that moment. Then along came several screen capture programs, and after a while, SnagIt became a standard tool for many of us. Now we can slice up the screen into segments or capture specific windows or snapshot menus, all with just a couple of clicks.

And the latest versions of SnagIt for PC provide such good editing tools that you can usually finish a shot (including everything from borders to balloons) without ever leaving the program. Since one requirement for great presentations is a strong visual component, SnagIt and PowerPoint make a terrific team — especially for creating courseware, tutorials, user manuals, and demos.

Three Surprising Ways to Use PowerPoint suggested using SnagIt’s “Send to PowerPoint” feature to build scrapbooks and galleries on the fly. But beyond that nifty trick, you can actually utilize SnagIt to build a presentation from scratch, setting up images and slides quickly, then completing in PowerPoint.

Start by setting up SnagIt to create a specific slide layout when you send images to PowerPoint. Just Select PowerPoint from the SnagIt toolbar, then choose Options. You’ll see a dialog box like this:

snagit-dialog-box

Set the options to “Insert into new slide,” then select a default “Slide layout.” Close the Options dialog, make your first screenshot, and when it comes up in SnagIt, choose PowerPoint from the toolbar and select “New presentation.” The image will be placed on a new slide, using the default format you selected.

I chose Title and Object in Options, and SnagIt created this slide for me, with the image already in the content box:

other-programs-snagit-1

Now I just save the presentation, and from that point on, all I have to do after snagging a screenshot is click the PowerPoint button on the SnagIt toolbar. The program will keep sending my snags to new slides in the newly created presentation until I say stop. I can change the default slide layout by going back to Options, and/or I can change the destination of my snags by choosing a different presentation from the PowerPoint pull-down on the SnagIt toolbar.

Using SnagIt to set up slides while you capture is a great timesaver, since you are actually creating the basic presentation as you make the screenshots. When you have all the shots, just continue to develop the presentation in PowerPoint: apply a theme, add text to the screenshot slides, and create any additional slides needed for the presentation.

There are many other great ways to use SnagIt and PowerPoint together, so look for more tips in future posts. Meanwhile, check out this interesting interview with the SnagIt product manager. And there are additional ideas for using PowerPoint with other programs in the recent Power of Three post

Your Ad Here

Recent Posts

  ©Ask Me Any. Template by Nagababu.

TOPO