It’s easy to fall into a habit, and manually type in a formula and copy and paste it within a worksheet. If so, you may not be getting the most out of the Formula tab on the Ribbon. From here, you can save yourself time by using Excel’s ready made formulas using Functions. The Formulas tab has […]
One of the best tips for Excel that I’ve ever been given is “if you can automate it…set up a formula”. There is nothing more frustrating than trying to figure out calculations if you don’t understand the rules – Excel can do the number crunching, which means I can focus on adding the data and […]
If you’ve used Excel for some time, you may want to learn more about the different logical functions such as IF, AND and OR. This post describes how these functions can be combined to perform very useful composite logical operations. IF Function The IF function will carry out one of two actions. One action is […]
The convert function is used to change data from one unit type to another in Excel. It’s often used to convert dates, but it can do so much more as there is a range of conversion units that you can use to make your life easier. The convert function is an engineering function. In Excel […]
In one of my earlier blog posts, I looked at how an Excel formula can add working days to a date. This was for a manager who wanted to set up deadlines for the tasks to be completed within the team’s appraisal meetings. I want to build on this and find out how to add […]
I use Excel for planning work and setting deadlines and I always work better if I know the due date for a piece of work. I used to manually work out the number of working days between dates, using my Outlook calendar, and then switching between screens to then add the dates to my Excel […]