Excel Issues Day 4 – How to enter formula correctly

Are you working with long PowerPoint Presentations?  Use Sections to divide your presentation into manageable chunks. We all know that we should avoid have death by Powerpoint. And that we should have as few slides as possible. However, sometimes for corporate presentations, or reasons beyond your control you have a large number of slides in…

How do you send newsletters and mailings to your customers?  Using email marketing enables you to send out numerous mailings to address lists, as well as keeping customers details confidential.  You will get a report on how many people have opened your email, what links they click on, and even the peak time for opening…

Has your job role suddenly changed to involve a computer?  This can be one of the hardest transitions to make if you have gone from a hands-on role using machinery, or been working on a building site or suddenly been promoted to a role that involves a computer.  You have all the capability and the…

Many people complain that they can’t use Pivot Tables and struggle to make them work. One of the big issues is the raw data they are using. Have a look at some of the common problems, and see if you can spot them in your data! Blank Rows or columns – a blank row or column…