Using Side Notes in Microsoft Office 2010 OneNote

Is your desk cluttered with sticky notes? Well, here is a neat way to start cleaning up.  Side Note is a feature in One Note that you can use to do exactly as it suggests and make a side note without having to open a new document, or stop what you are doing to find a pen and paper.  The benefit is you can use it even when the program is closed.  Simply press the Windows key +N on your keyboard and a small OneNote window will open where you can jot down a note.  Plus you don’t even have to save it; when closing the window the note is automatically saved to the Unfiled Notes section.  OneNote is a rather new and unknown application for Microsoft Office, but the more you use it and get to know it the more you will love it!   

Delegating Tasks to Your Team with: Britt Andreatta- Lynda.com

In this course, Lynda.com Director of Learning and Development Britt Andreatta walks you through her delegation process, which helps you assign the right tasks to the right people and better develop your team and meet company needs.

The course reveals what delegation can do for you and your team and introduces a four-phase model to delegate tasks and manage projects large and small. The phases include evaluating the task, handing the task over, supporting task completion, and closing the task. In between, learn how to pick the right level of autonomy for each task and the best ways to avoid micromanagement.

Add a Second Time Zone to Outlook 2010 Calendar

Many times we need to set up meeting with people in different time zones or your business may require you to travel between different time zones.  In your Outlook calendar you can have a second time zone displayed, which will make it easier to set appointments for parties in both time zones involved. Here is how:

•     First click on the File Tab
•     Then click on Options
•     Next click on Calendar and scroll down until you see the Time Zone section
•     Once there click the box labeled Show a Second Time Zone
•     Select and Label your additional time zone and click OK 

Now in your calendar you will see both time zones you have selected.

Copy Cat

Text to Columns in Microsoft Excel 2010

We use lists of text all of the time in Excel, but those lists do not always come neatly formatted.  Thankfully, there is a setting in Excel in called Text to Columns that can make the task of splitting information into multiple columns a simpler task.  For example, let’s say you are given a list of names in Excel that is not sorted and has the whole name in one cell.  This can be especially frustrating when you need to sort by last name, but now with this trick you do not need to retype all the information and here is how. 

• First select the group of data that you would like split

• Then go to the Data tab on the Ribbon and in the Data Tools group you will find the Text to Columns option
• This will open up a window where you can complete a wizard that will help you appropriately split your text

Now wasn’t that much easier than re-typing all your data?

Excel 2013 Power Shortcuts with: Curt Frye- Lynda.com

Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information.

Split Panes in Microsoft Office Excel and Word 2010

Many of our offices are going paperless theses day to save on printing costs, but there are some things that we just need to see side by side without having to scroll to different locations in your document.  So here is a neat trick that will fulfill both of those needs.  In Word and Excel you can split the panes to view opposite ends of a document on the same screen. First, go to the View tab on the ribbon and in the Window group select the Split option.  In Word, once you have clicked the Spilt option a gray line will appear on your screen, move it to where you would like the split on your window and click. In Excel, your window will automatically split into four different sections.  To switch between panes you can simply click into your desired pane, or you can also press F6 to change between panes.