Category Archives: Apps

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!

 


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.

 


Speaking Is Believing! Use Windows 10 Cortana to Help Your “Old School” Computer with Work Tasks!

That’s right—the tech geeks have proclaimed that you can use Microsoft’s Cortana digital assistant system found in Windows 10 with your “old school” computer to help you navigate and search the Internet, open some applications, make appointments, and remind you of to-do lists by simply plugging in a microphone.

According to Sean Hollister who reviewed Cortana for Gizmodo and who tried a number of microphone scenarios, Cortana seems to be able to recognize and perform voice-activated requests very handily. Marc Chiappetta who writes for Forbes, was impressed with the speed at which Cortana was able to perform requested tasks, although he does provide a wish list of improvements. One improvement he would like to see is for Cortana to be able to handle compound questions—Example: “What is the time and temperature in Chicago?”

 

Attention SmartPhone Users! Although Cortana has been available on Windows phones for a while, you’ll be happy to know that Cortana is coming to iPhones and Androids later this year—yeah! It will be nice to compare Cortana to Siri and Google Now—you be the judge.

 

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 contact Becky Jones, Associate Dean, bjones@dcccd.edu at 972-238-6215.

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

 


Let MS Office 2013 Custom Apps Help You Increase Your Productivity!

 

timing concept

Did you know there is much more you can do to enhance your experiences with the Microsoft Office 2013 Suite than what is already included in Word? Excel? PowerPoint? or Outlook? While the applications within the Suite are literally crammed with tons of powerful features, there additional ways (through add-ins) that you can customize your specific office needs even further, which can save you time and effort. These apps range from

  1. Converting PDF files to text (recognizes text in six different languages).
  2. Generating a tag cloud of text from a Word document.
  3. Sending fax documents without leaving Word.
  4. Searching the web via Google within Word, Excel, or PowerPoint—no need to toggle back and forth between your Office applications and your web browser.
  5. Creating a graphical idea map from any of the Office applications.
  6. Converting the case of your text in Excel files quickly—This can be a life saver if you are importing information into Excel from a variety of sources because it saves you time and energy by not having to make “hand edits” that are slow and manual.
  7. Creating Excel data as a “heat map” – provides a visual of data for the United States and is color coded.
  8. Previewing hyperlinks from Outlook email messages—helps to prevent messages sent that contain broken links.
  9. Integrating key information from LinkedIn from your profile with Outlook—can help with your networking capabilities.
  10. Sending Direct Messages from Outlook to Twitter.

Vangie Beal previewed a total of 30 MS Office apps that can help you increase your productivity and efficiency, but there are many others that have been added that may fit your needs also.

Many of the apps are free, while others may have a one-time charge or a subscription fee. If you see any that can help you, simply click this link to go to store.office.com and then “shop until you drop”!

P.S. I just found another app (for Excel) that can be very engaging when you are trying to transform data to a simple graphic quickly and easily. It’s free, it’s easy, and the name is Bubbles—try it, you might like it!

Take a look at the sample screen shot below.

06-29-2015 Bubbles App

If you want to learn new software or if you need to update your software skills, 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 contact Becky Jones, Associate Dean, bjones@dcccd.edu at 972-238-6215.

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

 


Windows 10 is Coming!

As is always true in the world of computer technology, change is coming very soon. Microsoft will announce and make available sometime later this year its newest version of Windows—Windows 10. Users of Windows 7 or Windows 8 or 8.1 will be able to get Windows 10 FREE. This is a first from Microsoft and is a step toward regaining user support. Many loyal Windows users were disappointed in Windows 8.

Exciting news about Windows 10 includes the return of the Start menu. Microsoft has also redesigned its browser, Internet Explorer, and given it a new name—Microsoft Edge.

Included below are two links: One will take you to a short article on CNet.com, which includes a list of things you need to know about Windows 10. The second link will take you to a list of FAQ’s on Windows 10 posted on Microsoft’s Web site.

What You Need to Know about Windows 10 (from CNET.com)

Microsoft’s FAQs Regarding Windows 10

Enjoy learning about what is coming next for users of Microsoft Windows!


How to Insert Checkboxes in an Excel 2013 Spreadsheet

Follow the link below to learn how to insert checkboxes on an Excel spreadsheet.  In the article, Bilal Ibrar discusses how to insert checkboxes and shares several examples of how you might use these checkboxes when designing an Excel spreadsheet.

The post is located on a blog called Write A Writing.  Please click the link on Write A Writing to learn more about using this Excel feature.

This is not a task that you will use on a daily basis in Excel; however, it may come in handy one of these days!

_________________________________________________________________________________________________

For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, bjones@dcccd.edu or 972-238-6215.