When you are using Microsoft Excel 2007, you usually need to copy a part of the content to other location in the worksheet or copy to another worksheet, sometimes different workbook. You can do it easily by using the copy and paste function in Microsoft Excel 2007.

Let’s open a blank worksheet (by now you should be able to do it by just opening Microsoft Excel 2007 or by clicking on Office Button and select New). We have to input some content into the worksheet before I could demonstrate the Copy and Paste functions to you. Let’s just randomly key in “Copy” into cells from A1 to A10. Now you have a series of text “Copy”. Say now you want to copy the whole series of text “Copy” to Cells D1 to D10.

Follow the simple steps as what I am going to show you now. Firstly select cell A1 to A10, then on your Keyboard, press Ctrl+C to copy the cells to the Clipboard. Alternatively you could put your cursor on the select area (A1 to A10), Right Click and select Copy, Or you could select Home– >Clipboard– >Copy.

You will find that the selected areas are now covered by dotted line (this is the indication that the area selected for copying). Next is move the cursor to cells D1 and press Enter (Alternatively you may want to Right Click on cell D1 and select Paste, or you could follow the path Home– >Clipboard– >Copy ), you will paste the content of A1 to A10 all the way to D1 to D10.

Copy and Paste functions are not only limited to text only, you can copy chart, formula, logical functions and any other features in Microsoft Excel 2007 to any location you prefer within Excel.

Isn’t it annoying? You’re looking at next month’s calendar to schedule a meeting with a client, you go to their contact record for their phone number, and when you go back to the calendar, it’s re-set to today. You have to do extra clicks to get back to the date you were looking at. Same thing happens if you pull up a contact, then go to your calendar, tasks, or email. When you return to contacts it goes to the beginning of the alphabet, and you have to hunt again for the correct contact.

Here’s the solution. In the navigation pane on the far left, right-click on the new folder you want to go to, then left-click on “Open in New Window” in the submenu. It opens a new window on top of the existing one which remains open underneath. Drag one window over, and you can view both contacts and the calendar (or the taskpad, or whatever) side-by-side. If you want to view multiple contacts and dates you can keeping opening new windows – your only limit is the size of your monitor.

Use Your Inbox as a To-Do List

This one is more of a time management tip that applies to any program you use for email, not just Outlook. Most people, once they’ve deleted unneeded emails, simply leave the ‘keepers’ in their Inbox. This can lead to serious email overload. An acquaintance of mine has over 8,000 emails in her Inbox!

Instead, create folders to store emails you must keep. The result – your Inbox only holds new messages and those you still need to act on; everything else has been filed away. Your Inbox becomes an extension of your To-Do list. This improves productivity and reduces the number of things that “fall through the cracks.”

See the Entire Day and Evening at a Glance

Would you like to see all your day and evening hours on the calendar without having to scroll until your wrist hurts? Here’s how: Right-click on calendar background. (You can be either in the daily, weekly, or monthly view, just so you click on the background and not on an appointment.) In the submenu that appears, click on “Other Settings,” and you’ll see a dialog box labeled “Format Day|Week|Month View.” Set the Time Scale field to “60 minutes.” Now you can see all the day & evening hours without having to scroll up and down.

Outlook Tracks Your Activities, Past and Future

An excellent, little-known feature in Microsoft Outlook is the Activities tab of the contact record. (In Outlook 2007 it’s a button, not a tab.) The Activities tab contains a comprehensive list of every meeting, task, and email related to every person or company (i.e., contact) in your Outlook database. If you use the journal to make notes of important phone calls, they’re listed here too. You must remember, though, to link meetings, tasks, and journal entries to the appropriate contact – unlike emails, they’re not linked by default. Try it – you’ll spend far less time looking for information in Outlook once you get into the habit of using the Activities tab.

Sorting Your Contacts

Need to sort contacts by criteria such as which project they’re related to, what industry they’re in, or where you met them? Or perhaps you need to sort tasks by project or client? Sorting this way is a huge time-saver, but you first have to label your contacts and tasks. Frankly, the best way is by use custom fields, which is easy to do in Act! or Goldmine.But unfortunately, in Outlook – if you want much more than name, address, phone number, department, etc. – you’re moving into programming.

