Tag Archives: microsoft excel

Excel’s Newest Function XLOOKUP

Posted on February 23, 2020 by

VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features … Continue reading →

Posted in Excel, excel function, Microsoft Office | Tagged , , , , , , | Leave a comment

How to Enter a Series of Dates in Excel That Are Only Weekdays

Posted on August 21, 2016 by

Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays.  All … Continue reading →

Posted in Excel, Microsoft Office | Tagged , , , , , | 1 Comment

Copying Excel Data into a Word Document

Posted on May 2, 2015 by

If you use both Excel and Word you may well want to copy data from Excel into Word and what would be really convenient is if the data in Word updated when you change it in Excel. Well that is … Continue reading →

Posted in Excel, microsoft word, productivity | Tagged , , , , , , , | Leave a comment

Selecting Data in Non-Adjacent Cells to Create Excel Chart

Posted on January 10, 2015 by

Creating charts in Excel is pretty straightforward and you can see how to that in this video, getting started with charts. What normally happens is you select a group of cells and then insert a chart but what do you … Continue reading →

Posted in Excel, Microsoft Office | Tagged , , , , , , | 1 Comment

Excel: How to Create a Custom Function

Posted on May 31, 2014 by

Excel has lots of built-in functions that do everything from summing up a column or row of numbers to loan repayments, statistics, engineering, trigonometry and so much more. Every now and again someone asks how they can create their own … Continue reading →

Posted in Excel, VBA, Visual Basic for Applications | Tagged , | Leave a comment

How to Use Excel PivotTables

Posted on February 17, 2014 by

Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick … Continue reading →

Posted in Excel, Microsoft Access, Microsoft Office | Tagged , , , , | 1 Comment

Excel Using Text Functions

Posted on December 28, 2013 by

Excel is great for dealing with numbers but it also has functions for dealing with text. You can check in a bit of the text by extracting it using one of the functions like LEFT, RIGHT and MID.  You can … Continue reading →

Posted in Excel | Tagged , | 1 Comment

Excel How to Use Subtotals

Posted on December 27, 2013 by

Excel is packed with lots of great tools. One of my favourites is the Subtotals. Here you can take a list, sort it into order so that appropriate items are grouped together, then click a button and it will determine … Continue reading →

Posted in Excel | Tagged , , , , | 1 Comment

Combining VLOOKUP and HLOOKUP Functions

Posted on December 26, 2013 by

HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and … Continue reading →

Posted in Excel, Office 2010 | Tagged , , , , | 2 Comments

Excel 2010: Conditional Formatting

Posted on October 29, 2012 by

Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly … Continue reading →

Posted in Excel, Office 2010 | Tagged , , , | Leave a comment