Welcome to the IT Help Desk!

The IT Help Desk is the central location for all IT related support and questions. If you are looking for an answer to a problem, start here:

  • Check out our Frequently Asked Questions (FAQs).
    • You can search our FAQs or browse through the different categories.
  • If you are unable to find your answer, submit a service request.
    • This service is only available to current Faculty, Staff, and Students.
  • Anyone may also create a service request by emailing the IT Help Desk.

Training Tip of the Week – Using the Status Bar (05/24/2018)

Microsoft® Office – Using the Status Bar

Thursday, May 24, 2018

When utilizing a Microsoft® Office Application (Microsoft® Word, Microsoft® Excel, and Microsoft® PowerPoint), you may have overlooked a very useful tool that can quickly provide you with some analytical information about the document, spreadsheet, or presentation you are authoring. Located all the way at the bottom of your application window you will see an application specific Status Bar. In this week’s IT Training Tip of the Week, I will be focusing on the Status Bar in Excel, but the Status Bar in Word and PowerPoint function very similarly.

In Microsoft® Excel, look all the way down to the left-side of the application window, and you will see the word Ready, and on the right-side, you will see the Zoom Slider, this is where the Status Bar is located.

If you right-click on the Status Bar, you will be presented with a menu of options that you can toggle on and off by clicking on them.

Enabling Status Bar Options –

  • Right-click on the Status Bar
  • Place checkmarks next to the following items to enable them:
    • Average
    • Count
    • Numerical Count
    • Minimum
    • Maximum
    • Sum

Note: If you are using Microsoft® Office 2016 for the Mac, you will need to right-click the Status Bar each time after placing a checkmark next to the option you enable.

Now, let’s say you have a spreadsheet with a column of numbers and you would like to quickly calculate the Sum of the numbers. Rather than having to create a formula to add up all the numbers, just highlight them with your mouse and look at the Status Bar. The options you enabled previously will provide you with real-time information about the data you highlighted, including the sum of the numbers.

Hint: You can highlight data in a single column, but you can also select across multiple columns and rows.

Note: All of the options selected from above will work with numerical data. If you have text in a cell, the Count option will only count the number of cells you have highlighted.

To learn more about all of the Excel Status Bar options, visit the Excel Status Bar Options support webpage.

Did you find this IT Training Tip Helpful?

Our Mission

To ensure that the technology services offered at the College are working in the most efficient and consistent manner for all employees and students.

Meetings and Collaboration

Members of the IT Help Desk Team meet during the following times to collaborate together in order to improve communication, efficiency, and to provide outstanding services to members of the Bates College Community.

Stand Up Collaborative Meetings: Monday, Wednesday, and Friday from 9:00am to 9:15am at the IT Help Desk in The George and Helen Ladd Library.

Weekly Staff Meeting: Wednesday’s from 3:00pm to 4:00pm at an off-site location.