A easy workaround is to use categories instead of fields. Categories are accessed via the command button in the lower right corner of the contact, appointment, and task dialog boxes. This button takes you to the Outlook’s Master Category list where you can create new categories for client, project, referral source, industry, or anything you wish. (You can also delete any the default categories you don’t need.) Once you’ve created your categories, it’s easy to assign contacts, tasks, appointments, journal notes, and emails to categories. There are situations where shoehorning categories to make them do the work of fields can cause problems down the line, but for many people it’s adequate.

Syncing

The built-in Outlook-Palm sync utility is limited and will only sync a limited number of categories. If you create a lot of custom categories, you’ll need to buy a decent sync program. Check out those from DataViz, CompanionLink, or Chapura.

Backing Up ALL Your Microsoft Outlook Data and Views

There are 2 kinds of people – those who have lost their contact database and those who will. If you’ve customized your Outlook and then tried to restore it from the pst back-up, you’ve learned the hard way that it doesn’t look like it’s supposed to. Sure, Microsoft’s website explains how to do a complete back up, but the instructions are so complicated that I doubt anyone has understood them, much less gone through the whole process. A great alternative is Eazy-Backup* software – check it out!

*The usual disclaimers apply. My mentioning these products is not a guarantee of any sort. Obviously, you should not change anything until you‘ve completely backed up your files. You already do that, right?

Copyright Jan Jasper 2008

What is a spreadsheet?

A spreadsheet is a rectangular table or grid used for organising and analysing data arranged in rows and columns. Data can be entered, edited, manipulated and stored as text or numbers. Data can be used in complex calculations, graphical chart creation or analysis.

Some common Excel terms

Worksheet – a single spreadsheet

Workbook – a single file containing a collection of one or more worksheets (up to 255).

Cell – a box where a row and column meet, into which data is input. Each cell has a different name, derived from the column and row in which it is contained. The cell name is displayed in the Name box

Active cell – cell indicated by a solid border, whose name is currently displayed in the Name box. The active cell is where data appears when keyed from the keyboard.

Formula bar – text or numbers that are keyed in to the active cell are displayed in the formula bar.

Range – a rectangular area of 2 or more adjacent cells

Menu – a list of application commands that is displayed when you click a menu name from the top of the Excel screen

Menu bar – horizontal bar below the title bar that contains the names of menus

Button – a picture that performs a command when clicked on

Title bar – the blue bar at the top of the window that displays the name of the workbook

Toolbar – contains a group of similar buttons

Worksheets and workbooks

Think of a ‘workbook’ as a book that contains ‘worksheets’ or pages. When Excel is started it opens a new workbook that contains 3 worksheets.

Common uses for spreadsheets

• storing complex data in tabular format e.g. customer records
• calculating budgets
• maintaining accounting ledgers
• performing “What If?” analyses

Examples of spreadsheet programs

• Lotus 1-2-3
• Microsoft Excel
• Corel Quattro Pro
• Microsoft Works spreadsheet

Some Excel facts

Each worksheet contains 256 columns and 65,536 rows… that’s 16,777,216 cells! If the entire worksheet was printed out, it would measure 5.6 metres wide by 327.7 metres long! Each cell can hold up to 32,767 characters… that’s a potential of 549,739,036,672 characters in just one worksheet!

With growth in the popularity of ERP software more and more companies have come up with the plans of owning ERP for their organization, this led to more software companies jumping in the market to fill in the demand with industry specific, solution based and economical ERP solutions .

SAP was established in 1972 in Germany and is largest software service provider in the world today, initially SAP's ERP solutions were robust and costly and were stamped as solutions for fortune 500 companies only. Today latest version of SAP ERP is SAP ECC 6.0 which was previously named as SAP R / 3, other products for mid size and small companies are SAP business one and SAP all in one. These all are part of SAP business suite, SAP business by design is in software as service model for providing hosted ERP solution to its clients.

