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.
(*Required)

sharepoint

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

Today I am providing some answers to common questions we get asked and not just focusing on Windows 10. However I will have one little Windows 10 section as well for those who have updated already.

Are you actually harnessing the power of Office 365?

Jethro-Facebook-Office-365-Mobility-Business

When you made the strategic decision to move some or all of your business to the cloud with Microsoft Office 365 that was a good call. But since you made that call have you actually extracted as much value from this tool as possible, or is a large part of your investment lying there just untapped?

With our free customer audits we offer the opportunity to discuss what you have in place and what you don’t but could be utilising. Here’s a quick checklist. Are you utilising the power of these products?

Feature

Description

Major Benefits

Who should use

Skype for Business

Instant Messaging and Hi Def Video conference communicator for staff, customers and suppliers

Find out about Skype for Business

Hi Def Video conversations

Instant messaging

Presence indicator

Tightly integrated with Outlook

Presentation and webinar system

Any business with multiple staff

Any business with customers or suppliers who use Skype or Skype for business

Anyone who uses Outlook heavily

Anyone who needs to share their content via voice conference or webinar (private or public)

SharePoint

Document management system

Find out about SharePoint

Multiple version management

Single point of reference

Reduce attachments in email

Remote / mobile access to documents

Collaborative (multi user) editing

Any business creating and sharing documents, spreadsheets, video content or PowerPoint decks

Any business with staff roles and security levels for access

Any user who has more than one device (e.g. laptop and PC, or tablet and mobile)

Any business who collaboratively creates documents

OneNote

Note taking application that includes web clipping, email saving and screen shot saving

Find out about OneNote

Organise notes, to do lists, screenshots, and other important information in one place.

Easily share some or all of any notebook with multiple people as read only or read write

Automatically syncs across every device you own with no need to save

Anyone who writes to do lists

Anyone who needs to store important information like passwords

Anyone who needs to share with staff important information e.g. shared notes about customers

Anyone who needs to create screenshots and turn them into images

Delve

Delve displays information that is most relevant for each person based on the work they are doing and the people with whom they are engaging

Find out about Delve

Surfaces information already being created in the organisation by other people you might not know about

Improves collaboration

Integrates with Yammer

Any business with a team working on a projects or shared work

Any user wanting to find other documents in the organisation

Any business with 3-5 or more staff who create and edit documents

Yammer

Private Enterprise Social Network.

Also allows connection with external networks

Find out about Yammer

Find information and answers to common questions easily

Communicate with peers and colleagues on projects and documents

Network with others inside and outside your organisation

Any business with multiple locations or remote workers

Any business that works with customers or suppliers who also use Yammer

Any business that runs projects

Sway

Online publishing tool

Find out about Sway

Create and share polished, interactive reports, presentations, personal stories, and more

Any business creating presentations or reports

Any user creating content

Anyone needing to provide a slick looking web presentation of their information or data

Contact us now to if you haven’t had your free audit or want to know more about any of these products.

SEO Is no longer an option for business it’s a Must

Here is a fairly long explanation of what SEO actually is if you ever wondered just what those telemarketers are offering when they ring up and say they can put you on the front page of Google. I debunk the myths and explain the actual science of SEO so business owners can understand it.

image001Definitions

  • SEO – Search Engine Optimisation – commonly referred to as getting on page one of Google for a search. However there is a lot more to it than that. It is actually about ensuring that the website has all the components in place to assist the search engine crawlers (Bing Yahoo and Google) to rank you correctly. There are a number of components and I have attached a cheat sheet that describes most of these. https://en.wikipedia.org/wiki/Search_engine_optimization
  • SEM – Search Engine Marketing – paying for ranking improvements by the use of AdWords, Click marketing and other techniques.
  • SMM – Social Media Marketing – very broad term around utilising social media as a marketing tool
  • Black hat SEO – refers to aggressive and often “bad” methods of attempting to “game” the crawler algorithms by taking advantage of them. Usually a short-lived approach and is generally only used by the scammers – those who call up in a foreign accent and tell you they want to help you improve your SEO. While these often work well for 1-2 months the end result is usually a lower result as you can get blacklisted for doing it.
  • White hat SEO – the professional approach to doing it right using known techniques that actually work.

Measurement

There are some easy ways to define measurement and then a whole range of additional metrics that are far more in depth and specific. The first task is of course a goal or goals that need to be set in order to measure improvement of the metrics against those goals. For example measuring the number of people who come to the site isn’t really relevant without adding in calls to action and then measuring those calls to action. Then you can determine if a particular piece of work changed any of those things.

