Welcome!

Wireless Authors: Liz McMillan, Carmen Gonzalez, Pat Romanski, Lori MacVittie, Elizabeth White

Related Topics: Cloud Expo, Open Web

Cloud Expo: Blog Feed Post

Google Apps: The Missing Manual

This book does a great job at capturing the core functionality of Google Apps

googleappsmissingmanualI’ve mentioned before that I run my small business, Crucial Point LLC, primarily by leveraging cloud computing capabilities. With this post I’ll mention a book that helped me do that: Google Apps: The Missing Manual.

This book does a great job at capturing the core functionality of Google Apps. However, no book can keep up with the capabilities and features of the Google Apps suite.  In cloud computing, features can be developed and fielded fast, and since Google intentionally invests in driving more and more features, a continuing stream of announcements on new functionality has occurred since I bought this book.

That said, the Manual is full of tips, techniques, suggestions and guidance for making the most of your Google Apps that remains very relevant.  Whether you are a user of the free personal/educational/non-profit editions or a business users these are very powerful tools and a book like this can help you think through ways to transform your workflow.

I’d recommend the book to anyone thinking about making the switch to cloud computing.  I should also point out that they give away some great free content from the book online at Amazon, right in the book review. For example, the following list of tips:

QUOTE:

Top 14 Google Docs Tricks

