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)

  • Sharebar

Welcome to the 37th edition of this newsletter. Did you realise that if you wrote a fortnightly newsletter to your clients that you would have 26 great articles a year to post on your website that demonstrate your expertise in your field of specialty? That creates amazing google juice for improving your SEO and website enquiries. Talk to use about disruptive selling techniques using digital marketing skills. More information below.

Disruptive Selling

Jethro-Marketing-facebook-highlight-jan-2016-1

Don Schultz, professor emeritus-in-service at Northwestern University, is often considered the pioneering thinker in the discipline of integrated marketing communications. At 80 years old he is still actively challenging conventional wisdom and advocating for change within the marketing profession.

In a recent interview with Forbes he says this:

…unfortunately very few organizations have learned, is it all starts with the customer. The big problem that most organizations have is they’ve all fallen in love with their products and they want to go tell people about it. They want to say, “Look what we’ve done. Look what we’ve made. Look at how important we are.”

He suggests instead that

…the first thing they ask you is, “What are you trying to do? What problem are you trying to solve?” They start with the customer and then work from there. Very few organizations are prepared to do that.

Bruce Rasmussen from Carpe Diem here in Australia has been teaching those who want to learn about disruptive selling and the new buyers journey.

Here at Jethro we help our customers wrap their heads around these concepts in relation to their business and how to apply technology to better market to their customers. As mentioned in the opening paragraph a blog site full of expert information answering new buyer’s questions before they even need to know them along with customer testimonials can help establish you as the go to source when they have their status quo shattered and need your product and service now!

Contact us today if you want to improve your website and social media presence and establish your expertise in your marketplace.

How to use Office 365 for Email

There are so many parts to Office 365 it can sometimes be confusing where to start. We often get asked by clients if they should be using SharePoint or OneDrive for Business for example.

Rather than describe each area I prefer to start with the common workloads people have and explain which are the best tools for each. Just as a landscape gardener might have a shovel, a bob cat and a backhoe each can be used to do the same job different ways and with different capacity, so the components of Office 365 often overlap.

Lets’ start with the most common requirements information workers have today. Ill cover off these over a few newsletters. Today we will start with email.

Email

We all receive lots of emails every day but there are different sorts of emails, and they have different functions. There are at least 5 places we can store and access email. However, there is one primary differentiator.

Does the email need to be seen and acted on by multiple people or just one person?

Personal emails should be sent and received using a user accounts personal email address – e.g. john.doe@yourdomain.com. Microsoft Exchange in Office 365 gives each user a 50GB mailbox and also an archive capacity that is dependent on the licence. (Kiosk users get 2GB). The best place to store these emails is in your personal email account.

For emails to be accessed by multiple people there are numerous places and the scenarios are a bit more complex so I’ll use a table to demonstrate some of these scenarios and the email location.

Scenario

Location

Explanation

A generic email address is needed for the organisation

It needs to be able to Send and Receive

Access to the email address is needed by one or more people

It needs to be accessible in Outlook

Shared Mailbox

Shared mailboxes in Office 365 make it easy for a group of people to monitor and send email from a common email addresses, like info@contoso.com, support@fourthcoffee.com or contact@contoso.com. When a person in the group replies to a message sent to the shared mailbox, the email appears to be from the shared mailbox, not from the individual user. Shared mailboxes are a great way to handle customer email questions because several people in your organization can share the responsibility of monitoring the mailbox and responding to queries. Your customer questions get quicker answers, and related emails are all stored in one mailbox.

Shared mailboxes are a great way to handle customer email questions because several people in your organization can share the responsibility of monitoring the mailbox and responding to the questions. Your customer questions get quicker answers, and related emails are all stored in one mailbox

A team, subcommittee or small group is created to manage a task or small project.

Emails need to be sent to the entire group and available to all.

Office 365 Group

A distribution list is a set of email addresses. You can use the distribution list to send an email message or meeting invitation to all the addresses at once. An Office 365 group includes a distribution list but also includes a shared:

· Inbox for group email communication

· Calendar for scheduling group meetings and events

· Library for storing and working on group files and folders

· OneNote notebook for taking project and meeting notes

