Computer Tutoring Logo
Est. 2002
Menu Button

Excel Questions and Answers

Below is a list of the common questions that I get on Excel training courses along with some answers that I hope are of help to others.

Excel If Cell is Empty

Need to check if a certain cell is Empty? Then you can use the ISBLANK() function. It may get you out of a thorny problem.

Create a drop down list in Excel

A drop down list is one method of making sure someone doesn't enter an incorrect value. This incorrect value can so easily mess up all of your data. Let's create a drop down list in this tutorial and see yourself how it can help you.

Excel Formula for Working Days

Just how do you calculate the number of working days between two dates? What's the formula you would use? This help file will show you how to use Excel along with the NETWORKDAYS function to do just that. I've been so kind as to include as list of public holidays from 2010 all the way to 2020 just to help you along. (Aren't I kind?)

Excel Phone Number - the Problem of the Missing Zero

You enter a phone number, it obviously starts with a zero. You press enter, the zero disappears. What has happened? More importantly, how do you prevent it? In other words how do stop the zero from disappearing. See why and how with this short explanation.

Using the OFFSET function

The OFFSET function is one for the repetoire. So if you have either seen it around the sheets you've been updating and wondered what it's all about. Or even if this is the first time you've seen it and want to include it in your Excel formulas then take a look at this guide.

VBA Code to Consolidate Data from Multiple Sheets

Tutorial showing you how to copy VBA code from multiple sheets into one sheet. See this step by step guide along with exercise files detailing how you can do create this extremely handy sub procedure.

Create Alternate Coloured Rows by Using Conditional Formatting

Here you will learn how to create alternating row colours by using Conditional Formatting with a formula.

Join mailing list!

Sign up to receive our monthly newsletter including special promotions, hints & tips, and the latest Computer Tutoring news!


Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.

We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.

We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at

By using our website, you consent to our use of cookies for the purposes outlined above.

For more details, please read our full Privacy Policy.