Going Against The Grain With Multiple Radio Buttons In Excel

Stan runs an online newsletter for a local group of games console football fans. They have just completed a knock-out cup tournament and Stan is entering the results in Excel. There were several penalty shoot-outs in the tournament, and Stan decides to display the outcomes of these using radio buttons; a filled button for a goal and an empty one for a miss. Of course, he soon comes across a problem.

The full article appears here:
http://www.microsofttraining.net/article-1969-going-against-grain-with-multiple-radio-buttons-in-excel.html

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

How To Grow Your Business With The Power Of Social Networking

As web-obsessed Britons, 72% of us spend an average of 16 minutes surfing our social networks while lying in bed, checking Facebook, Twitter and other social sites. The peak time for bed-based social networking is 9.45pm, with 18% of those online admitting to accessing Twitter at that time. Britons also spend an average of nine minutes per night sending text messages to friends and family. More than a quarter of us do our supermarket shop in bed, while 10% pay bills online from under the duvet.

The full article appears here:
http://www.microsofttraining.net/article-1427-how-grow-your-business-with-power-social-networking.html

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

Office Looks Set To Keep Remote Working One Step Ahead

Apparently we are on the brink of a new epidemic of emerging neologisms.

The full article appears here:
http://www.microsofttraining.net/article-920-office-looks-set-keep-remote-working-one-step-ahead.html

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

SQL Server, The Ideal Large Scale Data Solution For Your Business

Dan is a fictional head of an IT department of a government body that's responsible for managing the licensing of vehicles and drivers. It's a huge organisation, working with millions of pieces of information concerning cars, vans, trucks and motorbikes - and the people that own and use them - all across the country. And Dan needs to ensure that any element of this vast array of electronic data is always available immediately for any part of the organisation to use.

The full article appears here:
http://www.microsofttraining.net/article-1338-sql-server-ideal-large-scale-data-solution-your-business.html

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

Microsoft Project: What Are Dependencies?

I remember many years ago, when I made the acquaintance of Microsoft Word for the very first time, being bamboozled by all of the icons and drop down menus on the screen. I thought I'd never get to grips with so many features and the sheer sight of those loaded toolbars was enough to intimidate me. Gradually, though, I persevered with my tuition and I learned what all of these icons meant, and what the drop down menus actually did. Now I am fairly proficient in the use of Word and I look back wondering why I felt so overawed at the outset. Having said that, however, there is an awful lot to this excellent application that I still have to learn.

The full article appears here:
http://www.microsofttraining.net/article-1299-microsoft-project-what-are-dependencies.html

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

How SharePoint Can Have Your Business Sitting On Cloud Nine

Clouds used to be seen as such negative things - just think of all those songs about leaving the clouds behind you, moving onto something better with a bright clear sky. Nobody liked clouds. They presaged misery and disappointment and, well, rain. Yet suddenly, clouds are exciting, they're the cutting edge of technology, they're a solution to countless IT problems and a boon to internet users everywhere, on all kinds of devices. Suddenly, clouds are nothing but silver lining.

The full article appears here:
http://www.microsofttraining.net/article-1856-how-sharepoint-can-have-your-business-sitting-on-cloud-nine.html

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

Differences In Excel 2003, 2007 And 2010

Despite it being the latest version, many offices haven't yet switched over to Office (and consequently Excel) 2010, either because they are budget-conscious and making the most out of the old versions before support for them is withdrawn, or they are aware that staff will need to be trained up in the new version due to the difference being marked from its predecessors.

The full article appears here:
http://www.microsofttraining.net/article-1980-differences-in-excel-2003-2007-and-2010.html

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

How To Master Those Basic Financial Terms

There are many creative spirits within the modern corporate world just as there are a large number of natural leaders and motivators. The ability to see things that nobody else can see, to 'think outside the box,' is a highly desirable tool and there is no question that business thrives on these visionary creatives and the incredible new products and methodologies that they bring to the world.

The full article appears here:
http://www.microsofttraining.net/article-2004-how-master-those-basic-financial-terms.html

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