Using Google analytics is extremely important and should be enabled by your web developer. If you are not sure ask us. Metric management is about tracking the specific stats against a goal and the changes as you do things. Google analytics can measure how many people clicked on the contact form page and how long they stayed there, where they came from and where they went next. Some of the specific things that can be measured external to the google analytics are the number of enquiries you receive from the website forms. This can then help us create a ratio as follows:

no of people viewing a sales page : no of people clicking from the sales page with a call to action to the contact form page : no of enquiry forms received : your conversion from those enquiries to sales. Example 1000:150:8:5

This then allows you to set a goal around that ratio metric – e.g. increase the numbers or improve the ratios.

The actual measurement then requires three things:

  1. A measureable goal
  2. The stats being collected from the website
  3. And the additional stats provided by yourselves.

Additionally Goals themselves should be what is known as SMART goals:

Creating S.M.A.R.T. Goals

  • Specific
  • Measurable
  • Attainable
  • Realistic
  • Timely

Specific: A specific goal has a much greater chance of being accomplished than a general goal. To set a specific goal you must answer the six “W” questions:

  • Who: Who is involved?
  • What: What do I want to accomplish?
  • Where: Identify a location.
  • When: Establish a time frame.
  • Which: Identify requirements and constraints.
  • Why: Specific reasons, purpose or benefits of accomplishing the goal.

EXAMPLE: A general goal would be, “Get in shape.” But a specific goal would say, “Join a health club and workout 3 days a week.”

Measurable - Establish concrete criteria for measuring progress toward the attainment of each goal you set. When you measure your progress, you stay on track, reach your target dates, and experience the exhilaration of achievement that spurs you on to continued effort required to reach your goal.

To determine if your goal is measurable, ask questions such as……

How much? How many?

How will I know when it is accomplished?

Attainable – When you identify goals that are most important to you, you begin to figure out ways you can make them come true. You develop the attitudes, abilities, skills, and financial capacity to reach them. You begin seeing previously overlooked opportunities to bring yourself closer to the achievement of your goals.

You can attain most any goal you set when you plan your steps wisely and establish a time frame that allows you to carry out those steps. Goals that may have seemed far away and out of reach eventually move closer and become attainable, not because your goals shrink, but because you grow and expand to match them. When you list your goals you build your self-image. You see yourself as worthy of these goals, and develop the traits and personality that allow you to possess them.

Realistic- To be realistic, a goal must represent an objective toward which you are both willing and able to work. A goal can be both high and realistic; you are the only one who can decide just how high your goal should be. But be sure that every goal represents substantial progress.

A high goal is frequently easier to reach than a low one because a low goal exerts low motivational force. Some of the hardest jobs you ever accomplished actually seem easy simply because they were a labour of love.

Timely – A goal should be grounded within a time frame. With no time frame tied to it there’s no sense of urgency. If you want to lose 10 lbs, when do you want to lose it by? “Someday” won’t work. But if you anchor it within a timeframe, “by May 1st”, then you’ve set your unconscious mind into motion to begin working on the goal.

Your goal is probably realistic if you truly believe that it can be accomplished. Additional ways to know if your goal is realistic is to determine if you have accomplished anything similar in the past or ask yourself what conditions would have to exist to accomplish this goal.

T can also stand for Tangible – A goal is tangible when you can experience it with one of the senses, that is, taste, touch, smell, sight or hearing.

When your goal is tangible you have a better chance of making it specific and measurable and thus attainable.

How do we do this?

SEO is primarily about two things – Content and Currency.

Search engines rank you for the content on your site. They crawl words within context looking for relevancy. They look for timeliness or recentness.

This has to be developed backwards from the goals.

First you have to develop an avatar or a generic target customer. You create a mythical person who is your ideal next customer – the person you want to be having that phone call with selling your services. Once you identify the problem that person has that you can solve for them, then you need to work out how they find you. E.g. what was the problem? What words did they type into google to start finding solutions to the problem? How did that then find your website? When they found your website (page on your site) how well did the words you wrote confirm for them that you know how to solve their problem and convince them to contact you?

This leads you or us then to the ability to write content for your site that meets this objective. The more pages that can be written describing the real problems your customers have and how your company solves them. The more keywords there are that can be crawled by the search engines and the higher you will rank for those keywords. Adding in external links and other reference material, and then being referenced by other sites, analysts, uni students doing assignments on that problem and writing websites about them, etc. will help your rankings.