· Planning tool for organizing and assigning tasks and getting updates on project progress

When you join a group, your email address is automatically added to the distribution list and you gain access to all group information. You don't have to wait to see group email or view a shared document. You join, you have access to everything, from everywhere: in the cloud, on the desktop, or on a mobile device.

Check out this video to see Office 365 Groups in action.

Internal company information needs to be disseminated in a way that can be easily seen by everyone without getting lost in email inboxes

Public folders

Public folders in Outlook give you a great place to collect, organize, and share information about particular topics or projects within an organization. "Public" in this case means viewable by everyone within the organization, not the world at large. When you post a message to a public folder, you're not emailing it to anyone, so no one's Inbox gets cluttered. Instead, people can check the folder whenever they want to look for interesting posts.

Hopefully that gives you some ideas of how to sue the different places to store, send and receive emails from.

Contact us if you need help configuring or using any of these Mailboxes, Groups or Public Folders.

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:

Its end of Financial Year – Do you need a tax deduction? Purchase a 5-hour block support from us and save $165 on your next lot of support from us. Contact tim@jethromanagement.biz now for details.

Block Support Hours

clip_image002[3]

Our adhoc support cost is $121 inc GST / hour billed in 15 minute increments. For onsite call-outs we charge $143 for the first hour. Pre-purchase a minimum 5-hour block and we bill to closest 5 minute and the cost is only $440 for the 5 hours – saving of $165. Call out surcharges still apply where applicable. See all our rates and charges.

Contact us today if you want to pre-purchase before the EOFY.

Top Ten Tools for Any Startup

I recently wrote an article titled The Top Ten Tools for any Startup. It is relevant to probably all small and medium businesses regardless of their age.

Effectively I recommend the powerful Office 365 Business suite ads the primary productivity tool. Depending on your subscription level you should have access to these major products and if you are not using them you are missing out on some amazing tools.

  • Exchange Mail, Tasks, People and Calendar – Accessible Online, Outlook for desktop, Mail apps in PC and Mobiles – Includes enterprise features such as unlimited archiving* 50GB mailbox, shared calendars, delegate access to mail, calendar and tasks, shared mailboxes, Out of office messages and much more.
  • Yammer – enterprise level social network – separate subscription required*
  • One Drive – 1TB per user of file storage
  • SharePoint – document management, workflow, mailboxes, external sharing, real time document authoring collaboration and much more
  • Skype for Business - Professional meetings and collaboration—all integrated with your Office apps. Online meetings, messaging, calls and video with up to 250 people.
  • Online Office Apps – Excel, Word, PowerPoint and OneNote
  • Delve – monitors interactions between people and the information they use. It then applies machine learning to these interactions in order to determine what is most relevant. Read more about why Delve should be the centre of your office.
  • Video – create shared archive of video for your business, available online anywhere. Public or private.
  • Sway – visually creative online presentations created in minutes with no coding skill required.
  • Planner – online task management hub – I write more about this below.
  • PowerBi – extremely powerful way of visually analysing your data from accounting systems, sql servers, excel files, google analytics or many other data sources.

clip_image003[3]

See the full suite of Office 365 products.

*Some features are dependent on the subscription level.

Contact us if you need help configuring or using any of these applications. If you don’t have access we can check your subscription level and advise how to upgrade.

Excel Dashboards

clip_image005[3]A dashboard reporting system is a fantastic way of quickly demonstrating trends in company financial, production or human resource data. Many employees spend hours and sometimes even days a month creating reports like this. I have spent months in some organisations automating these to be generated automatically in order to save valuable employee time.

If you want to create visually engaging dynamic reports like the one pictured, then you need Charley Kyd’s Excel Dashboard tool.

I have been an affiliate for Charley Kyd’s Excel Dashboard reporting tools for years. If you want to create professional dashboard reports in Excel 2007 and above, then check out his deals.

Contact us today if you need help purchasing or using the Excel Dashboards.

Microsoft Lumia 950 and 950XL Available at Telstra and Harvey Norman

clip_image006[3]

Microsoft’s flagship mobile phone the Lumia 950 and 950XL are now both available from Telstra. They have been available at Harvey Norman for over 6 months as well as the Microsoft Store. Right now Harvey Norman have them on a sale, $400 cheaper than when I bought mine!