Poor Presentation And No Questions: Don't Fall For A Bad Trainer!

So you have swallowed your pride, acknowledged that you need help in a particular area and booked a place on a computer training course for a specific product or software program.

The full article appears here:
http://www.microsofttraining.net/article-2005-poor-presentation-and-no-questions-dont-fall-bad-trainer!.html

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

I Love It When A Plan Comes Together: Taking The Time To Construct A Proper Project Plan

Congratulations, you have just been appointed to your first project management role and you are feeling empowered and confident. You are chomping at the bit to get going, to prove to those superiors who put their faith in you that you are a bright, dynamic individual who can achieve even more than they expected you could. You have no desire to be cooped up in an office trawling through data or planning projections or strategies and, what is more, neither do your team who are enthusiastic and back you all the way.

The full article appears here:
http://www.microsofttraining.net/article-2006-construct-proper-project-plan.html

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

A Place Of Trust: How Microsoft Have Made Access 2010 Even More Secure

The computing revolution has given us so many positive developments from the ability to communicate with people on the other side of the world with the click of a mouse to storing a near infinite amount of data either online or within a highly sophisticated digital database.

The full article appears here:
http://www.microsofttraining.net/article-2007-how-microsoft-have-made-access-2010-even-more-secure.html

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

Maintain Your PowerPoint Photo's Impact With Semi-Transparent Text

Many years ago, before I'd ever typed a single character on a computer, I produced a sporadically released fanzine that was aimed at promoting the local music scene. It was a crude monochrome production that was printed on standard A4 paper. With its barely decipherable photos and marker pen headlines, it never did take its place in the newsagent alongside similar, more glossy music magazines. But it served a purpose and I enjoyed working on it.

The full article appears here:
http://www.microsofttraining.net/article-1972-maintain-your-powerpoint-photos-impact-with-semitransparent-text.html

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

Organisational Skills: Now Versus Orwell's Day

I recently read an essay by George Orwell (1903-1950), in which he illustrates the life of a book reviewer in the years immediately following the Second World War. It makes interesting reading if, for no other reason, the opening paragraphs give us a snapshot of how immensely difficult it must have been to maintain any system of organisation in the pre-computer age.

The full article appears here:
http://www.microsofttraining.net/article-1977-organisational-skills-now-versus-orwells-day.html

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

Creating And Importing Custom Lists In AutoFill

Excel has some excellent automatic features that save a lot of time and effort for the user. For the data entry user, AutoComplete saves thousands of keystrokes by predicting the current entry. This is extremely useful when entering names and addresses from a certain geographical area, where the same towns and cities are entered repeatedly. To enter Newcastle upon Tyne simply by typing the first two letters is an example of the enormous amount of assistance this feature offers.

The full article appears here:
http://www.microsofttraining.net/article-1970-creating-and-importing-custom-lists-in-autofill.html

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

Scheduling A Project In The Correct Order

Sometimes things have to be done in a certain order because that's what works best. The film director who shouts "Action, Camera, Lights" would have a flop on his hands, and the pupil on a driving test who understood MSM to mean manoeuvre, signal, mirror would find himself resitting his test at a later date.

The full article appears here:
http://www.microsofttraining.net/article-1978-scheduling-project-in-correct-order.html

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

Project Management: Working Within Parameters

As we live our daily lives, we constantly come across parameters we must stay within. Anyone who wishes to partake of an alcoholic drink in a public house must do so within the parameters of the current licensing laws. Similarly, if someone pays for a transaction using a debit card, then they must stay within the parameters of their agreed overdraft or a charge will be issued.

The full article appears here:
http://www.microsofttraining.net/article-1979-project-management-working-within-parameters.html

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

Knowing Your Way Around Expenses

Expenses used to have a good reputation, as a legitimate way to compensate staff and managers for any out-of-pocket expenses they incur (as we all do) in the course of our day to day jobs.