SEM – paying for it

A natural extension to the first component is to start paying for the results using AdWords and click marketing. E.g. paying for your site to be ranked higher or in suggested or advertised results sections on searches for certain keywords. Note there is no point doing this until you are already ranking well for those keywords. Your site needs to already have good content with those words before you can do this effectively.

SMM or Social Media Marketing

A powerful tool to massively leverage the ability for people to find your content and also improve SEO is SMM. This is extending the content you write on your site out into social media space – LinkedIn, Google+ and Twitter are probably the best places and definitely Facebook as well. Each space has a different set of “rules” and ways to work and Twitter and Facebook also have the ability for you to pay money to advertise.

How do we help?

We have a very specific targeted approach to this and can assist at any one of three levels:

  • We can do everything for you including writing the articles
  • We can assist you by doing the technical and web stuff after you have written the content yourself
  • We can teach you how to do it yourself and then stand back and let you go to it on your own.

Our approach is simple.

The first step is to have a planning meeting where we assist in working out goals, setting a timetable of 6-12 months for content creation, determining the scope – e.g. website alone or extending to Social Media

From there we can help you work out who does what and what the cost will be.

Each step we take helps you identify the goals, how will measure it – who does what and how much it will cost. No black box “pay $40 a week and we will get you onto page 1” false promises.

Contact us today if you want a free analysis of your website for the 7 most common mistakes most business websites make (Usually $199). If you want a free SEO cheat sheet email and I will send one to you.

Is Your WordPress site secure?

wordpress-logoWordPress is one of the most popular CMS (Content Management System) website software out there. We have developed a lot of WordPress sites for our clients. What many people don't realise is that both the WordPress core system and all of the available WordPress plugins are vulnerable to hacking, and need to be monitored and kept up to date on a regular basis.

Keeping your website up to date will help safeguard and eliminate uninvited intruders or bugs on your site.

Nearly all of our clients take the approach to allow us to manage all aspects of the domain name management, hosting, development and ongoing maintenance. However we do allow our clients the flexibility to host elsewhere, manage the site and maintenance themselves if they wish.

Obviously we can’t be responsible for their site if issues occur if they’re choosing to host elsewhere or managing the site themselves. And unfortunately some people fail to keep their ‘versions’ of software and plugins up to date, again causing possible opportunities for hacking. The lack of updates, coupled with poor hosting environments can leave a website wide-open for security threats.

But time and time again, we have clients who do it themselves come to us pleading for us to help them out of a horrible hosting mess or to fix the site when it gets hacked or goes down.

Where there are WordPress sites there are hackers, and over time we’ve seen an increasing number of hacking attempts and malware on WordPress sites. We daily get reports from our managed sites indicating the targeted attacks occurring and the successful blocking of those attempts.

What Jethro does for our managed WordPress clients

  • Our servers are entirely owned and managed by us. There are no other resellers or websites on the server that we don’t have control of. When you host with crazy domains or any of the other cheap hosts you are subject to the fact that there are hundreds of not thousands of other sites on the same server – and while your site might not have any issues something happening to one of those other sites might cause your server to go down.
  • We monitor the servers constantly. Both at the server level where we receive text message and email notifications if something occurs, and at individual site level.
  • We harden the security of the default WordPress site way beyond the standard install. The standard install script most hosters offer for DIY leaves folders unprotected, easily guessable admin user names and no usually no password complexity requirements. We ensure that the site is as hard as possible to get to.
  • We don’t install 35 “that might be nice to have” plugins that may cause compatibility issues, security flaws or other issues. Every plugin we use has been tested over a long period of time, is compatible and has good developer maintenance.
  • We offer a maintenance service level agreement for all our clients that includes regular off server backups, plugin and core updates, documentation of all changes made and easy recovery if problems occur and active monitoring of the site.

Talk to us today about your WordPress website and ask us for a quick analysis of the site for potential problems. Better yet let us maintain this business asset for as little as $550 a year.

Welcome to the New Windows 10

Your Start screen

The Start menu is back—and it’s more personal, more organized, and more fun than before. Go to Start Windows logo icon on the taskbar on your keyboard. You'll find your most used apps on the left, the All apps list, and shortcuts to other locations on your PC, like File Explorer and Settings

win 10 start screen

