OneNote 2010, just like any other word processing application, supports direct mailto links, so user wont have to hyperlink the mail address manually.
READ MORE
You might have noticed that on entering data, inserting table, or image, OneNote 2010 encloses every element in a container. READ MORE
Microsoft Office 2010 trial is only valid for 30 days after which you need to activate it by purchasing the product. Office 2010 Trial Extender is a free tool that rearms the trial and increase the total days from 30 to 180. See how it works after the jump.
READ MORE
By Nakodari on May 10, 2010
Tagging helps user in finding out specific notebook element easily. If you’ve tagged all of your notebooks elements, OneNote 2010 provides a handy feature which lets you find all the tagged items in a snap.
READ MORE
OneNote 2010 keeps a detailed record of recently used notebook editions, it can instantly show you recent edits within the range of last 6 months. If OneNote 2010 is your primary note taking application, you might want to list down all the recently edited notebooks.
READ MORE
Pivot Table, being the most celebrated feature of Excel, includes multitude of options to manipulate the data in desired way. Once pivot table is created from the source data, you can add fields & items without modifying source data, which comes in handy for doing quick calculations. In this post we will demonstrate adding a Calculated field in Pivot table.
READ MORE
WHERE is the most used command in SQL, providing easiest way to pull out specific data from table. Even though you can use SQL commands in Access 2010, but CLI (Command Line Interface) brings monotony along and database novices usually get their hands on a tool which offers simple GUI layout. So the best alternative around in Access is to use wildcard entries, aka, Like/Unlike conditions, which offers innumerable ways of pulling out desired info from tables, queries, etc.
READ MORE
Wouldn’t it be handy if you can save & categorize the table fields’ data in Excel, for using it later in spreadsheet. ZeeCell is a small add-in built especially to save the data, fields, columns, along with non-contagiously selected data in it’s repository. Apart from this, it also saves & learns the data pattern to remind you on saving exact data cells in a category.
READ MORE
Unarguably PowerPoint stands out when it comes to creating intriguing and appealing presentations, thus, it is widely used everywhere. Considering the fact that it is abound but there are still many users out there who can’t shell out to purchase the product. To cope up with this, Microsoft recently released the latest version of PowerPoint Viewer which allow any user view presentations without requiring PowerPoint installation.
READ MORE
If you have been wandering to get your hands on an app which provides complete emails statistics, Outlook StatView is just what you need. It is a small portable utility built specifically to give you complete statistics of mails you received in Outlook. As name implies, configured Outlook account is pre-req to extract email info from. Apart from mere a statistics viewer, it also provides you with multitude of options including, generating HTML reports, sifting down the emails through statistics categories bundled in columns, looking up for specific emails through Find feature and much more.
READ MORE
Macros has been an old phenomenon of Office apps allowing you to record set of actions you perform on document, and to repeat them in future. Through Macros, you don’t need to perform same action, i.e, change formatting, style, font family, size, and color over and over again in document. It actually records each and every click and keystroke you press while performing the task, so that you can play them back to perform same action over your documents.
READ MORE
Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type.
READ MORE
Applying different conditions over data fields comes in very useful when you need to evaluate data field values based on other fields. Expression Builder in Access 2010 provides you just that with full support of applying functions and formulas. It can be used anywhere in Access 2010 with any database element like; Forms, Reports, Queries and Tables. In this post we will be using expression builder in query for evaluating new data field values.
READ MORE
As the name implies, Query pulls out specific data from table fields included in database, thus, setting specific criterion in query helps you to filter down the table field data according to your needs. Through simple logical operators in Query Criteria you can set a criteria by using simple AND/OR operators, which lets you to confine the results of a query based upon the query criteria to check which table field data is to be included.
READ MORE
Excel 2010 provides list of DATE function to calculate date value promptly, as it is a tedious job when going for it manually. EDATE is right function to be used for this sole purpose, it will instantly returns future or past date value as per specified condition.
READ MORE
