Create Excel dashboards quickly with Plug-N-Play reports.

Whats your biggest need?

We're happy to help.
Contact our internet marketing
pros for a fast reply.

pc upgrades

This form has received the maximum number of entries.
  • Sharebar

Today I thought I would update you on all the services we offer. Often people are surprised at just what we can do and outsourcing jobs to us is often a way to get things done more efficiently and cheaper. I have also included some Office 365 news as usual.

Outsource Your Tech Today


We have been in business here in Australia for 20 years. Some of our staff have more than 25 years’ experience in computing and business. We have been active in the web since 1995. As a result, we have a significant skill set that you can take advantage of.

First some reasons why.

Can your business afford?

  • Missed sales and opportunities
  • Negative feedback – people talk about your business in social media
  • Wasted money

Common Mistakes of DIY

  • Buying unsuitable equipment on “special”
  • Incorrect licensing of software
  • Making the assumption the cloud is free
  • Untested backups, DR and BCP
  • Leaving it to untrained Gen Y staff
  • Inappropriate use of social media for business

Some of the products and services we can offer you

  • Advice – we employ professionals in these areas:
    • Business Architecture and Digital Strategy
    • Web Development and Design
    • SEO (Search Engine Optimisation)
    • SEM (Search Engine Marketing)
    • SMM (Social Media Management)
    • Reputation and Brand Management
    • Photography and Graphic Design
    • Sys Admins and Database Experts
    • Office Productivity Gurus
    • Writing and Content Development
  • Hardware:
    • Computer sales, repairs and upgrades – from basic business PCs to high end graphic design and gaming PCs
    • Mobile devices (phones, tablets) – sales, upgrades and connection
    • Internet connection – ADSL, NBN and Mobile Broadband
    • Wired and Wireless Networks – design, installation and security– design, sales, installation and configuration, racks and data storage
  • Software
    • Office 365 connection, setup and installation
    • Data migration – office accounting systems into the cloud, data storage into cloud
    • Website development, new sites, upgrades, ecommerce platforms, integration to store
    • Social Media - policy, setup and account management
    • Excel VBA development – spreadsheet design, automation, reporting tools and budgets
  • Training
    • Microsoft Office training – productivity and efficiency gains guaranteed
    • Website management
    • Social Media Use and Management

Talk to us about significant advantages to your business by OUTSOURCING YOUR TECH

Office 365 News

Using Skype for Business? If not why? Either way here are 8 features you didn’t know you needed for online meetings.

New Feature: Filtering common malicious attachment types in Email. Learn more about creating organisation wide settings to limit attachments of malicious file types. Ask us if you want this feature enabled.

Upgraded feature: The People Profile experience is being updated in Office 365. We are already using the new profile pages and it is a definite improvement when working with Delve. Ask us about how to improve your organisations information usage and sharing.

New feature: Integrate Dropbox into your Office 365 online experience. Ask us to talk through and plan this upgrade if you are heavy users of Dropbox.

Office 365 is changing all the time, schedule your free 6 monthly audit with us to see how you can take advantage of the tools that are available in your subscription

Follow Us On Social Media

As always Jethro is your web, cloud and technology specialists. I am constantly learning new things and spending time researching, playing and testing new systems and reading about other people in the IT world doing the same thing. If you want to follow along with what I share in various spaces, then connect with me:

Did you know that Windows 10 is being released tomorrow?


The world’s largest Software as a Service SaaS operating system release ever also marks the end of Windows as we know it. It will never again be released as an operating system the way we have known it up until now. Rather the company will begin releasing upgrades and future “versions” as streamed updates. I will talk about some of the changes in this edition as well as some important information. There are also some important changes for our Office 365 customers and I mention them also.

Telstra Increases Office 365 Pricing in line with Microsoft Changes

telstra apps marketplace pricing

Telstra announced a couple of days ago that they will be increasing Office 365 pricing across the board in line with Global Microsoft Price changes. However there are some important things to know.

First of all while Microsoft changes are as of 1 August, Telstra isn’t changing until 1 September so you get 1 more month to buy additional licences at the old price.

