Shortcut function keys in excel

Here is a list of shortcut keys in Microsoft Excel.

1. F1: Opens a help task pane
2. F1 + Ctrl: Opens or closes the help window
3. F2: To edit the text in the active cell
4. F2 + Shift: To write a comment in the active cell
5. F2 + Alt: Opens the save as dialog box
6. F3 + Shift: opens the insert dialog box
7. F3 + Ctrl: Opens the define name dialog box
8. F3 + Shift + Ctrl:  Opens the create name dialog box
9. F4:  To redo the last command
10. F4 + Ctrl: To close the workbook window
11. F4 + Alt: To close the excel program
12. F5: Opens the Goto dialog box
13. F5 + Ctrl: brings back to the first level of workbook
14. F6: To shift between help taskbar and the excel window
15. F6 + Shift: To goto the previous square in the open worksheet
16. F6 + Ctrl: If more than one workbook is open to switch between them
17. F7: To open spelling correction window
18. F7 + Ctrl: When workbook window is not maximised it will move the window
19. F8: To activate / deactivate extended mode
20. F9: Will calculate all the worksheets in all open workbooks
21. F9 + Shift: Will calculate the active worksheet
22. F9 + Ctrl: To Minimise the workbook window
23. F10: Will select the menu bar
24. F10 + Ctrl: To open minimised window
25. F11: Will create a chart using the current range
26. F11 + Shift: To select a new worksheet
27. F11 + Alt: To switch between visual basic editor and the worksheet
28. F11 + Alt + Shift: Opens microsoft script editor
29. F12: Opens save as dialog box
30. F12 + Shift: Saves the active workbook
31. F12 + Ctrl: To open the Open dialog box
32. F12 + Ctrl + Shift: Opens the print dialog box

Alternatives to Microsoft Excel

So what if you don’t have Microsoft Excel? There are many alternative applications to Excel. Here is a list of those alternate programs to Excel.

1. Google Spreadsheets: Google spreadsheets is  part of Google Docs. You can create spreadsheets or even open an excel file from here. If you already have a gmail account, you maybe already using it. Just click on http://docs.google.com to reach google spreadsheets
2. Zoho Sheets: It is also similar to google spreadsheets and is available at http://sheet.zoho.com. You can even edit and share the same file with your friends or colleagues just as google docs enables you.
3. EditGrid: This is an online spreadsheet service. This has all the features of Excel. Available at http://www.editgrid.com
4. NumSum: Available at http://numsum.com this application also enables online creation, sharing of spreadsheets.
5. Simple Spreadsheet: You can get it from http://www.simplegroupware.de/cms/Spreadsheet/Home .
6. Wikicalc: Get this application from  http://www.softwaregarden.com/products/wikicalc
7. Zcubes Calci: This is also another spreadsheet application available online.

As you can see all the above applications are available online in internet and there is no need to install any application on your computer. If on the other hand if you would prefer to install as an application on your desktop and use it, without internet connection, then you can use the following applications which are available as desktop applications.

1. Open Office Calc: This is part of the Open Office suite of applications.
2. IBM Lotus Symphony Spreadsheets: Available at http://symphony.lotus.com/software/lotus/symphony/home.nsf/product_sse
3. Abykus: Available at http://www.abykus.com
4. Gnumeric: This is part of the Gnome desktop
5. Spread32: Available at http://www.xtort.net/officeandproductivity/floppyoffice/

Screen Rotation Lock and Volume Buttons

Use the screen rotation lock to keep the iPad screen in portrait or landscape orientation. Use the volume buttons to adjust the sound volume of songs and other media, and of alerts and sound effects.
Lock the screen orientation Rotate the screen to an orientation you like. Slide the screen rotation lock down to lock iPad in that orientation. When the screen is locked, the icon appears in the status bar. Slide the switch up to unlock the screen orientation.
Increase the volume Press the Volume Up button. To set a volume limit for music and other media, in Settings, choose iPod > Volume Limit.
Decrease the volume Press the Volume Down button.
Mute the sound Press the Volume Down button until the sound is completely off.
WARNING: For important information about avoiding hearing loss, see the iPad Important Product Information Guide at support.apple.com/manuals/ipad.

How to burn an iso file in mac

