Category Archives: Outlook 2016

What You Need to Know About Administrative Hiring Trends

 

As time and technology both march forward, you need to be sure that both your soft skills* AND your software skills** are at a sought-after level by potential employers—that when employers review your capabilities and experience, they find both skill sets highly desirable!

In a recent article in which Brandi Britton, district president of OfficeTeam, was interviewed by Certiport, she emphasized certain trends that administrative professionals need to keep in mind both for current and future career prospects.

Overwhelmingly, managers are aware that administrative professionals are important to the success of the managers of these companies. Consequently, and as Britton summarized this point, she noted that, “Employers are looking for support staff who are adaptable and can help with projects beyond their traditional job descriptions.”

Administrative professionals must be able to demonstrate their ability to save their bosses time without compensating quality. The old adage “time is money, and money is time” has never been truer!

Administrative professionals also must demonstrate their ability to communicate effectively and professionally with internal and external groups. Highly-developed verbal and written communication skills are essential to progressing up the career ladder.

Britton also indicated that it is essential for administrative professionals who want to emphasize their proficiency with the most widely-used office productivity software—Word, Excel, PowerPoint, Outlook, Access—to demonstrate they are proficient by showing proof—by passing the Microsoft Office Specialist (MOS) exams and thus earning the accompanying certifications!

She also pointed out that job advancement as well as the possibility of salary increases are two good reasons to work towards the goal(s) of passing one or more of these MOS certification exams. They are your proof that you are indeed knowledgeable and proficient in the given software application(s).

Brandi Britton closes her Certiport interview by leaving readers with some great advice for administrative professionals who are looking for employment in today’s job market. You can click on this link and then scroll down to watch that video.

If you are interested in getting more information on how you can get your Microsoft Office skills to a proficient level; or if you want to know how you can get your MOS Certification in one or more MS software applications, let Richland College’s BOSS program help you get the answers to these and other questions.

Question 1: I use Word and Excel on a daily basis at work, but how can I determine if I already know enough about the software to just go ahead and take one of the MOS exams without having to take any classes or training?

Answer 1: Because Richland College is an authorized MOS testing center, you can contact us at 972-238-6215 for more information on purchasing a testing voucher and then scheduling and taking the specific MOS exam here at Richland.

It is, however, strongly suggested that you click on your chosen software application link below and then analyze whether you feel you are proficient in all of these objectives for the application AND that you can complete the scenario tasks in a timed situation.

These objectives are the official Microsoft objectives for which individuals are expected to demonstrate their proficiency when taking the timed MOS certification exams.

MOS Access 2016 Objectives

MOS Excel 2016 Objectives

MOS Outlook 2016 Objectives 

MOS PowerPoint 2016 Objectives

MOS Word 2016 Objectives

Question 2: How involved are the BOSS Microsoft Office classes?

Answer 2a: The software specific BOSS classes are designed to provide you with comprehensive knowledge and skills development in basic, intermediate, and some advanced software features. The software is learned via presentation, hands-on assignments, tests, and software simulation training/testing of the MOS testing environment.

Answer 2b: The BOSS program offers specific software classes that are dedicated to students learning the software applications at a proficient level and incorporating all of the official Microsoft objectives through textbook tutorials and assignments, hands-on tests, and simulated software that provides further reinforcement through training and timed testing.

Question 3: Are these classes offered in more than one format, and how many times a week must I come to Richland’s campus?

Answer 3: These are great questions; and, yes, there are three learning formats available to you, as well as a special option:

(A) If you feel you need to have an instructor present the material and explain certain concepts and features to you on a face-to-face basis, we offer these courses on an “on campus” basis. Typically, the on-campus courses meet twice a week. Some sections may be offered on a flex-term basis.

(B) If you feel comfortable taking the classes remotely (you still have full access to your instructor) and your work/personal schedule make it difficult for you to physically attend on campus, then online is the format you want. The online sections include the same content, and you have electronic access to your instructor to answer questions that you may have about features, content, etc. You don’t have to come to campus.  Some sections may be offered on a flex-term basis.

(C) If time or transportation to campus is a big issue for you, but you still feel you need to interact face-to-face with your instructor, you might want to consider the hybrid format. You meet once a week on campus for the presentation of material, and your assignments are submitted electronically.

(D) Special Option: If, at any time, during the course you feel confident enough to take the MOS exam early and you do indeed pass the exam, you will receive an automatic B in the class without having to complete any remaining assignments, tests, etc. This option rewards you with earning college credit AND MOS certification early!

Question 4: If I decide to take more than one of these BOSS software classes, can I apply these credits towards some type of certificate?

