Microsoft Office
-
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. 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, you wouldn’t…
-
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…
-
Using Microsoft PowerPoint 2010 – Walk Before You Run
MS PowerPoint does not see quite as much use as the twin giants of Word and Excel and just like a great classical musician must be proficient in a piece before they start improvising, we’re going to have a look at getting the basics right in PowerPoint 2010. Don’t forget to have a look at…
-
Importing CSV Data into Access 2010
Synopsis: Access 2010 provides facilities in importing data of many types and in many formats. Here we look at the import of data in CSV format. CSV (Comma Separated Value) format is a very popular way of moving data from one system to another. Although it has its limitations in terms of the types of data…
-
Creating a Chart with Excel 2010
Synopsis: In this article we look at how to create charts in Excel 2010. The ability to create informative and good looking charts is one of the great strengths of Excel 2010. Recent versions of MS Excel have not only made this process easier, but have added powerful additional design and formatting features. A chart…
-
Microsoft Windows 7 Tips and Tricks for the Desktop
Want to improve your grasp of Windows 7? Here are five tips and tricks to help you get the best out of your Windows 7 user interface. Before we begin it’s important to remember that a clean desktop is a happy desktop. If your desktop is cluttered you’ll notice that your computer will slow down….
-
Tips and Tricks for Microsoft Word 2010
Want to make life easier when working with MS Word 2010? Check out the selection of tips and tricks below to develop your knowledge and skills. Tip 1 – Control that mouse! We all know how frustrating it can be when all you want to do is highlight a small selection of text and suddenly…