Math in OneNote

OneNote can do simple math! In many of our meetings we end up talking about budgets and what can be afforded for different events.  Well, now while you are taking your notes in OneNote you don’t have to get out of it to do your math. Simply type out the math you would like OneNote to do (ex:25/5=) followed by an equal sign and then hit Enter or the Space bar and you will see the answer.

Sorting Slides in Microsoft PowerPoint 2010

When you have large presentations with a lot of slides, it is easy to get “lost” in your slides.  To help you keep your place in your presentation you can sort your presentation into sections.  In the Navigation Pane, right click between the slides and click Add Section.  Then, right click on Untitled Section and click on Rename Section, then you can title your section appropriately.  When you click on the arrow to the left of your newly titled section it will neatly tuck all those slides away. Now you can view only the slides that you need to work with in a specific section.

Using OneNote with Outlook

Many of us diligently use our Outlook Calendars to keep up with our day to day tasks and meetings.  But did you know that you can use OneNote with your Outlook to sync your tasks and notes from meetings?

In the Home Tab in OneNote you will see the Outlook group. In the Outlook group if you click Meeting Details it will show your upcoming events from your Outlook Calendar.  Once you have selected one of your events, a section for you to take notes will open up that already has the title, date and time of your meeting with space to add attendees and notes.  Also, when you are in a meeting and it’s decided that there is a task that needs to be completed, you can use the Outlook Tasks option and the task you create is automatically inserted into your Outlook calendar without ever leaving your notes in OneNote. 

Using Building Blocks in Microsoft Word 2010

Many times in our daily work we use the same type of documents with the same wording.  For example, if you have to create an agenda for a weekly meeting you can use Building Blocks to save your formatting and wording, where you can easily insert this information to a new document.  Here is how to use this function.

• Create your document or text that you would like to use and highlight it
• Click the Insert Tab
• In the Text Group you will Click Quick Parts
• Next Click Save Selection to Quick Parts Gallery
• This will open up a pop up window where you can name your Building Block
• Now that your Building block is created, it is ready to be inserted to any document of your choice
• To insert your Building Block go back to the Insert Tab and Select Quick Parts
• But this time Click Building Blocks Organizer, Select your Building Block and Click Insert

By taking this little bit of time to save your Agenda, Cover page, Header, ect. as a Building Block, you have saved a lot more time since you will no longer have to continually re-create it.

iPad Tips and Tricks with: Christopher Breen- Lynda.com

In iPad Tips and Tricks, author Christopher Breen provides expert tips for getting the most out of the Apple iPad (first generation) and iPad 2, including gesturing, typing, and adding content, as well as troubleshooting common device issues. The course explains how to download and manage apps, configure email accounts, create presentations, and set up video conferences. The course also demonstrates both built-in and third-party solutions for opening and editing files, streaming video and audio wirelessly, and troubleshooting common device issues.

Remove Formatting in Microsoft Word 2010

Sometimes when creating a document we experiment with what formatting will look best.  But it can be frustrating to have to step by step remove that “bad” formatting until you get the desired look.  Well here is a neat trick that can save you some time, and quickly get you back to your default formatting.  Highlight the text that you would like to have the formatting removed and press CTRL+ SPACE.   Just like that you are back to your default formatting.

Security Question

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.