Answer 4: Absolutely, there are three academic entry points that may interest you: the BOSS program’s (1) Software Application Specialist certificate, (2) Administrative Specialist certificate, or (3) Executive Assistant associate degree.

Question 5: I’m not sure I have the most up-to-date version of Microsoft Office on my home computer. Will I need to purchase the latest version?

Question 5: If you are already a student (or planning to become a student) at any of the Dallas County Community College District’s colleges (Richland is one of the seven colleges), then you will be able to download the latest version of Office 365 for free! Office 365 includes the software applications listed above and as well as others (such as OneNote, Skype, and Publisher).

In conclusion, let Richland’s BOSS program help you to maximize your potential in terms of your soft skills, your software skills, and your future career goals–enhance/acquire these skills at an affordable price!

You can get more details by visiting our website at https://www.richlandcollege.edu/boss

Richland College, which is located in northeast Dallas at 12800 Abrams Road, offers online, on‑campus, and hybrid courses in flex-term and full semester formats. For more information email RichlandBOSS@dcccd.edu or call 972‑238-6215.

**Richland College is an authorized Microsoft Testing Center.

*Soft skills have been defined as those behaviors and qualities that lead to satisfactory or above-satisfactory interaction with others such as communication (listening, writing, speaking), collaboration and teamwork, critical and creative thinking, leadership, self-management and initiative, social responsibility, etc.

** Software skills demonstrate an individual’s knowledge of and proficiency in computer technology software. Proficiency with such technology greatly assists with the management and successful completion of office tasks and managing data effectively and efficiently on a time and output basis.


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.

 


Handy Tips for Linking Outlook and OneNote 2016 Together That Can Make Your Meetings More Efficient!

Do your responsibilities include planning meetings for yourself with (or for) others?

Let Microsoft’s Outlook and OneNote help you to plan these meetings, to develop agenda items, to assign tasks, and to stay in contact with key people all along the way.  

Tip 1: Create Agenda Items in OneNote.

While you are in OneNote, you can develop your agenda items from background materials and supporting information. OneNote is great for storing (and importing) detailed information from other sources such as the Internet, Word files, Excel files, PowerPoint, etc., as you continue to plan and develop the content for your meeting. If you need to share and get input from others, the OneNote Share feature comes in very handy during the preparation phase. You also have the option of emailing a OneNote page to a colleague.

Tip 2: Create Group(s) with Attendees in Outlook

If you meet with a group of individuals on a regular basis, you will want to create a group in Outlook that includes these individuals so your emails go out to them on a group basis. You can also easily keep track of who will be attending the meeting

Tip 3: Manage Your Calendar in Outlook

You can show others your availability for upcoming meetings and specify the range of dates and your availability type—busy, free, tentative, etc. The image on the left shows several options for viewing this information and whether you want to include details. Depending on you and your groups needs and wishes, you can also create group calendars that can be shared and emailed so that everyone is informed.

Tip 4: Take Meeting Notes in OneNote

Once your meeting begins and minutes need to be taken, you have two great OneNote options—if you have a laptop (or tablet) that supports handwriting conversion, you may want to use the Draw feature to write down the key points from the meeting. However, if your tablet doesn’t support “inking”—Ink to Text, you can still use your tablet to write down your minutes and then use a Windows PC with OneNote to convert the handwriting to text.

And you have yet another option, which is to record the minutes using the Audio feature (also includes a Video feature) in OneNote and is available on laptops. If you choose this option to capture your minutes, be sure you have a compatible microphone (and/or camera) for your laptop. Note: The OneNote app for tablets (iPad and Android) also allows you to record audio and video.

Tip 5: Follow Up on To Dos and Tasks in Outlook and OneNote

After most meetings, there is typically some follow up to be handled or task assignments made to various individuals. Use Outlook to assign specific tasks to individuals and review the progress on task completion. If you created your task assignments in Outlook, you can easily put this information in OneNote and vice versa. However, the one drawback, at this point in OneNote, is that note tags created in OneNote don’t show up in Outlook—though I’m sure Microsoft must be working on getting this feature off “the wish list” and granted!

If you want to learn how to increase your productivity and efficiency, consider taking an online course on Outlook and/or OneNote in the Business Office Systems & Support program (BOSS) at Richland College. The Outlook 2016 course is 7½ weeks (listed as POFI 1104-83438). This course also includes preparation to take the MOS certification exam for Outlook 2016. The OneNote 2016 course (POFI 1104‑83448) is also being offered online for 7 ½ weeks. Click this link for more details on dates for both courses.

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 and can be used on up to 5 devices.