OnlinePCTips.com

PC Tips and Tricks to make your life easier
Subscribe

Excel – How To Save Time Using Shortcuts

May 28, 2011 By: lilybird Category: Software

In today’s hyper-speed world, endless streams of data and figures bombard us on a daily basis, especially in the office. As many people know by now, one of the most popular methods by which to gather these numbers in order to present them graphically and in an orderly fashion is with the help of Microsoft Excel 2010. Helpful spreadsheets and tables are created using this Microsoft Office program, and there are many features to be found on it. There are a few time saving shortcuts and features that will allow you to navigate Excel quickly and efficiently.

Enabling one to fill out spreadsheets is one of Excel’s specialties, and there are several keyboard shortcuts that will save you time and make the process even simpler. When you are moving between spreadsheets, pressing Ctrl + Page up will take you to the previous worksheet in the file. As you might expect, Ctrl + Page down will move you to the next sheet in the file. While navigating inside one particular worksheet, Ctrl + F9 minimizes the current worksheet. Ctrl + F10 will maximize it, while Ctrl + P brings up the backstage view in order to print the document.

Shortcuts also allow the user to enter information into cells quickly and efficiently. You will see that by pressing Ctrl + Shift + the semicolon keys you may insert the current time into the selected cell. Ctrl + the semicolon key inserts the current date. By combining Alt + =, you are able to insert a formula that adds up the value of a column of numbers as long as there are no gaps between the cells. In a selected cell, if you hold down Ctrl + K, you may insert a hyperlink into it.

The ribbon at the top of the page is an integral part of Microsoft Excel 2010. F1 brings up the Excel Help task pane. Pressing Ctrl + F1 will either display or hide the ribbon. A slight alteration, using Alt + F1, will create an embedded chart consisting of data in the current range. If you wish to insert a new worksheet, then you may do so by pressing Alt + Shift + F1.

As in previous versions of the program, Microsoft Excel 2010 makes heavy use of the Ctrl, Alt, and Shift keys in its shortcuts. Many shortcuts will therefore be familiar to users of prior Excel programs. As you may know, there are plenty of other shortcuts for Excel, but those herein are some of the most common and most used, saving you time while utilizing the program’s many features.

Now Try – Excel Courses

Windows Vista? Or Windows 7?

March 27, 2011 By: lilybird Category: Software

Microsoft has been developing fully integrated operating systems for over 30 years. The last 2 releases, Windows Vista and Windows 7 have been, although visually quite similar, very different pieces of software that had different aims during the development stages. Whereas Vista was aimed at improving communication and security while at the same time, reducing users’ ability to make adjustments that could cause conflicting processes or increase vulnerability, Windows 7 was programmed to take all the best bits from previous operating systems to create a more refined experience. Ultimately Windows 7 was targeted as being more of an update to previous versions than a completely new operating system whereas Vista was an (arguably failed) attempt to redefine what an operating should be.

One of the primary goals that Microsoft set itself when developing the Windows 7 operating system was to make integration of components, whether external or internal, much better in terms of performance, effectiveness and efficiency. This meant that Windows 7 had to be able to recognize and support all various types of components that could be found connected to a computer, no easy feat. As this task is almost impossible, especially with newer technology being developed and integrated every single day, Microsoft also ensured that if a product was not supported, it would either be updated to support it or provide the ability to directly communicate with the manufacturer to obtain support software. Another function that Windows 7 has, or has improved upon, over Windows Vista is the ability to make better use of a computer’s resources. Microsoft has toned down the number of programs and services that are loaded up on start-up so that computer resources are not wasted on ancillary programs that are not being utilized. This has meant that Windows 7 ultimately runs faster than Windows Vista.

The Windows 7 taskbar is another area that has been not only improved upon, but almost completely changed. Users are now able to customize the taskbar much more than in Windows Vista, to the way they want it. The seemingly constant notifications that plagued Windows Vista are gone and in comes a new function that enables users to preview running programs just by hovering over their icons in the taskbar, a feature that looks especially cool when hovering over windows containing movies or games. The UAC (User Account Control) in Vista was something that most users had a problem with. When making any changes in seemingly very minor instances, the UAC would flag up a question box to ask for permission to make the changes. Most users saw this as a hindrance and thankfully, Windows 7 has toned down the UAC to give users more freedom and responsibility to make their own adjustments.

