Growth depends on desire. You cannot grow without desiring it and then acting on that desire.
Posts Tagged ‘tech tip’
One of the cool things about Microsoft products is that each new version seems to give users more control over their user environment; for example, starting in Excel 2007 and now expanded in 2010, is the ability to customize the quick access toolbar (QAT).
For those that don’t know what the quick access toolbar is, it’s the little submenu that sits atop your ribbon:
The reason a lot of people don’t really notice it’s existence is because initially, the QAT doesn’t have much on it, just the Save and Undo features; but notice the little down arrow on the right end:
Clicking on it brings up this dropdown:
Anything you click on the dropdown will be added to the QAT, making it faster, quicker and easier to run those commands:
Here we’ve added the New command.
But, it wouldn’t be cool if that was all you could do, note at the bottom of the dropdown, the option that says More Commands. Clicking on it brings up this pane:
Anything on the left side can be put on the right, making commands that you use frequently, always just a click away. To add them either double click on the one’s you’re after, or highlight them and then click the Add button:
Note also that you can move the commands around so that they will appear in a different order on your QAT by using the Up and Down arrows:
Once you’ve added the commands you want and have them in the order you like, click the OK button to accept your changes, note how the commands you added are now shown on your QAT.
Another way to add commands to your QAT is to right-click commands on your ribbon menu. You can add a picture to a chart, for example, by clicking the Insert tab on your main ribbon, then right-clicking on Picture, to get this drop-down:
Choosing Add to Quick Access Toolbar, will do just that:
And finally, you can move your QAT by clicking on the down arrow at the end of your QAT and then choosing Show below the Ribbon. This puts the QAT below the ribbon, like this:
Customizing your QAT is one way of making your life easier in Excel where it’s not always easy to remember where the commands you want to use are located, or to speed up the use of those you use more often than others.
Oftentimes, users of Excel find they’d like to be able to import data from an external source such as a web page, this is particularly true of web sites that list stock information. What many people don’t know is that Excel does have a facility for doing just this.
To see how it works, open Excel to a new blank document, then click somewhere in your sheet to make it your current document, then click on the Data tab on the main ribbon
9.) Remove unnecessary programs in Windows
If you buy a computer from an OEM such as Dell or HP, it’s most-likely filled with “bloatware”, the programs that are usually trial but are installed with the OEM’s copy of Windows. While these programs are harmless, they get annoying because they slow your computer down considerably. You can either manually uninstall each program from CONTROL PANEL – ADD/REMOVE PROGRAMS, or you can download and install PC Decrapifier. This program searches your computer, targets the programs that are considered bloatware such as “Auto Backup – Free Trial!”, “McAfee 90-day Trial”, and “eMusic” and un-installs them to not only free up hard drive space, but also increase performance.
This obviously sounds like a chore but keep in mind that with the super fast pace of technology, having the most up-to-date software is important for a computer’s stability, compatibility and performance. For example, if you play PC games or do heavy graphics editing, your gaming/editing performance might suffer if you’re using outdated drivers from the video card manufacturer. (Or OEM PC maker)
3.) Upgrade your computers hard drive to a new/bigger/faster one!
Hard drives are getting faster, cheaper and bigger so pick up a new one! Whether your current one is old, sputtering on its last spindle rotation, or almost at full capacity, you can purchase a 500GB, 750GB or 1 Terabyte drive that has much more buffer cache, faster spindle speeds and can even consume less power! (eco-green models) Even if your current drive is working fine, a second hard drive is handy as a large dumping ground for files or can serve as a place to store back-up images of your current hard drive. If you don’t feel like cracking open your case, you can opt for an external hard drive and dump your archive files there to free up space. The reason is because as a hard drive gets full, its performance decreases because it has to work harder to access files.
This primarily applies to problems you might have with your computer at home but it can happen anywhere. While working on your computer did you ever get an alert message and you had no idea what it meant? You know, something that looks like this:
I can’t tell you what an error messages like this means but I can tell you how to find out:
- When an alert box pops up with an error message in it take note of what it says. If it doesn’t make sense to you write down exactly what it says (or highlight the text and copy it if you can)
- Open up the internet and go to a search engine (google, yahoo, ask). Type (or paste) the error message into the search engine and click “search”
- Look at the responses carefully. Chances are you are not the first person who has ever seen this message before. Some of the people who have seen that error before have actually made entire web pages up about their experience. Some of these websites might tell you how to fix the problem. In many cases the company that created the software will create a website that offers free downloads that you can use to repair the error. Check out these sites for a solution to your problem.