Second, the changes only impact you when you end your current contract period (this is the 12 month anniversary of your original subscription date).

When you login to Telstra Apps Marketplace you should be able to see a table that lists your services and the contract period. This Telstra Apps Marketplace FAQ webpage has step by step instructions on how to see this.

Contact us now if you would like to learn more about taking advantage of the current pricing or how the new pricing changes coming in September will affect you.

Windows 10 is Coming Tomorrow


In a major change starting 29th July 2015 Microsoft is ending the Operating System version process as we have known it since at least 1995 when they released Windows 95. From now on all updates will be released as they are tested and made available to all users around the world via the internet. No longer will your operating system be old or out of date. For a 12 month period all existing Windows 7 and Windows 8 /8.1 users will be able to upgrade to Windows 19 for free as well. New machines will be sold with Windows 10 installed and will then update online to the current version.

The upgrade process is fairly simple. Once the upgrades are made available to you (there is a staged release cycle so not everyone will get it on the 29th necessarily) your computer will run preliminary checks to ensure that both the existing hardware is capable of supporting Windows 10 and that you have no known issues with the upgrade. The upgrade will commence and the existing operating system will be rolled back if it experiences problems. There will be no loss of data in either case. Applications will continue to work and your connected peripherals (providing they are compatible) will continue working.

We are recommending that customers ask us to run this for them. Of course if you want to do it yourself you can and we don’t anticipate issues for those of you who are not running server based networks. We suggest waiting for all those businesses with a server and asking us to book a time to manage the upgrade over a weekend or some other time when we can have the least down time for your staff.

Talk to us about Upgrading today. We are anticipating a number of our customers to upgrade from Windows 7 fairly soon so will need to book you in sometime in August or September.

We have some special deals – we will charge only $149 for a single machine upgrade (ensuring we have a backup first). Talk to us about bulk machine pricing.

Windows 10 Changes from Windows 7 and 8 /8.1

windows 10 start screen

One of the biggest changes is the revised start screen. It brings back the familiar Windows 7 interface with windows 8.1 live tiles. It is fully customisable and apps can be dragged and dropped, resized and added to groups. Unlike Windows 8 this start screen personalisation will not sync to all your devices as individual devices have different uses and different screen sizes so can be personalised individually.

windows 10 notificationsNote all the familiar icons can be pinned to the taskbar as in 7 and 8. The new icon directly to the right of the search box is the app switcher – allowing the ALT TAB application switching command to be clicked or touched.

Modern or touch screen apps from windows 8 can now run in a window and do not have to be full screen.

Touch Devices, tablets and 2 in 1 devices will automatically identify what mode they are in, keyboard or touch and change automatically. This can be set to ask you before changing. However it makes the rapid transition from a touch device to a keyboard interface very simple.

A new notification centre on the right hand side (similar to android phone and tablets and windows phone notifications centres) displays on the right hand side and also allows quick access to settings.

Wi-Fi Sense in Windows 10 is a Potential Security Risk


Most people use a wireless network or Wi-Fi access via their home or office modems for mobile devices including phones, tablets, laptops and even desktop PCs. There is a new setting in Windows 10 called Wi-Fi Sense. By default this is turned on but can be easily switched off. However turning it on can create a potential security risk as it allows you to share your Wi-Fi network settings to your friends so they can access your network. Doing this allows them to also share that with their friends. There is a solution and that is to change the name of your Wireless Access Point or SSID. These links explain the Wi-Fi Sense settings:

And this page tells you how to change your SSID. It will need to be named with an “_optout” at the end.

we can re-configure your router remotely quickly and easily

Follow us on Social Media

As always Jethro is your web, cloud and technology specialists. I am constantly learning new things and spending time researching, playing and testing new systems and reading about other people in the IT world doing the same thing. If you want to follow along with what I share in various spaces then connect with me:

What’s the biggest challenge facing you in business right now?

If you don’t read the rest of this article maybe just take 30 seconds to email me and send me an answer to that question. It’s possible I can locate something or know something that can help you. Or maybe one of my other clients can; the power of networking is invaluable!

Seminar Update


