Microsoft Office
Exporting to Microsoft Excel in Project 2010
Synopsis: Sometimes you need to process project information in a way that Project 2010 itself does not support. In this article, we look at the facilities in exporting project data to Microsoft Excel. Project 2010 includes flexible facilities for both the import and export of data. Wizard features are provided to assist with both of…
More Tips with PowerPoint 2010 Shapes and Pictures
Shapes and pictures are essentially the main component of PowerPoint presentations along with text. Knowing how to manipulate them properly can only make you a more skilled PowerPoint user. Read on for selection of tips and tricks concerning shapes and pictures. FacebookLinkedinTwitter Shape effects You can edit shapes to give your presentations a much sharper…
How to Use Smart Tags in Microsoft Access 2010
Synopsis: Learn about how to use smart tags in Microsoft Access 2010. Smart Tags were introduced in Access 2003 as a simple way of connecting simple functionality to a field in a database table with a minimum of effort. Many databases contain fields and types of fields that occur very frequently in a whole range of applications. …
Tips and Tricks for Microsoft Word 2010 – Part 3
Here are another four tips and tricks for intermediate to advanced users to increase your working knowledge of Microsoft Word 2010. Tip 1 – An easy change of case We all remember how frustrating it was in previous versions of Word when we’d typed out a large chunk of text only to find that Caps…
How to Personalize Microsoft Outlook 2010
Everybody likes to have things their own way. That’s not always possible but there are a number of things you can do in Outlook 2010 to customise the user interface and the style of your email messages. Read on for our top customization tips. FacebookLinkedinTwitter 1 Main theme You have three choices when it comes…
Creating PDF and XPS documents in Excel 2010
Synopsis: In this article we look at how to convert a workbook to PDF or XPS format. These formats are readable by people who do not have Excel 2010 installed. Excel 2010 is a very popular spreadsheet program, but not everybody has it installed. To share a workbook with people who do not have Excel…
Using SmartArt in PowerPoint 2010
Synopsis In this article we look at how to use SmartArt in PowerPoint 2010. We add SmartArt to a slide then customize it to our specific requirements. SmartArt was introduced in PowerPoint 2007. It has proved to be a very popular and flexible way of including graphical elements in a presentation. It is particularly used…
Tips and Tricks for Microsoft Word 2010 – Part 2
Tips and Tricks for Microsoft Word 2010 – Part 2 We’re going to run through a further four tips and tricks to enhance the MS Word 2010 experience for intermediate to advanced users. Tip 1 – Set a more readable default MS2010 font ‘Calibri’ is the default MS Word 2010 font when you launch the…
5 Tips for Using Windows 7 to Help Your PC
Several developments built-in to Windows 7 make it easier for you to look after your Windows environment and the overall health of your PC. We take a look at these in the form of 5 tips and how they can help you… Power efficiency This is one for frustrated laptop users who are sick of…
Managing Microsoft Outlook 2010 with Mailbox Rules
Outlook mailbox rules are instructions to perform automatic actions on emails as soon as they come in to your mailbox. Automating what happens to incoming mails not only keeps your mailbox free from clutter but saves you a lot of wasted time on routine administrative tasks. Read on to find out more about rules and…
Using Input Masks in Access 2010
Synopsis: Input Masks can be used to limit the pattern for the entry of data into a database. They can also make data entry easier.Facebook Linkedin Twitter With many data fields, there is little pattern to the data that can be entered. For example, if you want users to enter a free text description of something,…
Creating and Formatting Sparklines in Excel 2010
Synopsis: Sparklines were introduced in Excel 2010. In this article, we look at how to create and format these tiny charts. Until now Excel charts have been graphic objects that are generally positioned and sized independently of worksheet cells. In Excel 2010 Microsoft introduced the Sparkline, a new type of chart that actually lives in…