Oracle Corporation famous for its database and hardware solutions today provides suite of business applications which can perform tasks like CRM, SCM ERP and financial management. Oracle comes with few solutions like Oracle E-business suite, Peoplesoft, JD Edwards enterprise one, JD Edwards world and Siebel. Oracle has made number of famous acquisitions which has improved the versatility in its solution list. The company gained third biggest revenue after Microsoft and IBM and provides services like consulting, training, SaaS and support.

Infor Global Solution is another big player of ERP market established in 2002 with the name of Agilisys in USA, later after acquisition of Infor Global Solutions the company changed its name to its present name. Infor apart from ERP solutions provide number of specific solutions for SCM, CRM, Enterprise asset management, Work force management, Product management, PLM, HCM and Financial management. Industry specific solutions like for Public sector and Hospitality industry also gives Infor a unique identity in the market. Infor ERP solutions have been very popular in manufacturing industry because of its support for all types of manufacturing methods lean, discrete and process.

Microsoft Corporation has four ERP products which have been enhanced and developed after acquisitions which Microsoft made. Microsoft GP, NAV, SL and AX are four ERP solutions along with CRM, all the ERP solutions have almost similar modules and effort was made by Microsoft to merge them to form a single ERP solution which failed.

Companies like Epicor have also worked out a place for themselves amongst the big players of the ERP market by providing economical and solutions focused for particular business areas. Epicor comes with number of enterprise solutions for mid size and small companies like supply chain management which includes support to other areas like customer relationship, supplier relationship and supply chain execution. Other offerings from the company cover areas like human capital, retail, service and IT services management. Epicor tried to unify all the solutions in Epicor 9 to provide one single solution but this product needs some more enhancements for proper functioning.

Netsuite is world's leading hosted ERP service provider, though company mainly focuses on mid size market and has chunk of its clientele from this sector but has launched Netsuite Global one which supports divisions of large organizations and companies with many subsidiaries and divisions by features like consolidation, multi-currency, and languages.

There are numerous other small and big ERP solution providers like Sage, Syspro, Ramco, Intacct, Lawson Software, Baan etc playing an important role in developing the ERP market.

Do you want to set up a restore point in your Windows 7 computer? It's an easy and helpful feature that allows you to undo the changes and reinstate your computer to an earlier time or date. These nightmare-like changes can be irreversible in nature at times and can cause your computer to crash. The built-in system restore feature comes in handy in such a situation. Here is your comprehensive Microsoft Windows 7 support guide, which will help you easily perform the task.

Instructions:

Click on the Start menu, right-click on Computer, and choose Properties from the drop-down options. Instead of going to the Start menu, if there is a Computer shortcut icon on your Desktop, right-click on it and choose Properties. When in the Control Panel window, click on the System protection link on the left hand pane. If prompted for an admin password, type it in and continue. When in the System Properties dialog box, highlight the System Protection tab. Click on the Create button and it will push another dialog box Create a restore point.

Give a name to your restore point (any name of your choice so that you can recall it easily) in the empty box and then hit Create. It will initialize the process showing 'creating a restore point'. It can take some time depending on the speed of your PC and the volume of data stored on it. When done, it will display the 'The restore point was successfully created' message. Click the OK button to exit the dialog box. Close all the windows including System Properties'. If prompted, reboot your computer. Your computer is now well-equipped to deal with uncertain changes caused by a malfunctioning application or virus attacks etc.

You can also instruct Windows 7 to setup automatic restore points whenever a change takes place in your computer. To do so, click on the Start button, type 'task scheduler' (without quotes) in the Start Search field, and hit the Enter key. When the Task Scheduler window comes up, browse to Microsoft> Windows> and SystemRestore on the left hand pane. When the SystemRestore folder opens up, double-click on a line in the first half of the window saying 'SR Queued Multiple triggers defined dated —'.

