Category Archives: Microsoft Office 2013

5 Reasons to use Microsoft Publisher
  1. Affordable

Publisher is significantly cheaper than other desktop publishing programs.  In fact, it is bundled (or included) in many versions of Microsoft Office and Office 365 so you might already have it available on your computer.

  1. User Friendly

Publisher is very user friendly.  Since it is part of the Microsoft products, many of the commands are the same as in Microsoft Word.

  1. Templates

Microsoft Publisher comes with a large assortment of templates to help you create document.   These include flyers, posters, business cards, newsletters, banners, tickets, cards, and labels to name a few.

  1. Mail Merge

Publisher lets you use mail merge or email merge so you can customize publications to specific clients or information.  This provides a “personal touch” to your documents.  You can add merge to documents, emails, labels, or as a graphic overlay.

  1. End Product

You can save the file as a publisher file, a PDF file, a HTML file, a Word file, or a graphic file (JPEG, TIF, PNG or GIF).

  1. High Quality End Products

You can print the documents you create on your personal printer as an RGB color publication. There is also a wide variety of specialty papers you can purchase to print special document.  For example, there is special perforated, heavy stock paper you can purchase for business cards.    The documents created in publisher can also be exported to a file that is ready to be taken to a commercial printer.  Just make sure you are aware of any requirements the printer has before you create the document.

If you are interesting in learning more about a Publisher class or the Richland College Business Office Systems Program, send us an email at RichlandBOSS@dcccd.edu.


Creative Gift Giving

Do you have someone on your holiday list that is hard to buy for or someone who seems to have everything? Looking for a one of a kind gift? Microsoft Office has the answer. Create custom calendars to give as gifts. Calendar templates are available in every program. Word has 39 templates, Excel has 45 templates, PowerPoint has 11, Publisher has 19, and Access has 2. Each program has a variety of layouts, sizes and color schemes. Customize the calendar with personal photos and meaningful dates. Print the calendars on cardstock and staple (either at the top or in the middle so it can be folded). For a small fee you can get the calendar professionally printed and bound at a local office supply store.

To create a calendar, click, on File, New, type in Calendar in the Search for Online Templates box, and choose your favorite template.

Enjoy!


Why You Should Learn Excel!

Click on the YouTube video below to listen to the song that was created by University of Texas Professor Clint Tuttle and get an entertaining, enlightening serenade on why you should learn Microsoft Excel.

According to a 2015 U.S. News & World Report article, “If you want a better job, master Excel.”

Middle-skill Jobs—those jobs that require more than a high school diploma, but less than a bachelor’s degree—are considered the jobs that have long been associated with middle income wage earners. For example, jobs such as office and administrative assistants as well as managerial positions in industry, communications, retail, healthcare, and other major sectors want their employees to be proficient in spreadsheets—Excel.

In fact the demand for digital proficiency for these middle-skill jobs has only grown over time and will continue to grow. You can read more about these jobs by clicking this link to read the 2015 report (PDF file) prepared by Capital One Financial Corporation and Burning Glass Technologies.

Meanwhile, sit back and enjoy Professor Tuttle’s musical message—it’s the truth, folks!

GET DIGITALLY PREPARED TODAY by taking an Excel class or other Microsoft Office productivity software classes—Word, PowerPoint, Access, and Publisher—through Richland College’s BOSS Program. The Microsoft Office 2016 version and Windows 10 will be offered this coming fall!

**Richland College is an authorized Microsoft Testing Center for the Microsoft Office Specialist certification exams.

DYK–if you take a DCCCD class, you are eligible for a free download of the latest Microsoft Office 365 version? You can use your MS Office software on up to 5 devices!

Richland College is located in northeast Dallas at 12800 Abrams Road. For more information on BOSS class offerings, please call 972-238-6215 or email Angela Nino at anino@dcccd.edu.


Calculations Quickly!

Here’s a quick but very useful Excel tip.  It is especially helpful when performing calculations on lengthy columns. 

Excel Tip

Give this tip a try to see if you like this method better than dragging the fill handle down, which is the method used by many who work with Excel daily.  It is easy and very fast!


For more information on the Business Office Systems and Support department, contact Angela Nino, Lead Faculty, anino@dcccd.edu, 972-238-6382.

 


Let MS Office 2013 Custom Apps Help You Increase Your Productivity!

 

timing concept

