A picture is worth a thousand words–especially at work. The data we present every day is what helps us drive decision-making in the workplace. But understanding how to visualize a story can be difficult if you’re left staring at numbers sitting stagnant in rows or columns within a spreadsheet. 

This is where visualization with charts and reports becomes critical. Let’s say your team needs to understand global sales trends. If you have a waterfall chart that shows regional contribution to total revenue or a scatter plot that shows individual salesperson performance, it’s much easier to spot patterns, draw insights, and make informed recommendations. The same goes for analyzing travel expenses.

In Google Sheets, we have several built-in tools that make it easy to create and share useful charts and reports so that you can quickly visualize data (without having to leave the spreadsheet). Follow these tips to showcase your data in Sheets and influence decisions.

1. Pick the most compelling way to visualize your data.
Perhaps just as important as the data you reference is the way in which you present it. Charts are the basic building blocks for data visualization and can take many forms–from bar charts to line graphs to scatter plots. There are more than 30 chart types to choose from in Sheets, and we’re constantly adding more ways to express your data. Here are a few we recommend:

• To draw attention to a key metric or KPI, try the brand new scorecard chart. For example, you can show the total sales number for your organization’s top-selling product, and even call out percentage increase or decrease over time. 
• To illustrate how values add to or subtract from a starting value, try a waterfall chart. For example, show how your product sales and restocking efforts led to a net decrease in inventory from last quarter to this quarter.
• To represent different data series using lines and bars, try a combo chart. For example, you can show revenue in bars and profit margins in a line across the same chart, giving you a more complete picture of your organization’s financial health.

If you’re unsure how to best present your data, Google’s built-in machine learning can help you choose the right visualization—Sheets intelligently suggests charts for you. Simply highlight data you would like to visualize, click the chart button, and then select one of the suggested charts. According to our internal data, more than 1.5 million charts are inserted into Sheets each week based on intelligent recommendations.

Note: Once you have a chart inserted into Sheets, you may want to control the look and feel. We recently made it possible to click directly on data labels, chart titles, or legends and drag to reposition them. You can also easily delete these elements using the delete or backspace keys, if you want to make other data points stand out. We’re exploring even more ways to customize charts—stay tuned.

2. Be sure to tell a complete story. 
Data really comes to life when you put several charts and tables together into a report or dashboard. Going back to our sales data example, an individual line graph showing revenue over time gives you quick insight into the general sales trend for your organization (hopefully, up and to the right!). But when you surround that line graph with other charts and tables–like a pie chart showing total revenue breakdown by-product, or a stacked bar chart comparing revenue driven by each sales team–you can tell a more complete story. 

If you do build reports featuring multiple charts, there are ways that Sheets can help you organize and format them more quickly. Earlier this year, we made it easier to align, size, and position objects within your spreadsheets so you can quickly put several charts together. We also recently added themes, which let you alter the look and feel of an entire spreadsheet—including charts, pivot tables, and cells—to ensure a consistent look and feel across the elements in your report. To apply a preset theme, select Format > Theme and choose the right option. Faster formatting can mean faster reporting.

Workplace collaboration continues to evolve as hybrid work expands its footprint. While both “same-time” and “staggered-time” (or asynchronous) collaboration modes each have their place in the hybrid work environment, organizations and teams sometimes overuse one mode over another. That’s probably because in-person meetings or collaborating in real time have been the default for many organizations, leading to a “same-time” bias, even as new tools make working across time zones and locations seamless. Ultimately, the key for making collaboration scalable and to support employee wellbeing is choosing the right method and tool for the task at hand. With that in mind, here are some ways to get the most out of same-time and staggered-time collaboration in your organization.

Making same-time collaboration more valuable

Historically, many organizations have valued same-time interactions for the fast, direct exchange of information and feedback. They also bring teams together and build human connections. While all these outcomes are powerful and important, same-time collaboration also has some drawbacks — especially in a hybrid environment.