This will open up another dialog box. Highlight the Triggers tab if it's not highlighted by default. It will show you the default System Restore set up for startup. Click on the Edit button at the bottom to edit the settings. Click on the drop-down arrow next to Begin the task and choose the desired option (self-explanatory). From the Settings menu, customize the time settings viz. One time, Daily, or Weekly etc. and then hit the OK button. Highlight the Conditions tab and customize the schedules (self-explanatory). When done, save the changes and exit all the windows. If prompted, restart your computer. Your Windows 7 computer is now all set to create automatic restore points as instructed by you.

Additional Tips:

The above mentioned procedure will also work for Windows Vista operating system. If you are unable to create a restore point or if the restore point does not do its job, you can contact a Microsoft technical support service to resolve the issue.

Just about everybody who is capable of utilizing computers knows how to make use of Microsoft Office Products. In spite of this, only a handful of them can declare to be true specialists in making use of this software. Individuals who initiate professional teaching courses to learn the use of this remarkable software can increase their performance substantially, as individuals who are beginners tend to take a longer time to undertake tasks. As a result an effective way for organizations to increase effectiveness of their employees is to have Microsoft Office training a necessity for their workforce.

Improvement in Performance:

Microsoft Office programs are highly often used; a lot of people think that Microsoft Office training can add minor benefits to their knowledge. The truth is, this training is not only about knowing keyboard shortcuts, as training provided by certified professionals can transform the entire expertise of using Office applications. Customization associated with these software packages can cut process times by as much as fifty percent (50%). For instance, by making use of the mail merge attribute on MS Word, the time for you to type mailing labels are generally decreased to about 1/4th.

As Microsoft’s products are utilized in just about every business for different needs, proficiency in using these applications will help conserve time, which typically results in financial benefits for the business, therefore making it more beneficial.

How to Determine Employees’ Skill Level?

Microsoft asserts that its end users are unaware of the degree of capability its products provide to the user. A regular survey demonstrated that people taken into account the features of MS Office to be modest and used it as a basic word processor. In the same way MS Excel, despite the fact that in reality incredibly is powerful software, is considered to be a mathematical processor. MS Excel can be utilized as relational program and a number of spreadsheets can be combined together.

The same survey may be carried out in any organization as it will disclose the skill level of personnel pertaining to proficiency in MS Office. Most business owners would find that their personnel are not achieving the full capability of Office applications but running only a component of the application’s features, and Microsoft Office training will assist you to show you ways of increasing proficiency.

Types of Training Methods:

There are several ways, such learning programs can be performed. For corporations, the possibility is even larger since training providers are willing to offer customized programs based on a companies’ requirements and budget limitations. Microsoft Office training may be performed either in-house, through online multimedia or demand employees to take part in classes at the learning institute. There are advantages for each approach and are outlined subsequently.

Most of the time, in-house and e-learning or online training is favored by business owners to deliver Microsoft Office training to their staff, for the reason that both approaches are less cumbersome. An in-house course can be carried out by a certified or competent lecturer, and involves the benefit of in-person lectures. Furthermore, workers get a chance to make inquiries and also go based on their own pace. An e-learning training program is a more affordable alternative most of the time, and staff members have the choice of availing it from their office or the comfort of their home in their spare time. This puts less stress on their work load, however takes longer and might not be as good as a live presentation.

Where is Microsoft Office today?

Today Microsoft Office has evolved from a group of private productivity products to a more complete and integrated system. Building on the well-known tools that a lot of people are familiar with already, the Microsoft Office System includes servers, services, programs and solutions meant to work as one to help deal with a broad range of business dilemmas.

What’s my benefit for getting Microsoft Office?

A Microsoft Office System gives you a building block for solutions that helps:

It gives business users enhanced access to data, and therefore they can get better insight and take actions that are more valuable. And it improves an organizations capability to expect, handle, and react to changes in the market. Further it is allowing teams and organizations to work jointly with swiftness and quickness. And finally, the most important, it improves individual efficiency and enables more business users to contribute in the all the time more challenging environment around them.

What is Microsoft Office?

