Create a Sparkline to show data trends in Excel
I can hear you asking it now, what is a Sparkline? It’s a very good question which I’m going to answer for you now. Sparklines were introduced in Excel 2010
I can hear you asking it now, what is a Sparkline? It’s a very good question which I’m going to answer for you now. Sparklines were introduced in Excel 2010
Many people have heard about Excel’s VLOOKUP and HLOOKUP functions but have unsuccessfully used them. This Vlookup tutorial will solve any confusion you have about using either of these lookup
For years I have been creating screenshots for various reasons; for use in training courseware; to illustrate to a remote user a button I want them to press; to relay
Microsoft Excel provides a great way to summarise and analyse data using charts. The terminology used can differ between referring to them as charts or an Excel graph. Either way
Microsoft Excel is a fantastic program allowing you to collate, analyse and sort data in various formats. Gone are the days of needing a calculator beside you to manually work
A common feature used within all of the Microsoft Office applications is the cut, copy and paste feature. I personally use this A LOT. The ability to cut, copy and
At the start of almost every Microsoft course I teach, I discuss the options you have to customise any of the Microsoft Office products. The Quick Access toolbar (QAT) is
This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it
For anyone who is completely new to Excel or is wanting to venture into the world of formulas and functions, this post is here to give you some basic tips
Any of the Microsoft Office programs includes the ability to create a PDF file for you. I’m always surprised at how many people are still unaware that this function is