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

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

Delay delivery and schedule email sending 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

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