The servers, services, programs and solutions, which put together, forms the Microsoft Office System, are:

Office Editions is the successor to Microsoft Office XP, and the foundation of the Microsoft Office System.

Microsoft Office Access is the Office database management program, and offers an enhanced ease of use and an extended ability to export, import, and work with XML data files.

Microsoft Office Excel is the Office spreadsheet program, and includes support for XML plus features that make it easier to analyze and share information.

Microsoft Office FrontPage is the Office Web site creation and management program, which delivers powerful features plus controls to help you design superior Web sites.

Microsoft Office InfoPath is the Office information gathering as well as management program, which streamline the process of gathering information.

Microsoft Office OneNote is the Office note-taking plus management program, which enables you to organize, capture and reuse notes on a laptop or desktop computer.

Microsoft Office Outlook, which is the Office personal information manager plus communication program, provides a integrated place to manage calendars, e-mail, contacts and other personal or team information.

Microsoft Office PowerPoint is the Office presentation graphics program, which allows you to produce an impact in person or online.

Microsoft Office Project enables organizations to line up business initiatives, resources and projects for improved business results.

Microsoft Office Publisher is the Office business publishing plus marketing materials program, which makes it easier than ever to produce, design, and publish expert marketing and communication materials.

Microsoft Office Visio is the Office business plus technical diagramming program, which helps you transform ideas plus conventional business data into diagrams.

And finally Microsoft Office Word is the Office word processor.

Final word about Microsoft Office.

As you see, Microsoft Office covers it all. Try it out. See if you or your business can benefit from this fantastic office tool. Give it a go and see for your self.

John Smith: Last Known Survivor of the Microsoft Wars

Roland Hughes

Logikal Solutions

ISBN: 978-1-939732-00-2

Trade Paperback

2012

274 pages

Do you ever reflect about how your life could have been different if you had made different choices twenty, thirty, forty years ago? Imagine yourself sixty-eight years now in the future. What choices should you have made now on November 13, 2013? How could these affect your life and every living creature on the planet?

On November 13, 2013, the world ceased to exist as we know it. Now, sixty-eight years later, John Smith attempts to explain life before this time. He wonders if finally people are ready to understand the history that created the world of today.

Now, people live at a basic survival level without the use of our established means of transportation, communication, health care, and food service. How do you prevent the catastrophe of the past from ever happening again. In the hopes that this history will never occur again, John Smith has left his isolated world to communicate the mistakes of the past to a world that has no memory. He is the only known survivor from this event sixty-eight years ago.

John Smith was only eleven years old at this time making his age of seventy-nine the oldest known person alive today on the planet. On that fated day, John’s family had built a bunker when the Microsoft Wars started where he was trapped for ten years.

Susan Krowley is a newspaper reporter for The Times which is published twice a month with the widest circulation of 5500. Reading newspapers is not a common activity and only for the few and the privileged. She is thrilled to be able to conduct this interview for her newspaper. This is her story of a lifetime interviewing John Smith who is the only known living person who actually experienced the Microsoft Wars.

The world is much different now. People travel on horseback. Schools of the past no longer exist, including colleges. Everyone learns from their home. Jobs that formerly required college degrees now are filled within families. Technology as we know it does not exist. Knowledge and books are limited. Life is at a simplistic level. Even access to books is extremely limited. Without the widespread usage of computers, telephones, and nuclear energy, life is very different.

The seven continents are now twelve. There is no way to travel or communicate from one continent to the next with an ocean covering much of the center of the United States. John was very fortunate that his bunker was in an area that had not been covered by an ocean.

“John Smith: Last Known Survivor of the Microsoft Wars” is thought provoking. The author reviews much of our technological advances throughout the years, while also demonstrating the uneven advances and questionable uses and obvious abuses with the ethical practices. This book is a warning of what could happen if we continue without a complete understanding of our societal choices.

This entire book is written as an interview between John Smith and Susan Krowley, as a question and answer format. Within the responses are the elements of action usually in a novel. This is definitely a different perspective of a novel and the message within the story.

