Category Archives: Professional Development

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.


Microsoft Office 2016 (Office 365) BOSS Classes Are Here!!!

Office 365 Apps as of May 2016Do you need to learn Microsoft Office or update your Microsoft Office skills?

GET DIGITALLY PREPARED TODAY by taking one or more Microsoft Office productivity software classes—Word, Excel, PowerPoint, Access, or Publisher—through Richland College’s BOSS Program.

REGISTRATION is going on now through Saturday, August 20, 2016, for full-semester classes.
For online and flex-term classes, registration will resume on Monday, August 29, and will be available until the beginning of the actual class start date. Click here to see the class schedule for Fall 2016 BOSS classes.

  • Word 2016 – offered on campus and online
  • Excel 2016 – offered on campus and online
  • PowerPoint 2016 – offered on campus and online
  • Access 2016 – offered on campus and online
  • Publisher 2016 – offered on campus and online

As you learn the latest software version of Microsoft Office, you will also be preparing for the Microsoft Office Specialist certification exam(s) that are available for Word, Excel, Access, and PowerPoint. Getting your certification in one or more of these software applications lets employers know that you are proficient and highly knowledgeable about that application, which can help you with employment and promotions.

For more information on these courses and how to get registered, please contact Angela Nino at 972‑238‑6215 or by email at anino@dcccd.edu

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