Now Try – Windows Training

Microsoft Training Course Providers – Tips And Advice For Finding A Good One

March 25, 2011 By: lilybird Category: Software

A Microsoft certified training course provider is an independent company (not part of Microsoft) that uses knowledge and expertise gained from Microsoft certified training programs to teach trainees how to use, or make better use of Microsoft certified products such as the Windows operating systems, spreadsheets and other software. By further advancing the skills of your employees on specific software, you can ultimately increase production, efficiency, output and therefore cash flow, as long as you choose the right training provider.

Training providers are businesses that pay to acquire Microsoft accreditation and in order to do so, must meet stringent quality control measures, one of which being that there must be at least 2 members of the workforce that have current Microsoft Certification and real-world experience in Microsoft products. If you are looking for a provider to train yourself or your employees, an internet search will give you a few options, but to find a training provider that will be right for you may take a little more effort.

Initially you should begin by deciding if you or your employees will be taking an online course, a course taken at a training facility or possibly even at your place of work. Obviously an online course will be easier, although it can be argued that without physical guidance and face to face interaction with the trainer and other students, learning can be compromised. In addition, there needs to be a high level of self-motivation from students. A course taken at a training facility will normally be the most effective solution as all functions will be provided for and the environment will be more orientated towards learning. If logistics becomes an issue or your company has tight deadlines which could cause a problem with employees away on a training course, a good compromise is having a trainer come to your place of work to run the course.

Now you have an idea of the type of training you want, you now need to find a provider that can meet your needs. Have a search online, though local business directories and in local and national newspapers and IT magazines and create a list of possible training providers. Then, narrow down that list by removing providers that are logistically impractical and cannot provide the specific software training you desire. Make sure the businesses that are left can prove their abilities and certification, have ample experience and can provide training to Microsoft standards using Microsoft official learning materials, as any certified training provider must do.

Now Try – Microsoft Training Courses

Windows Phone 7 – A New Operating System For Smartphones

January 14, 2011 By: lilybird Category: Software

During July 2010, Microsoft previewed to the press a beta stage development of their latest operating system that would hopefully be able to directly compete with Apples iOS4, Google’s Android 2.2 and subsequent 2.3, and other mobile phone operating systems. In October and November 2010, the final version of Microsoft Windows Phone 7 version 1.0 was released to the general public on a variety of handsets from a number of manufacturers.

For the new operating system, Microsoft had decided that the previous Windows Mobile platform had reached the end of its life and terminated development in favor of an all new system. With WP7, Microsoft decided to target the consumer market solely, as opposed to the enterprise market that Windows Mobile was previously aimed at. This meant that more had to be done to support popular and fashionable functions such as social networking support and touch screen capability, which it seems it has achieved.

What makes the Windows Phone 7 operating system so good is its fantastic visual interface that is just as easy to use as competing operating systems from Google and Apple. Page transitions are fast and smooth and it is able to integrate compatibility with Microsoft’s Xbox Live and the Microsoft Zune entertainment platform and portable music player. WP7 also uses social networking functions to great effect, with the ability to be in constant synchronization with your Hotmail, Google, Facebook and of course MSN contacts, plus emails and notifications from each.

Some reports have suggested that Microsoft have been working on an updated mobile phone platform since 2004 but each one has been scrapped and some even being adapted into Windows Mobile updates. It has been confirmed, though, that in actual fact the Windows Phone 7 OS has only been in development for a relatively short period since 2008, when Microsoft first recognized that the Windows Mobile platform needed too much work. Ultimately this has meant that although it is a great OS, WP7 is still at least a years development behind Android and iOS4.

To sum up, the Windows Phone 7 operating system is a great looking platform that is easy to use and access, with very good multi-tasking capabilities compared to the competition and very efficient processor utilization but ultimately lacking in most other areas. What makes up for this is that WP7 is a great starting point for future updates to iron out these small problems and Microsoft seem to be committed to their new platform. So although it may seem that right now WP7 can not quite compete with Android and iOS4, it looks like it will not be long before it can.