Who is the intended audience? Everyone who inhabits this planet. The relevance of this novel is a perfect example of cause and effect and even goes beyond that concept. This is required reading for everyone.

Do you know everything you need to know about Microsoft Word? Or are you so overwhelmed with all the functionality that you are not sure if there are features you could be using to make your life easier? If so, then don’t feel bad. You’re not the only one! But now there’s help! You can receive quality Microsoft Word Training today!

Word is the most widely used business application used. And you would think that since so many people use Word, there would be an abundance of good, affordable training, but amazingly, there is very little available. As a consequence, most people are self-trained and don’t know what they don’t know.

3 Ways to Learn Microsoft Word

1. Self-taught – In dollars and cents, the cheapest. There are many very comprehensive books on the market the will take you from basic introductory skills to advance skills. However, it is not be the cheapest in the long run because there is so much to learn and the time to figure everything out yourself is extremely time-consuming.
2. Classroom Based Training – If you have a good course and instructor, this is a great way to learn certain subject matter. If you don’t understand something, you simply ask the instructor. The disadvantage is the classes can get expensive, and there is not a real resource you can refer to after the class.
3. Computer Based Training (CBT) – This offers the best of both worlds. In dollars and cents, it is relatively cheap to purchase a CBT course. Instead of just reading from a book or Word’s Help screens, it is very interactive. You will be shown exactly how to perform a task, and although you can’t ask a question, you can go back and view it as many times as you would like.

Can You Learn Word? Of course you can! Anyone can, as long as the employ the correct Word training methods. There are multiple Word training CBT courses on the Internet. Now it’s up to you to find the right one for you.

What is Office 365?

Traditionally, Microsoft Office has been a software application that you download and install onto one or more PC’s under a single or multiple user license agreement.

First introduced in 2010 and expanded in 2013 to include new plans, Microsoft Office 365 is a pay-as-you-go subscription version providing ONLINE access to various software and services removing the need to have your own Microsoft Small Business Server. Typically the plans can include:

• Microsoft Office Suite (word, publisher, excel etc)
• Microsoft Exchange Online (hosted email)
• Microsoft Lync 2010 (communications server)
• Sharepoint Document Management (document server)
• Skydrive Storage
• Malware Protection

So is MS Office 365 right for you and your business?

The Pros of Office 365

• Your applications can be accessed via any device (including mobile), through any web browser as long as you have the correct permissions and access to an internet connection, (even wi-fi).
• Reduced capital expenditure
• Instead of paying for new versions, Office 365 upgrades are automatically included within your subscription
• Multiple users can have access to the same documents, for example you can store documents in Sharepoint 2010 and have the ability to make changes, review versions or even leave notes for colleagues.
• Removes any infrastructure headaches should you need to undertake office relocation.
• Greater server stability, with a high uptime Service Level Agreement. (assumes network reliability)

The Cons of Office 365

• Your data is stored in ‘the Cloud’ in Microsoft Data Centres so you are reliant on both network and bandwidth. If your internet connection fails you will lose access to your software and data until it is restored
• You have very little control over this ‘cloud’ environment your data is stored in, whilst there are uptime guarantees any datacentre infrastructure failure can have a direct impact on the availability of Office 365. If Microsoft or other high end Data Centre provider outages do occur, small businesses have no leverage.
• You may consider there to be higher security risks associated with ‘online’ data storage. If this is a key factor for your business, there are upgrade options available but they could be cost prohibitive.
• Application performance may be slower over an internet connection, especially if you have home based users with inferior internet connectivity and broadband speeds. This could have the knock on effect of reducing productivity
• There are limits to the number of email recipients you can have within a 24 hour period

Ultimately if you are considering switching to Office 365, you need to evaluate its suitability based on your own individual business requirements. How would your business be affected if you were unable to access the applications? Are the possible security implications an issue? What budget do you have available? Do you have any internal IT support? Will you still need a local server for certain requirements?

With any IT decision it’s always better to seek help to identify the impact on your business and how to minimise any potential risk.