Category Archives: Microsoft Office 2013

Winter Holiday Templates

184406076 (640x640)If you are like me, you really enjoy the winter holidays. There are so many different activities to enjoy! With each activity usually comes an invitation, a sign, and even thank you cards. If you share a special holiday food with someone you may need recipe cards. To help with all of these things, you can use Microsoft Word’s great templates. Here are a few below:

Gift List

Winter Snowman Invitation

Holiday Party Invitation

1/2 page Party Invitation with Poinsettas

Family Holiday Newsletter

Winter Event Flyer

Holiday Gift labels

Elegant Event Menu

Holiday Place Cards

Poinsetta Thank You card

Enjoy your winter holidays!!

___________________________________________________________________________________________________
For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, bjones@dcccd.edu 972-238-6215.


Thanksgiving Word Templates

187954920 (640x425)Are you planning your Thanksgiving dinner or event? If so, you can use Microsoft Word templates to help you create all the necessary documents. Templates are very easy to use. You just type your text into the placeholders. You can use the images included on them, or you can delete the images and add your own. Some templates can be printed and written on, if you prefer to do so.

Here are links to several of the files that can make your preparations much easier. Just right-click on each one and save the file to your computer:

Party Invitation

Fall Celebration sign

Place Card

Menu

Recipe Card

Thank You Card

Enjoy creating all of the items for your special celebration or event!

___________________________________________________________________________________________________
For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, bjones@dcccd.edu 972-238-6215.


Excel Formula Problems? Try These Troubleshooting Tips!

