Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

Friday, 26 October 2018

Google Docs and Microsoft Word



Intro

Hi.  Welcome to episode 12 of this Productivity Matters podcast.
Do you write a lot of documents? Have you thought there maybe an alternative to the tools you use?
I’m Julian, your host for this episode, and I’m going to take a look at online document creation, and two of the main tools available, Google Docs and Microsoft Word.
Coming up right after this...

In the beginning..

35 years ago Microsoft began introducing the world to their software suite of office products - starting with Word (for word processing), followed up with Excel (for spreadsheets) and Powerpoint (for creating presentations).
Suddenly, it became possible to write and save documents, do calculations and present all of it relatively quickly and simply - if you had a computer of course.
Over the years, Word became the defacto application for creating all things related to the written word.  It has grown in functionality and has never, quite, been beaten for what it can do.  Apple created their own version, called Pages, but it's not that intuitive; in my opinion.

Welcome Google

All of that changed in September 2007 (yes, just over 10 years ago) when Google launched their own, online, versions; called Doc, Sheets and Slides.  I’m sure you can guess their equivalents. 
It was quite basic, but the gauntlet had quite clearly been thrown down.  Let's face it; Google shook up the browsing world, with Chrome, and now they were set to do the same for office productivity.

Word

Microsoft Word is a fully-featured word processing application that allows you to write and write and write; and format your text into various fonts (and there are a multitude to choose from), not forgetting setting paragraphs, columns, styles, borders and colours to bring a document to life.  Once created, you can save your work to continue later, or, if ready, it can be printed out or shared via email.
Google Docs, on the other hand, has had 30 years to catch-up on.  After a rudimentary offering, they have built on the functionality each year, and they now offer a very advanced application.
Don't be misled by the bare-bones look and feel.  You won't find it lagging too far behind Microsoft.
One of their biggest selling points was in collaboration.  Whilst Microsoft offered all the bells and whistles to create a beautiful looking document, Google used their cloud presence as a huge advantage.  Share your document, in real-time, with colleagues, and make changes live.  
Suddenly, the Google offering, whilst not as fully-featured, offered something not previously available.  The ability to share and work together, and be able to see the history of all the changes - just in case!  Having said that, the need to be online was also a negative; as you had to be connected to the internet to use it.  That has now changed, with Google having now enabled the ability to create and edit offline.
Integration with Google Drive soon followed, and now any documents (or spreadsheet or presentation) created in Google Drive will not count towards the storage space.
This is a huge advantage for those with buckets of documents.  

Using Google Docs

I use Google Docs and the others, quite extensively.  They're easy to use and easy to export to various formats; whether that be PDF or even to the native Microsoft Word format, so that anyone with Word can open the document.
Google even created a business offering, called G-Suite; giving companies an enterprise version, with the controls they need. Of course, this isn’t free, but it is a fraction of the cost that Microsoft charge for their suite of products. 

Cost

