Call 1300 885 420
iTandCoffee | Patient help with your personal and business technology
  • Home
  • About Us
  • Classes
    • What's On
  • Appointments
  • Books | Videos | Tips
    • Books
    • Videos
    • Blog
    • Newsletter
    • Tips Library
  • Gift Vouchers
  • iTandCoffee Club
    • Members Area
    • About the Club
    • Membership Options
  • Store
  • Contact
  • Home
  • About Us
  • Classes
    • What's On
  • Appointments
  • Books | Videos | Tips
    • Books
    • Videos
    • Blog
    • Newsletter
    • Tips Library
  • Gift Vouchers
  • iTandCoffee Club
    • Members Area
    • About the Club
    • Membership Options
  • Store
  • Contact
Search by typing & pressing enter

YOUR CART

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

24/8/2022 0 Comments

How to modify and send an Excel spreadsheet when you don't have Excel

Picture
A client who uses only an iPad - doesn't have a computer - had been sent an Excel file to fill in. The sheets in the Excel workbook were all set up with calculations, and she just had to fill in some figures and return the sheet to the sender.

She is not a Microsoft 365 subscriber - so did not have Excel on her iPad. 

Luckily, there are ways to work on an Excel file without needing the Microsoft Excel app - and you can do this on a computer (Windows or Mac), an iPad, or on any other mobile device. And the solution does not need to cost you anything.

Read More
0 Comments

2/8/2022 1 Comment

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

Picture
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.

Read More
1 Comment

18/5/2022 0 Comments

The easiest way to share/send a Word, Excel or Powerpoint file

Picture
This week, I was assisting a business client who was having issues attaching an Excel file to an email in Outlook. The file was saved to Sharepoint, but when she tried to add that document to an email from her File Explorer, she got an error message that the file wasn't available - even though she could see it there in the list of files.

It turned out that the document had not successfully sync'd to her computer (indicated by a sync symbol that wouldn't go away) - which was resolved by her exiting the file, which she currently had open. This then allowed the file to sync properly to her computer.

But she was unaware of a simpler way of sharing that Excel file directly from Excel. So I figure this might be something that other readers have not yet discovered. 

Read More
0 Comments

2/4/2022 0 Comments

Data Validations in Excel - how to make sure only valid data is entered

Picture
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. 

Read More
0 Comments

16/11/2020 0 Comments

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

Picture
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!)

Read More
0 Comments

1/12/2019 0 Comments

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

Picture
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 ...

Picture
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.

