Friday, November 25, 2011

Is Your Professional Future Predicted In The Stars?

Many people make it a daily habit to check our horoscopes in the newspaper on the way to work. For some people it may be the desire to gain insight into what may lie ahead, or others see it as light-hearted relief before the work day starts. How about a management style related horoscope for today...what would the stars be telling you about your management style today?

The full article appears here:
http://www.microsofttraining.net/article-1683-is-your-professional-future-predicted-in-stars.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Monday, November 21, 2011

Why You Don't Need To Dice With Dirty Data Or Dodgy Databases

More than 25% of the most critical data in the world's top companies is flawed. The problem, however, is due to bad business practice and not to any IT glitches. Safe and secure databases require hardware and software that you can trust. And in a world of continuously growing amounts of data, data quality is also crucial. Whether you are interested in data capture, data cleaning or data enhancement, in order to store, retrieve and analyse your data is going to be of prime importance.

The full article appears here:
http://www.microsofttraining.net/article-1930-why-you-dont-need-dice-with-dirty-data-or-dodgy-databases.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Turn Negative Thoughts At Work Into Positive Actions

All of us at one time or another has become a victim to those 'little voices' in our head which fuel an emotion or event and turn it into something dark and depressing.

The full article appears here:
http://www.microsofttraining.net/article-1475-negative-thoughts-into-positive-actions.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Sorting Birthdates Into Their Respective Months In Excel

The marketing team at Dodd Gee Enterprises have come up with an inventive wheeze that they hope will fleece their entire clientele of a portion of their hard-earned cash. Their records contain information on each client, including dates of birth, and it is through this that the scam will operate.

The full article appears here:
http://www.microsofttraining.net/article-2020-sorting-birthdates-into-their-respective-months-in-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Developing Your Access Skills. The Recipe For Success

There's a site on the internet that I've been using quite a lot lately. It's very handy: you tell it what ingredients you have lying about in your fridge or cupboard, and it tells you what you can make out of them. Ingenious, effective, and a real time-saver - no more rummaging around in cookbooks hunting for some inspiration.

The full article appears here:
http://www.microsofttraining.net/article-2011-developing-your-access-skills-recipe-success.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series

Excel 2010 charts are very versatile, and let you chart more than one set of data on the same chart. What if one of the data sets in is percent? This article explains how to create a chart with two sets of data, one number and the other of percent and allow both sets to display on the same chart. The secret is in using a secondary axis.

The full article appears here:
http://www.microsofttraining.net/article-2013-how-create-excel-2010-chart-show-both-number-and-percent-data-series.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Young Bosses Teach Older Employees New Tricks

Young bosses may be viewed with hostility and great resentment by their older peers. This may stem from the view that they are too 'wet behind the ears' to have the experience required to make important decisions.

The full article appears here:
http://www.microsofttraining.net/article-996-young-bosses-teach-older-employees-new-tricks.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Create A Macro In Excel 2010

Have you ever wondered how to go about creating an Excel macro? A macro can be a really effective way to automate actions you carry out repeatedly and can be used in a great variety of situations. This article describes how to create a macro in Excel 2010 and summarises practical examples.

The full article appears here:
http://www.microsofttraining.net/article-2014-how-create-macro-in-excel-2010.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Learn To Do The Quick Steps In Outlook 2010

One of several new features introduced in Outlook 2010 is Quick Steps. This feature lets you create a list of custom actions to apply to emails. There are some presets supplied which you can edit, and you can also create your own. This article describes how to get to grips with this very useful feature of Outlook 2010.

The full article appears here:
http://www.microsofttraining.net/article-2015-learn-do-quick-steps-in-outlook-2010.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Sunday, November 20, 2011

How To Share Files In Excel 2010

Whether you're new to working with Excel 2010 or you're an experienced user, you may have come across the Share feature in Excel. This lets several people work on the same Excel file at the same time. This article describes how to create an Excel shared file and summarises how a shared file can be used.

The full article appears here:
http://www.microsofttraining.net/article-2016-how-share-files-in-excel-2010.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How Does The Startup Work When Access 2010 Launches The Northwind Database

Every version of Microsoft Access includes the example database Northwind. When you open the Northwind database a particular form open. This tradition continues with Access 2010. If you create Northwind in Access 2010 using the supplied template, and then open the database, a form opens, depending on whether the file sources is trusted or not. Then a Login form loads where you make a selection and then the Home form opens. This article describes how this is done.

The full article appears here:
http://www.microsofttraining.net/article-2017-how-does-startup-work-when-access-2010-launches-northwind-database.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Negotiate Positively In Business

Ideally, negotiation should always end in a win/win outcome, but many people tend to forget that and view it as something far more competitive and aggressive. Knowing how not to negotiate is probably a good start at honing your actual negotiating skills, because it prevents you from making common mistakes early on, and allows you to practise your technique over time.

