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…
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.
Blog
The JayTray Blog Head over to the JayTray Blog site. Blog posts include tutorials and tips and tricks covering a range of computer and process improvements techniques.
WocS
WocS WocS is about Working Smarter – doing more with less. It includes a collection of process improvement tools and techniques that can be applied to your processes to improve your processes, flow, workplace and reduce waste, pressure, stress and time taken to complete tasks. The techniques involved include 5S Six Sigma Lean WocS (Work [obair cliste] Smart) also includes …
9 To 5
The JayTray 9To5 9To5 is aimed at people who work with computers. Covering everything from the basics to more advanced training for people who are comfortable with computers, but want to further their knowledge and skills. 9To5 involves working with you to review your needs and tailor training to meet those, rather than giving a predefined “off the shelf” training …
For Fun
The JayTray For Fun The JayTray For Fun is all about the fun side of computers. Training is aimed at anybody that wants to know more about the fun side of computers, covering areas including (but not limited to) Basics of computers E-mail Web Social Media Photo editing Video editing Skype Office Windows Past trainees have included college students, retirees, …