Contact us today if you want to know more about Business Phones

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:

I recently read an article written by Dropbox titled the top ten tools for any new startup.  I’ve removed the redundant word “new” in my title. However the reason I am writing this article is to to both lightly criticise that article and to give you an alternative set of tools with some practical startup business reasons why my reasons make sense.

Jethro-facebook-highlight-office365-simple-complicated

First of all the Dropbox article does make a lot of sense functionally. Each of the tools they suggest contain functional requirements for any startup and most businesses as well. So, understand that my criticism isn't of the functionality requirements.

Their top Ten apps – and broad or main functionality are:

  • Squarespace - Website
  • Xero – Accounting
  • Mailchimp – email lists
  • Trello – Project management
  • Segment – Customer data tracking
  • Slack – Team communication
  • Rapportive – Gmail plugin to connect Linkedin
  • Dropbox Business – file storage and collaboration
  • LinkedIn Solutions – premium networking
  • Streak – Gmail based CRM

My reason for criticism is based on the independence and thus lack of interdependence each of these apps have with each other. Each has their own authentication process and sign in, each has their own data set or information gathering component, and most of them don’t talk to the others. Yes I am aware there are workarounds and that you can join things together with the right tech skills and APIs but that is another whole layer of tech and complicated.

Why is this important? Imagine your startup is just you and a mate, and then you find a developer or a team of developers, start working with a marketer for content development and maybe you then employ a sales professional. Now you have a team of people – maybe several teams, and you need to get them all authenticated in every one of these systems – each with its own process. the more layers of complexity the more time and money is sucked out of you to onboard every new person, and the more complex it it to setup in the first place.

I’m going to focus on the primary items in this list and suggest that Microsoft Office 365 does them all better than the apps in this list, with one sign in access to everything, collaboration in each of those spaces that knows about all of the spaces, security already in place for access to data and so on.

Lets look at my alternative list:

  1. Email - Missing from Dropbox’s list is email. Love it or hate it, email is the centre of the communication workers world right now. Even if we have better internal tools we still need to communicate with our partners, vendors and customers, and email does this. Note: for small mailing lists exchange email can be used for email newsletters but you will need Mailchimp or an alternative at some point once that list gets over say 100 recipients.
  2. Mailchimp – I agree with Dropbox this application is critical for managing mail lists. Fortunately the entire team doesnt need access to it, probably only a couple of key people.
  3. Skype for Business – Instant Messaging, Video conferencing, Webinars, Presence, Unified Comms. You name it – this tool is invaluable for any team to communicate together. This replaces Slack – which also has an aggressive pricing model – if you want access to your archives after 10,000 messages you have to buy in. Skype for business is free inside Office 365, has integrated presence and IM history stored in Exchange.
  4. Planner – the Microsoft Planning hub is a fantastic light team based project management system that is comparatively similar to Trello, free inside Office 365, and has security tied in. IT connects seamlessly with your data and Email - Trello doesn’t do either of these. If you need a heavier solution Microsoft Project isn’t free but available inside Office 365 and does the heavy lifting for project management.
  5. SharePoint and One Drive for Business. Free inside office 365 SharePoint makes Dropbox look childlike. All the same basic functionality of storing files, version control and syncing to local machines are there. However SharePoint contains team tools like workflow, Delve, content meta-data tags and tight integration with the whole Office 365 suite. Security and authentication are the same so no extra logins required. The power of SharePoint may not be obvious to the causal user but there is far more capability for extensibility.
  6. Accounting. I wont specify a specific accounting tool here, though there are some reasons i don’t prefer Xero as a cloud accounting application. Price and price of plugins is one reason. Financials for Office 365 is one option. Others include MYOB and QuickBooks Online. Ensuring your system has hooks out (APIs) for data analysis with tools like Excel, PowerBi or PowerPivot will make your accountant happy (Quickbooks Online does for instance).
  7. CRM. Microsoft Dynamics CRM can be integrated with Office 365 and can include the same credentials.
  8. Website – Squarespace or WordPress are good starting points for a cheap and easy to create and manage site. Drupal is a much better option for long term scalability and growth.
  9. LinkedIn Solutions – i’m going to leave this one here for the same reasons Dropbox suggest it.
  10. PowerBi – Data analysis – for everything. From Google analytics data to accounting data to CRM data to just about anything else you can think of.