If you missed the seminar we will be holding a repeat one. However we are aware Wednesday mornings are not good for a lot of people. We are also prepared to come and do a customised version directly with customers and their staff for a flat fee.

Contact us now if you want to do this for Your Business

Windows 10 Specifications

More and more information is coming out around Windows 10 and the specifications have now been released for the upgrade. There potentially will be deprecations of applications and features. The official Windows 10 Specifications page lists the minimum requirements for hardware and also lists all the potential issues.

WARNING! At this stage if you are running a small business network with a server we don’t recommend upgrading to Windows 10 yet. If you are running individual PCS then there should be no problem, but I would recommend either doing it on a non-critical machine first or asking us to assist. Finally you should have a Microsoft ID before upgrading. Windows 8 users will likely already have one but Windows 7 users might not.

Talk to us first if you are not sure about updating to Windows 10.

Office Shortcut Keys


Learning to use Office applications effectively is critical for information workers. So many hints and tips are out there it is sometimes hard to know where to start. Even the little ones we provide in these newsletters or online are just a drop in the bucket.

Today we are going to show you a bunch of really effective short cut keys that we use regularly and that once mastered will speed up your use of Excel. Print these out maybe and put them near your screen. I have highlighted the best ones that are my constant use Go Tos.

Keys for moving and scrolling in a worksheet or workbook

Arrow keys: Move one cell up, down, left, or right

CTRL+arrow: key Move to the edge of the current data region
HOME: Move to the beginning of the row
CTRL+HOME: Move to the beginning of the worksheet
CTRL+END: Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
PAGE DOWN: Move down one screen
PAGE UP: Move up one screen
ALT+PAGE DOWN: Move one screen to the right
ALT+PAGE UP: Move one screen to the left
CTRL+PAGE DOWN: Move to the next sheet in the workbook
CTRL+PAGE UP: Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB: Move to the next workbook or window
CTRL+SHIFT+F6 or CTRL+SHIFT+TAB: Move to the previous workbook or window
F6: Move to the next pane in a workbook that has been split
SHIFT+F6: Move to the previous pane in a workbook that has been split
CTRL+BACKSPACE: Scroll to display the active cell
F5: Display the Go To dialog box
SHIFT+F5: Display the Find dialog box
SHIFT+F4: Repeat the last Find action (same as Find Next)
TAB: Move between unlocked cells on a protected worksheet

Keys for moving in a worksheet with End mode on

END: Turn End mode on or off
END, arrow key: Move by one block of data within a row or column
END, HOME: Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
END, ENTER: Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)

Keys for entering data on a worksheet

ENTER: Complete a cell entry and move down in the selection
Start a new line in the same cell
Fill the selected cell range with the current entry
Complete a cell entry and move up in the selection
Enter an array formula (must be used when editing an existing array formula)
Complete a cell entry and move to the right in the selection
Complete a cell entry and move to the left in the selection
Cancel a cell entry
Delete the character to the left of the insertion point, or delete the selection
Delete the character to the right of the insertion point, or delete the selection
Delete text to the end of the line
Arrow keys:
Move one character up, down, left, or right
Move to the beginning of the line
F4 or CTRL+Y:
Repeat the last action
SHIFT+F2: Edit a cell comment
Create names from row and column labels
Fill down
Fill to the right
Define a name

Keys for working in cells or the formula bar

BACKSPACE: Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents
ENTER: Complete a cell entry
CTRL+SHIFT+ENTER: Enter a formula as an array formula
ESC: Cancel an entry in the cell or formula bar
CTRL+A: Display the Formula Palette after you type a function name in a formula
CTRL+SHIFT+A: Insert the argument names and parentheses for a function after you type a function name in a formula
CTRL+K: Insert a hyperlink
ENTER (in a cell with a hyperlink): Activate a hyperlink
F2: Edit the active cell and position the insertion point at the end of the line
F3: Paste a defined name into a formula
SHIFT+F3: Paste a function into a formula
F9: Calculate all sheets in all open workbooks
CTRL+ALT+F9: Calculate all sheets in the active workbook
SHIFT+F9: Calculate the active worksheet
= (equal sign): Start a formula
ALT+= (equal sign): Insert the AutoSum formula
CTRL+; (semicolon): Enter the date
CTRL+SHIFT+: (colon): Enter the time
CTRL+SHIFT+" (quotation mark): Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (single left quotation mark): Alternate between displaying cell values and displaying cell formulas
CTRL+' (apostrophe): Copy a formula from the cell above the active cell into the cell or the formula bar
ALT+DOWN ARROW: Display the AutoComplete list

