- Home
- tips and tricks
PowerPoint 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 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 readingExcel VBA Macro Demo
Starting from this post we have covered a range of areas relating to Excel VBA Macros. From the feedback received, it seems that people can see the benefits and uses of macros, but are still wary of them! As long as you record sections, breakdown code, comment it well, and have a search engine available […]
Continue readingExcel VBA : Debugging Errors
Debugging VBA Errors When creating macros in VBA, even if you just record one and amend the code you are almost certain at some stage to come across an error. When you run the macro you get a dialog box with an error message, it’s not as helpful as my example above, but at least […]
Continue readingExcel VBA : Working With Multiple Files
During the last few posts we have been building on our knowledge of Excel VBA Macros. This time we will use what we have already seen, but now we are going to work with more than one file. The Goal From this post, we will create a Billing file with a macro. This macro will […]
Continue readingExcel VBA : Finishing Our File – Comments, Borders & Column Width
If you have been following the series of posts so far, you should have a file like the above. A macro has changed the text in the headers, changed the format of the header row, added a formula in column D and a total at the bottom of column D using variables. This series started […]
Continue readingExcel VBA : Message Boxes & User Inputs
Message Boxes are easy to create and can be both informative and impressive to your program’s users. They appear as pop-up dialog boxes to your users and can give an update, information, warning, options, or other data. Similar to Message Boxes, are input boxes which allows the users to enter something to a dialog box, […]
Continue readingExcel VBA Macros : Variables
In VBA Macros, Variables are used to temporarily store information. This piece of information can be retrieved by your code and used or changed and then reused. In a lot of cases, using variables instead of setting values can make your code snippets and macros more reusable across files. For example, in a quiz you […]
Continue readingExcel Tip : Offset
In Excel there is a formula called “Offset”. This returns the value of a cell that is a given number of rows and columns away from a cell that you referenced. The syntax is =OFFSET(Reference, Rows, Columns). Reference is the cell you are going to refer to, or start from Rows is a number, it is […]
Continue reading