1. If you install Google Gears (http://gears.google.com/), you can edit Docs word-processing documents offline, and Docs automatically syncs them with the online version the next time you sign in online.

2. If you make other folks collaborators on Docs documents and spreadsheets, everyone can work on the files simultaneously. To invite collaborators, head to the upper-right Share button (for documents) or Share tab (for spreadsheets).

3. It’s a snap to publish documents created in Docs as blog posts—just select “Publish as web page” from the Share menu, and then click the “Post to blog” button.

4. If you want to embed a Docs presentation in a Web site, just go to the Publish tab, click “Publish document”, and then copy the HTML that appears in the Mini Presentation Module box. Paste the code into your site’s HTML, upload the revised version of the site, and voilà!

5. Google gives you a whole slew of functions to help make working with spreadsheets more efficient. For the complete list, go to www.docs.google.com/support/spreadsheets. (The GoogleLookup function is particularly nifty.)

6. If your Docs list is getting cluttered, you can hide files (documents, spreadsheets, or presentations) to keep your list clean. Just turn on the checkbox next to any file you want to hide (you can select more than one), and then click the Hide button. To make a hidden file reappear, find All Items in the left-hand menu and, if necessary, click its + sign to expand it. Then click Hidden to see your hidden files; select the one(s) you want to see in your Docs list, and then click Unhide.

7. You can easily turn spreadsheet data into all kinds of charts: column, bar, pie, line, area, or scatter. To create a chart, open your spreadsheet to the Edit tab, select the range of cells you want to convert into a chart, and then click the “Add chart” button. In the Create Chart box that appears, tell Docs what kind of chart you want to create and fill in the other info it needs, and then click “Save chart.”

8. If you create a chart based on a Docs spreadsheet, you can save it as an image and insert it into a Docs document. After you create your chart, click its upper-left Chart link and select “Save image”. Save it to your computer, and then open the document you want to put it in. Click Insert and select Image, then tell Docs where to find the file on your computer.

9. If you don’t like a change that you (or someone else) made to one of your Docs files, no problem. Just head to that file’s revision history (click File and then choose “Revision history”) and pick a previous version that you like better.

10. If you’re working on a computer that doesn’t have Adobe Reader and you need to print a document, click Share and select “View as web page (Preview)” to open the formatted document as a Web page. You can then print it from your Web browser. The formatting isn’t quite as good as if you print from a PDF—and you’ll probably have the browser’s header and footer—but all the content is there.

11. If you’ve published a Docs document as a Web page, you can make the Web page update automatically whenever you edit the document. Just click Share and select “Publish as web page”; then turn on the “Automatically republish when changes are made” checkbox.

12. To see how your Docs document will look to folks you share it with, click the Share This Document page’s “Preview document as a viewer” link. If the preview doesn’t look quite right, then go back and edit the document before you share it.

13. You can add YouTube videos to your Docs presentations. In the blue bar above the edit pane, click “Insert video”. Google opens a box where you can search YouTube videos by keyword. Find the one you want and click it to select it. Then click the Insert Video button to put the video on your slide. Once it’s there, you can move, resize, or delete it, just like any image or shape. During a slideshow, viewers can play the video by clicking the Play button on its slide.

14. When you’ve got several collaborators editing the same document all at once, have each person choose a different color for his text to help sort out who made what changes. (The simplest thing is to have each person use the same text and highlight color.) Then, when you finalize the document, simply select the whole thing and click the “Text color” button to change the rainbow of text colors to basic black.

UNQUOTE

The Amazon review also provides a list of the “Top 10 Cool Things about Gmail” and “11 Ways to Save Time with Google Apps.”

You can find many other user-focused books on Cloud Computing, but in my opinion, Google Apps: The Missing Manual remains the best.

Related posts:

  1. Cloud computing and my small business
  2. Google App Engine: CTOs should check it out
  3. A Google Knol on Disruptive Technology

Read the original blog entry...

More Stories By Bob Gourley

Bob Gourley, former CTO of the Defense Intelligence Agency (DIA), is Founder and CTO of Crucial Point LLC, a technology research and advisory firm providing fact based technology reviews in support of venture capital, private equity and emerging technology firms. He has extensive industry experience in intelligence and security and was awarded an intelligence community meritorious achievement award by AFCEA in 2008, and has also been recognized as an Infoworld Top 25 CTO and as one of the most fascinating communicators in Government IT by GovFresh.

@ThingsExpo Stories
Cultural, regulatory, environmental, political and economic (CREPE) conditions over the past decade are creating cross-industry solution spaces that require processes and technologies from both the Internet of Things (IoT), and Data Management and Analytics (DMA). These solution spaces are evolving into Sensor Analytics Ecosystems (SAE) that represent significant new opportunities for organizations of all types. Public Utilities throughout the world, providing electricity, natural gas and water, are pursuing SmartGrid initiatives that represent one of the more mature examples of SAE. We have s...
The security devil is always in the details of the attack: the ones you've endured, the ones you prepare yourself to fend off, and the ones that, you fear, will catch you completely unaware and defenseless. The Internet of Things (IoT) is nothing if not an endless proliferation of details. It's the vision of a world in which continuous Internet connectivity and addressability is embedded into a growing range of human artifacts, into the natural world, and even into our smartphones, appliances, and physical persons. In the IoT vision, every new "thing" - sensor, actuator, data source, data con...
How do APIs and IoT relate? The answer is not as simple as merely adding an API on top of a dumb device, but rather about understanding the architectural patterns for implementing an IoT fabric. There are typically two or three trends: Exposing the device to a management framework Exposing that management framework to a business centric logic Exposing that business layer and data to end users. This last trend is the IoT stack, which involves a new shift in the separation of what stuff happens, where data lives and where the interface lies. For instance, it's a mix of architectural styles ...
The 3rd International Internet of @ThingsExpo, co-located with the 16th International Cloud Expo - to be held June 9-11, 2015, at the Javits Center in New York City, NY - announces that its Call for Papers is now open. The Internet of Things (IoT) is the biggest idea since the creation of the Worldwide Web more than 20 years ago.
The Internet of Things is tied together with a thin strand that is known as time. Coincidentally, at the core of nearly all data analytics is a timestamp. When working with time series data there are a few core principles that everyone should consider, especially across datasets where time is the common boundary. In his session at Internet of @ThingsExpo, Jim Scott, Director of Enterprise Strategy & Architecture at MapR Technologies, discussed single-value, geo-spatial, and log time series data. By focusing on enterprise applications and the data center, he will use OpenTSDB as an example t...
An entirely new security model is needed for the Internet of Things, or is it? Can we save some old and tested controls for this new and different environment? In his session at @ThingsExpo, New York's at the Javits Center, Davi Ottenheimer, EMC Senior Director of Trust, reviewed hands-on lessons with IoT devices and reveal a new risk balance you might not expect. Davi Ottenheimer, EMC Senior Director of Trust, has more than nineteen years' experience managing global security operations and assessments, including a decade of leading incident response and digital forensics. He is co-author of t...
The Internet of Things will greatly expand the opportunities for data collection and new business models driven off of that data. In her session at @ThingsExpo, Esmeralda Swartz, CMO of MetraTech, discussed how for this to be effective you not only need to have infrastructure and operational models capable of utilizing this new phenomenon, but increasingly service providers will need to convince a skeptical public to participate. Get ready to show them the money!
The Internet of Things will put IT to its ultimate test by creating infinite new opportunities to digitize products and services, generate and analyze new data to improve customer satisfaction, and discover new ways to gain a competitive advantage across nearly every industry. In order to help corporate business units to capitalize on the rapidly evolving IoT opportunities, IT must stand up to a new set of challenges. In his session at @ThingsExpo, Jeff Kaplan, Managing Director of THINKstrategies, will examine why IT must finally fulfill its role in support of its SBUs or face a new round of...
One of the biggest challenges when developing connected devices is identifying user value and delivering it through successful user experiences. In his session at Internet of @ThingsExpo, Mike Kuniavsky, Principal Scientist, Innovation Services at PARC, described an IoT-specific approach to user experience design that combines approaches from interaction design, industrial design and service design to create experiences that go beyond simple connected gadgets to create lasting, multi-device experiences grounded in people's real needs and desires.
Enthusiasm for the Internet of Things has reached an all-time high. In 2013 alone, venture capitalists spent more than $1 billion dollars investing in the IoT space. With "smart" appliances and devices, IoT covers wearable smart devices, cloud services to hardware companies. Nest, a Google company, detects temperatures inside homes and automatically adjusts it by tracking its user's habit. These technologies are quickly developing and with it come challenges such as bridging infrastructure gaps, abiding by privacy concerns and making the concept a reality. These challenges can't be addressed w...
The Domain Name Service (DNS) is one of the most important components in networking infrastructure, enabling users and services to access applications by translating URLs (names) into IP addresses (numbers). Because every icon and URL and all embedded content on a website requires a DNS lookup loading complex sites necessitates hundreds of DNS queries. In addition, as more internet-enabled ‘Things' get connected, people will rely on DNS to name and find their fridges, toasters and toilets. According to a recent IDG Research Services Survey this rate of traffic will only grow. What's driving t...
Connected devices and the Internet of Things are getting significant momentum in 2014. In his session at Internet of @ThingsExpo, Jim Hunter, Chief Scientist & Technology Evangelist at Greenwave Systems, examined three key elements that together will drive mass adoption of the IoT before the end of 2015. The first element is the recent advent of robust open source protocols (like AllJoyn and WebRTC) that facilitate M2M communication. The second is broad availability of flexible, cost-effective storage designed to handle the massive surge in back-end data in a world where timely analytics is e...
Scott Jenson leads a project called The Physical Web within the Chrome team at Google. Project members are working to take the scalability and openness of the web and use it to talk to the exponentially exploding range of smart devices. Nearly every company today working on the IoT comes up with the same basic solution: use my server and you'll be fine. But if we really believe there will be trillions of these devices, that just can't scale. We need a system that is open a scalable and by using the URL as a basic building block, we open this up and get the same resilience that the web enjoys.
We are reaching the end of the beginning with WebRTC, and real systems using this technology have begun to appear. One challenge that faces every WebRTC deployment (in some form or another) is identity management. For example, if you have an existing service – possibly built on a variety of different PaaS/SaaS offerings – and you want to add real-time communications you are faced with a challenge relating to user management, authentication, authorization, and validation. Service providers will want to use their existing identities, but these will have credentials already that are (hopefully) i...
"Matrix is an ambitious open standard and implementation that's set up to break down the fragmentation problems that exist in IP messaging and VoIP communication," explained John Woolf, Technical Evangelist at Matrix, in this SYS-CON.tv interview at @ThingsExpo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
P2P RTC will impact the landscape of communications, shifting from traditional telephony style communications models to OTT (Over-The-Top) cloud assisted & PaaS (Platform as a Service) communication services. The P2P shift will impact many areas of our lives, from mobile communication, human interactive web services, RTC and telephony infrastructure, user federation, security and privacy implications, business costs, and scalability. In his session at @ThingsExpo, Robin Raymond, Chief Architect at Hookflash, will walk through the shifting landscape of traditional telephone and voice services ...
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at Internet of @ThingsExpo, James Kirkland, Chief Architect for the Internet of Things and Intelligent Systems at Red Hat, described how to revolutioniz...
Bit6 today issued a challenge to the technology community implementing Web Real Time Communication (WebRTC). To leap beyond WebRTC’s significant limitations and fully leverage its underlying value to accelerate innovation, application developers need to consider the entire communications ecosystem.
The definition of IoT is not new, in fact it’s been around for over a decade. What has changed is the public's awareness that the technology we use on a daily basis has caught up on the vision of an always on, always connected world. If you look into the details of what comprises the IoT, you’ll see that it includes everything from cloud computing, Big Data analytics, “Things,” Web communication, applications, network, storage, etc. It is essentially including everything connected online from hardware to software, or as we like to say, it’s an Internet of many different things. The difference ...
Cloud Expo 2014 TV commercials will feature @ThingsExpo, which was launched in June, 2014 at New York City's Javits Center as the largest 'Internet of Things' event in the world.