The full article appears here:
http://www.microsofttraining.net/article-1984-knowing-your-way-around-expenses.html

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

Differences Between Gantt Chart And Network Diagram View In Project 2007

Whether you're a new or experienced Project 2007 user you'll no doubt be accustomed to using the Gantt Chart view which shows tasks organised in linked relationships on a calendar type display. However did you know that the Network Diagram View offers an equally informative view of the project plan but from a different perspective. This article describes the key features of the Network Diagram View compared to the Gantt Chart View.

The full article appears here:
http://www.microsofttraining.net/article-1950-differences-gantt-chart-network-diagram-view--project-2007.html

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

Differences Between Gantt Chart And Network Diagram View In Project 2007

Whether you're a new or experienced Project 2007 user you'll no doubt be accustomed to using the Gantt Chart view which shows tasks organised in linked relationships on a calendar type display. However did you know that the Network Diagram View offers an equally informative view of the project plan but from a different perspective. This article describes the key features of the Network Diagram View compared to the Gantt Chart View.

The full article appears here:
http://www.microsofttraining.net/article-1950-differences-gantt-chart-network-diagram-view--project-2007.html

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

Have You Microsoft Office Compatibility Issues?

Many Office users use Office 2003 as well as Office 2007/2010 and sometimes it is important to understand how compatibility issues can affect application files if they are used in different Office versions. The article summarises the key differences and describes several compatibility issues.

The full article appears here:
http://www.microsofttraining.net/article-1951-have-you-microsoft-office-compatibility-issues.html

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

A Brief Guide To The Project Options Panel In Project 2010

Whether you're a new or experienced Microsoft Project user, you'll find that Project 2010 is very different compared to previous versions in many ways. And sooner or later you'll need to view or change the Options settings. This article guides you through each option category and describes the main categories in each.

The full article appears here:
http://www.microsofttraining.net/article-1952-brief-guide-project-options-panel-project-2010.html

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

What Are PST Files Used For In Outlook 2010?

Whether you're a new or experienced Outlook 2010 user, you'll have used some kind of data file in which Outlook stores all your work. If you use Outlook without linking to an Exchange Server then Outlook creates and updates a PST data file on your computer.

The full article appears here:
http://www.microsofttraining.net/article-1954-what-are-pst-files-used-in-outlook-2010.html

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

Find Out Where Outlook 2010 Stores The PST Data File

Have you ever wondered where the PST file is located in Outlook 2010? In this article we'll describes where Outlook 2010 stores this data file, how to easily find this location and should you need to, how to add additional PST files.

The full article appears here:
http://www.microsofttraining.net/article-1955-find-out-where-outlook-2010-stores-pst-data-file.html

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

How To Use The New Windows Explorer In Windows 7

The new Windows Explorer in Windows 7 has a new icon, introduces you to libraries and folders and lets you search for file by name all within the same pane. This article summarises the main features and describes how to use them.

The full article appears here:
http://www.microsofttraining.net/article-1956-how-use-new-windows-explorer-in-windows-7.html

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

What You Need To Know About LOOKUP Functions In Excel 2007/2010

Lookup functions allow you to extract data from an Excel table and use the resulting values somewhere else in Excel. However there are quite a variety of LOOKUP functions available and it's not always easy to decide which function to use. This article summarises the main LOOKUP functions available and describes how they are used.

The full article appears here:
http://www.microsofttraining.net/article-1958-what-you-need-know-about-lookup-functions-in-excel-2007-2010.html

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

How To Sort And Filter A Table In Access 2010

Once you've created a database in Access 2010 you'll have realised there are powerful ways to sort and filter table date using queries. But did you know you can sort and filter a table from the normal table view without needing to design a query. This article explains how to do this.

The full article appears here:
http://www.microsofttraining.net/article-1959-sort-and-filter-table-in-access-2010.html

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

Some Interesting Finds In Excel 2007/2010 Using Find And Select

