Category Archives: Uncategorized

What’s New in PowerPoint 2016

Tell me what you want to do – This help feature lets you type in a task, function, or question.  If it is quick task, you can do it from that task pane.  If it is a more complex task, it will open the regular help feature with options that best match your request.

help

Zoom – (available in Office 365) when you create a Zoom in PowerPoint, you can jump to a specific slide or section in any order you want while you are presenting.  There are three kinds of zooms—Summary Zooms, Slide Zooms, and Section Zooms.

Text Highlighter –  This feature has been available in Word for several years.  Now you can pick different colors to highlight and add emphasis to your text.

Enhanced collaboration – You were able to collaborate with other users on presentations in previous versions of PowerPoint using OneDrive or Sharepoint.  Now when you open a shared presentation, you can see at a glance who is working on the document and what slide they are working on.  The new activity icon will allow you to see a complete list of changes that have been made.  The comment icon will let you make, view, or reply to comments.

collaboration

Morph Transition (available in Office 365) – This new transition allows the user to automatically animate, move and add emphasis to objects across slides creating more advanced animation effects.  In order to use the Morph transition, you will need to have two slides with at least one object in common.  The easiest way to do this is to duplicate the slide.   You can use this feature  to:

  • Create motion and emphasis animations – An object can be moved, resized (zoom animation), rotated, or the color changed.
  • Animate words
  • Create an anagram effect by rearrange individual characters on the slide
  • Zoom in on an image
  • Create a 3-D rotation

Six New Chart Types – In addition to the standard chart types that were available in previous versions, PowerPoint 2016 also includes the following chart types:  Treemap, Sunburst, Histogram, Box and Whisker, and Waterfall.

 Did You Know?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.

Click here for more information about these new features.

Microsoft. (2016). What’s new in PowerPoint 2016 for Windows.

 


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.


Watch Your International Manners! Important Don’ts to Observe in 15 Countries

480098185--04-18-2016 Flag imageClick on this link to take a look at the Business Insider graphic that was created by authors Sarah Schmalbruch and Samantha Lee on what NOT TO DO when visiting any of the following 15 countries.

Body language along with other overt actions are very important components of your communications, and they should be kept in mind and respected when traveling abroad.

  1. Chile
  2. Croatia
  3. France
  4. Germany
  5. India
  6. Ireland
  7. Japan
  8. Kenya
  9. Mexico
  10. New Zealand
  11. Norway
  12. Russia
  13. Singapore
  14. Turkey
  15. United Kingdom

Source: http://www.businessinsider.com/how-not-to-behave-infographic-2015-5

If you want to improve your communication skills or learn/update your computer software skills, consider taking a Business Office Systems & Support (BOSS) course 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.


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.

 


Exploring New Features in Word 2016

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

01-19-2016 Word Feature 1aThis 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.
01-19-2016 Word Feature 1b

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.

01-19-2016 Word Feature 1c

 

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!

01-19-2016 Word Feature 1d01-19-2016 Word Feature 1e

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, aedwords@dcccd.edu 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.



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

 


Use the 7 Cs to Become a More Successful Communicator

Having a successful career depends on your ability to communicate effectively with others in the workplace. To become a good communicator, make sure you are aware of those important aspects oral communication—tone of voice, eye contact, and other body language signals.

Click the graphic below to review Evan Carmichael’s infographic on the 7 Cs of Communication, which illustrates 7 proven communication strategies that you should use as part of your oral communication toolkit.

02-08-2016 7 Cs Graphic

Source: Evan Carmichael, The Entrepreneur Blog, June 21, 2011
Link: http://www.evancarmichael.com/blog/2011/06/21/infographic-7cs-of-effective-communication/

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