Tag Archives: Excel 2016

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.


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.