OneNote 2010: How To Merge Two Notebook Containers

1026d1277894807mergetwocontainers.jpg
Unlike other note taking applications, OneNote 2012 provides content containers, which act just like content place holders, allowing users to quickly separate content written within the notebook. Not only does it help you easily organize notes, it also lets you quickly resize and delete container content without having to manually select the text present inside the container. By default the containers are enabled, and OneNote automatically creates one as soon as you add content to your notebook. However, if you want to disable content containers, you can easily do so from OneNote 2010 Options dialog. If you love using containers to separate the content, OneNote offers you a quick way to merge two selected containers, present within a single note sheet. In this post, we will explain how you can merge two containers together. This will append the content from one container to selected container.  Read More

Find Correlation Between Datasets In Excel 2010

table1.jpg
Excel 2010 supports a multitude of statistical functions that bring ease for calculating statistical data promptly. Amongst Stats functions, finding a correlation manually between two given datasets can be cumbersome, but with built-in Excel 2010 CORREL function, finding co-relation coefficient is a cinch. The function lets you easily calculate co-relation between any two given data sets or set of values. You need to specify the data range or values, it instantly shows you the co-relation between them. You can quickly apply applied CORREL function over required data sets by just copying the cell containing the CORREL function. All it requires is two simple arguments to be filled in the form of arrays. The Correlation values range from –1.0 to +1.0, implying +1.0 as best co-relation between datasets and converse is the case with –1.0. Read More

How To Change OneNote 2010 Notebook Section Color

271d1273661634howchangesectioncolor.jpg
Looking for a way to change the default color assigned to your notebook section? OneNote 2010 automatically applies a random color to your notebook section as well as its pages, sub pages and 3rd level sub pages. Whenever you click the new tab on the tab bar present in the main window, it creates a new notebook section and enables you to tweak the default settings including paper size, rule lines, gridlines etc., of the notebook page from the View tab on the ribbon. Although OneNote 2010 provides you with an option to change the default notebook page color in order to visually differentiate between multiple notebook pages, it doesn't offer a direct way to change the default color while creating a new section. Using the tab right-click context menu, you can quickly change the section color; just click the required notebook section's tab, and from Section Color menu, select the color you wish to apply to your notebook section. Read More

OneNote 2010: Create Hyperlink To Mail Address In Notebook Section

1027d1277894870createhyperlinkmailaddress.jpg
OneNote 2010 is just like any other word processing application that supports direct mailto links. It is helpful because users don't have to hyperlink the mail address manually. Hyperlinking to any email address is a quick way to email. If you want to create an important note or reminder and also want to start emailing in just one click, then you can use mailto: function. Read More

Wildcards Entries In Access 2010

createquerydesign.jpg
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

ZeeCell Clipboard For Saving Data & Category In Excel

addins.jpg
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

PowerPoint 2010 Viewer

p11.jpg
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

View Statistics Of Outlook Emails With Outlook StatView

statview1.jpg
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

Create Macros In Word 2010

document1.jpg
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