To Summarise

I have suggested my list on an assumption that the primary authentication anyone needs for everything is email. You need an email account to create an account anywhere else. A start up, like any established business wants and needs to control information and data flow for security and potentially legal reasons. Having one place to manage as much of your security as possible limits the exposures and risks of data leakage. This is especially important in a startup who maybe be working with new technology or an advantage that needs secrecy.

Microsoft Office 365 provides that Email account, authentication and security. For no additional cost or signup requirements and with one single download and install you then get access to all the productivity apps of Office, Instant Messaging, High Def Video Conferencing, Planner, SharePoint and One Drive for Business and even PowerBi with some licences. There’s 5 of the ten straight up, though I would argue the tightly integrated combined power of these is far higher than the non integrated combined power of Trello, Dropbox, Slack and Rapportive. Add PowerBi and Dynamics CRM with the same authentication if you need them.

The only separate items are accounting, Mailchimp and LinkedIn, each of which your entire organisation doesn't need access to anyway.

With Office 365 you have now dramatically reduced cost, simplified your onboard and offboard process for employees, gained tight edge control security. All your data is in one authentication space and not constantly bouncing between several.

MSFT silver cloud logo reversed-300As a Microsoft Silver Midmarket Cloud Partner we have access to the vast marketing, technical and consulting resources that Microsoft has. We also sell and support the Windows PC and Server Platforms, Office 365 suite and Azure Cloud storage and virtual machine services.

Get solutions that help you grow your business with greater efficiency—by reducing costs and getting exactly the technology you need when you need it. And because it’s Microsoft, you can build on familiar tools, so growing your company doesn’t have to mean growing your training and ramp up costs.

Grow Efficiently Banner1_728x90

The only constant is change, especially when it comes to the technology we use to help run our businesses. And the pace of that change is constantly accelerating, whether as a result of major innovations like cloud computing or the impact of economic events.

Technology should be an asset—one that helps you to anticipate, manage, and respond quickly to change. Technology should also help your organization reduce costs and get more from the investments you make.

When it comes to growing with greater efficiency, there are some key questions businesses are asking today:

  • How quickly can we get new employees up and running with the tools they need?
  • How do we keep up with the massive growth in data needed to do business today?
  • Are we getting the maximum return on our technology investments?
  • Can we simplify IT, so less time is spent on repetitive tasks and more is focused on addressing strategic business needs?

Get solutions that help you grow your business with greater efficiency—by reducing costs and getting exactly the technology you need when you need it. And because it’s Microsoft, you can build on familiar tools, so growing your company doesn’t have to mean growing your training and ramp up costs.

ModernBiz - Grow Efficiently Pitch Deck

Get modern protection for evolving threats, with solutions that help protect your business data and minimize the disruptions caused by unexpected events. With Microsoft, enterprise-grade protection is built into its technologies. So you don’t have to think about it. From advanced data protection to solutions that help you recover quickly from unexpected events, get technology that is designed to help safeguard your business.

Safeguard your Business Banner1_728x90

Businesses today face a constantly evolving set of potential threats, from data security breaches to downtime from unexpected events. Businesses are asking questions like:

  • With growing use of the cloud and mobile devices at work, how can we keep business data protected?
  • As my data grows, how can I make sure it is all backed up without spending a fortune?
  • If an unexpected event occurred, like a fire, break-in, or flood, how long would it take our business to get back online? And what would this downtime cost our business?
  • How do we keep up with a constantly changing compliance landscape?

Get modern protection for evolving threats, with solutions that help protect your business data and minimize the disruptions caused by unexpected events. With Microsoft, enterprise-grade protection is built into its technologies. So you don’t have to think about it. From advanced data protection to solutions that help you recover quickly from unexpected events, get technology that is designed to help safeguard your business.

ModernBiz - Safeguard your business Pitch Deck

ModernBiz - Safeguard your business Pitch Deck 2