Read More
0 Comments

    Receive great articles like this 
    fortnightly to your Inbox

    Picture

    Follow us on Facebook

    iTandCoffee

    Picture

    Join the iTandCoffee Club

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

    Join our growing community of local and online members who love learning about their technology - through FREE club sessions, remote/phone support, online tips, tricks and tutorials, special members-only offers and discounts, and more. Membership starts at only $49/year.
    Find out more about The iTandCoffee Club

    What's on at iTandCoffee ?

    Below is our list of videos, classes and other events that are coming up soon.
    ​Videos shown are offered for eligible members of the iTandCoffee Club.
    If you have questions, why not join fun and informative 'user group' meetings, held once a month.
    All iTandCoffee classes are run as online classes (using Zoom), which means you can attend from anywhere.

    Archives

    November 2023
    October 2023
    September 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    November 2012
    October 2012
    September 2012
    August 2012
    May 2012

    Categories

    All 1800-number Accessibility Accessories Activity Monitor Adware Airdrop Airplay Airpods Alarms Alerts Android Apple Id Apple-id Appleid.apple.com Apple Music Apple News Apple-pencil Apple Tv Apple Watch Apps App Store App Windows Apss Audio Autolock Automatic-downloadsupdates Automator Backup Backups Battery Be-connected Be-connected Bigpond Big Sur Bitcoin Blockchain Bluetooth Books Boot Camp Business Buying Guide Calendar Camera Canva Captcha Catalina Cellular Data Centrelink Channel 9 Charging ChatGPT Christmas Chrome Classes Client Stories Cloud Cloud-storage Cloud-storage Club Club News Colours Com Compass Contacts Continuity Control-center Control Centre Convert Cookies COVID COVID 19 COVID-19 Cybersafety Datad777f385d3 Data Usage Delete Desktop Dictation Dock Do Not Disturb Downloads Dropbox DVD Education El-capitan Email Emergency Emojii Entertainment ESIM Ethernet Evernote Excel Facebook Family Family History Files Finance Finder Find My Find My Car Find-my-iDevice Fingerprint Sensor Fonts Force Reboot Forgetting Curve Fraud Free Friday Gift Ideas Gmail Google Google Drive Google Flights Google Photos Google Sheets Guides Handbrake Handoff Handy Hints Hard-drive-crash HDD Health High Sierra Home Button Homepod Home Screen Hotmail Housekeeping Humour ICloud ICloud Backup ICloud Drive ICloud Family ICloud Photo Library Identity Theft Images Image-to-text IMAP IMessage Imovie Instagram Internet Internet Issues Internet-options Internet-options Ios Ios-11 Ios-11 Ios-12 IOS 13 IOS 14 IOS 15 IOS 16 IOS 17 Ios Photos Ipad Ipad-tips Iphone Iphone-12 IPhone 13 Iphone8 Iphone-8 Iphone Basics Iphone-calendar Iphone Settings Iphonex Iphone-x Ipod Itandcoffee Itandcoffee Club Itandcoffee News Itandcoffee Services Itandcoffee-swap-shop Itandwine Itunes Junk Keyboard Keychain Kidsandtechnology Kids And Technology Lifestyle Lock Screen Mac Mac-basics Mackeeper Mac Mail Mac-mail Mac-monday Macos Mac Photos Mac-photos Mac Tutorials Mac-videos Magnifier Magsafe Mail Malware Maps Measure Media Medical-id Messages Messenger Microphone Microsoft Microsoft 365 Mobile Banking Mobile Data Mobile-data Mobile Porting Mojave Monterey Mouse Movies Multitasking Music MyGov My-health-record NBN Netflix Notes Notifications Number Porting Office 365 Onedrive Onenote Online Safety Online-safety Optusnet Os-x Outlook Pages Parental Controls Passwords Paypal PDF Personal Hotspot Phishing Phone Photo Book Photo-books Photos Photos On Mac Podcasts Popups Powerpoint Preview Printing Privacy Productivity Product Launch Publicity Publicityads57a389ac69 Purchasing-an-idevice Qa QR Code Quicktime Raise-to-wake Ransomware Reachability Reboot Recommendations Recovery Relay Reminders Remotewipe Repairs Restore Restrictions Rings Rotation-lock Router Safari Safari-favourites Samsung Santa Scam Scam Email Scams Scan Scannable Scanning School-ipad Scoopit Screen Screen-brightness Screensaver Screenshots Screen Time Scrolling Secondhand-devices Security Sell Seniors Seo Services Sessions Settings Share Shared-calendar Shop Shopping Shortcuts Sierra Signature Silent-auction Sim Siri Skype Slideover Slides Slideshow Slideshows Slow-device Slow-mac Smart-tv Sms Snapfish Socialmedia Social Media Softwareupdate Software Update Software Updates Sonoma Sounds Spam Spinning-beachball Split Screen Split View Spotlightsearch Startup Storage Storage Space Streaming Subscriptions Sunrise Switch Symbols System Preferences Task Manager Tasks Taskswitcher Task-switcher Teams Technology Technologyarticles Technologydependency Technology-lifestyle Technology-solutions Technologytips Techsupport Telco Telcos Telstra Telstracomplaint Text Text Replacements Theft The-katering-show Thermomix Thesenior Timemachine Time-to-leave Tio Toys Trackpad Training Videos Transcribe Translate Travel Travel Sim Tripadvisor Troubleshooting Tutorial Tutorials Two Factor Authentication Twofactor-authentication Two-step-verification Typing Typing Shortcuts Undo Universal Control Unlock Update Updates Upgrade Uppercase Usage User Group Utilities Ventura Video Video-blog Videos Virus Voice-and-data Voicemail Voice-memos Volume Vpn Wallet Wallpaper Warnings Weather Web Browser Website Weebly Whatsapp Widgets Wifi Wi-fi Wifi084d04ddac Wifia524b72547 Wifi-calling Windows Windows10 Windows-10 Windows-11 Word Wordpress Worldclock Yosemite Youtube Zoom

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
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.

Services
Classes
Event Calendar
Private Appointments
Gift Vouchers
Remote support
​Business Services
​Help for families

Online Content
​Newsletter
User Guides
Video tutorials/classes
Tips and Hints
​Blog
iTandCoffee Club
About the Club
Free Club Sessions
Sign In/View Account
Members Area
Prices/Policies
Prices
Privacy
Cancellations, Refunds, Returns
About iTandCoffee
Home
About

​Contact us
Testimonials
In the press

Picture
​© 2012-2023 iTandCoffee Pty Ltd. All rights reserved  ACN: 606 340 434