Recently, I went to the DMV to renew my license. I failed the eye exam and had to get glasses for the first time in my life. Are glasses the only way to see Excel sheet tabs better? There’s no control in Excel that will do it.
That’s why you have to adjust your system settings to do it. Right click on your desktop, select properties, click appearance, and select advanced. You will see a drop-down box labeled item- simply select the scrollbar item and increase it’s size. For some reason unkown to mere mortals, sheet tabs are affected along with the scrollbars in windows- the only trick is to balance how much you increase it, as all scrollbars will also increase in size.
Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.
Want to learn the basics of Excel formulas in less than an hour? Take this free course from Microsoft.
Jared Hawk teaches Excel Seminars in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com.
VLOOKUP allows you to type one bit of information into a cell, then have all the related information from a list or database populate next to it. For example, if you type in someone’s name and hit enter, Excel will search the list or database and pull up their address, SS#, Telephone number or any other related information. It’s a lifesaver if you use Excel for data storage.
For some free Excel VLOOKUP Tutorials click here.
Jared Hawk teaches
Excel Classes in Boise, ID. He is also a contributing author to
www.masterthebusiness.com.
Can you use Excel’s text-to-speech functionality in VBA? You bet. Simply use this line of code: application.speech.speak and then specify your text in paranthesis or you can even use a variable. If your variable was called Announcement, your code would look like this:
application.speech.speak announcement
And to read text:
application.speech.speak (”This is the text!”)
Simple!
Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com.
Step 1: Highlight the table/data, including the column and row labels
Step 2: Press F11
Excel automatically builds a chart for you- you can customize it by right-clicking and selecting different chart types and options. That’s it!
Jared Hawk is a professional Excel Class Instructor and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com.