Ribbon with FBWhen you work with formulas in Microsoft Excel, there are sometimes some glitches. Excel is good about letting you know when there is an error and even offering some help. The Error Checking feature on the Formulas tab in the Formula Auditing Group will find errors such as Divide by zero errors or errors in cell references (#VALUE!) where a cell referenced in the formula does not contain a number.

Also in the Formula Auditing group are the Trace Precedents, Trace Dependents, and Remove Arrows buttons. The Trace Precedents button shows arrows that indicate which cells affect the value of the currently selected cell. The Trace Dependents button show arrows that indicate which cells are affected by the value of the currently selected cell. The Remove Arrows button removes the arrows drawn by the Trace Precedents and Trace Dependent buttons. These buttons are very helpful when determining incorrect cell references in formulas.

However, with especially long formulas, it is sometimes necessary to examine small parts of the formula at a time to figure out the problem. You may use your mouse pointer to look at only a certain part of a formula and press F9 to evaluate just that section. Press Esc to go back and keep searching. The Evaluate Formula button on the Formula Auditing group will also allow you to examine small parts of a long formula.

Another common problem in Excel formulas is a circular reference. A circular reference in an Excel formula is one that depends on its own value. The most common type of circular reference occurs when you mistakenly refer in the formula to the cell in which you are building the formula itself. For example, suppose that cell B10 is active when you build this formula,  =A10+B10.   As soon as you enter this formula in cell B10 (assuming the program is in Automatic recalculation mode), Excel displays an Alert dialog box, stating that it cannot calculate the formula due to the circular reference.

Do not forget, too, that by clicking the down arrow at the right end of the formula bar you can expand the size of the formula bar to include more than one line. Use these tips to become an expert in troubleshooting Excel formula problems—something that we all encounter when using Excel’s powerful calculation features!

____________________________________________________________________________________________________
For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, bjones@dcccd.edu 972-238-6215.

Did Your Ribbon Disappear?

One of the new features introduced in Office 2007 was the Ribbon interface.  The Ribbon is still a vital part of Office 2010 and the newest version, Office 2013.

Some users become very frustrated because suddenly as they are hurriedly completing a task the buttons on the Ribbon are no longer visible and all that can be seen are the tabs across the top of the Ribbon, for example in Microsoft Word 2013, Home, Insert, Design, Page Layout, References, Mailings, Review,  and View.  You might call this the “mystery of the missing buttons,” which can be most annoying to the user.

Ribbon

Ribbon with Only Tabs Displayed

The cause of the problem and its solution are, however, very simple.  We have all become very accustomed to double clicking the left mouse button to issue a command.  However, if you double click a tab on the Ribbon, it hides the buttons on the Ribbon.  How do you get those buttons to reappear?  Simply double click any tab again, and, magically, everything is back as it should be!

_________________________________________________________________________________________________

For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, bjones@dcccd.edu 972-238-6215.


9+ Reasons Why OneNote 2013 Can Help You Become More Successful!

08-11-2014 OneNote LogoTake a “working tip” from Richland College’s POFT 1309 Administrative Office Procedures course on how to increase your productivity and efficiency at the office.

Like so many other things these days, projects at work seem to have many moving parts—some parts need your attention right away, and other tasks come later but are equally as important.

Use the tag feature in OneNote 2013 to help you keep your priorities and tasks in order and to help make sure your project is completed successfully.

OneNote 2013 (the desktop version) comes equipped with a wealth of tags that can make creating notes and tasks, inserting images, locating important web sites, gathering contact information, etc., easy to organize, track, and search as you progress through your project.

There are nine handy OneNote tags described below; however, there are a number of other OneNote tags that can help you with your work load as well. You can also create custom tags for even more specialization.

08-11-2014 One Note Complete

Use OneNote tags to help you plan, organize, and complete those multiple tasks that are so important to the successful completion of your work projects!

If you want to improve your office productivity skills, consider taking one or more courses in the BOSS program at Richland College. Richland College, which is located in northeast Dallas at 12800 Abrams Road, offers both online and on-campus courses. For more information contact Becky Jones, Associate Dean, bjones@dcccd.edu 972-238-6215.

***Get a Free Copy of Microsoft Office Pro Plus 2013***If you are a student in the Dallas County Community College District, you are eligible to download a free version of Microsoft Office 2013 Pro Plus (or 2011 on the Mac) which includes Word, Excel, PowerPoint, Access, Outlook, Publisher, and OneNote.


Microsoft Certification

bossMicrosoftOfficeSpecialistDo you have a job that uses Microsoft Word, Excel, Outlook, or PowerPoint? Have you been job hunting and continue to run across Word, PowerPoint and Excel on job descriptions?

Becoming Microsoft certified in Word, Excel, Access, Outlook or PowerPoint could improve your resume. You might want to think about adding one (or several) Microsoft Office Specialist certificates to your list of accomplishments.

We might think we know Microsoft Excel or Word, even at an advanced level. Have you ever started a job or project and realized that you don’t know the software like you need to?

Why not back up your skills with a world recognized certificate from Microsoft. Just studying and preparing for the exam can help you learn more about the software.

If you are interested in taking one of the certification exams, start at the Certiport website. (http://www.certiport.com) They administer the Microsoft exams. Richland College is a certified testing center. We have classes that can help you prepare. Give us a call: 972-238-6215!

Richland College, which is located in northeast Dallas at 12800 Abrams Road, offers both online and on-campus courses. For more information contact Becky Jones, Associate Dean, bjones@dcccd.edu 972-238-6215.

***Get a Free Copy of Microsoft Office Pro Plus 2013***If you are a student in the Dallas County Community College District, you are eligible to download a free version of Microsoft Office 2013 Pro Plus (or 2011 on the Mac) which includes Word, Excel, PowerPoint, Access, Outlook, Publisher, and OneNote.


The VLOOKUP Function (A Mystery to Many Excel Users)

by Meggen Mills

The VLOOKUP Function is one of the most useful functions in Excel.  It is also one of the most confusing and least understood functions.  This article describes the formula syntax and usage of the VLOOKUP function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

Description

You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range.

Example:

You are a new employee in the Benefits department of a large company with over 2500 employees.

Suppose your department has just sent a notice to selected company employees (approximately 750 employees) notifying them that they still have  vacation days available this year, and your boss has asked you to determine the department these selected employees work in. The only problem is that the notice you sent did not ask for their department; you only know their Name and Employee ID number. Continue reading


Make Your Business Charts More Effective!

06-30-2014 Effective Charts Thinkstock Photos 164540686Take a “working” tip from Richland College’s POFT 2312 Business Correspondence & Communication course:

Tip: Understand that the use of charts in today’s communications is accepted, and actually expected, as a way of getting your readers to understand your message faster and easier.

So what can you do to make your charts more effective?—in essence how can you make your charts “do the talking?”

Consider these six key points when creating business charts:

Effective Business Charts

If you want to improve your written communication skills, consider taking POFT 2312 Business Correspondence & Communication, which a course in the BOSS program at Richland College. For more information contact Becky Jones, Associate Dean,  bjones@dcccd.edu 972-238-6215.

***Get a Free Copy of Microsoft Office Pro Plus 2013***If you are a student in the Dallas County Community College District, you are eligible to download a free version of Microsoft Office 2013 Pro Plus (or 2011 on the Mac) which includes Word, Excel, PowerPoint, Access, Outlook, Publisher, and OneNote.

Sources:

Bovee, John V. Thill and Courtland L. Excellence in Business Communication. 11th. Boston: Pearson, 2015.

HubSpot. Data Visualization 101: How to Design Charts and Graphs. 2014. Document. 21 June 2014. <http://offers.hubspot.com/data-visualization-guide>.

Visage. A Business Guide to Visual Communication. 2014. Document. 21 June 2014. <http://visage.co>.

[contact-form][contact-field label=’Name’ type=’name’ required=’1’/][contact-field label=’Email’ type=’email’ required=’1’/][contact-field label=’Website’ type=’url’/][contact-field label=’Comment’ type=’textarea’ required=’1’/][/contact-form]

 


Work Smarter with Excel Shortcuts

flikr-work-smarterWe all want to find a way to work more efficiently. For me, that involves knowing some ways to shorten my tasks in Excel, since I seem to use that frequently. Here are a couple of keyboard shortcuts that help me out.

The first is using the F9 key with formulas. When creating the formula, you can hit the F9 key and the formula will display actual values instead of the cell references. For example, type numbers in a few cells and use the Sum function button to create a simple Sum formula. Press the F9 key and you will see the actual values it is using in the formula instead of the cell references.

The second shortcut involves formulas, too. When I am debugging a worksheet, I sometimes want to highlight the cells that are referenced in a formula. To do this, I click on the cell with the formula and press Ctrl-[ (that’s Ctrl-open-square-bracket key just to the right of the P key). Excel highlights all the cells referenced by the formula, and moves to the first of the referenced cells.

_______________________________________________________________________________________________________

For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, bjones@dcccd.edu, 972-238-6215.