Excel tutorials, functions and advanced formula examples

Find and replace special characters in Google Sheets

Getting tired of all those smart quotes, accented letters, and other unwanted special characters in Google Sheets? We have a few ideas on how to replace them effortlessly. Continue reading

How to remove text from Excel cell and leave numbers or vice versa

Imagine this: you receive raw data for analysis and find out that numbers are mixed with text in one column. In most cases, it will certainly be more convenient to have them in separate columns for closer examination. Continue reading

Video: remove the same characters and substrings from multiple Google Sheets cells

Today's video is all about getting rid of unwanted text from several Google Sheets cells at once. You'll see how our Remove Text add-on removes specific characters and various substrings from different positions in cells. Continue reading

How to remove table formatting in Excel

By default, Excel tables are equipped with a number of great features including predefined table styles. In some situations, however, you may want to remove formatting keeping all other functionality of a table. This tutorial will teach you how to quickly do that. Continue reading

Extract data from Google Sheets cells: text, numbers, URLs, hyperlinks, email addresses, dates, and time

This next bit of our operations with text in spreadsheets is devoted to extraction. Find out ways to extract various data – text, characters, numbers, URLs, email addresses, date & time, etc. – from various positions in multiple Google Sheets cells at once. Continue reading

How to highlight duplicate text strings or words in Excel cell

Excel Conditional Formatting makes it possible to highlight duplicates in every possible way you can think of. But, as usual, there is a "but" - conditional formatting rules work on a cell level while you may want to highlight duplicate text rather than entire cells. This can only be done with macros. Continue reading

How to find and replace multiple values at once in Excel (bulk replace)

How do people usually search in Excel? Mostly, by using the Find & Replace tool, which works just fine for single values. But what if you have tens or even hundreds of items to replace? Luckily, there are a few more effective methods to perform mass replace in Excel, and we are going to look at each of them in detail. Continue reading

Outlook email templates: 10 ways to quickly reply to repetitive emails

If a major part of your online communication is repetitive emails, it would be only natural that you strive to optimize that part of your work. Replying with template can be a great alternative to composing emails from scratch in a tedious keystroke-by-keystroke way. Continue reading

Video: how to add text to multiple Google Sheets cells

We have plenty of useful add-ons to manage text in spreadsheets. Add Text is one of them. Watch today's video to learn how to insert the same text to multiple Google Sheets cells: at the beginning & at the end of cells, after the Nth character, before/after a certain text string. Continue reading

How to write recursive LAMBDA function in Excel with examples

With the introduction of the LAMBDA function, recursive computations in Excel have become available to anyone, not just VBA programmers. To put it simply, you can now construct formulas that behave like a programming language and allow you to achieve so much, with so little, so fast :) Continue reading

Excel LAMBDA function: how to write and use

Until recently, user-defined functions were the prerogative of programmers. The introduction of the LAMBDA function has made them available for everyone. With this wonderful addition to Excel's toolbox, we no longer need VBA skills to create our own custom functions. Continue reading

How to create a meeting template in Outlook

An engaging and informative invitation is an important part of running a successful meeting, and a well-crafted template can save you enormous time on the job. This article looks at how to quickly create meeting templates in Outlook, preset any fields, add input boxes, drop-down menus, and more! Continue reading

Outlook Quick Steps: how to create and use

When doing the same things day in and day out, most irritating is the necessary do it from scratch every time. What would you say if instead of tedious multi-step processes you could accomplish your email routines with a button click? It is what Outlook Quick Steps are all about. Continue reading

How to fix #SPILL! error with Excel VLOOKUP, INDEX MATCH and SUMIF

It is sad enough when a brand-new feature refuses to work in your Excel. But even more frustrating is when a good old thing stops working all of a sudden, and you are receiving an error for a formula that worked perfectly for years. This tutorial will teach you how to fix a #SPILL error in some popular formulas. Continue reading

How to add a dropdown list to Outlook email template

Want to create a dropdown list in your email template? Make it possible to select multiple items? Populate a dropdown from a database? You will find all the solutions in this tutorial. Continue reading

Video: how to split cells with text to multiple columns in Google Sheets

Yet another splitting instrument for your Google spreadsheet toolset: Split Text add-on. It splits cells in Google Sheets by multiple delimiters at once, by text strings, by the desired position, and even by capital letters. Come see for yourself ;) Continue reading

How to create and use nested templates in Outlook

This manual will show you different ways to create nested Outlook templates. You’ll see how to use predefined templates and add dynamic fields to your emails. Continue reading

How to find and remove duplicate cells in Excel

Is duplicate data in your worksheets causing you a headache? This tutorial will teach you how to quickly find, select, color or delete duplicate cells. Continue reading

How to dynamically change color, width, and style of cell borders in Outlook table

In this manual you’ll see how to apply conditional formatting to Outlook tables in order to change their borders’ color, width or style. Continue reading

Google Sheets: remove the same text or certain characters from multiple cells at once

Learn formulas and formula-free ways for Google Sheets to trim whitespaces, remove special symbols (even the first/last N characters) and the same text strings before/after certain chars from multiple cells at once. Continue reading

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31