Through this website my mission is to show you how to do all things Excel from writing your very first IF statement to creating useful tools and VBA scripts that will help you automate a variety of complicated tasks.
The guides cover a range of topics so whether you are a casual user looking to improve your knowledge, a student studying Excel, or a budding Excel expert working in the business world you can use this site to take your Excel knowledge to that next level.
“Easy to read and understand, step-by-step guides with images and downloadable sample files. These guides show you how to implement your new knowledge, not just a formula.”
There is already a resource of many useful guides on this website and new ones are added regularly so please be sure to bookmark this website. You can follow us on Twitter to find out when new posts have been added, or get the RSS feed to get all the latest guides straight to your email account. You never know when that next guide will be just the problem you have been looking to solve so don’t miss out!
We also have a Share feature at the bottom of every post so why not help out a friend in need and Share any useful posts you read via FaceBook, Twitter or one of many other channels provided.
If you want to get involved or have a question relating to one of the guides please leave a comment or contact me via Twitter.
- Scottish Football Fixtures 2017-18 in Excel
After a few requests I have added the Scottish Football Fixtures for the 2017-2018 season in Excel format, again both XLS and XLSX formats are available so please download which version is relevant for you. This is the first time…
- How to Add comments in Excel formula
A little-known trick in Excel is adding a comment to the Excel formula, a comment like a brief description of what the formula does in layman terms that other users may find helpful. To find out how to add a…
- How to Remove PageBreaks in Excel with VBA
This post came about as a client of mine introduced a document classification product called Titus that works as an add-on to Microsoft Excel. The Titus classification add-on caused an unexpected consequence, when you set the security classification of the…
- UK Football Fixtures 2017-18 in Excel format
A year, and another football season, has passed and the promise of a new season starts today with the release of the UK Football Fixtures for the 2017-2018 season. I have published the UK Football fixtures in Excel format for…
- Create an Excel Chart with a Scroll Bar
Scroll bars, or Sliders on an Excel Chart are a great addition if you are building interactive Excel Reports and Dashboards. This guide will walk you through the steps in creating an Excel Chart with a scroll bar… Why add…