- Home
- computer training
UPPER, lower & Proper in Excel
In an earlier post I discussed using len, left and right and mid. Now I will look at more functions that fall under “Text” in Excel – upper, lower and proper. These 3 functions allow you to change the case of text in your files. I usually use these functions on files that have been […]
Continue readingSort Left To Right In Excel
If you’ve covered even the basics of Excel, there is a good chance that at some point you have sorted at least 1 column of data in ascending or descending order. Sorting up and down is well covered in classes, books, tutorials and with a big button in Excel ribbons that says “Sort”, but […]
Continue readingOffice Design Tip
I’m often asked for help with, or to recommend a good (cheap) program for designing certain shapes like banners etc. There are many good ways to do this out there, feel free to look into some yourself, this is what I usually tell people, but I also give them an Office design tip. A […]
Continue readingHow To Add Macros To Custom Toolbar
Having trained a variety people and helped others with macros, especially in Excel, I have noticed a common issue – assigning keyboard shortcuts to the most regularly used macros. Ctrl along with most of the letters are already assigned as shortcuts, by assigning for example Ctrl and B to your macro, this overwrites the […]
Continue readingA Quicker Way To Create VLookUps Across Multiple Columns
Recently I have been asked by a few people for a quicker way to create VLookUps across multiple columns. In each case the user wanted a VLookUp to pull in several columns of data, but did not want to have to create a VLookUp for each column (one case would have been over 20 columns […]
Continue readingAdd Video To PowerPoint
Would you like to add video to PowerPoint presentations? Videos and other media can add to your presentations, enhance slides and for longer presentations they can give you a break from talking and give your audience a break from listening to you (no offence intended). So how do you add video? A common technique I […]
Continue readingPowerPoint Animation Pane
So you’ve put together the content of your presentation and you are now ready to animate it. This is where the PowerPoint animation pane comes into play. As well as making animation easier, faster and less painful to work with, the PowerPoint animation pane may also give you easier access to some options. If […]
Continue reading2 Powerpoint Tips: Make your point, point by point
So, you have put together your presentation and are happy with the content, but how do you get your audience to listen to you presenting? Here are 2 PowerPoint tips to help you. #1 Use short points to make your point There are a few advantages to using short points to get your message […]
Continue readingPowerPoint Animation Tip: Leave it to the end
The first PowerPoint Animation tip I would give any client would be to leave it to the end!! I’ve seen so many presentations with good content ruined by poor attempts at animation which end up making the whole presentation look rushed and devalues the good content. I have even been told by some people […]
Continue readingProblem Solving Tip
This is probably the best troubleshooting or problem solving tip you will ever read when it comes to trying to figure out why a macro, a formula, a link, a chart, etc is not working the way you want to. There are only 3 steps involved! Take your left hand and put it on […]
Continue readingEmail Tip : Sort Out Your Inbox
Have you ever experienced returning to work after holidays, feeling refreshed and able to take on the world? That is until you check your email and the holiday becomes a vague, distant memory and the relaxed and refreshed feelings are replaced with stress, doom an gloom! OK, that may be a bit of and exaggeration, […]
Continue readingPaste Special
Paste Special is another time saving trick that may be going underused. You are probably already familiar with the cut, copy and paste functions in a lot of applications. Copy allows you to make a copy of selected or highlighted data to be pasted somewhere else Cut allows you to remove selected or highlighted data […]
Continue readingOne button that will boost your personal efficiency
Top Fives I have a faint memory of reading about a statistic regarding how much men like lists (top 5 lists, top 10, etc). At the time I remember believing it to be true because a lot of my friends and I were constantly comparing top fives of pretty much everything. But, this statistic was […]
Continue readingExcel Pivot Tables
In Excel, Pivot Tables are a quick and easy way to summarize, analyse and present data. The speed that the tables can be put together and rearranged makes them an invaluable and important tool for analysis and decision making. The more data you have to analyse, the more obvious the uses of Pivot Tables are. […]
Continue readingPage Breaks In Word
Page Breaks Page Breaks are one of Word’s underused gems. A long time ago in a college far far away…. In those late coffee-fuelled nights putting together projects and typing my fingers to the bone I would spend half of my time formatting and reformatting, and then formatting some more. Have you gone through the […]
Continue reading