Keys for editing data

F2: Edit the active cell and put the insertion point at the end of the line
ESC: Cancel an entry in the cell or formula bar
BACKSPACE: Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
F3: Paste a defined name into a formula
ENTER: Complete a cell entry
CTRL+SHIFT+ENTER: Enter a formula as an array formula
CTRL+A: Display the Formula Palette after you type a function name in a formula
CTRL+SHIFT+A: Insert the argument names and parentheses for a function, after you type a function name in a formula
F7: Display the Spelling dialog box

Keys for inserting, deleting, and copying a selection

CTRL+C: Copy the selection
CTRL+X: Cut the selection
CTRL+V: Paste the selection
DELETE: Clear the contents of the selection
CTRL+HYPHEN: Delete the selection
CTRL+Z: Undo the last action
CTRL+SHIFT+PLUS SIGN: Insert blank cells

Keys for selecting cells, columns, or rows

CTRL+SHIFT+* (asterisk): Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)
SHIFT+arrow key: Extend the selection by one cell
CTRL+SHIFT+arrow key: Extend the selection to the last nonblank cell in the same column or row as the active cell
SHIFT+HOME: Extend the selection to the beginning of the row
CTRL+SHIFT+HOME: Extend the selection to the beginning of the worksheet
CTRL+SHIFT+END: Extend the selection to the last used cell on the worksheet (lower-right corner)
CTRL+SPACEBAR: Select the entire column
SHIFT+SPACEBAR: Select the entire row
CTRL+A: Select the entire worksheet
SHIFT+BACKSPACE: Select only the active cell when multiple cells are selected
SHIFT+PAGE DOWN: Extend the selection down one screen
SHIFT+PAGE UP: Extend the selection up one screen
CTRL+SHIFT+SPACEBAR: With an object selected, select all objects on a sheet
CTRL+6: Alternate between hiding objects, displaying objects, and displaying placeholders for objects
CTRL+7: Show or hide the Standard toolbar
F8: Turn on extending a selection by using the arrow keys
SHIFT+F8: Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range

Let us know if you like these tips or want to know how to use any of the Microsoft Office products more effectively. Training your staff in how to use their computers more efficiently and effectively is a small investment that can make them more productive.

Call us today!

Social Media Images Sizes


There are so many different social media platforms and they all have different recommended image sizes for use in the header, profile pic and content. It can be very difficult working out what size to use where. Getting it wrong can mean that images don’t display correctly, scale badly, crop text or logos from the image or worse. We actually use a spreadsheet tool we have developed to identify the correct sizes for to convert images to for each platform as well as many other regular formats such as A4 portrait and landscape, DL flyers, business cards and more. If you struggle with this talk to us and we can help. In the meantime this website gives you a great cheat sheet for social media image sizes on some of the more popular platforms (Facebook, Twitter, LinkedIn, Instagram and Pinterest) and the sizes to use for headers, profile pics and inline content.

Ask us for help with developing great images with text overlays for your social media advertising and web content

Follow us on Social Media

As always Jethro is your web, cloud and technology specialists. I am constantly learning new things and spending time researching, playing and testing new systems and reading about other people in the IT world doing the same thing. If you want to follow along with what I share in various spaces then connect with me:

All content © Tim Miller. Feel free to share or send these emails on. If you want to unsubscribe just reply with Unsubscribe in the subject.

The first quarter of 2015 is almost done so let’s get straight into it.

Cloud Management Tips – Who Owns the Cloud?

cloudLast newsletter prompted a question of “Who owns the cloud?

The answer is it depends – on what sort of cloud you are talking about.

Common public cloud scenarios like drop box, or Flickr, or Office365 the infrastructure is owned by the company involved. The data is always yours. Always check the terms and conditions!