Have you ever used the Find and Select command in Excel 2007/2010? Then you'll have found that you can find cell contents such as text or formula, and you can replace one value for another if you wish. But did you know there are some other hidden gems available here too. This article summarises how to use Find and Replace and then looks at two other very useful features, Find and Replace formatting, and Go to Special.

The full article appears here:
http://www.microsofttraining.net/article-1960-some-interesting-finds-in-excel-2007-2010-find-and-select.html

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

Discover How To Use Fill In Excel

If you've used Excel for some time you may have discovered the Fill feature. You can use fill to copy and paste a formula over a range of cells, create a series of values depending on the cell contents, create a series of values from a built in list, or create your own custom list to Fill. This article describes how the Fill feature can be used in Excel in different ways.

The full article appears here:
http://www.microsofttraining.net/article-1961-how-use-fill-in-excel.html

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

How To Use The New Navigation Form In Access 2010

You can create a Navigation Form in Access to let the database user choose to display a form or report without needing to use the navigation pane or open the objects directly. This article describes how to create a simple Navigation Form and also describes how to set this form to display when the database is opened or viewed as a web database.

The full article appears here:
http://www.microsofttraining.net/article-1962-how-use-new-navigation-form-in-access-2010.html

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

How To Create Your Own Access 2007/2010 Navigation Pane

Access 2007/2010 has a brand new Navigation Pane which you can customise to suit your own database. Although it's a completely new feature compared to previous Access versions, this pane can be easily customised with your own content to enable you to create your own clickable navigation system. This article describes how you can do this.

The full article appears here:
http://www.microsofttraining.net/article-1963-how-create-your-own-access-2007-2010-navigation-pane.html

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

Combining Logical Functions In Excel

If you've used Excel for some time, you'll realise there are different logical functions such as IF, AND and OR. This article describes how these functions can be combined to perform very useful composite logical operations.

The full article appears here:
http://www.microsofttraining.net/article-1965-combining-logical-functions-in-excel.html

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

Don't Get Lost In A Sea Of Data, Use Excel Navigation

It's a sad fact that 59% of 1,000 US and UK middle managers say that they frequently miss important information every day because they just can't find the data within their own company. And that an astounding 15% of all paper handled in businesses is lost, with employees using 30% of their day trying to find misplaced documents.

The full article appears here:
http://www.microsofttraining.net/article-1989-dont-get-lost-in-sea-data-use-excel-navigation.html

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

The Best Way To Use Clip Art Images In Excel

Sometimes it's not just about numbers and targets. At a recent industry conference delegates were presented with facts and figures showing the positive trend of fewer accidents occurring within their sector. Next year's target was to reduce the figure even more.

The full article appears here:
http://www.microsofttraining.net/article-1990-the-best-way-use-clip-art-images-in-excel.html

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

Use Split Form View In Access For Simultaneous Views

A problem has arisen down at Billy's DVD rental store. When new members filled out their application forms to join, supplying their date of birth was optional. This was fine in most cases, but for those hovering below the 18 years-old mark, confusion arose as to whether or not they were allowed to hire films that were 18 certificate. He had refused to serve a member in a school uniform with an 18 certificate film, and the lad had become quite vociferous in his protest.

The full article appears here:
http://www.microsofttraining.net/article-1968-use-split-form-view-in-access-simultaneous-views.html

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

Are You Ready To Let The Cloud Lift Your Business?

For anyone thinking about entrusting their IT infrastructure and business applications to the cloud, the questions of security is going to be paramount. Of course you need to be completely satisfied that the new cloud set-up is resilient and secure, but it's not just about productivity: You need to be assured that compliance with data protection is addressed, that traceability is seamless and that there are disaster recovery processes in place. Microsoft's global network of high-spec data centres are being marketed as conforming to stringent international standards to address all of these criteria âˆ' and more.

The full article appears here:
http://www.microsofttraining.net/article-1992-are-you-ready-let-cloud-lift-your-business.html

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

Perfect Persuasion: A Positive Influence On A Successful Business

