Category Archives: Excel 2016

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.

 


Creative Gift Giving

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.

Enjoy!


What’s the Difference between Office 2016 and Office 365

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.

 

What’s the

Difference?

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

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

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

Storage

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

Included

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.

A Comparison of Versions of Office 2016 and Office 365

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.  (anino@dcccd.edu 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!


Accounting versus Currency Format in Excel

When formatting numbers, do you understand the difference between the Accounting number format and the Currency number format?

When you click the $ button on the Home Tab in the Number group on the Ribbon, you are applying the Accounting format.

To apply the Currency format, you would need to either click the down arrow in the Number format text box or launch the Number Dialog box.

Both the Accounting and the Currency format will add two decimal places.

Accounting Format

  • aligns all the dollar signs at the left edge of the cell
  • a dash is displayed for a zero value

Currency Format

  • aligns the dollar signs next to the number
  • a zero is displayed when the cell’s value is zero

currencytable

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

 


EXCEL 2016 Offers New Chart Types

If you have ever examined Excel’s charting tools, you may be wondering what other chart types could there be as previous versions of Excel offered eleven chart types.  These included Column, Line, Pie, Bar, Area, X Y (Scatter), Stock, Surface, Doughnut, Bubble, and Radar.

Microsoft’s newest version, EXCEL 2016, brings with it some new and modern chart types to help you better illustrate data that you include in your worksheets.  These charts are also available in PowerPoint 2016 and are:

TREEMAP:   A Treemap chart displays hierarchically structured data. The data appears as rectangles that contain other rectangles. A set of rectangles on the same level in the hierarchy equal a column or an expression. Individual rectangles on the same level equal a category in a column. For example, a rectangle that represents a type of food found in a grocery store (Dairy)  may contain other rectangles that represent products in that category.

See Treemap chart below.

treemap-chart-in-excel-2016

 

 

 

 

 

 

 

WATERFALL:  As explained by Microsoft, “Waterfall charts are ideal for showing how you have arrived at a net value, by breaking down the cumulative effect of positive and negative contributions. This is very helpful for many different scenarios, from visualizing financial statements to navigating data about population, births and deaths”.

PARETO:  A Pareto chart contains both bars and a line graph. Individual values are represented by bars. The cumulative total is represented by the line.

HISTOGRAM:. A Histogram chart displays numerical data in bins. The bins are represented by bars. It’s used for continuous data.

BOX and WHISKER:  A Box and Whisker chart, as explained by Microsoft, is “A box and whisker chart shows distribution of data into quartiles, highlighting the mean and outliers. The boxes may have lines extending vertically called ‘whiskers’. These lines indicate variability outside the upper and lower quartiles, and any point outside those lines or whiskers is considered an outlier.”

SUNBURST:  A Sunburst chart is a pie chart that shows relational datasets. The inner rings of the chart relate to the outer rings.   It’s a hierarchal chart with the inner rings at the top of the hierarchy.

For more information from Microsoft regarding the creation and use and to view samples of these new chart types, click the following link:

New Chart Types in Excel 2016

Interested in learning Excel 2016?  Please contact Angela Nino, lead faculty in the Business Office Systems & Support Department at Richland College.  (anino@dcccd.edu or call 972-238-6215) The BOSS department is a Microsoft Authorized Testing Center; if Excel certification is important to you, keep in mind that you will be able to both learn to use Excel 2016 and attempt the Microsoft Excel 2016 Certification exam with us!

 


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.

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.


Calculations Quickly!

Here’s a quick but very useful Excel tip.  It is especially helpful when performing calculations on lengthy columns. 

Excel Tip

Give this tip a try to see if you like this method better than dragging the fill handle down, which is the method used by many who work with Excel daily.  It is easy and very fast!


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