Microsoft Office
How to do a Mail Merge in Microsoft Word 2013 – Part 1
Mail Merge is an important functionality in Word 2013, one that has improved across versions of Word but remains a difficult thing to do. Word provides a Mailings Tab which contains numerous groups and commands useful in Mail Merge, such as the Create, Write and Insert Fields, and Preview Results groups. A Mail Merge Wizard…
Clean, Smooth and Sexy: Could this really be PowerPoint 2013?
The word sexy is rarely, if ever, used to describe Microsoft Office products, but in the case of PowerPoint 2013 an exception will need to be made. Like an ugly duckling that became a majestic swan the latest rendition of Microsoft’s presentation software has undergone a jaw dropping transformation. The changes aren’t even just on…
How to Insert Video and Audio in Microsoft PowerPoint 2013
There is a new and unique feature to be found in Microsoft PowerPoint 2013 that will make life easier for everyone using the presentation software. It used to be that if you wanted to insert video into your PowerPoint presentation you needed to have a file on your computer to open but now all that…
Using the Junk Email Options in Outlook 2013
Dealing with Junk and Spam Email is vital to email management in Outlook 2013, which provides tools to do so. It is important that Outlook be meshed with installed third-part security software for both to be effective. A Junk Email Options Dialog is available through the Home Tab’s Delete Group, and contains various options pertaining…
Getting Excited About Outlook 2013 New Features
Microsoft Outlook remains the leading choice of email, contact, and calendar application for millions of users and businesses worldwide. But keeping track of contacts, emails and calendars can slurp untold time out of any workday. Microsoft Outlook 2013 is designed to help you to achieve more by streamlining and simplifying contact and email management. The…
Finding Duplicate Records in Access 2013
Synopsis: A common problem when working with databases is the presence of duplicate records. In this article we look at some of the facilities in Access 2013 for identifying duplicate records. There are various causes for duplicate records in a database. One common scenario occurs when two or more databases are merged. Another situation that…
How to Create a Database in Microsoft Access 2013
Synopsis: In this article we look at the options for creating a new database in Access 2013. In earlier versions of Microsoft Access, a database has usually meant a desktop database. This is a database comprising data structures and user interface components that enable one or more users to maintain data. In the most common…
The Ribbon Is Large and in Charge in Excel 2013
The Excel menu has been slowly transitioning over the years from the grid with drop-down menus towards the “ribbon.” In the latest version of Excel, the ribbon transition is complete, and users are now left with this smoother, seamless menu option. The ribbon is that rectangular bit at the top of Excel, with command options…
A Roomier Look in Microsoft Excel 2013
The all new layout of Microsoft Excel 2013 is less crowded than before, with much more open space than previous versions contained. The reason is both functional as well as having a secondary, aesthetic appeal that users are finding to their liking. This extra space facilitates easier access on mobile devices as well as makes…
How to setup rules in Microsoft Outlook 2013 – Part 1
Synopsis: In Outlook 2013 you can define rules that tell Outlook to perform specific actions on incoming or outgoing E-mails. In the first of two articles we look at how to create basic rules. In the second article we will look at some more advanced options. If you have good anti-virus and anti-spam software it is…
How to Setup Additional Microsoft Outlook 2013 Profiles
Synopsis: In Outlook 2013 a user’s profile determines which mail accounts are used. If several people share a PC, it is possible for each of them to have their own profile. In this article we show you how to setup additional Outlook 2013 profiles. For most users a single Outlook 2013 profile can enable them to…
Understanding Access 2013 Relationships between Tables – Part 2
There are several features in Access 2013 that make tables much interactive and versatile. Lookup wizard allows you to predefine the set of values that a field can take. The potential values appear as a drop down menu, and you can simply select the correct value for that particular record. You can further choose to…
