Category Archives: Microsoft Office Specialist Certification exam

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.


Want to “Spice Up” Your Resume?

Are you about to enter the job market?  What credentials do you have on your resume that might catch a potential employer’s eye?

Many individuals looking for employment are learning that computer skills are very important and often required.  How is it possible to display on your resume that you are proficient in using application programs such and Microsoft Word and Microsoft Excel.

Let’s take a look at the Microsoft Office Specialist Certification program.  This program offers exams in the most current version of Office (2016) as well as the two previous versions, Office 2013 and Office 2010.

Microsoft Office 2016 Specialist Certifications are offered in the following categories:

  • Microsoft Word 2016
  • Microsoft Excel 2016
  • Microsoft PowerPoint 2016
  • Microsoft Access 2016
  • Microsoft Outlook 2016
  • Microsoft Word 2016 Expert
  • Microsoft Excel 2016 Expert

All Microsoft Office Specialist (MOS) certification exams are timed and require a comprehensive knowledge of the features provided by the software.  Click on the following link to download the exam objectives for one or all of these exams.  These objectives provide a list of tasks you could be asked to perform when taking the exam and serve as a guide to assess your current skill level and prepare to take one of the exams. You may need to scroll down to see the objectives.

Microsoft Office Specialist 2016 Exam Objectives

Here is a partial sample (not in order) of the Excel 2016 Exam Objectives:

Creating and Manage Worksheets and Workbooks

  • Create a workbook
  • Import data from a delimited text file
  • Add a worksheet to an existing workbook
  • Copy and move a worksheet

Navigate in Worksheets and Workbooks

  • Search for data within a workbook
  • Navigate to a named cell, range, or workbook element
  • Insert and remove hyperlinks

Format Worksheets and Workbooks

  • Change worksheet tab color
  • Rename a worksheet
  • Change worksheet order
  • Modify page setup
  • Insert and delete columns and rows
  • Change workbook themes
  • Adjust row height and column width
  • insert headers and footers

Perform Conditional Operations by using Functions

  • Perform logical operations by using the IF function
  • Perform logical operations by using the SUMIF function
  • Perform logical operations by using the AVERAGEIF function
  • Perform logical operations by using the COUNTIF function

Format and Modify Text by using Functions

  • Format text by using RIGHT, LEFT, and MID functions
  • Format text by using UPPER, LOWER, and PROPER functions
  • Format text by using the CONCATENATE function

Richland College is a Certified Microsoft Testing Center.  The Business Office Systems and Support department offers courses both in the classroom and online in Office 2016 applications (Word, Excel, PowerPoint, Outlook, and Access). These courses are designed to prepare students to attempt with confidence the Microsoft Office Specialist certification exam for the course in which they are enrolled.

If you are thinking of going back to work, changing careers, or entering the job market for the first time, MOS certifications are excellent credentials to add to your resume. Employers know that certification guarantees knowledge without further training and often look for these credentials on a candidate’s resume.

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

 


Wanted: Top-Flight Administrative Professionals Who Want to Grow with Their Companies!

499171549_aYes, today’s employers understand that not only are talented, highly-skilled administrative professionals assets to their companies but that they are also essential to the competitive success of these companies!

Over the years, the role of the administrative professional has changed dramatically, and the future shows that people who work in this capacity will continue to see changes in terms of duties and expectations.

In a 2015 joint research project conducted by Office Team and IAAP (International Association of Administrative Professionals), it was found that the skills most valued by employers and needed by administrative professionals include the following:

Time Management

The ability to maximize tasks effectively and efficiently is highly valued and desired. In fact, top-flight professionals are not only expected to manage their own tasks and time but also to manage the schedules of those whom they support—this may include team members, managing supervisors, and executives. Multi-tasking takes on a whole new meaning, but it goes with the turf for those who are truly successful in the art of task/time management.

Technical Skills

595140878_cBeing highly competent in Word, Excel, and PowerPoint—having your MOS certification in one or more of these applications—will go a long way in convincing a potential employer of your productivity capabilities.

Knowledgeable in layout and design—Microsoft Publisher for basic design (for more advanced projects, consider Adobe InDesign or Photoshop) can assist you in making your output look professional.

Collaboration and knowledge of databases—collaboration packages such as SharePoint are highly valued by companies as a way of housing company content and sharing this information within and among work groups. Other packages that are used by work groups for sharing (and by individuals) on projects include OneNote and Evernote. Your ability to work with databases such as Access and FileMaker Pro can only add to your attractiveness.

Social Media

Managers have increasingly turned to their admins in order to stay up-to-date on company social media interaction with customers, clients, and others. Knowing how to use social media professionally is now expected. Be sure you have a professional acquaintance with sites such as Facebook, Twitter, LinkedIn, Pinterest, and Instagram; and know their role and how to use them as business tools.

 

170463151_eFinally, and according to Matt Krumrie, those skills that have become known as “soft skills” and that include excellent communication skills (written and verbal), outstanding tact and diplomacy when working with others, and strong critical-thinking skills are indispensable. These soft skills “round out” what goes in to becoming and staying a top-flight administrative office professional!

 

 

