Have you ever been faced with the task of keeping a running tally of items that may have a change in status over time? If so, the COUNTIFS function can help you stay current with the status of your data/population.
However, there are two important guidelines that must be observed–(1) the ranges you are examining must be consistent in terms of the way data is entered, e.g., use the same case and wording—if you use IT once, then be consistent and type the same wording for this item—don’t type It. or it the next time; (2) the Criteria Ranges should be made absolute ranges, e.g., $C$3:$C$350 or the ranges should be given specific names so they remain constant when copied.
Well, Excel has a built-in “Speak Cells” audio feature that can help you as you proofread numbers and other information by sounding out the information for you. You can choose whether you want the information repeated by column or by row.
If you want to add the “Speak Cells” icons to your Quick Access Toolbar (QAT), simply click the down arrow to the right of the QAT and then click on the selection More Commands… When that dialog box opens, find the Choose Commands area and click the drop down arrow next to Popular Commands and change to All Commands.
If you are like most people, you will be surprised to see the expanded array of Excel commands that are available to you. It’s amazing to see what is under Excel’s hood!
Next, scroll down (the commands are listed in alpha order) until you see the commands for Speak Cells. Suggestion: The image below shows a list of Speak Cells icons to consider adding to your QAT. Adding these icons will increase your flexibility in using the Speak Cells feature. Simply select the desired icon(s) and click OK after each selection.
Click on Excel Speak Cells Feature to view and listen to a demonstration of how this feature works.
For more information on BOSS software offerings, the BOSS degree and certificates, and how the BOSS program can help you with your career, contact Becky Jones, Associate Dean, firstname.lastname@example.org 972-238-6215.