T-Suite Approved PartnerFor businesses that want to capture new opportunities and create a competitive advantage, Telstra Cloud Services provide end-to-end solutions that scale up or down as needed.

Telstra has a Cloud Partner Program made up of leading industry ICT partners to help them develop and deliver the right cloud solutions for their customers. As a Telstra Partner Jethro Consultants has access to many digital products and services as well as great back end support for our customers.

Telstra Apps Marketplace is the next evolution of Telstra’s T-Suite Applications service, providing new services and capabilities to our customers and partners. The marketplace is one-stop shop and management portal, making it easier than ever to find, buy, and use leading cloud-based business, mobile and communications applications hand-picked by Telstra.^

Key features of the marketplace include a single intuitive and user friendly platform to manage applications and users; 1-click trial - no requirement for customers to provide billing details for trials; end-user access and single-sign-on capability to most applications from one central location. In addition, Telstra partners can buy and manage applications on customers’ behalf.

Telstra Logo UpdateThe following applications are currently available via the Apps Marketplace: *

  • Box - stores and organises business information such as sales presentations and videos in a simple and safe way. Access and share it with colleagues and partners from a compatible mobile device, at work or on the move.
  • DocuSign - lets you sign documents electronically from compatible tablets or smartphones and provides a full audit trail of the signing process.
  • Deputy - lets businesses take control of their rostering by assigning, monitoring and communicating to employees via a simple, easy to use interface.
  • Shoeboxed - an expense management app that allows customers to turn their paper receipts into usable data for tax and expense reporting.
  • Zunos - gives your customers employees access to specific content and tools on their compatible smartphone or tablet.
  • Canvas - an easy and economical way for businesses to find, customise and create digital forms on their compatible smartphone or tablet.
  • GeoOp - job dispatch and management software including GPS Maps Job Scheduling and Management and Data Capture.
  • MozyPro® - online computer data backup service that gives you and your users the capability to backup and restore data files to and from servers or users’ computers on your computer system for an agreed period of time.
  • Symantec - a range of Symantec™ information security and information management products.
  • McAfee - A comprehensive desktop and server security solution that provides up-to-date virus protection even when your staff are working remotely.
  • Work Guardian - makes it easier for customers to manage staff or cope with the compliance or changes to employment law.
  • Domain Names - offers business customers a simple web address and an identity online.
  • Website Services - a range of self-service tools and design services to build a small business website.
  • Website Hosting - allows you to host your website with Telstra
  • Microsoft Online Services Specialised Pricing - Telstra provides specialised pricing for customers seeking Microsoft® Online Services in certain scenarios
  • Mural - Mural services are designed to accelerate application implementation and improve customer satisfaction.
  • Onboard 365 - A migration, setup and ongoing support service for customers purchasing applications through the Telstra Apps Marketplace.  
  • Time Tracker - Time Tracker Business App helps you manage and track your time, billing, payroll and expenses anywhere, anytime.
  • iWebGate Workspace Suite - Is a suite of virtualised network services securely integrated into a single software platform managed through the Virtual Services Platform (VSP).
  • Neto Online Store - is a Telstra Digital Commerce solution that enables businesses to build and maintain online stores.
  • Microsoft Dynamics CRM Online - It’s an online customer relationship management (CRM) App

As a Telstra Partner we are authorised to sell any of these services to our customers with the following provisos:

  • Customers must be an Australian business and have an ABN or ACN to create an account.
  • Customers can choose to bill to Telstra bill (Flexcab only) or Credit Card
  • Customer must be vetted as an authorised representative and be authorised to add services to the nominated Telstra (Flexcab) account.

We also use several of the applications on this list as a customer and can provide you with scenarios and case studies to show how you can benefit from these services.

* Apps list as of 26 May 2016

^ Accessibility and functionality of the Telstra Apps Marketplace and its applications may be affected by the internet connection, browser and computer system the customer is using.

Like us on Facebook

What people say..

I learnt some points that enable me to look at my business in the (way) that will improve my bottom line. Thanks Tim and Ian.

Free Business Seminar Feedback Nov 2012

— Roland - Financial Advisor

Navigation

Syndicate