During an unsuccessful challenge for the Republican nomination in the 1968 US Presidential Election - both contests eventually being won by Richard Nixon - Michigan Governor George Romney spoke of the influence the military had had on forming his opinion of the Vietnam War. He claimed that he'd been 'brainwashed' into believing hawkish views on the conflict which he later found to be untrue - a claim to which Democratic candidate Eugene McCarthy retorted, 'Brainwashed? I'd have thought a light rinse would have sufficed'.

The full article appears here:
http://www.microsofttraining.net/article-1945-perfect-persuasion-postive-influence-on-successful-business.html

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

How To Use The Quick Access Toolbar In Office 2007/2010

All the Office 2007/2010 applications have the new Quick Access Toolbar located above the tabs in the ribbon navigator. This article describes how you can easily customise this toolbar by adding your own favourite commands to the toolbar. In this way you can have a set of commands at your fingertips which you can apply with just one mouse click.

The full article appears here:
http://www.microsofttraining.net/article-1953-how-use-quick-access-toolbar-in-office-2007-2010.html

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

How To Use The Page Layout Features In Excel 2007 And Excel 2010

Excel 2007/2010 has many very useful features including working with data, lists and charts, but equally important are the Page Layout features which help you organize Excel to created printed results. This article describes how to use the Page Layout tab and Page Layout views to create effective results.

The full article appears here:
http://www.microsofttraining.net/article-1964-how-use-page-layout-features-in-excel-2007-and-excel-2010.html

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

To Delegate Or Not? That Is The Question

As a manager you know that a good way to demonstrate your suitability for the job is to delegate tasks to others. This ensures that you apply maximum effort to the project, and it shows your own manager that you are on the ball when it comes to spreading out the workload. But any tasks that come in should be considered carefully before being delegated

The full article appears here:
http://www.microsofttraining.net/article-1966-to-delegate-or-not-that-is-question.html

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

Create Date Sensitive Colour Changing Cells In Excel

Billy has bought a job lot of used DVDs to set up a movie rental business. Instead of renumbering the entire batch of discs and cases, which were ex-rentals, he has used their existing numbers, but he applied Excel's Ensure Unique Values function to avoid duplicating any numbers. He knows his stock, and has unique references so that he can keep track of them. So far, so good for Billy.

The full article appears here:
http://www.microsofttraining.net/article-1967-create-date-sensitive-colour-changing-cells-in-excel.html

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

Liaise Closely With The Chair For Effective Minute Taking

Two key elements of efficient minute taking are good preparation and close liaison with the Chair. The former ensures an accurate record of the meeting, while the latter regulates the level of discussion being recorded.

The full article appears here:
http://www.microsofttraining.net/article-1973-liaise-closely-with-chair-effective-minute-taking.html

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

Positional Bargaining: The Soft Or Hard Approach?

I am always on the lookout for things that might prompt an idea for an article, and television shows are as rich a source as any. We can glean an insight into how certain management skills are used by watching them in action on the small screen. For example, Dragons' Den is the place to witness hard-nosed negotiating skills over sums of money that run into the tens of thousands of pounds, and Grand Designs shows us project management in action, including delays and unexpected problems, and their remedy.

The full article appears here:
http://www.microsofttraining.net/article-1975-positional-bargaining-soft-or-hard-approach.html

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

Choosing A Training Style To Suit You

Staff training used to mean either someone coming to your workplace, giving a presentation and leaving, or for you to travel as a group to a training venue, to have the same presentation, and then leave.

The full article appears here:
http://www.microsofttraining.net/article-1982-choosing-training-style-suit-you.html

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

How To Really Work Those Apps With Office

It's official: The Internet is well and truly going mobile. In the final quarter of last year, more smartphones than PCs were purchased and marketers can expect anything between 12% and 20% of searches in their sector to originate on a mobile device. If you own a smartphone, you've got the world at your fingertips. And now that the Windows Phone comes with mobile versions of all your favourite Office apps, you can work anywhere at any time.

The full article appears here:
http://www.microsofttraining.net/article-1993-how-really-work-those-apps-with-office.html

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