Tutorials, videos, useful tips for Excel, Outlook and Google Sheets, page 8

How to create a table in Excel

At the surface, an Excel table just sounds like a way to organize data. In truth, this generic name covers a ton of useful features. Tables containing hundreds or even thousands of rows and columns can be instantly recalculated and totaled, sorted and filtered, updated with new information and reformatted, summarized with pivot tables and exported. Continue reading

How to insert Google Sheets checkmarks and cross marks

Lists help us put things in order. Stuff to buy, tasks to solve, places to visit, movies to watch, books to read, people to invite, video games to play - everything around us is practically filled with those lists. And if you use Google Sheets, chances are that it would be best to track your endeavours there. Let's see what instruments spreadsheets offer for the task. Continue reading

Useful Google Sheets functions that don't exist in Excel

This blog post brings the majority of those Google Sheets functions that Excel doesn't have to your attention. They are conveniently classified by Google based on their primary task. So just pick the group from the table of contents and you'll find their descriptions with the simplest examples. Continue reading

Schedule email sending and delay delivery in Outlook

Does it often happen to you that you send an email and a moment later you wish you hadn't? Perhaps you clicked Reply All instead of Reply, or accidentally sent sensitive information to a wrong person, or just realized that your angry response was a bad idea and you need to cool down. Continue reading

Handy tools to manage text in Google Sheets

Despite lots of perks offered by Google Sheets, it also has its drawbacks. A clear example of that is the shortage of simple tools to manage text. Are we bound to add or replace text in Google Sheets manually or with complex formulas? Not anymore. :) We've filled this gap with simple one-click tools. Allow me to introduce them to you in this blog post. Continue reading

How to recall email message in Outlook and Gmail

A hasty click of the mouse can happen to the best of us. So, the Send button is hit, your email is on its way to the recipient, and you are cringing at the thought of what it may cost you. Before you start weighing the consequences and composing an apology notice, why not try to retrieve the erroneous message? Continue reading

Developer tab in Excel: how to add, use and remove

You want to access one of advanced Excel features but are stuck at the very first step: where's the Developer tab they all talk about? The good news is that the Developer tab is available in every version of Excel though it is not enabled by default. This article shows how to quickly activate it. Continue reading

Google Sheets percentage formulas - usage and examples

You may think percentage calculations are useful only if you use them for work. But in reality, they help you in everyday life. Do you know how to tip properly? Is this discount a real deal? How much will you pay with this interest rate? Come find the answers to these and other similar questions in this article. Continue reading