First, same-time interactions can be difficult to arrange. Coordinating schedules requires advanced planning, especially when employees are distributed across time zones or working outside of traditional business hours. Second, back-to-back scheduling can contribute to meeting fatigue. In our recently commissioned global hybrid work survey with Economist Impact, 72% of respondents acknowledged that virtual meetings improve inclusion and participation. At the same time, 68% said there are too many virtual meetings in general, suggesting that even though employees value same-time collaboration, they want it in moderation.

To address these challenges, organizations should consider the collaboration scenarios in which same-time interactions can make the greatest impact. It’s particularly useful when consensus or immediate action is needed, as in briefings, decision-making, and crisis management.

For effective same-time collaboration in a hybrid environment, your employees need tools that help them coordinate real-time interactions and minimize time spent switching apps and context. With Google Workspace, teams can create and access a shared agenda or Google Doc inside a Google Calendar invite, helping align expectations and goals before, during, and after scheduled same-time work sessions. And, the more integrated your collaboration tools are, the easier it is for employees to get right to work when inspiration strikes or a quick decision is needed. For example, team members can initiate spontaneous work sessions by starting a Google Meet directly from Docs, Sheets, or Slides.

Additionally, consider how you can bring real-world collaboration activities into virtual environments to enhance same-time collaboration for distributed teams. For instance, digital whiteboard tools, like Jamboard and Miro in Google Meet, allow people to brainstorm, ideate, and problem-solve in real time from anywhere. Interactive solutions like these empower employees to work together in new ways.

Expanding what’s possible with staggered-time collaboration

Widespread adoption of hybrid work has prompted organizations to turn more frequently to staggered-time collaboration — where team members are free to share and respond to information in their own time. A key benefit of staggered collaboration is improving the experience and wellbeing of employees — specifically, by promoting participation across the team and support for flexible work habits. Allowing team members to engage when they’re most productive, or when it doesn’t interfere with their scheduled focus time, supports their wellbeing. It can also help employees feel heard, valued, and empowered. Staggered-time collaboration can also give team members who may feel uncomfortable or vulnerable speaking up in real time, or who just need time to think about their feedback, a more inviting way to share their perspectives.

Staggered-time collaboration can enhance a range of collaboration scenarios, including assigning tasks and action items, knowledge- and resource-sharing, brainstorming, and giving feedback. To make these interactions successful, employees need secure, intuitive tools that give them the information they need to do their jobs from anywhere, at any time. For example, in Spaces, team members can initiate and take part in group chat threads devoted to project- and topic-based discussions, as well as access files and tasks, to stay in the loop whenever they’re able to participate. For people working on a task or project at varied times, creating a dynamic, single source of truth makes all the difference.

When collaborating on shared documents, a feature like smart canvas enables teammates to assign tasks, build checklists, and share files using @-mentions for easy information access. Meanwhile, automated, built-in summaries in Docs help the team get up to speed without losing focus. Features like these help everyone stay on the same page (literally), even if they’re contributing to a project at different times.

Flexibility and collaboration are not mutually exclusive

Helping people know which tasks call for real-time collaboration and which tasks are better done on their own time is critical for sustaining productivity and wellbeing in a hybrid work world. Employees who are empowered to work in ways that complement their needs, preferences, and schedules typically reward their organization for that flexibility. As Holger Reisinger, Paul Sephton, and Dane Fetterer wrote for the Harvard Business Review, “When leaders give employees the freedom to choose where and when they work, it signals they trust them to do the job they were hired to do. The data shows that that trust is then paid back…at a very high rate, building a tight-knit culture of inclusivity and belonging.”

When you create team norms around same-time and staggered-time collaboration, you can help your employees stay productive and connected — to each other and the broader organization. And by giving them tools that support seamless, secure collaboration experiences from anywhere, the impact on productivity, employee wellbeing, and morale can be transformational.

In 2020, many businesses across industries turned their focus and investments towards digital strategies. APIs being an integral part of every organization’s digital disruption, will grow in relevance throughout 2021. Read the report to gain more insights on driving API-led digital transformations and in-depth analysis of Google Cloud’s Apigee API Management Platform usage data, case studies and third-party surveys conducted with tech leaders.

