Excel tutorials, functions and advanced formula examples, page 2
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
Spilling in Excel: what it means and how to use it
The recent dynamic array update has bought a wealth of inspiring new capabilities. But all is centered around the core concept of "spilling". So, let's take a close look at this feature and how you can leverage it to improve your Excel experience. Continue reading
How to use conditional formatting in Outlook tables
This manual will teach you to conditionally format your Outlook tables and change the color of their text and background in a blink of an eye. Continue reading
How to make Outlook email template with fillable fields, variables and dropdown lists
If replying to repetitive emails is part of your daily routine, then most likely you are using Outlook templates to automate this part of your work. But what if your template contains some variables that you need to change before an email goes off? Continue reading
Auto-fill rows and tables in Outlook email templates
This manual will teach you how to connect one or several datasets to an Outlook table and fill it in automatically. Continue reading
Add text to Google Sheets cells at a certain position: at the beginning/end, before/after characters
This tutorial will teach you how to add text in Google Sheets at the same position of all cells at once: at the beginning, at the end, after the N-th character, before or after particular characters. Continue reading
How to remove duplicates in Excel cell
When it concerns removing duplicate cells or rows, Microsoft Excel offers a number of different options. But when it comes to removing duplicate text within a given cell, Excel provides… nothing. Well, if there is no inbuilt function we need, let's go write our own one. Continue reading
How to create and format tables in Outlook email templates
In this article, you’ll see how to create, modify and fill Outlook tables and use them as templates for your emails. Continue reading
