Handy hints, tips and tricks for iPad, iPhone, Mac and more

2/8/2021 0 Comments

If you have an Excel file that you need to use over and over - create a Template

If you have an Excel spreadsheet that you use over an over - perhaps using the Save As function to save as a new version each time you need to re-use it - it's really worth considering saving it as a Template instead.

0 Comments

8/4/2021 0 Comments

Data Validations in Excel - how to automate validation of dates entered into cells

In the Excel Boot Camp series of classes and videos, one of the important topics that we cover in Part 5 is Data Validations - how to set up automated validations to ensure that entries into cells are correct. For example

Date validations - making sure the entered date is after and/or before a particular date, where that other date is perhaps in another column.
Text validations - making sure the text contains a particular character or string or pattern
List validations - making sure that the value entered into the cell is one of the values in a list of valid values

and so much more.

This week, we include an extract from Part 5 for iTandCoffee Club members, showing how to automate the validation of dates entered into cells in a column.

0 Comments

16/11/2020 0 Comments

How to quickly convert a whole column of numerics/non-numerics to text in Excel

Image by Pexels from Pixabay

What I love about my job is that, nearly every day, I have one of those "I didn't know that!" moments - for example, where I find out there is a quick way to do something that was otherwise quite tedious and potentially error prone.

I have regularly come across the problem in Excel where a column includes values that are generally numeric, but can also sometimes include an alphabetic character. Excel will often assume that the numeric value is number, when I really need the whole column to be treated as text.

When this happens, it can cause problems for any formulae that try matching against the column values - if the formulae expects text, but the value stored is numeric. Changing the overall column format to text is not enough - the numeric values already in the column remain as numbers even when this is done.

In preparing one of the recent Boot Camp sessions for Microsoft Excel, I discovered that that there is such an easy way to convert a column like that so that all entries are text - with no need for formulae or copying and pasting values (which is what I used to do!)

0 Comments

1/12/2019 0 Comments

How to print an Excel worksheet so that it fits across a single page

If you are new-ish to Excel, you may have found that printing of your Excel worksheet can be a tad challenging - working out how to ensure that the worksheet is not split across multiple pages and impossible to read.

There is a simple trick to ensuring that your worksheet's width is set to fit one page - and we have recorded a short tutorial on this topic for our iTandCoffee Club members.

Printing Excel worksheets to fit 1 page width

Let us know your own Excel question or issue in the comments below - and we will include a 'how to' it in a future article on this blog.

Not yet a member of The iTandCoffee Club?

Join before Christmas 2019 and you will receive an extra 3 months on your 12-month subscription - 15 months for the cost of 12!

0 Comments

28/12/2018 0 Comments

What to do if Excel won't let you edit or save a file ...

If you are running a newer version of Microsoft Excel on Windows, you can sometimes find that it stops you from editing and saving an older Excel file - or (like an iTandCoffee business client recently found) from editing and saving a temporary Excel file created by some old software that you are running

There is a way that you can adjust Excel's file protection settings to allow you to edit and save these files. Visit the Options settings (found in the File menu). The relevant settings are found in the Trust Centre option.

Watch this short video for further details.

0 Comments

27 Sycamore St, Camberwell, Victoria Australia

Call 1300 885 420

to book an appointment or class, or to enquire about our services and products

SENIORS CARD WELCOME HERE:
Seniors Card holders qualify for a 10% discount on all classes booked and paid for online (excludes PTT sessions and classes already discounted during COVID-19 crisis). To activate the discount at the time of booking, select Redeem Coupon or Gift Certificate and enter 10OFFSEN before selecting Pay Now.

YOUR CART

Tips, Tricks and News
about all sorts of technology in your life!

If you have an Excel file that you need to use over and over - create a Template

Data Validations in Excel - how to automate validation of dates entered into cells

How to quickly convert a whole column of numerics/non-numerics to text in Excel

How to print an Excel worksheet so that it fits across a single page

What to do if Excel won't let you edit or save a file ...

Receive great articles like this
fortnightly to your Inbox

Follow us on Facebook

Join the iTandCoffee Club

for free content, tutorials, videos, classes, offers, discounts and more

What's on at iTandCoffee ?

Archives

Categories

Call 1300 885 420

to book an appointment or class, or to enquire about our services and products

YOUR CART

Tips, Tricks and News about all sorts of technology in your life!

If you have an Excel file that you need to use over and over - create a Template

Data Validations in Excel - how to automate validation of dates entered into cells

How to quickly convert a whole column of numerics/non-numerics to text in Excel

How to print an Excel worksheet so that it fits across a single page

What to do if Excel won't let you edit or save a file ...

Receive great articles like this fortnightly to your Inbox

Follow us on Facebook

Join the iTandCoffee Club ​for free content, tutorials, videos, classes, offers, discounts and more

What's on at iTandCoffee ?

Archives

Categories

​​Call 1300 885 420 ​to book an appointment or class, or to enquire about our services and products

Tips, Tricks and News
about all sorts of technology in your life!

Receive great articles like this
fortnightly to your Inbox

Join the iTandCoffee Club

for free content, tutorials, videos, classes, offers, discounts and more

Call 1300 885 420

to book an appointment or class, or to enquire about our services and products