Did you know there is much more you can do to enhance your experiences with the Microsoft Office 2013 Suite than what is already included in Word? Excel? PowerPoint? or Outlook? While the applications within the Suite are literally crammed with tons of powerful features, there additional ways (through add-ins) that you can customize your specific office needs even further, which can save you time and effort. These apps range from

  1. Converting PDF files to text (recognizes text in six different languages).
  2. Generating a tag cloud of text from a Word document.
  3. Sending fax documents without leaving Word.
  4. Searching the web via Google within Word, Excel, or PowerPoint—no need to toggle back and forth between your Office applications and your web browser.
  5. Creating a graphical idea map from any of the Office applications.
  6. Converting the case of your text in Excel files quickly—This can be a life saver if you are importing information into Excel from a variety of sources because it saves you time and energy by not having to make “hand edits” that are slow and manual.
  7. Creating Excel data as a “heat map” – provides a visual of data for the United States and is color coded.
  8. Previewing hyperlinks from Outlook email messages—helps to prevent messages sent that contain broken links.
  9. Integrating key information from LinkedIn from your profile with Outlook—can help with your networking capabilities.
  10. Sending Direct Messages from Outlook to Twitter.

Vangie Beal previewed a total of 30 MS Office apps that can help you increase your productivity and efficiency, but there are many others that have been added that may fit your needs also.

Many of the apps are free, while others may have a one-time charge or a subscription fee. If you see any that can help you, simply click this link to go to store.office.com and then “shop until you drop”!

P.S. I just found another app (for Excel) that can be very engaging when you are trying to transform data to a simple graphic quickly and easily. It’s free, it’s easy, and the name is Bubbles—try it, you might like it!

Take a look at the sample screen shot below.

06-29-2015 Bubbles App

If you want to learn new software or if you need to update your software skills, consider enrolling in the Business Office Systems & Support program at Richland College. You will have a wide selection of courses (offered online and face-to-face) from which to choose. These courses range from basic keyboarding, computer literacy, business communications, Word, Excel, PowerPoint, Access (includes preparation for the Microsoft Office Specialist certification exam**), office procedures, etc. These courses can all lead you towards a college-credit certificate or a 2-year associate’s degree.

Richland College is located in northeast Dallas at 12800 Abrams Road. For more information contact Becky Jones, Associate Dean, bjones@dcccd.edu at 972-238-6215.

**Richland College is an authorized Microsoft Testing Center.

***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.

 


How to Insert Checkboxes in an Excel 2013 Spreadsheet

Follow the link below to learn how to insert checkboxes on an Excel spreadsheet.  In the article, Bilal Ibrar discusses how to insert checkboxes and shares several examples of how you might use these checkboxes when designing an Excel spreadsheet.

The post is located on a blog called Write A Writing.  Please click the link on Write A Writing to learn more about using this Excel feature.

This is not a task that you will use on a daily basis in Excel; however, it may come in handy one of these days!

_________________________________________________________________________________________________

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


Do Your Administrative Professional Skills/Talents REALLY Measure Up to What Today’s Employers Want?

04-13-2015 Talent 188065235Talents, skills, talents, skills—these words are thrown around a lot today by employers and job seekers alike. And yet, what do these words really mean to people who want to get or upgrade their job marketability so they can be as attractive as possible to potential employers? What can you do to maximize your administrative skills/talents so that your earning potential is increased?

If anyone out there thought that careers in the administrative professional area were disappearing or boring, they need to read the latest reports to see how admin careers and roles are expanding and changing.

According to the 2015 salary guide for administrative professionals that was prepared by the Robert Half Company, 1.5 million new administrative professional jobs will be added between 2012 and 2022. Today’s administrative professionals will share a bigger role in company communications with customers and customer relations, and their salaries will be increasing.

Question: What does the changing role of administrative professionals mean if you are interested in the administrative professional field?

  • Answer: It means you need to have top-flight written and verbal communication skills—if you are bilingual, that could be a big plus.
  • It means you need to demonstrate to employers that you are flexible and willing to learn new tasks. Your related work experience is also a valued commodity.
  • It means you need to display professional behavior and keep abreast of trends by joining at least one professional organization.
  • It means you need to learn all you can about social media tools and how to use these tools in business settings. Some of the most widely used SM tools that are used by companies today include LinkedIn, Facebook, Pinterest, Twitter, Google+, and Instagram. It means you will need to show potential employers that you have excellent problem-solving abilities.
  • It means your technical skills need to be proficient, and in some cases advanced, in software applications such as Excel, Word, PowerPoint, Outlook. You can prove your software proficiency to employers by passing one or more of the Microsoft Office Specialist certification exams. These exams are available in Word (Core and Expert), Excel (Core and Expert), PowerPoint, Access, and Outlook.