If you want to develop or upgrade your skills to 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, administrative office procedures, business communications, Word, Excel, PowerPoint, Outlook, OneNote, Access (includes preparation for the Microsoft Office Specialist certification exam**) etc. These courses can all lead you towards a college-credit certificate or a 2-year associate’s degree.

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

**Richland College is an authorized Microsoft Testing Center.

***Get a Free Copy of Microsoft Office 365***If you are a student in the Dallas County Community College District, you are eligible to download a FREE version of Microsoft Office 365, which includes Word, Excel, PowerPoint, Access, Outlook, Publisher, and OneNote, which can be used on up to 5 devices.
Sources:
1.  Krumrie, Matt (2016, July 7) What to Look For In A Great Administrative Assistant. Retrieved from  https://www.ziprecruiter.com/blog/what-to-look-for-in-a-great-administrative-assistant/
2.  Office Team (A Robert Half Company) and IAAP (2015) How to Hire All-Star Administrative Professionals and Maximize Their Potential. Retrieved from https://www.roberthalf.com/officeteam/office-of-the-future-how-to-hire-all-star-administrative-professionals-and-maximize-their-potential

 


Congratulations to Professor Dee Hobson!

small-dee-hobson-image-with-frameCongratulations to Professor Dee Hobson on being selected as Richland College’s 2016-2017 Excellence in Teaching recipient!

“Dee,” as she is known to colleagues and to many of her students, is a full-time BOSS faculty member in Richland’s BOSS program, where she has taught for the past 17 years. Dee holds a Bachelor’s Degree in Business Teacher Education from Southern Illinois University and a Master’s Degree in Business Education from Memphis State University.

Dee brings a tremendous wealth of experience and knowledge to students who are enrolled her BOSS classes in many important ways, because she has

  • taught at private and public education institutions (both at the secondary and community college levels).
  • provided corporate training to a number of companies in the DFW area.
  • designed curriculum for public and private institutions.
  • created staff development programs and activities for several local DFW ISDs.
  • supervised and managed corporate personnel both in the United States and abroad.
  • served on the board of directors of the Dallas County affiliate of The Susan G. Komen Breast Cancer Foundation. She also received that organization’s Volunteer of the Year Award.
  • received Microsoft Office Specialist (MOS) software certifications over the years in the key Microsoft software applications–Word, Access, Excel, PowerPoint.

We are proud to call Dee one of our own, and we are thrilled that her on-going contributions to helping students succeed have received such laudatory recognition!

If you want to develop or upgrade your skills to help you in today’s job market, consider enrolling in the Business Office Systems & Support (BOSS) 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, please contact Angela Nino at anino@dcccd.edu or call 972-238-6215.

**Richland College is an authorized Microsoft Testing Center.

***Get a Free Copy of Microsoft Office***If you are a student in the Dallas County Community College District, you are eligible to download a FREE version of Microsoft Office, which includes Word, Excel, PowerPoint, Access, Outlook, Publisher, and OneNote, which can be used on up to 5 devices.


Introducing Excel 2016’s New IFS Function!

Have you ever needed to establish categories or summary ranges for numerical information?

Let’s say you have the feedback from a seminar that was held earlier this year, and you’ve chosen the categories of Excellent, Satisfactory, Needs Improvement, and Unsatisfactory to help determine what items need improvement or attention as you plan future seminars.

In our example, the results have to have a rating of 87 or above to be considered Excellent, 86 to 75 to be Satisfactory, and 74 to 70 for the Needs Improvement category. A score of 69 and below is considered Unsatisfactory.

08-29-2016_dYou can use the new IFS Function in Excel 2016 to help you quickly obtain your information. In fact the Excel 2016 IFS function can help obtain the conditions on 127 different conditions!!  In our example, you can see the categories and scores for these items, but how can we quickly determine what needs improvement, is satisfactory, etc.?
Just one word of caution
–if you open a file containing the IFS function in an older Excel version, the error message #NAME? will appear.

The two screen shots below allow you to see the conditions and the criteria for this function that must be met for each category. We simply create the IFS function for the first item and include conditions and what will appear for each score. In this case Cell C3 is where the IFS function will appear for the conditions in Cell B3.

 08-29-2016_a08-29-2016_bOnce all of your conditions are stated in Cell C3, you can then copy the function in to Cells C4, C5, C6, C7, C8, and C9 and presto! You have your work completed! The finished results appear below:

08-29-2016_cKeep learning how to use Excel more efficiently so that you work smarter,
not harder!!!

If you want to develop or upgrade your skills to 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 located in northeast Dallas at 12800 Abrams Road. For more information, please contact Angela Nino at anino@dcccd.edu or call 972-238-6215.

**Richland College is an authorized Microsoft Testing Center.

***Get a Free Copy of Microsoft Office***If you are a student in the Dallas County Community College District, you are eligible to download a FREE version of Microsoft Office, which includes Word, Excel, PowerPoint, Access, Outlook, Publisher, and OneNote, which can be used on up to 5 devices.