We also need to look at the cost.  It may come as no surprise that Google Docs, Sheets and Slides are free to use.  Totally.  No gotchas.
Although, as we know with free YOU are the product and should expect Google (in this instance) to use your data to further enhance its marketing capabilities.
Microsoft Word is not free - in fact, you will usually buy it as part of a bundle together with their Office suite of software (which allows up to 6 users) 
This is £80 per year.  
If you use all 6 licences, that works out at just over £13 per person, per year. 
That gives you access to Word, Excel, Powerpoint, the email manager, Outlook, OneNote (their alternative to Evernote), Publisher and Access (both of which are only available on PC - and I don't know who uses them anymore, anyway!)
It’s not an unreasonable cost for a family. 

Conclusion

So, how do we summarise this. 
There is no need to buy Microsoft Office if all you need is available from Google.  Their Docs application has everything you need to do what you want; it's less cluttered than it's counterpart (which can seem quite bloated at first) and it’s fairly intuitive to use.  You will need to have a play with it to see how it works for you.
Whilst there are others on the market, but for the purposes of this podcast, to get the familiar looking experience with all the functions you would ever want, then you have no choice but to pay up and get Office.  It's not cheap; but you will never want for anything again, when it comes to writing documents, creating spreadsheets or presentations.

Thank You

I hope you’ve enjoyed this episode.
If you have any questions about Google Doc, Microsoft Word, or anything else related to office applications, then please get in touch via Twitter @prodmatters
Don’t forget to subscribe where you normally listen to podcasts.
Thank you very much for listening and until next time, remember, Productivity Matters.

Equipment I use to make my podcasts:
Blue Yeti Microphone - https://amzn.to/2R2am1N
Pop Filter - https://amzn.to/2OVMbQP
Professional Microphone Boom Arm - https://amzn.to/2P4EIio

If you purchase from these links then I may receive a commission.  This does not affect the price you will pay.  Thank you.

Friday, 5 October 2018

Notion


Intro

I'm going to take a look at a relatively new app, called Notion. It's like a one-stop shop for all your stuff.


 

Welcome

If you’re a user of Evernote, ToDoIst, Trello, calendars, even wikis, then there’s a app in town that has you pretty much covered.

Notion.so is an all-in-one workspace.
In fact, their own website likens then to a Lego-style building blocks for your information.

Introduction to Notion

Notion is completely free to use on iOS, Android, Mac, Windows and via the web. Notion allows you to build workspaces to store and manage information for whatever you like.
A good example to start with is this podcast.
I use Notion to collate and write my scripts. I can upload documents, add images, to be used in the blog transcript, and use a kanban board for my to do list - when I need to complete scripts, when I need to record, etc.
I use Notion to update the blog version, before copying it into my blog.
In fact, Notion has been touted as a replacement for Evernote; although I don’t think it’s quite there yet in terms of some of the functionality.


Notes & Wikis

Notion is great for businesses and individuals alike. So what does Notion claim they can replace?
For notes and documents, then it can replace Google Docs and Evernote - although, as I mentioned before, the full capability of Evernote is not there yet.



The knowledge base style could replace Confluence or GitHubWiki. With code snippets a breeze, it's a great tool for capturing coding standards. You can embed a document stored on Google Drive. Add a link from Google Maps. Do you use Invision for your designs? These can be embedded too. There are 50+ integrations.

Tasks & Projects

For tasks and projects, Notion say they are a good alternative to Trello, Jira and asana. I have to agree that the Trello style boards is really rather good, with plenty of options to add statuses, reminders, tags and the like.
You can create to do lists, and add a reminder.




At the moment you can’t create recurring tasks, so it’s not a replacement for ToDoIst or Reminders just yet. But I’m assured that’s coming.

Finally, spreadsheets and databases. For this, they suggest this can replace Google Sheets and Airtable. Using views, Notion does give you access to your information in a variety of ways.

General

Editing across the application is as simple as drag and drop. You can do font customisations, select colours and add comments; which is ideal for collaboration.
Talking of collaboration, you can also use the Slack integration to push updates to the rest of your team.

Just by highlighting text, you can create bulleted or numbered lists and one of my favourites is the toggle list - which allows you to expand / or hide a section of text at the click of a button.
Notion can also be used offline and will sync with your other devices when reconnected.
I could spend many more hours talking through the various options.

Cost

Earlier on I mentioned that Notion is free to use, and that is true. You can have unlimited members, and you get 1000 blocks of whatever type of content you want to create. A block is any single piece of content you add to your page; like a to-do item, an image, embedded file. It's a lot of information - my entire set of scripts and blogs are created here and I have plenty of room left.

The free version also limits file uploads to 5MB for each file.

Once you reach the limit, you can either delete blocks to free up space, or you can subscribe to the completely unlimited personal version, with no file upload limit, and advanced permissions for $48 per year (which is about £36 at todays rate).

The Team version, which also adds administrative tools is $96 per year, per user (about £74). When you consider the costs of the other tools combined, this is not overly expensive.

Conclusion

Now, whilst I am extolling the virtues of Notion, it must be said that it comes with quite a steep learning curve.

It can do so much, and when you first start to look at it, it can be a little daunting. However; it is definitely worth spending some time getting to know what it can do - and since it's free, then there's nothing lost; except time.

Thank You

I hope you’ve found this post interesting.
If you have any questions about Notion, then please get in touch via the comments below.

Equipment I use to make my podcasts:
Blue Yeti Microphone - https://amzn.to/2R2am1N
Pop Filter - https://amzn.to/2OVMbQP
Professional Microphone Boom Arm - https://amzn.to/2P4EIio

If you purchase from these links then I may receive a commission.  This does not affect the price you will pay.  Thank you.