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:
- Numerical Count
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.
To learn more about all of the Excel Status Bar options, visit the Excel Status Bar Options support webpage.
Meetings and Collaboration
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.