Wildcards *?~….what am I talking about? And no, it’s not an expletive. Let’s start with an example. COUNTIF using Wildcards What say you wanted to count the number of cells containing the word ‘apple’ in this table. You could simply use a wildcard (an asterisk, *, is a wildcard in Excel) in your COUNTIF formula [...]
August 2011
In Excel there are two almost identical functions; SEARCH and FIND. The SEARCH and FIND functions allow you to find the location of text within a string of text. They’re identical because they perform the same function except the FIND function is case sensitive, whereas the SEARCH function is not, and SEARCH allows the use [...]
Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data first? If you use Access then this is a great productivity booster because once you connect to your Access query you simply refresh the data connection and your Pivot Table updates, as do any charts [...]
So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look at our options to make this better: Chart Axis Alignment We could use the alignment tools. Right-click axis > Format Axis > Alignment. But before you waste time doing this there is a better way. [...]
One of the Excel questions I get asked often is; how do I add a secondary axis to my chart? It’s actually quite easy but there is a trick to it. Excel Secondary Axis Trick Step 1 Let’s take this data. Now, the first thing you want to do is simply insert your chart. Insert [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