Creating a secure-by-default experience based on robust defenses has always been a core design principle for Gmail. That’s why we’ve established a strong baseline of security in Gmail, with built-in protections to help automatically filter out potentially malicious messages. While these defenses help keep Gmail users safe, email functions as part of a large, complex, interconnected ecosystem that we continually invest in and work to protect. After first announcing Gmail’s Brand Indicators for Message Identification (BIMI) pilot last year, today we’re announcing that over the coming weeks we’re rolling out Gmail’s general support of BIMI, an industry standard that aims to drive adoption of strong sender authentication for the entire email ecosystem. BIMI provides email recipients and email security systems increased confidence in the source of emails, and enables senders to provide their audience with a more immersive experience.

“Bank of America has a wide range of security measures in place to support our customers, and we constantly evolve our program to deliver best in class protection. Part of this effort is our partnership with Google on BIMI, which provides an easy way to validate if correspondence is from us.” — Bank of America

BIMI enables organizations that authenticate their emails using Domain-based Message Authentication, Reporting, and Conformance (DMARC)—a standard for providing strong sender authentication that allows security systems to perform better filtering, separating legitimate messages from potentially spoofed ones—to validate ownership of their logos and securely transmit them to Google. BIMI is designed to be easy: for organizations with DMARC in place, validated logos display on authenticated emails from their domains and subdomains.

Here’s how it works: Organizations who authenticate their emails using Sender Policy Framework (SPF) or Domain Keys Identified Mail (DKIM) and deploy DMARC can provide their validated trademarked logos to Google via a Verified Mark Certificate (VMC). BIMI leverages Mark Verifying Authorities, like Certification Authorities, to verify logo ownership and provide proof of verification in a VMC. Once these authenticated emails pass our other anti-abuse checks, Gmail will start displaying the logo in the existing avatar slot.  

“Gmail’s support of BIMI is a win for email authentication, brand trust, and consumers alike. BIMI gives organizations the opportunity to provide their customers with a more immersive email experience, strengthening email sender authentication across the entire email ecosystem.” — Seth Blank, Chair of the AuthIndicators Working Group

This is just the start for BIMI. The standard expects to expand support across logo types and validators. For logo validation, BIMI is starting by supporting the validation of trademarked logos, since they are a common target of impersonation. Today, Entrust and DigiCert support BIMI as Certification Authorities, and in the future the BIMI working group expects this list of supporting validation authorities to expand further. To learn more about BIMI and see the latest news, visit the working group’s website.

To take advantage of BIMI, ensure that your organization has adopted DMARC, and that you have validated your logo with a VMC. For Gmail users, no action is required. We’re proud to be one of the leading members in both establishing and supporting the BIMI standard and will continue to support efforts that contribute to security for the entire email ecosystem.

When I reflect back on the past year and the pandemic, I’m struck by how the reliance on remote work and operations has changed the fundamentals of business forever. For the financial services industry, this rings particularly true. Many conversations I’m having right now with organizations revolve around embracing a transformation cloud, and thinking of cloud computing not just as an infrastructure decision, but also as the locus for transformation throughout the company. 

Today, as we welcome the industry to our Financial Services Summit, we’ll demonstrate just how Google Cloud accelerates a financial organization’s digital transformation through app and infrastructure modernization, data democratization, people connections, and trusted transactions. We hope you’ll join us.

How we’re helping financial services firms build their transformation clouds

At Google Cloud, we continue to focus on areas where we can bring the best of our capabilities to banking, capital markets, insurance, and payments customers around the world. Our work with financial services industry customers has given us a deep understanding of the real-world, specific use cases that matter most to them. This groundwork led us to engineer products and solutions that are open and flexible, not ones that force them to rip out existing investments in ERP or other early IaaS cloud implementations. 

It’s why we’ve engineered solutions such as Lending DocAI, Open Banking with Apigee, and Datashare for financial services to help transform the industry. These solutions were created with our customers’ security and compliance top-of-mind and are built at the intersection of user-optimized experience, technology, and sovereignty.