Windows 10 Store

win 10 storeThe Store is a one-stop shop for music, videos, games, and apps.

Try out an app before you buy it, or pick a free one. Your Windows 10 apps will work on all your Windows 10 devices.

Application Switcher and Virtual Desktops

Click the application switcher for quick access to all your running apps. Or create and switch between virtual desktops.

win 10 desktops

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.

2012-07-14 Brisbane French Festival 017Did you know that today was Bastille Day? Will you be celebrating?

Just as this French National day commemorates the beginning of the French Revolution I hope that this newsletter can help you begin a revolution at work with some innovative ideas utilising Office 365.

Quickly create an Online Survey – using Excel and OneDrive

When you login to Office 365 you should see an icon in your apps list for OneDrive. This is your personal user accounts 1TB of storage space. Once you go there online you get access to some interesting features not available on your PC.

 

One of these is the ability to create an Excel survey. Click the New icon and then choose Excel Survey. You will get a prompt to create the Survey workbook with a title and then the opportunity to create questions with options for free text, Yes No, your choice selections and so on. The resulting survey that is created can then be shared with anyone you want to. For example please take this short survey.

There are lots of really awesome use cases for this. Use this as a pre appointment data collection option with a tablet with customers who walk into your business, use at trade shows or send it to customers with a QR code after they purchase from you for post sales feedback and follow-up. Results can be seen real time in the office in a spreadsheet that you can customise as necessary.

office 365 apps list

excel survey 1excel survey 2

Contact us now if you would like to learn more about creating Online Excel Surveys.

Using Sway to generate Online Documents and websites – no programming!

Nearly every business uses PowerPoint and Word. Turning your documents into online applications is far easier than you might think. Using Sway (on your Office 365 app list or by going to www.sway.com) you can turn your existing PowerPoint and word documents into websites that you can send your customers to. For example here is the digital strategy presentation we give to our customers. This took 5 minutes to upload and tweak using the visual tools in Sway.

digital strategy

Talk to us about using Sway to enhance your online presence, integrate with social media and incorporate into client presentations. Upgrade your Corporate Look!

Using Delve to improve your Corporate Communications

Businesses today create large amounts of data. From sales reports, customer presentations, tenders and quotes, SOP, Office Procedures and other how to documents to excel spreadsheets and power points there is endless amounts of data being created. SharePoint is the ideal place to store all this data as it is so easily accessible by all users from any location and on any device.

But how do you know what is being created? Are you repeating work that someone else has done, or do you need to copy and paste boilerplate text? What about utilising someone else’s spreadsheet to get you started with that new analysis report your boss just asked for? Office Delve is the new tool being rolled out in Office 365 to assist with surfacing information that is tailored to you.

From the Office Website:

Delve helps you discover the information that's likely to be most interesting to you right now - across Office 365. You don't have to remember the title of a document or where it's stored. Delve shows you documents no matter where they're stored in OneDrive for Business or in Sites in Office 365.

Delve also lets you view your colleagues' profiles, or edit your own. Your profile is like an electronic business card you share inside your organization.

Delve never changes any permissions, so you'll only see documents that you already have access to. Other people will not see your private documents. Learn more about privacy.

When you and your colleagues view, edit, and share each other's documents, Delve learns from how you work and tailors the information to each of you on your personalized Home page. What you see in Delve is different from what your colleagues see.

delve

But how do you know what is being created? Are you repeating work that someone else has done, or do you need to copy and paste boilerplate text? What about utilising someone else’s spreadsheet to get you started with that new analysis report your boss just asked for? Office Delve is the new tool being rolled out in Office 365 to assist with surfacing information that is tailored to you.

From the Office Website:

Delve helps you discover the information that's likely to be most interesting to you right now - across Office 365. You don't have to remember the title of a document or where it's stored. Delve shows you documents no matter where they're stored in OneDrive for Business or in Sites in Office 365.

Delve also lets you view your colleagues' profiles, or edit your own. Your profile is like an electronic business card you share inside your organization.

Delve never changes any permissions, so you'll only see documents that you already have access to. Other people will not see your private documents. Learn more about privacy.

When you and your colleagues view, edit, and share each other's documents, Delve learns from how you work and tailors the information to each of you on your personalized Home page. What you see in Delve is different from what your colleagues see.

Talks to us about getting Delve working in your organisation

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 get Skype for Business installed? The recent upgrade for all Office 365 users should have taken affect by now. Talk to us if not.