04-13-2015 Career Ladder 81387343Question: What are some of the job titles for administrative professionals?

  • Answer: There are a large number of job titles in the administrative professional area; and while some of the traditional titles include Executive Assistant, Senior Office/Facilities Manager, Receptionist, there are new titles coming on the scene. These new job titles have been created by some companies to reflect the new duties many find admin personnel find themselves performing. According to Robert Hosking, who writes a blog for administrative professionals and employers, these new titles include Chief Executive Administrator, Administrative Services Manager, Director of Administration, and Administrative Chief of Staff.

Question: What are some salary ranges for administrative professionals and related jobs?

  • Answer: The table below, which was taken from data reported in the Robert Half Company survey, Administrative Hiring Trends Salary Guide 2015 reflects a “snapshot” for just a few of the titles reported and the salary gains from 2014 to 2015. For a more complete look at administrative salaries, click this link to visit the Robert Half Company web site and download the PDF 2015 salary guide (begins on page 10) for Administrative Professionals.

04-13-2015 Salary TableIf you want to upgrade or develop skills that can help you in today’s job market, consider enrolling in the Business Office Systems & Support program at Richland College. You will have a wide selection of courses (offered online and face-to-face) from which to choose.

These courses range from basic keyboarding, computer literacy, business communications, Word, Excel, PowerPoint, Access (includes preparation for the Microsoft Office Specialist certification exam**), office procedures, etc. These courses can all lead you towards a college-credit certificate or a 2-year associate’s degree.
**Richland College is an authorized Microsoft Testing Center.

Richland College is located in northeast Dallas at 12800 Abrams Road. For more information contact Becky Jones, Associate Dean, bjones@dcccd.edu at 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.

 

 


QUICKLY Rearrange Paragraphs in Word

SWord 2013witching the order of paragraphs in a Microsoft Office Word document can be a frustrating task.  If you cut and paste the paragraph, you often have to add or remove space before or after the paragraph to make certain that the spacing is correct.

Instead of cutting and pasting, try using the SHIFT + ALT keyboard shortcut method.  The task is easy using this method.  Follow these steps:

  1. Click anywhere in the paragraph you wish to move
  2. Hold down SHIFT + ALT
  3. Move the paragraph up or down using the up/down arrow keys
  4. Each press of an arrow key causes the paragraph to “jump above or below” one adjacent paragraph

If you are unfamiliar with the SHIFT + ALT method, try it!  You will find this method both quick and easy to use, and your document will be complete with all paragraphs in the correct order in no time.  It is another little known perk of Microsoft Office Word.


Five Easy Word Tips Every User Should Know

We all have our favorite Microsoft Word tips and shortcuts! My favorite shortcut is that pressing the F12 key opens the Word Save As dialog box.

In this article, Susan Harkins shares five easy-to-implement tips that will simplify your Microsoft Word tasks. Another of my favorites, which she discusses in her first tip, explains how to quickly select a sentence. This tip is especially handy when the sentence begins and ends in the middle of a line.

Please click the link below to read all of the tips from Susan on the Tech Republic Web site; save time and have fun using your newly acquired knowledge!

5 Easy Word Tips by Susan Harkins

____________________________________________________________________________________________________

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


Using the Data Validation Feature in Excel  

Have you ever wished for a way to limit the data in an Excel cell to match certain parameters?  If so, the Data Validation feature located under the Data tab in the Data Tools group is for you!  It is a feature that is simple to use and offers several options.

Let’s say that the name of your column in Excel is Paid and the correct response in the cells of this column is either Yes or No.  To limit the values for this column to either Yes or No, do the following:

Select the cells you wish to limit to a value of either Yes or No.  Click the DATA tab; in the Data Tools Group click the Data Validation button.  The dialog box shown below will open.  Click the down arrow in the Allow text box and choose List.  Click in the Source box and type Yes, No as shown below.  This will limit the data input for the selected cells to accepting only Yes or No in the cell.

Validation Yes No box

The cells to which the validation is applied will also have a drop down arrow allowing the user to select either Yes or No from the drop down list when the cell is selected.

If you click the Input Message tab, you may enter a short message telling the user the values that may be entered in the selected cell.  When one of the restricted cells is selected, the message you see at left will appear.

Validation Message

Could it be any easier?

______________________________________________________________________

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