DYK?–if you take a DCCCD class, you are eligible for a free download of the latest Microsoft Office 2016 (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.


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.

https://www.youtube.com/watch?v=SPLzV0-X0lI%20

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.


Watch Your Mobile Manners!

With the widespread use of mobile devices such as smartphones, tablets, and smartwatches for communicating in the business environment, it’s important to remember the role of manners and why using good mobile etiquette counts.

Here are some are tips you should keep in mind when communicating on your mobile device. (Please click twice on the table below to get a larger view.)

2016-01-08_Table Image for Word Press Import

Source: Dianne S. Rankin and Kellie A. Shumack, The Administrative Professional: Technology & Procedures, 15th edition, Cengage Learning, Boston, 2017, pp. 125-126.

If you want to improve your communication skills, consider taking the BOSS program’s POFT 2312 Business Correspondence and Communication 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, please call Angela Nino, Lead Faculty, aedwords@dcccd.edu 972-238-6382.

**Richland College is an authorized Microsoft Testing Center.

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


Public Speaking Tips Video

Two Must-HaveIf you suffer from stage fright every time you are asked to make a presentation in front of a group of people, this video was made for you!

Created by the Richland College Speech Faculty, the video was prepared to help instructors remind students of important public speaking behaviors prior to giving a presentation.

If you would like to learn more about how to speak in public and communicate effectively, why not consider enrolling in a speech course at Richland College!

Enjoy the video!

Click here to view the Speech Tips Video


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


WRITING TO WIN: Coordination in Successful Teamwork

By Royce Murcherson

Royce top pictureIn the last blog, I talked about collaboration as part of an overall team structure that helps colleagues come together to craft solutions and improve processes. Communication is also a key component in collaboration, for without communication there can be no real collaboration. And without coordination, the fruits of communication and collaboration are lost.

The Three ‘C’ Model:  COMMUNICATION * COLLABORATION * COORDINATION

What is coordination? It is the glue that holds the model together. Coordination within teams is simply ensuring the job gets done.  If you find yourself in the role of ‘team leader’, you must ask yourself two questions. What is my role and what will it take to get the job done?

The Role of Team CoordinatorRoyce People holding MS logo puzzle

  • The team leader or team coordinator serves as a primary liaison between team members.
  • The team coordinator is responsible for making sure team members are keenly aware of their specific roles and function within the group.
  • Team coordinators are also tasked with the authority to make critical decisions when the team cannot arrive at a consensus.

Coaching ResponsibilitiesThe Responsibilities of the Team Coordinator

Think of a team coordinator as a coach in a team sport. The team is made up of individuals each with particular skills or talents. The team coordinator must channel all of these talents into an effective force that will bring a project to completion.

The Team Coordinator Must:

  • Have a long term vision of the work to be done
  • Know each team member
  • Define team roles
  • Ensure the team has a common goal
  • Make sure all team members know their assignments
  • Leverage resources and specific skills of the team
  • Create a workable plan
  • Have the correct tools available for the team to complete their tasks
  • Encourage effective communication among the team
  • Conduct periodic checkpoints to determine progress against deliverables.

 

Coordination AbsentWhat Happens when Coordination is Absent?

A lack of coordination within a project team can decrease productivity, complicate processes and delay the completion of projects. Below are some common signs:

  • Duplication of Work A usual sign of a lack of coordination within a project team is redundancy. Redundancy is caused by a lack of communication. With redundancy, an organization will spend double the efforts, materials and time to produce the same item twice. Redundancy typically results from the poor coordination of a project team.
  • Lost Information Teams must effectively share information to function at an optimal level. When this information is not readily available as needed within the team, the lack of information can create a cascading effect that will damage the team. Lost information can lead to delays.
  • Delays on Deliverables – Deliverables are the building blocks of an overall project. Deliverables can be reports, documents, and software upgrades, anything that contributes to the successful delivery of the project to the customer. One of the signs that team lacks coordination is called ‘delay’ and delays on deliverables can cause a project to miss a completion date.

Advantages of Team CoordinationThe Big Advantages of Team Coordination

The advantages of team coordination are realistic. Roles, responsibilities and deadlines are assigned. Informal coaching and mentoring takes place which benefits the group. It ensures a consolidation of work that can be measurable, attainable, and time constrained. It provides a single access point of communication between the team coordinator and business executives.

For an expanded discussions on effective business writing and workplace etiquette, see my book:

Royce Murcherson, Ph.D., The Guide to Persuasive Business Writing: A New Model that   Gets Results. Iowa: Kendall-Hall, 2013

Clip Art, provided by Microsoft Office Professional Academic, 2010

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

 


Are You Ready for These Administrative Assistant Positions???

03-31-2016-TI Job Search 515964426

 

 

 

 

 

 

 

 

Click on this image to find out more about administrative assistant positions that have recently been posted by Texas Instruments. Be sure to pay close attention to the qualifications and skills that are required for these jobs. Improve your hiring chances by making sure your skills are up-to-date.

If you need to update your communication and business writing skills OR your software skills, register for classes in Richland College’s BOSS program. For more information on classes, certificate programs, or the associate degree plan, e-mail Angela Nino at ANino@dcccd.edu or reach us by phone at 972-238-6215.


Are Two-Year Colleges Sometimes Better than Four-Year Universities?

graduation-hatCommunity colleges (also known as junior colleges) offer a two–year degree called an associate degree. A student with a strong academic record at a community college can then transfer to a more expensive state or private college for two more years to earn a bachelor’s degree.

However, the second function of community colleges is to prepare students for the job market by offering associate’s degrees in the career and technical areas and entry-level career training. Adult students who want to upgrade their skills for workforce reentry or advancement are also using the offerings of community colleges.

For some, community college is an opportunity to get extra academic guidance and support. Community colleges often have small class sizes. The priority of the faculty is teaching, not research. Plus there are generally lots of support services, such as mentoring programs and organized study groups. The difference in cost between a community college and a four-year university is substantial.

Read what the Washington Post had to say in an article published on June 29, 2015 regarding community colleges:  What’s wrong with going to a community college? How two-year colleges can be better than four-year universities.

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

 


Richland College’s Techie Transfer Fair: AAS and Beyond

What does your future include???

     Take your technical certificate to an AAS degree, and then take your AAS degree to a bachelor’s degree–BAAS!

     Visit Richland College on Thursday, March 3, to get more information on using your skills and experience to help you get to that next educational level!!!

Spring 2016 Techie Transfer Fair

 


WRITING TO WIN: Teamwork and the Three ‘C’s’ of Success

by Royce Murcherson, Ph.D.Royce 1 Man

What are the real benefits of teamwork in business? Why is it increasingly important? Teamwork and team building are being used in business environments where the nature of the work is complex or multifaceted, not to mention fast-paced. Working in isolation as a single contributor may not be as productive as several colleagues with different skills working toward a single goal. Successful teams rely on three effective mechanisms: communication, collaboration, and coordination. I will discuss each of these mechanisms over the course of three posts, the first being this one which is dedicated to ‘communication’. 

WHAT IS EFFECTIVE BUSINESS COMMUNICATION?

It is a successful exchange of ideas between colleagues or team members that produce solutions to problems, improvements in process, setting expectations, knowledge sharing, and creating awareness. In short, effective communication assures quality in products and services. 

Royce 1THE RULES OF EFFECTIVE BUSINESS COMMUNICATION

  • It should be concise.
  • It should present information in the form of a well thought out plan.
  • It should be clear and easy to understand.
  • It should speed up the decision-making process.
  • It should be inherently persuasive. That is, the material or information being presented should be convincing and factual.

FORMS OF BUSINESS COMMUNICATION

  • Correspondence
  • Proposals
  • Reports
  • Meetings
  • Informal Discussions
  • Presentations

Royce 2VERBAL INTERACTION AND THE TEAM MEETING

Rules and forms of communication are obvious. What is not obvious is the manner in which team members or colleagues verbally interact with each other. Be aware that you are a member of a team which means each person has a voice in the process. When making comments or presenting information, be sure to invite your colleagues to respond with questions, improvements or enhancements, possible redundancies or even errors of which you may not be aware.

  • Consider Your Audience Your audience is your team, colleagues, or stakeholders. Written and verbal communication must not be overly informal. Think of the tone in which you are communicating. When writing, do not fall into ‘text talk’ or ‘sofa chat’. At the same time, do not be overly formal. Remember, you are not at a back yard barbecue, nor are you addressing Congress. This advice also applies to verbal communication. The most important skill is being able to identify your audience and adapt your tone and style of communication to the situation.

 

  • Question, Listen, and Encourage When working within your team, think of yourself as a teacher or facilitator. Yes, you should invite questions and comments, but you should also take it one step further. The roles of teacher and facilitator focus on developing a healthy exchange between students and attendees. What is the best way to accomplish this? Question, listen, and encourage. Question your team members on their points of view. Make a concerted effort to listen and show sincere interest in their ideas. When comments or feedback display creativity or ingenuity, encourage more dialogue. Invite your colleagues to explore their ideas and report back to the group.

 

  • Stay on Point Whether facilitating or communicating within a team meeting, stay on point. Follow the agenda. Be aware of time constraints even as you question, listen, and encourage. This burden does not always fall to the person who called the meeting. Each member has a responsibility to make valuable contributions.

Next time, look forward to my discussion of the second ‘C’, the benefits of collaboration in the team environment.

For an expanded discussions on effective business writing and workplace etiquette, see my book:

Royce Murcherson, Ph.D., The Guide to Persuasive Business Writing: A New Model that   Gets Results. Iowa: Kendall-Hall, 2013

Clip Art, provided by Microsoft Office Professional Academic, 2010

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