Google Sheets is powerful. It's not as powerful in some ways as Microsoft Excel has become over the past four decades, but it's stuffed full of functions - Google's name for formulas - and these can be used to turn the spreadsheet service into a powerhouse for data organization and … [Read more...] about How to use the VLOOKUP function in Google Sheets to find things in a table or range by row
Workspace Sessions
Welcome to the Workspace Sessions. This is our ongoing series to help you and your organization make the most out of the Google Admin Console, Workspace apps, hardware and more.
Support our independent tech coverage. Chrome Unboxed is written by real people, for real people—not search algorithms. Join Chrome Unboxed Plus for just $2 a month to get an ad-free experience, access to our private Discord, and more. Learn more about membership here.
START FREE TRIAL (MONTHLY)START FREE TRIAL (ANNUAL)
How to enable Dark Mode on Google Docs for Android and the web
Are you sick and tired of editing late at night and being completely blinded by the light of a white user interface in Google Docs? What's astonishing to me is that despite the many ways that Google has already baked Dark Mode into many of its apps, several others remain without it in 2022. That's … [Read more...] about How to enable Dark Mode on Google Docs for Android and the web
How to use Google Sheets Filter Views to analyze data without screwing it up for everyone else
Have you ever been invited into a Google Sheet to view or analyze data only to then right-click a column or row and sort it from A to Z for easier viewing and realize that you've completely screwed up the organization of that data for everyone in the team? You may have even caused the colorful, … [Read more...] about How to use Google Sheets Filter Views to analyze data without screwing it up for everyone else
How to swap Google Calendar’s default color scheme for new and interesting color palettes
I know you're over-saturated with Google's popular primary color scheme, and you may even love it as much as I do, but when you use your Google Calendar to time block every morning and plan your day, bright red, yellow, blue, and green can get a bit visually overwhelming. Have you ever wished … [Read more...] about How to swap Google Calendar’s default color scheme for new and interesting color palettes
How to autocomplete a series or a list of numbers, dates, and formulas in Google Sheets
Google Sheets has come a long way over the years. At launch, it lacked many features that statisticians and spreadsheet users came to expect based on decades of Microsoft Excel use. While it's not even close to Microsoft's offering, even today, depending on who you ask or how fancy they need to get … [Read more...] about How to autocomplete a series or a list of numbers, dates, and formulas in Google Sheets
Cameyo joins Chrome Enterprise Recommended Program
Virtual App Delivery has become a very hot topic over the past couple of years as thousands have shifted to a remote or hybrid workflow. For many businesses, the shift to Chrome OS and the Chrome Enterprise Platform means finding a way to embrace Google's cloud-centric services while still being … [Read more...] about Cameyo joins Chrome Enterprise Recommended Program
Google Docs adds new Smart Canvas features including Summaries and Pageless formatting
Google's "Smart Canvas" update for Docs, Sheets, and Slides provided a much-needed boost to collaborative flexibility and tools in the company's ecosystem last year, and it's still reimagining what it looks like to work together with others in a more efficient, interconnected, and rich way to this … [Read more...] about Google Docs adds new Smart Canvas features including Summaries and Pageless formatting
Microsoft lures unhappy Workspace legacy free edition users with a steep 365 discount
Corporate Vice President for Microsoft 365 wrote a blog post this week that details the company's sweet, sweet offer for disgruntled Google Workspace legacy free edition users. Microsoft is offering this group 60% off of a 12-month Microsoft 365 Business Basic, Business Standard, or Business Premium … [Read more...] about Microsoft lures unhappy Workspace legacy free edition users with a steep 365 discount
CTL launches cost-effective 14-inch Jasper Lake Chromebooks
Last fall, CTL launched its newest education-focused Chromebook in the form of the 11.6" PX11-E. That device comes bearing the latest small-core Jasper Lake CPUs from Intel and is geared towards K-12 students. This month, the Oregon-based technology company brings a follow-up Jasper Lake device … [Read more...] about CTL launches cost-effective 14-inch Jasper Lake Chromebooks
[Correction] Google Calendar simplifies managing tasks you never got around to
Correction: We stated that Google Tasks would move with you to a new day if not marked off as complete, but this feature only works with Reminders. The original article has been left intact, but we're noting the correction here for accuracy. Thanks, Edward Darrah! I use Google Tasks a ton in … [Read more...] about [Correction] Google Calendar simplifies managing tasks you never got around to
Chromebase for Meetings can now participate in Google Meet Polls and Q&As
Thanks mostly to HP, the Chromebase has made a strong comeback, and the all-in-one Chrome OS desktop presents itself as a solid option for the workplace, consumer kiosks, and home setups alike. For those that use a Chromebase at work or as a work-from-home device, Google is adding a very useful … [Read more...] about Chromebase for Meetings can now participate in Google Meet Polls and Q&As
Google launches Workspace Essentials Starter, costs you nothing but doesn’t include Gmail
A brand new version of Google Workspace is launching since we don't already have enough. It's called Workspace Essentials Starter, and it's going to cost you a big, fat zero dollars per month for you and your team. Wait, what? That's right, Essentials Starter will cost you nothing, and that's … [Read more...] about Google launches Workspace Essentials Starter, costs you nothing but doesn’t include Gmail
