Tag Archives: spreadsheets

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.

Use Excel 2007/2010’s Table Feature to Help You Quickly Calculate, Format, and Sort Data

Have you ever needed to make an Excel spreadsheet look good in a hurry? Well, Excel’s table feature (introduced in the 2007 version) can help you get that data computed, sorted, and formatted in just five easy steps.

Here’s how the data initially looked on the left. Notice, the data has not been organized on any fields, and the format is very bland. Look at the difference once the table feature has been applied! (Click on the image to enlarge)

Use Excel's Table Feature To Make A Difference!

To give your spreadsheet data a more professional appearance, simply: 

  1. Select the data range and then click the Insert tab. ***IMPORTANT***Be sure there are no blank rows between your column headings (fields) and your actual data.
  2. Click the Table icon from the Table Group to determine your range and then click OK
  3. Select from one of the other 60 pre-designed table styles, if you don’t want to use the default table style.
  4. Click the Total check mark in the Table Styles Options Group and then scroll to the last row in the table and click the drop-down arrow to the right of the column(s) you want summarized (Count, Sum, Average, Min, etc.). In our example, we will include a total (SUM) for 1st Quarter Sales and take a count (COUNT) of the sales reps by last name.
  5. Sort the data on specific fields. In our example, we will sort the data by last name (LName field) by clicking on the arrow for that field and select the Sort A to Z option.

For more information, contact Becky Jones, Associate Dean, bjones@dcccd.edu, 972-238-6215