So you downloaded an .iso or .dmg file, and now you want to burn it to CD or DVD on your Mac. Fear not! No extra software is required.
The delightfully useful Disk Utility built into OS X can burn disk images to optical media in a few easy steps. Read on for how to go about burning your new disc.
Windows users: You should check out the free ISO Recorder for similar functionality.
Launch Disk Utility (Applications > Utilities).
Insert your blank DVD or CD.
Drag and drop your .dmg or .iso file to the left pane in Disk Utility. Now both the blank disk and the .iso/.dmg should be listed.
Select the .iso/.dmg file you want to burn to disc, and click on the Burn button. A dialog box confirming the destination (your blank CD/DVD) will appear.
Sit back and wait while your new disc gets written!
All discs burned on the Mac work across platforms; you’ll notice in the screenshot that I’m burning the Ophcrack Live CD, which is obviously for use on Windows. This is a great way to back up software installation .dmg’s to optical disk to free up space on your Mac’s hard drive.

What Is RSS?How It is Useful For Bloggers and Readers

RSS is very popular among bloggers and readers.RSS stands for Realy Simple Syndication.It is used for distribution of content to wide niche audiences.Its origin can be traced back to 1999 but it struck the limelight after Microsoft and Opera decided to adopt the Rss Feed icon in their browsers.RSS files are essentially XML formatted plain text.

How RSS is Useful For Readers?

Everyday a regular Internet surfer reads many new blogs and articles.If you really find some interesting blogs either you can bookmark them or Subscribe to RSS feeds to stay in touch with the latest updates of the blog.

Why RSS Subscription is Better than Bookmarking?

RSS is relatively convenient than bookmarking because the latest posts (or excerpt) can be delivered directly into your email inbox.You don’t have to visit over and again to check for new posts.
If you haven’t subscribed to RSS you have to manage a large bookmarking list of favourite websites and keep on visiting them to check for new updates.This is not appropriate as

• You have to check a lot of websites each day
• You may get frustrated if the blogs are not updated frequently as you will find same posts each day
• You may miss some crucial updates if you don’t check the blogs regularly.

Tidy Up You Desktop

One of the neater features in the Linux and Mac operating systems is multiple desktops. It’s a simple enough idea, if you habitually have lots of programs open and running, set just the way you like it, switching between then can be a pain. With multiple desktops you set up each program or desktop as you want it and use a hotkey, or single mouse click to switch between them. Now you can add this feature to Windows, courtesy Sysinternals, with its Desktops utility. The program is small, lightweight and very simple to use. Just set up each of your desktops, click the icon in the System Tray and assign it to one of the four available slots. That’s all there is to it, and for the record it runs on all versions of Windows from XP onwards.

How to improve your Wireless internet and network connection?

Microsoft Windows gives you a notification whenever your wireless network has a weak signal. This is a sign that you should improve your wireless network. When you get this notification, it means that the wireless connection is not as reliable or high-speed as it's supposed to be. In fact, the wireless connection signal may be completely lost in certain areas of the house. If you would like to improve your wireless network signal, you should carry out a few of these tips. These tips will extend the wireless range. They will also improve the overall performance as well as reliability of the wireless network.

Re-position the wireless router (or wireless access point) to the centre of the house.

Place the router away from walls.

Place the router off the floor.  

Place the router away from metal objects.

Instead of using a standard antenna which you get with the router, use a hi-gain one. If the standard router is placed by an outer wall, part of the wireless signals will be directed outside the house. This will also waste the power of the router. Hi-gain antennas send the wireless signals in a single specific direction which you are able to aim on the path where you need them a large amount.

Replace your laptop or computer's wireless network adapter with a USB network adaptor. It uses an external antenna that improves the range of the signals. (Laptops which have built-in wireless normally contain outstanding antennas. They do not usually require to be upgraded.)
Add a wireless repeater to extend the signal range.

Change the wireless router's channel to increase the strength of its signal. You can do that through the configuration page of the router. The computer will detect the new channel itself.

