Category Archives: Word 2016
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.
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.
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.
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.
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.
As a student at any of the DCCCD campus locations (Brookhaven, Cedar Valley, Eastfield, El Centro, Mountain View, Northlake, Richland) you are able to download for free Office 365 including free space on Microsoft’s OneDrive (cloud storage space).
Do you know all of the benefits of this free software? Review the third column in the table below to better understand what you are receiving at no cost.
If you are not a student but are considering upgrading to Office 2016 or Office 365, you may also want to review the table. The first column lists the feature, the second the features you will receive if you purchase Office 2016, and the third the features you will receive if you subscribe to Office 365.
|One-time Purchase (Example: Office Home & Student 2016)||Office 365 Subscription (Example: Office 365 Home)|
|Cost||Pay a single, one-time cost||Pay a small monthly fee, or save by paying for a full year|
|Office Applications||Get Office 2016 applications, like Excel, Word, and PowerPoint. Your apps won’t be updated when new features are released.||Get the latest version of Office applications, like Excel, Word, PowerPoint, and Outlook. Right now that’s Office 2016, but your version will continue to receive new feature updates. PC users also get Access and Publisher.|
|Feature Updates||Security updates are included, but you won’t get new features that are added to Office 2016. Upgrades to major releases are not included.||Your version of Office will always be improving. Get the latest features and updates from Microsoft. Major upgrades to future versions are included.|
On More than One Computer
(Mac or PC)
|One-time purchases are designed for a single operating system, so your copy of Office is good for either one Mac or one PC.||With Office 365 Home, you can install Office desktop applications on up to 5 computers, which can be a combination of Macs and PCs. If you don’t need all of those installs, share them with members of your household.|
Get Advanced Features on Tablets and Phones
|Get basic editing features only on your tablet or phone.||Get extra features when you sign in to Office apps on your device. With Office 365 Home, you’ll get these extra features on up to 5 tablets and 5 smartphones.|
|Not included.||Securely store your files in the cloud and access them from anywhere. Get 1 TB of OneDrive cloud storage per user, for up to 5 users.|
|Initial technical support is included for installing only.||Contact us throughout your subscription at no extra cost for help with technical issues, or for subscription and billing support.|
If you are interested in seeing a comparison of the various versions of Office 2016 and Office 365, click on the following link.
Although you may have a preference, most software is going to subscription pricing. This might be the last version of Microsoft Office to offer a one-time purchase option. Regardless of which option you choose, Microsoft continues to expand the features available to users of their Office software suite.
Source: Support.Office. Com
Interested in learning more about courses offered by the Business Office Systems and Support Department at Richland College? Please contact Angela Nino, lead faculty, of the BOSS department. (firstname.lastname@example.org or call 972-238-6215) The BOSS department is a Microsoft Authorized Testing Center; if Microsoft Office certifications are important to you, keep in mind that you will be able to both learn MS Office 2016 software and attempt the Microsoft certification exam of your choice with us!
“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 email@example.com 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.
With Word 2016 making its debut last September and now that the year 2016 has arrived, it’s a good time to explore some of the new features that are in this latest version of Word.
Use the Tell Me Feature
This feature can help you get the answers (and steps) to tasks quickly and easily. Simply look to the right on the ribbon and locate the text field which will allow you to type in your query or topic.
For example, I decided I wanted to find out how to insert a math equation into a Word document. As you can see in the next two illustrations, it’s just that easy—type the topic and you will be presented with a list of possibilities. Another feature that is contained within the equations area is Ink Equations.
Write with Ink Equations
If I decide at this point that I want to actually “write” an equation, I can use my mouse to draw the equation or use my finger or a stylus with a touch screen device. My “written” equation will automatically be converted to text.
Take Advantage of Smart Lookup
Use Bing’s lookup feature to help you with research on the web or word definitions without leaving Word. Simply select the word or phrase and right-click it and then choose Smart Lookup from the short-cut menu. You will at least get definitions, perhaps some Wiki articles, and depending on the topic/phrase, you may get graphics as well. I chose “social media” as my topic, and the second screen shot below shows a wealth of information that was generated, and all without leaving Word!
Collaborate Quickly and Easily
Need to work on a document with other people? If you use OneDrive or SharePoint, you can collaborate in “real time.” In other words, you can see the changes made by each other as they happen. Once you’ve saved the document online, you just click Share (located in the far-right corner) to generate a link or email an invitation. Once the others have opened the document and agreed to share changes, you can see their changes as they happen.
Create Great Looking Shapes Faster and Easier
Word’s lineup up of shapes from the Shapes gallery just got easier by allowing you to give your documents that professional look in selecting the color or special effect enhancements for your shapes from a list of presets.
If 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 located in northeast Dallas at 12800 Abrams Road. For more information, please call Angela Nino, Lead Faculty, firstname.lastname@example.org 972-238-6382.
**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.