Now Try – Windows Phone 7 Deals

Microsoft Dynamics NAV : The Basics Explained

December 14, 2010 By: lilybird Category: Software

One of the questions most asked by mid-sized company managers is how to best make use of their resources and increase productivity. Microsoft must have heard these questions, because their software Microsoft Dynamics NAV helps companies do just that. Microsoft Dynamics NAV is an enterprise planning software that shows companies how to best use their resources. In this article we will take a look at Microsoft Dynamics NAV, along with the many ways it can help your company to increase its overall effectiveness.

In business today, simplicity is the name of the game, and that’s exactly what you’ll receive when you implement Microsoft Dynamics NAV. Microsoft Dynamics NAV is a “complete enterprise resource planning” software that is quick to install and implement and extremely easy to use. Whatever your business may be, or wherever it’s located, Microsoft Dynamics NAV can help you succeed with solutions which are industry-specific and functional and available in more than 40 country versions.

Companies that wish to be competitive, regardless of the type of industry they represent, must become more simplified. Microsoft Dynamic NAV is a software package that can assist managers in assessing each phase of the operation to maximize productivity. It does this by gathering, centrally storing and integrating all company-related data, from supply chain to personnel. Instead of having data spread out over five or six departments, everything is contained in one program with role-tailored access to help each member of your team increase their productivity.

Often times in business, the everyday, run-of-the-mill tasks get in the way of what actually needs to be done. With Microsoft Dynamics NAV, however, each day your employees will have access to the information and tasks which are relevant to their particular phase of the operation, with a quick view that prioritizes those tasks based on productivity. And if the needs of your business change, Microsoft Dynamics NAV can quickly adapt to those changing needs by adding functionality and custom applications. It truly is a smart business solution.

As businesses grow, they often need assistance managing and evaluating each phase of the operation—especially when information is spread out over several departments. Microsoft Dynamics NAV provides a simple solution by effective gathering and storing that information into a single, easy-to-use program which is easily configured to meet the needs of any type business throughout the world.

Now Try – Thinking And Thriving

What You Need To Know About Windows Phone 7

December 10, 2010 By: lilybird Category: Software

Microsoft, as everyone knows by now, is a major player in technological pursuits. The company has made its presence felt in the realm of smartphones with the Windows Phone operating system. Found on several models of handsets, Windows Phone is an operating system and experience all of its own. The latest version is Windows Phone 7, and here are some things to expect from it.

Several regions of the world experienced the launch of Windows Phone 7 in November of 2010. The user interface found on 7 is known as Metro. Microsoft has dubbed the home screen the Start screen, a title familiar to those who have Windows on their PC. On the Start screen is a series of Tiles, buttons that act almost like thumbnailed widgets. They provide links to applications, email clients, and many other customizable functions and features. Tiles experience real time updates, making for instantaneous email flags and stock quotes among other alerts. Tiles can be added, deleted, and rearranged according to the user’s needs.

On Windows Phone 7, organizational tools known as Hubs combine functions and features with similar traits into groups. Content found both locally and online are integrated with social network sites like Facebook and Windows Live. Contacts found on Gmail, Facebook, and Windows Live are gathered together by what is known as the People Hub, creating a single place from which to update and organize all of these contacts. Another hub is the Video and Music Hub and it integrates with Zune to accommodate multimedia activities. The style and operation of the Hub is reminiscent of Zune itself. For gaming, the Games Hub integrates with Xbox LIVE. Windows Phone 7 also features Windows Phone Marketplace and Microsoft Office.

The browser on Windows Phone 7 is a version of Internet Explorer Mobile that has been described as a hybrid of IE7 and IE8. Specific sites can be placed on the Start screen in the form of a Tile and six tabs running parallel to one another are supported by the browser. Pages are shared with others using email and the browser can perform inline searching tasks. Flash Player 10.1 will soon be offered by Adobe on Windows Phone 7 phones. Users of Windows Phone 7 handsets can steam YouTube video, and the Video and Music Hub can store them.

Windows Phone 7 is made for combining multimedia with cell phone functions in an easy to use and slick package. Customer favorites were considered when creating the OS. The result is an enjoyable smartphone experience for those who want more out of a cell phone.