Reduce wireless interference by avoiding wireless electronics which use the 2.4GHz frequency. You should use cordless phones which use the 900MHz or 5.8GHz frequencies.
Update your firmware updates for your router through the manufacturer's website. Update your network adapter driver through the Windows Update feature of Windows 7 and Vista or visit the website www.update.microsoft.com for Windows XP.
Upgrade 802.11b devices to 802.11g or buy a new 802.11 g equipment.  It is five times faster than an 802.11b device.

How to Secure a Wireless Network from Hackers?

The reason we secure a wireless network is to stop people from using the services of our network who don't have permission to utilize them. It is harder to secure a wireless network from hackers as compared to a classic wired network. This is due to the fact that a wireless network can be accessed anywhere inside the range of its antenna.

In order to secure a wireless network from hackers, we should take proper steps to save ourselves against security issues. If you don't secure a wireless network from hackers, you might end up without its service. The consequence might also include the utilization of our network to attack further networks. To secure a wireless network from hackers, you should follow these simple wireless networking tips:

1.       Strategic antenna placement:

The first thing you have to do is to position the access point's antenna in a place which restricts the range of its signal to go further than the required area. You should not put the antenna close to a window because glass can't obstruct its signals. Place it in a central location of the building.

2.Use WEP:WEP stands for Wireless encryption protocol.  It's a customary technique for encrypting traffic on a wireless network. You should never skip it as that will allow hackers to get instant access to the traffic over a wireless network.

3.       Change the SSID, disable the broadcast of SSID:

SSID stands for service set identifier.  It is the recognition thread utilized by the wireless access point due to which the customers are capable of starting connections. For every wireless access point arranged, select an exclusive as well as unique SSID. Also, if it's attainable, hold back the broadcast of the SSID out over the antenna. It won\t appear in the listing of offered networks, while being able to provide services as usual.

4.       Disable DHCP:

By doing this, the hackers will have to decode the TCP/IP parameters, subnet mask as well as the IP address in order to hack your wireless network.

5.       Disable or modify SNMP settings:

Change the private as well as public community settings of SNMP. You can also just disable it. Otherwise the hackers will be able to utilize SNMP to get significant info regarding your wireless network.

6.       Utilize access lists:

For additional security of your wireless network, and if your access point support this feature, employ an access list. An access list lets us determine precisely which machinery is permitted to attach to an access point. The access points which include the access list can employ trivial file transfer protocol (TFTP) now and then in order to download modernized lists to steer clear of hackers.

How to speed up the Help dialog in Office 2007 and 2010?

When we are in a hurry we don’t like the fact that Office Help takes long to connect to the web and then help us out. Slow internet connection annoys us as the Help Dialog in Microsoft Office tries to download new content as we open it. The feature of online help is there to benefit us from the latest help files. However, most of the times we want to get things done fast without having to wait for it. By default, the Help Dialog is set to online help.  In order to overcome this problem and speed up the Help Dialog in Office 2007 and 2010 we can change its settings. There is a simple trick to speed up the Help Dialog in Office 2007 and 2010. Follow these easy steps to speed up the Help Dialog in Office 2007 and 2010:

1.       Press the F1 key to open the Word Help dialog box.

2.       Click on the “Connected to Office.com” button if you are using Word 2010 or the “Connected to Office Online” button if you are using Word 2007.

3.       Click on “Show content only from this computer” from the menu.

By following this method you will speed up the Help Dialog in all the applications of Office 2007 and 2010 by automatically altering the settings.

Latest Laptop---Roll Top

Proposition

Rolltop is not a “virtual and futuristic” gadget, existing only on the screen of your computer as in the most of similar concepts and visions! Most of the existing design concepts usually have been developed without any deep technologic and ergonomic elaboration and often could be difficult or even impossible realized. From the beginning Rolltop has been developed as a real future product. During its development a lot of different scenarios (e.g. usability, functionality etc.) were simulated. Moreover we have included in Rolltop the best worldwide ergonomic, mechanic and electronic practices.

Technology

The device of the flexible display allows a new concept in notebook design growing out of the traditional “bookformed” laptop into unfurling and convolving portable computer. Rolltop incorporates both latest high-tech devices and a new brand design techniques into a computer that will increase the quality and productivity of the designers work. On top of everything else no laptop bag needed – all computer utilities from an interactive pen through power supply to the holding belt are integrated in Rolltop. This is really an all-in-one gadget.