The full article appears here:
http://www.microsofttraining.net/article-2033-how-negotiate-positively-in-business.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Manage Upwards For The First Time

Many people who are asked to 'manage upwards' and who don't know what it is could be forgiven for getting into somewhat of a panic. Managing upwards? It goes against logic - surely management only ever gets directed downwards, as that's the whole point of being a manager and a leader?

The full article appears here:
http://www.microsofttraining.net/article-2035-how-manage-upwards-first-time.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Three Essentials For The New Manager

If you're about to be a manager for the first time, your level of confidence will be reflected in your previous experience. Perhaps you've acted up or stood in for your boss on occasion, so the job isn't that daunting for you. Perhaps you've led a team before, but have not had this level of responsibility.

The full article appears here:
http://www.microsofttraining.net/article-2034-three-essentials-new-manager.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Improving Financial Performance In Business

If you're a non-financial manager, you may think that the improvement of finance is little to do with you - and best left to the accountants. That's not strictly true, because finance has a domino affect on every part of the business, including your salary.

The full article appears here:
http://www.microsofttraining.net/article-2036-improving-financial-performance-in-business.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Using Creativity To Solve Problems At Work

When faced with a problem or a difficult decision at work, we normally try to solve it in a serious, methodical way. Although this often works, many of us leave out a critical tool in our problem-solving arsenal, and that's the ability to use creativity to solve problems. We've all heard of it - usually deemed "thinking outside the box" or "from left field", but many of us either don't practise this or don't know how. Here are some tips on how to unleash your creative side when faced with a problem or decision:

The full article appears here:
http://www.microsofttraining.net/article-2032-using-creativity-solve-problems-at-work.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Three Ways To Manage Your Team Better With Outlook

Contrary to what many people think, Outlook isn't just for email. It can be used to good effect when managing a team or even just sorting out a project among your colleagues, when a larger programme such as Project might be overkill. If you have the full Office suite, then you can also integrate your Outlook use with Word, Excel and other programs to make managing your team easier. Here are three ways you could use Outlook to make your management tasks easier.

The full article appears here:
http://www.microsofttraining.net/article-2037-three-ways-manage-your-team-better-with-outlook.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Tuesday, November 08, 2011

How To Create Navigation Forms In Microsoft Access

If you've used Microsoft Access for a little while, you'll no doubt have come across different ways to navigate between the different Access objects of forms, tables, queries and reports. Access versions from 97 to 2007 give you the option of creating and using Switchboards to create your own navigation system, whilst versions 2007 and 2010 prefer you to customise the new navigation pane with your own categories and groups. Another way, though, is to create your own form based navigation system. This article describes how to create such a system.

The full article appears here:
http://www.microsofttraining.net/article-2018-how-create-navigation-forms-in-microsoft-access.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Monday, November 07, 2011

Creating Error Alerts In Excel Using Data Validation

I have recently been getting in some late-season camping with my partner before putting my tent away for the winter. The light, balmy evenings of summer have been replaced by cooler, moonlit ones where darkness comes early, and the temperature drops considerably through the night, but we have some decent equipment and we were comfortable enough.

The full article appears here:
http://www.microsofttraining.net/article-2021-creating-error-alerts-in-excel-using-data-validation.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Is It Time For You To Trade Up To Excel 2010?

Consumers in fast-moving retail sectors including fashion and consumer electronics welcome trade-in programmes, as they help offset the prohibitive expense of staying up-to-date with always-desirable new products with ever-shorter life spans, and often ensure that outdated items get reused or recycled. Trading-in gives us the opportunity to quickly and conveniently unlock the value of our old products, while instantly getting our hands on new, improved versions.

The full article appears here:
http://www.microsofttraining.net/article-2023-is-it-time-you-trade-up-excel-2010.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Ensure You Always Make A Complete Data Recovery

Most of us have experienced that sinking feeling which comes by hitting the NO option when saving, or even saving the wrong version of a document instead of the one we need. Fortunately, most of these incidents are relatively inconsequential, representing only a few minutes of lost work or the deletion of unnecessary files. However, sometimes the cost of lost data is substantial. A recent study, for example, has estimated that a company that experiences a computer outage lasting for more than 10 days will never fully recover financially and that 50% of companies suffering such a predicament will be out of business within five years.

The full article appears here:
http://www.microsofttraining.net/article-2025-how-ensure-you-always-make-complete-data-recovery.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Make Your Audience Tune Into Your Presentation

Music is often an afterthought when it comes to designing and delivering a PowerPoint presentation, and it's frequently used for nothing more than background noise. However, by giving some thought about how music is going to be used in your PowerPoint presentation, you can help create a number of benefits for you and your audience.

The full article appears here:
http://www.microsofttraining.net/article-2028-how-make-your-audience-tune-into-your-presentation.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Experience: A Vital Resource For Any Company

