Want to design your own website without having to buy software? Or are you using a CMS and want to know more about CSS and styling? Click on the posts below to follow the series of posts. HTML Basics HTML Lists HTML Links HTML Images CSS Basics CSS Border CSS Selectors HTML & CSS Layout
The Multiplication Table Challenge & Solution
Can you enter a formula in cell B2 that will multiply the numbers in column A by the numbers in row 1, creating a multiplication table? This should be one formula copied across the remaining cells. Can you do it? Read here to see how.
UPPER, lower & Proper In Excel
This week’s blog post looks at 3 text-related formula : UPPER, LOWER & PROPER. Click Here To Read More…
Office Design Tip
Want to know how to quickly and easily create 3d looking banners and ribbons like the above? Click here to read more
How To Add Macros To Custom Toolbar
This week’s blog post looks at how to add macros to the custom toolbar in Excel, or indeed other MS Office apps too. Click here to read more…
Unplugging
It’s Time To Unplug Even geeks need to unplug now and again. I’ll be back to normal mid-September
A Quicker Way To Create VLookUps Across Multiple Columns
Click here to read the full post. Have you ever had to create several VLookUps across multiple columns and found it to be a slow (sometimes confusing process)? Here I show you how to create one VLookUp and then slightly change the formula so you can then copy it and apply to more than one column.
A Simple Maths Formula
Can you figure it out?
PowerPoint Animation Tip : Leave it to the end
When it comes to designing presentations and animating your slides, the first piece of advice I would give you would be to leave it to the end!! I have seen so many presentations with good content ruined by rushed or bad animation. Click here to read more…
Excel VBA Macros
This is a link to our Excel VBA Macros page, which includes a demo video based on an example of a macro created which reduced a task from 1.5 hours per week to a few minutes.
- Page 1 of 2
- 1
- 2