Remember you can find the Lync app for iPad and iPhone in the iTunes store, Android app in the Google play store, and the Windows phone app in the Windows Store. In all cases you just need to sign in using your Office 365 credentials.

Cloud Management Tips – Migrating your data to your Cloud Storage

clip_image001You might have files on your computer that you want to copy to your cloud storage areas. Before you just start copying them én masse you might want to consider some important things first.

Storage Limits

There are more storage limits on services than just the total space although that is critical to think of. Many services what file types can be stored. There are also usually limits on the number of files, and individual file sizes. Usually the retail or free service is limited more than the business or paid service as well.

Accessibility

Not every loud storage solution makes it easy to access your files. Ensure that the app is available on your platform of choice, that files can be selectively synced and that you can access your files when you need them by testing with a few simple ones first.

Editing

Not all services or apps allow editing of the documents in a browser or on a mobile device. If you need to edit documents on the go then check this feature out first.

Sharing and Security

There are different ways to share with each different service. Some like SharePoint can share a single file as read only or edit. Others like Dropbox can only do that a folder level. Check what you need before deciding which to use.

We can sit down with you and talk about your current data storage and how to migrate this into the cloud in the most cost effective and efficient manner. Call to discuss today on 0414 770 002.

Windows 10 is coming – Free Upgrade from Windows 7 or 8

windows 10 logoWindows 10 will be released later this year. And if you upgrade from Windows 7, Windows 8.1 or Windows Phone 8.1 in the first year from its release you will get the upgrade free*.

Some of the features from Windows 8 that some people found annoying have been removed or changed in Windows 10. These include:

  • Full screen modern app windows can now be moved and resized like regular resizable windows and are no longer full screen or docked in the sliding panel. Each has the familiar resize icons on the right hand side for minimise, restore and close.
  • Internet explorer is now going to be one version – not two – and never knowing which is which will be gone! The new browser is codenamed Project Spartan. Stay tuned for this one.
  • The Start screen is fixed. There is a start menu just like in Windows 7, and the revised start screen can be customised to show apps that you choose so you can have the best of both worlds. It can be toggled to full screen or work just like the old Windows 7 one did – your call!
  • The corner based navigation system is gone. When you stick your mouse in the corner the apps and charm bar wont display. In fact the entire charm bar has been replaced by a really cool notification centre similar to what windows and android phones have that can be pulled up or down, and used to see notifications and dismiss them as necessary.
  • VERY COOL – a multiple desktop function built in. you can have multiple desktops with different applications open on each one and switch between them. Excellent for laptop users.

office 365 on the go survey detailsSpecial Deal – If you are interested in previewing Windows 10 we can show you some devices with it running and then talk about when your business will migrate to Windows 10 and take advantage of the under the hood features that will make your staff more productive.

*Doesn’t apply to customers running Windows Enterprise or on Software Assurance.

Office 365 gives You more Mobility

Have you ever checked your mail in the bathroom? What about taken a business call while at the beach? While we all need balance in our lives, being more mobile can both be a curse and a blessing.

Check out this info graphic that shows some interesting stats. Can you identify with any of these? Or are there some other spots they missed? What about the movies? Ever responded to email while munching on popcorn? I’ll post this on Facebook for you to respond with your plugged in confessions! Confess now!

Let us know where you need better access to your data and we can help you design a solution that works for you or your team. Telecommuting can save you money and make your staff more productive. Call us today!

Using The Round Function in Excel

The ROUND function is extremely useful to truncate calculated values with long decimal places to the 2 decimal places we need with currency calculations. Typically where this is a problem is where you have calculations on financial figures being added up and the sum at the bottom “appears” to be wrong. Solve the problem of a board member adding the figures on a financial report with a calculator and then calling you out on the total (this happened to me once).

Read all the instructions on how to use this powerful function online at http://spyjournal.biz/excel/ROUND

If you want to know more about using some of the more powerful formulas in Excel to improve your productivity then give us a call.

Social Media Tips and Information – What not to do!

I bet you have heard of someone who shared something inappropriate on social media who now wishes they hadn’t. Maybe it adversely affected their employment, relationships or even got them fired. While there are (maybe not as obvious as they should be) levels of TMI (too much information) that personal sharing from our friends and family can cause us to cringe, it’s just as bad for business.

Having a social media policy is one thing. But do you have a strategy documented for dealing with the worst case scenario, an employee upsets customers or even without that provocation they just go rank on you. Do you know what you should, and equally important, shouldn’t do?