There's not a company in the world that won't benefit from making the most of the resources available to it. What these resources are may vary between organisations - for instance, raw materials that need to be used efficiently or effectively - whilst there are certain resources that are common to all businesses, such as the time available for work. And, of course, there's the most important and most limiting resource of all, money, the one whose ups and downs dictate so much else that goes on in the company.

The full article appears here:
http://www.microsofttraining.net/article-2010-experience-vital-resource-company.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How SharePoint Can Lift Your Business Into The Cloud

A London borough council discovered that the power of the cloud helped to combat overflowing rubbish, fly-tipping and graffiti - while saving everyone money. Members of the public who spotted a problem were encouraged to upload photographic evidence to a specially designated website. The council's environment department then provided an update, complete with new photos.

The full article appears here:
http://www.microsofttraining.net/article-2026-how-sharepoint-can-lift-your-business-into-cloud.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Friday, November 04, 2011

Find Out What's Happening On The Cartoon Network

Cartoons were typically used in the production of frescoes on plaster or walls so that an artist could link different parts of a freeze created over several days. Today, we think of a cartoon as a short animation which is usually humorous and is designed to entertain. Although the term can be applied to any animated presentation, it most often features anthropomorphized animals and superheroes. However, the cartoon can create impactful messages in a way that still life can't in any PowerPoint presentation.

The full article appears here:
http://www.microsofttraining.net/article-2029-find-out-what-is-happening-on-cartoon-network.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Tuesday, November 01, 2011

How To Turn Demotivation Into Motivation

It is a well established fact that a well motivated team works better than a demotivated one. With this in mind you should always monitor the motivational status of your team, and act accordingly on any shortfalls. If your team is performing adequately but there is room for improvement, you might look at ways of motivating them to perform even better. If your team is performing inadequately, however, you must find the cause of their demotivation and deal with it.

The full article appears here:
http://www.microsofttraining.net/article-2022-how-turn-demotivation-into-motivation.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Working With Word Means Your Organisation's Success Story Is Not A Fairy Tale

Are you sitting comfortably? Then I'll begin. Once upon a time, in a big building right in the centre of town, lived a business. The business was happy to have got as far as it had, holding off rivals and building a prosperous, upbeat world for itself. When storms would come, the business weathered them, and in bright sunshine, it made the best of the conditions. And when bandits and enemies attacked, it bravely defended itself and its home. As the years went by, the business grew strong and tall and came to be seen by some as a hero in those parts.

The full article appears here:
http://www.microsofttraining.net/article-2012-working-with-word-means-your-organisations-success-story-is-not-fairy-tale.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Make Sure You Keep Remote Control

If you have to manage a team remotely, one of the most important things you need to do is to make the team roles and responsibilities clear. It is vital for team members to know exactly what is expected of them at work, and what they can expect from their roles if you are not always on the shop floor. Providing employees with clear job descriptions and a thorough induction to explain how your role will operate are both effective ways of doing this. And if team members take on new responsibilities as they progress and develop in their roles, their job descriptions should be updated to reflect these changes.

The full article appears here:
http://www.microsofttraining.net/article-2030-how-make-sure-you-keep-remote-control.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How Better Organisation Can Mean A Better Coordinated Business

How often have you heard it said of an organisation that 'the right hand doesn't know what the left hand is doing'? It's common enough, for companies large or small: one individual, group or department isn't aware of something that's happening or needs to happen in another. And of course, those concerned don't intend for it to be that way, but they're too busy with their own work, don't have time to pay attention to anyone else's or tying the strings that connect them.

The full article appears here:
http://www.microsofttraining.net/article-2008-how-better-organisation-can-mean-better-coordinated-business.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

The Three Es For Seamless Change Implementation

Our history is littered with examples of people resisting change. There were those who stated with confidence that electric lighting would never supersede gas. Other diehards claimed that the automobile would never replace the horse as a mode of transport, and, in a famous incident known as the Decca audition, the Beatles, no less, were rejected by the Decca record company, the fab four being told that "guitar groups are on the way out" and "the Beatles have no future in show business". These no-hopers went on to become the biggest name in pop music, and they have sold some 80 million records to date.

The full article appears here:
http://www.microsofttraining.net/article-2031-the-three-es-seamless-change-implementation.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Sorting Names By Surname When They Are Ordered By First Name In Word

Tom is creating a website about the history of his local football club. Among the famous wins and memorable goals that will appear there, he is compiling an A-Z of every player to have pulled on the shirt. There are hundreds of players on this list and he hopes that eventually he will write a brief biography of each one. The site would be set up so that when a user sought information about a specific player, they would simply click on the required letter of the alphabet to bring up every player whose surname starts with that letter and choose the one they seek from the list. Tom has entrusted his brother to type out a complete list of players for him.

The full article appears here:
http://www.microsofttraining.net/article-2019-sorting-names-by-surname-if-ordered-by-first-name-in-word.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com