- Home
- tips and tricks
Sum Odd or Even Numbers only in Excel
Pardon the pun, but it may seem like an ODD request to want to know how to sum odd or even numbers only in Excel, but it is still a question asked. Since being asked for help on this, I have started using this formula myself recently where I need to sum odd numbers and […]
Continue readingCustom Sort
So, you can sort from A-Z, Z-A, smallest to largest number and so on, but can you create your own custom sort? Let’s base our custom sort on this data: Before going onto the custom sort, let’s very quickly look at “normal” sorting. If you are comfortable with the normal sorting, you can skip […]
Continue readingAvoid #REF! in Excel by knowing your Dependents and Precedents
Have you ever opened a file in Excel and saw the dreaded #REF! where a formula result should be. I usually see people fixing this formula by removing the section with the error, or guessing what range should be entered instead of the #REF!. This may work a lot of the time, but it might […]
Continue readingHow To Auto Fill Sequential Letters in Excel Video
To date, the blog post “How to auto fill sequential letters in Excel” is my most searched post (click here to read how to auto fill sequential letters in excel). For this reason I thought it was worthwhile creating a video breaking down the formula. As well as the formula itself, I also often get […]
Continue readingPowerPoint & The Star Wars Opening Effect
It’s hard to believe, but apparently there are people out there who have not seen any Star Wars movies!! For those of you that have seen it, I am about to show you how to replicate the opening text sequences using PowerPoint to create the PowerPoint Star Wars Effect. For those of you that have […]
Continue readingSimplify IF AND OR eBook
My second eBook is almost ready! It is now being reviewed and will be available soon to all subscribers. This time around we look at IF AND OR functions – these are areas where I am frequently being asked for help to clarify.
Continue reading1 Tip For More Effective Meetings
In an earlier post I wrote about my pet hates when it comes to meetings and ways I thought could lead to more effective meetings (The ABCs of Good Meetings). Now I would like to add 1 more tip for more effective meetings. 1 Tip for more effective meetings So, I have seen an improvement […]
Continue readingUsing Pivot Charts For Better Analysis
Using Pivot Charts when analyzing data can show you more in one image and quicker than standard charts where you may have to create multiple charts. In this image, there are two standard charts showing the sales by person and the sales by region. But to the right we have a Pivot Chart which shows […]
Continue readingVLookup with multiple values
So, you can use a VLookUp to retrieve a piece of information. You can use SumIf to total a range based on criteria and you can use CountIf to count how many times criteria appears. What do you do though when you have to create a VLookUp with multiple values? The VLookUp will run through […]
Continue readingEXCEL SUBSTITUTE FUNCTION
I have been coming across more and more cases where people have problems with lookup formulas because databases do not have matching information. The most common type of incident I come across are where one database contains a name like “Adam O’Reilly” and another database has the name as “Adam OReilly”, with no apostrophe. So […]
Continue readingSelecting Next Cells In A Different Order
If you have ever used Excel, you probably know already that you can move from your current cell to the one to the right, or below by using the tab or return keys. So what if you want to select the next cell, but the next cell is not in the normal order? For example, […]
Continue readingWhy have a website?
Why have a website? This is a link to an article I published recently on LinkedIn.
Continue readingLayout With Columns
Improving your layout with columns is easy to do. Whether you want to set a layout with 3 columns, or a 3 column layout, it’s simply and gives very different results. I say 3 columns, but this could be 2, 4, 5 whatever you want (the more columns you have, the less impressive the page […]
Continue readingHTML5 CSS LAYOUT
So, you can display text and images on screen, you can insert numbered lists and bullet point lists, you can change elements of the page, but you’re probably not feeling as warm and fuzzy about your website as you feel. Let’s look at HTML5 CSS Layout now, “div” in particular and then hopefully you will […]
Continue readingCSS Selectors
CSS Selectors allow us to target and style specific elements of our webpage. In the last post, we applied borders and fonts to different headers in our page. The different level headers (h1, h2, h3) are different elements of the page. In the CSS file, we use CSS selectors to select and style those […]
Continue reading