If managing social media seems like a scary prospect for your business (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.

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 on these platforms:

· Twitter https://twitter.com/spyjournal technology, cycling, social media, management, business, and web

· Linked In http://www.linkedin.com/in/jethromanagement

· Delicious https://delicious.com/jethrocon saved links

· Blog http://spyjournal.biz/ all sorts of stuff including personal and family updates

· Spyjournal Facebook https://www.facebook.com/spyjournal.biz tech, cycling, and other stuff

· Subscribe to our daily Newspaper https://paper.li/spyjournal/1345852972

· Subscribe to our weekly Newspaper https://paper.li/spyjournal/1345853288

· Jethro Management Facebook https://www.facebook.com/JethroManagement business, management, web

· Jethro Marketing Facebook https://www.facebook.com/JethroMarketing social media, marketing

· Dreamcoat Photography Facebook https://www.facebook.com/DreamcoatPhotography

· Dreamsport Photography Facebook https://www.facebook.com/DreamSportPhotography

· Red Hot Snapper Facebook https://www.facebook.com/redhotsnapper roller derby

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.

Hope you had a relaxing and safe Easter break. Did you check your email while you were away from work? Typically most people do. Did you set up an out office email response? If you didn’t remember how to do that then check out this previous newsletter where we showed you how to do it.

All our previous newsletters can be found online at www.jethroconsultants.com

As always I am available to respond to your requests, queries and provide you with information.

Cloud Management Tips – Protecting Data in the Cloud?

Cloud data is just like computer storage in one respect – but with some big differences.

All data is subject to accidental or deliberate deletion.

If you have an adhoc approach to cloud usage, where employees bring their own cloud storage, no policies on where data is to be stored and accessed then you have potential issues if that employee leaves or accidentally or maliciously removes or deletes data. Even with a corporate storage solution like SharePoint, Box or Dropbox for Business, data can still be deleted.

2014-11-26 Walk to Park 050-580So how do you protect against that? We have numerous different solutions we can implement into a customer’s business to safeguard against that. SharePoint has some very good built in protection levels including major and minor version history with different permission levels. Access to data can be read only or edit to certain user groups. Dropbox for Business and Box Enterprise also have similar features. Putting in external backup solutions can work or implementing a cloud backup service that backs up your cloud and non-cloud data to a repository like Amazon web services or even another cloud service like google Drive can also be setup for minimal cost. Peace of mind for a few cents a day.

There is no one size fits all solution – we tailor each solution to the customer’s specific needs and risk levels.

We can sit down with you and talk about your current data management, disaster recovery and backup services you could be using to protect you against data loss. Call me to discuss today on 0414 770 002.

Office 2016 for MAC

2012-01-14 DDU2012 010-387Finally a refresh of Office for our clients using Apple Macs is close. The preview is out for those who want to take advantage of that. The current version of Office for Mac 2011 is very dated and its functionality is very limited compared to what the PC users get with Office 2013. For the last 12 months I have been suggesting users use SharePoint and Office online or the apps on the iPad for a better experience.

Watch the video https://www.youtube.com/watch?v=6SKGIJ2brzg to see all the updated versions of the Office programs for Mac.

Special Deal – If you are a Mac user and you currently don’t have the 2011 version installed at least let us help you with that. We can connect remotely and install it for you for $44*

*Qualifying Office 365 subscription required

Using The SUMIF Function in Excel

excel logoThe SUMIF function is one the most powerful and easy to use functions in Excel. It is used to sum the values in a column when the value in another column is equal to a certain value. E.g. In the table below you might want to know the number of casual staff in Victoria. The SUMIF function is the key to unlocking this data easily.

excel sumifRead all the instructions on how to use this powerful function online at http://spyjournal.biz/excel-function-week-sumif

 

If you want to know more about using some of the more powerful formulas in Excel to improve your productivity then give us a call.

iPhone and iPad Apps for office 365 Email and Calendar

outlook logoIf you have an iPhone or iPad then check out either OWA or Outlook from the Apple store. Both of these free apps will connect to your Office365 Exchange email account and give you a much better experience than the standard Apple mail and calendar apps. If you are a power email user than the Outlook app is probably the best. If you need access to colour categories in calendar and tasks than the OWA app is probably better. If you are not sure install them both and trial them. I would love to hear your feedback on these Apps.

Social Media Tips and Information – Advertising on Facebook

facebook_logo-200Social Media Marketing (SMM) can be hard to understand. Facebook advertising is one of the places for businesses to be investing money – but how do you know you aren’t just throwing away your cash when you Boost posts. We recently presented an article on how to use Facebook Advertising to a business group. Feel free to view it online.

If advertising in social media seems like a 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 – Should you invest in theme design or content?

NEWSFLASH

Google has announced that from 21 April sites that are not meet mobile friendly will be penalised in search. More information on what that means can be found at this site http://searchengineland.com/everything-need-know-googles-new-stance-mobile-216870

If your site is not going to pass the test than a simple resign refresh might be the answer.

It used to be that to have a great looking website you had to spend thousands on a designer creating a theme (graphical content, visual layout and navigation elements, buttons, menus and colours) in order for you to stand out from the crowd and visually represent your brand.

However that is no longer the case. Any website developer who tells you otherwise (at the expense of creating good quality fresh content) is just feathering their own nest at the expense of your pocket. While it is true that good design is important, spending large amounts of money to get it isn’t necessarily needed. And it should never be spent in place of creating content.

Here’s why.

A responsive mobile design theme that meets Googles mobile design requirements as well as showcasing your brand and company can be purchased for as little as US$50. Within a few hours a good developer can customise (with no coding required) this theme to your needs including adding your logo, changing the colour scheme and utilising one of the several built in templates to give you a unique look. You can then spend the rest of your web development investment budget to generate the good quality content that will rank you in search engines, establish your expertise in your field, and give you great content to share in social media.

Here are some sites we have built recently or installed new themes in which in all cases the theme budget has been a maximum of $500 including purchase and configuring. In no case has there been custom code meaning that ongoing upgrades can be applied for minimum of effort and cost (in most cases covered by our maintenance SLA and performed automatically).

Note; most of these sites have plans for content creation that have yet to be implemented.

· http://attitudecoach.com

· http://sentinel-erm.com.au

· http://irlabs.com.au

· http://opalhatblocks.com.au

· http://jonomiller.com

· http://narangbabaptist.org.au

· http://kinshagold.com.au

· http://paintplaceburpengary.com.au

· http://psychscreen.net.au

Contact us today if you need help making your site mobile friendly, 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:

· Twitter https://twitter.com/spyjournal technology, cycling, social media, management, business, and web

· Linked In http://www.linkedin.com/in/jethromanagement

· Delicious https://delicious.com/jethrocon saved links

· Blog http://spyjournal.biz/ all sorts of stuff including personal and family updates

· Spyjournal Facebook https://www.facebook.com/spyjournal.biz tech, cycling, and other stuff

· Subscribe to our daily Newspaper https://paper.li/spyjournal/1345852972

· Subscribe to our weekly Newspaper https://paper.li/spyjournal/1345853288

· Jethro Management Facebook https://www.facebook.com/JethroManagement business, management, web

· Jethro Marketing Facebook https://www.facebook.com/JethroMarketing social media, marketing

· Dreamcoat Photography Facebook https://www.facebook.com/DreamcoatPhotography

· Dreamsport Photography Facebook https://www.facebook.com/DreamSportPhotography

· Red Hot Snapper Facebook https://www.facebook.com/redhotsnapper roller derby

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.

Does your business experience productivity slow downs when email fails?

Do you have a large investment in IT infrastructure?

Do you struggle to stay up to date with office software?

 

Microsoft Office 365 is the world’s leading cloud software provider for small medium and large businesses. Why? simply put, nearly every business uses Microsoft Office to create and view documents, spreadsheets and presentations, has email, and needs to share their files with customers, suppliers and staff.

Microsoft Office has been delivering that solution on the desktop since 1995 – now almost 20 years later Office 2013 Professional Plus is available as a free add on to the Office 365 Cloud Subscription service. Heres what you get (specific offerings will depend on the actual price point) out of the box.

 

Jethro-Office365-A6-Advert

We have been helping our customers migrate from their desktop and on premises email and document management solutions to full cloud based document management systems for several years now. We operate int he cloud – you can too.

Experience the productivity gains, expense savings (its cheaper!) for yourself. We can even set you up with a 90 day demo.

Like us on Facebook

What people say..

Enjoyable and helpful information. Great introduction - made me want more info.

Feedback from Free Business Seminar Jan 2013

— Kathie - Business Owner

Navigation

Syndicate