Common private cloud ones like all your online banking for instance are owned by the bank – but you can access your data – though I suspect it’s not actually ours.

And then you can own your own private cloud. For as little as a few hundred dollars, the right router and some hard drives you can create a private cloud structure where you can access your data anywhere – while it is stored right at your house or office. Mind you this is not a safe a scenario as using something like Office 365. For instance your encryption layers will not likely be anywhere near as good as Microsoft’s. Neither will physical access to your premises be anything like as secure as theirs.

We can sit down with you and talk about your current business technology usage and what cloud services you could be using that could benefit you in one or more of these areas – cost reduction, efficiency, data security and access, and business continuity. Call me to discuss today on 0414 770 002.

Windows 8.1 and Windows 10

windows8I think all of our customers are finally off Windows XP. Hopefully there are none left using Vista – please contact me if you are! We still have quite a few customers using Windows 7 and in some cases we have plans to migrate them to Windows 8.1 soon. However many people don’t like change and think Windows 8.1 is strange, scary or confusing. So this section is a little bit about why you should be thinking seriously about upgrading to Windows 8.1 now and Windows 10 soon.

First of all here are some of the major reasons Windows 8.1 is better than Windows 7.

  • Improved Start-up times – the same PC will boot up a LOT faster with Windows 8.1
  • Better Battery Life – laptops get longer battery usage with Windows 8.1
  • Faster PC – your existing PC will run faster with Windows 8.1
  • More stable – Windows 7 was pretty good – Windows 8.1 is even better
  • Synchronisation – Windows 8.1 synchs your data, settings and desktop through OneDrive – it’s the same on every PC you log into
  • More secure – Free antivirus and anti-malware built in
  • Designed for Touch – if you have a touch screen or device you will rapidly find speed gains over using the mouse – especially useful for tablets

We recommend Windows 8.1 Pro for all businesses as there are some significant additional features over the standard (consumer) edition including:

  • Join a domain – required to network to your company server
  • BitLocker – encrypt your hard drive against theft – very important with laptops
  • Remote desktop application – connect to another PC remotely
  • Hyper-V – ability to run virtual machines inside your computer

Windows 10

Office 2016

Skype for Business

Windows 10 builds on Windows 8.1and according to Microsoft “is their best enterprise platform yet enabling our enterprise customers to be more productive, simplifying management and deployment, working with all of their existing apps, and helping to protect corporate data better than ever.”

More on Windows 10 in another edition. Right now we are trialling the developer previews of Windows 10, Office 2016 and Skype for Business in a virtual machine and learning about them.

Typically we upgrade a computer to Windows 8.1 from Windows 7 for $150 plus the cost of the software - $189 for Pro and $129 for Standard. All your existing programs and data will remain in place.

Special Deal – mention this newsletter and get a 5% discount off our Windows 8.1 upgrade price. Call us and we will help you identify exactly what you need and what benefits you can achieve with an upgrade to Windows 8.1.

Using Paste in Excel

excelCopying and Pasting is an important PC skill to know and learn. Office 2013 has built on previous versions of Office and provides many options for pasting.

Some examples include just pasting the formats, just he values, just the functions or more esoteric things like column widths in Excel, and even utilising mathematical functions. This article gives you some great tips and information about pasting in Excel.

If you want to know more about improving your spreadsheet design for more efficient use and ensuring your results are accurate then give us a call.

Other office 365 News and Updates

Office 365 continues to pump out updates, improvements and features.

The latest news is that OneDrive for Business comes to Mac and iOS devices

onedriveSometimes One Drive stops synching correctly. If you have One Drive folders that are not synching correctly try this Repair tip.

Right click the blue cloud in the task bar and click Repair. Follow all the prompts.

Social Media Tips and Information

Today we are just going to give you a list of some great information that has come across our desk in the last 2 weeks. If you want to get more regular updates, follow us on twitter, or our daily or weekly newspapers.

If social media seems like foreign world or nightmare to manage (and it can be) then try out sourcing it to us. Our global team of social media experts can work with you to successfully represent your business in social media with cost effective measureable results

