Ultimate Suite for Microsoft Excel
极速赛车全国最新开奖网址
Shared Email Templates
Simply templates for your emails. And nothing else.
Power Tools for Google Sheets
A complete collection of tools for simpler work with spreadsheet data
Products
极速赛车直播网站
How to highlight active row and column in Excel
When viewing a large worksheet for a long time, you may eventually lose track of where your cursor is and which data you are looking at. To know exactly where you are at any moment, get Excel to automatically highlight the active row and column for you! Continue reading
How to create dynamic Outlook email templates for the current user
Let's say, you have a really nice template, and your teammates would be happy to use it in their correspondence, but you're stuck on making this template dynamic. The problem is that each of your colleagues would like to get a different image, an individual attachment, and some specific text added to the template every time they use it. Continue reading
VLOOKUP to compare two columns in Excel for common values and missing data
When you have data in two different lists, you may often need to compare them to see what information is missing in one of the lists or what data is present in both. Comparison can be done in many different ways, which method to use depends on exactly what you want from it. Continue reading
Video: How to move multiple Google sheets to new, existing or several separate spreadsheets
Have you ever tried to move – cut & paste – Google sheets from one file to another? There's no such option available in spreadsheets. But it doesn't really matter if you have Sheets Manager at hand. It knows how to split your Google spreadsheet by tabs or simply move multiple tabs to a new or the existing file at once. Continue reading
How to use and store custom functions in Excel
You will learn how to call custom functions from another workbook or add-in. Continue reading
Video: How to copy multiple Google sheets to the current, new, existing or several separate spreadsheets
In today's video, I'll show you why Sheets Manager is a better alternative when it comes to copying multiple Google sheets. You'll see the handiest way of duplicating several tabs and, what's more, learn how to copy them into multiple separate spreadsheets in one go. Continue reading
How to remove whitespace and empty lines in Excel with Regex
Whichever input data you are using, you'll hardly encounter a dataset without spaces. In most cases, whitespace is good. In some situations, however, it may become evil - extra spaces can mess up your formulas and make your worksheets almost unmanageable. Continue reading
Video: How to lock several Google sheets, copy them, hide/unhide, move, etc. with a special add-on
Though Google Sheets offers its ways to process multiple tabs, there's a faster and user-friendly solution I'd like to share – our Sheets Manager add-on. It even knows a few tricks you won't cover with standard tools. But please, don't take my word for it – come watch today's video to see for yourself. Continue reading
Custom UDF function vs VBA macros: advantages and drawbacks
This article will help you understand the differences between UDF and Macro. Also, custom functions have many advantages, but there are also many limitations when using them. Continue reading
How to extract substrings in Excel using regular expressions (Regex)
Microsoft Excel provides a number of functions to extract text from cells. Those functions can cope with most of string extraction challenges in your worksheets. Most, but not all. When the Text functions stumble, regular expressions come to rescue. Continue reading
Excel: featured articles
Outlook: featured articles
Google Sheets: featured articles