At their core, financial institutions want to drive growth, reduce costs, mitigate risk, stay compliant, and increase efficiency. As a result, when we partner with them on their transformation journeys, we consider three essential focus areas: 

• Enabling the human experience and connected interactions
• Building an open and intelligent data foundation for better insights
• Providing the most trusted and secure cloud in the industry

Enabling humans and connected interactions

A company’s transformation is about more than technology; people and culture ultimately drive change. HSBC, for example, recognized its business users would benefit from guided answers to common questions around risk policy compliance, and turned to Google Cloud to leverage AI and machine learning bots to assist employees, ease the burden on policy experts, and improve the user experience. Using Dialogflow, a core component of Contact Center AI, HSBC was able to build a conversational platform that quickly and accurately addresses user needs at scale. 

Another example is Equifax, which used Google Workspace to support collaboration not only internally between employees, but also externally with customers. Customers can use Google Cloud solutions for financial services to build these sorts of technology-enabled human interactions quickly and easily—supporting organizational change at scale.

Building an open and intelligent data foundation for smarter, faster insights

The real impact of Google Cloud solutions for financial services comes when the whole company has access to the right information at the right time, and can act more intelligently on that data. Our solutions help businesses safely leverage their data and get a complete 360-degree view of their customers’ information, which can often be scattered across multiple systems (CRM, lending, credit, etc.). This helps financial institutions improve the overall customer experience—and sometimes even develop new products quickly. 

Indeed, all financial institutions are looking for ways to grow revenue and reduce expenses, and data can be a critical ingredient to doing both effectively. As daily transactions rise, so does the volume and complexity of data. But to implement new customer experience innovations (and new revenue streams), financial institutions must first capture data effectively. This is why AXA Switzerland, for example, uses real-time analytics on Google Cloud to gain cross-industry insights about future trends and customer preferences.

Financial services organizations also need the confidence of building on a platform that provides choice, flexibility, and agility to move fast. It’s why we have an open cloud approach that allows Google Cloud services to run in different physical locations such as on-premises, other public clouds, and the edge. Customers can also harness the power of data and AI through our open APIs, machine-learning services, and analytics engines on any major cloud platform. This is why companies like Macquarie Bank are taking advantage of Google Cloud’s open, hybrid architecture to modernize and empower its developers.

Compliant and secure to address risk and regulatory needs

As a highly regulated industry, financial services is focused on security and compliance, risk and regulations, and fraud detection and prevention. Google Cloud offers unique capabilities to earn customers’ trust as part of our continuing work to be the most trusted cloud in the industry. Google Cloud provides a secure foundation that you can verify and independently control. Our cloud technology reduces risk and data loss, because it is built on comprehensive zero-trust architecture. Finally, we offer a shared-fate model built on best practices in risk management via automation, guidance, and insurance. This is why customers like BBVA have confidence anywhere their systems may operate. 

On the regulatory front, global legislators and regulators continue to focus on the stability of the industry that only a decade ago went through one of the biggest liquidity crises in history. With this oversight comes strong expectations of risk mitigation. Google Cloud offers a single, global set of controls, reviewed by financial institutions and regulators around the world, and verified in collaborative audits—making compliance simpler and less costly for our customers.

Finally, Google Cloud allows financial services firms to operate confidently with advanced security tools that help protect data, applications, and infrastructure, as well as their customers from fraudulent activity, spam, and abuse. We help protect your data against threats, using the same infrastructure and security services we use for our own operations, ensuring you never have to trade-off between ease of use and security. Google Cloud encrypts data at-rest and in-transit. And we now also offer the ability to encrypt data-in use, while it’s being processed for customer VM and container workloads.

Let us help you with your transformation cloud journey

We’ve seen leading financial services companies embrace Google Cloud to help them move beyond infrastructure toward the next phase of their cloud evolution. This is an era where no company is better positioned to lead than Google Cloud, and we’re excited to help you with your journey.

Learn more about Google Cloud for financial services.