Web Design - What should your website be trying to achieve?

Many websites are confusing. Why do I say that? Because if you stand back and look at the site there is no clear purpose or intention of the site. A businesses website should be very obvious. Either its purpose is to inform and educate, sell product, or provide a mechanism for the enquirer to quickly and easily contact the business. Sometimes it is a mixture, and when that occurs the separation should be clear. E.g. a blog should be used for the education and information component. It should be used as a tool to drive customers to calls to action either on the site or directly with your business. Sales and shopping pages should be obvious and easy to navigate.

When considering a basic website for a small business the primary purpose of the website is effectively marketing. It is to create a way to bring customers into the business and add sales revenue and profit. If the website does not do that it should be retrained or sacked just like you would with a non performing sales employee.

Spending sometimes several thousand dollars on a “brochure ware” site that contains some outdated historic information about the companies past, a google map and some very bland generic product or service statements is basically a waste of money. The first and foremost goal is to create a way for prospective customers to actually contact you. This should be done through sales messages, advertising images and text, calls to action and contact forms. Showcase your company’s offers, deals and discounts, provide easy access to virtual sales people, real world online chat or at the very least a telephone number and email address.

The first marketing action we perform is to first find out what exactly the clients goals are. We ask the client about what they want the website to deliver to the business in terms of sales, contacts or enquiries. We then do some market research – search keywords, audience insights from social, competitive analysis. This allows us to set the site up correctly for SEO analytic tracking and measurement. Finally the customer has something that can be used to effectively replicate them in an online world.


Here are our basic design principles:

  1. Keep it simple stupid – KISS - Don’t make it hard to find things. One layer of navigation, front page calls to action, side bar enquiry forms and information.
  2. Clarity, Conciseness and Care - Short simple sentences work best. Say exactly what you mean. Spellckecha evyrething!
  3. Use The Correct Heading Hierarchy - Websites have structure. We use this because SEO loves it and it reads better.
  4. Limited use of colours - We use colour palette generators by much smarter people than us who have thought these things out already. Readability for vision impaired is smart as well as thoughtful.
  5. Keep people on your page - We use content sharing tools to recommend further content from within the site
  6. Keep people coming back for more - Regular updated content is extremely important for SEO, and keeps people coming back. It is a great driver for ongoing social engagement and interaction.
  7. Be Social - We use simple recognisable tools to make it easy for people to like and share your content as follow you on social media

Contact us today if you need help fixing your site, or for a whole new refresh! Mention this newsletter and we will provide a free site review – normally worth $199.

Follow us on Social Media

As always we are your web, cloud and technology specialists. I am constantly learning new things and spending time researching, playing and testing new systems and reading about other people in the IT world doing the same thing. If you want to follow along with what I share in various spaces then connect with me on these platforms:

Jethro Consultants is a partnership owned by Tim & Judith Miller.
We are based in Brisbane on the East Coast of Australia in sunny Queensland. Jethro Consultants and Jethro Management work together to provide solutions in the areas below.


Innovation in software development is in creating customised solutions for our clients. We develop Excel based reporting solutions using Excel and VBA. Our web design and hosting portfolio is growing fast with lots of new Websites being designed and hosted by Jethro.




Collaboration is a big part of what we do. Training in the Office suite including SharePoint, along with work in knowledge management is provided to our clients. We have written a full suite of cooking eCourses available from Our hints and tips website, contains hints and tips on Excel, blogging and website development and technology.




Technology is something we love! Big fast computers, software and gadgets fill our office and we are always learning how better to deploy hardware solutions to our clients. We offer a full service install option with PCs being lovingly assembled, installed and configured to your exact requirements. We transfer data from your old PC and set up your email, browser, peripherals, wireless network and broadband and other personal settings for you.




Support. We provide basic business support, book keeping and basic accounting to numerous key clients. If you need help with bank reconciliations, payables and receivables then contact us now.

Like us on Facebook

What people say..

Valuable information from both an online and business aspect spoken in everyday terms.
Thanks and Merry Christmas

Free Business Seminar Feedback Nov 2012

— Jodie - Social Entrepreneur