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

How to redo in Excel: comprehensive guide

As you work on complex spreadsheets in Excel, you may find yourself making changes, undoing them, and sometimes needing to re-apply your actions again. The Redo function is a handy feature that allows you to reverse the effects of an "undo" and restore your spreadsheet to a specific point in time. Continue reading

How to insert emoji and smiley in Outlook

In today's digital age, online communication has evolved far beyond mere words. We've found creative ways to express our emotions, humor, and personality by using small images known as "emojis" or "smileys". Microsoft Outlook has adapted to this trend, letting us incorporate emojis into emails. Continue reading

Excel Quick Analysis tool with examples

Microsoft Excel is a powerful spreadsheet application that can handle various types of data, but sometimes, you need to quickly get insights from your without diving deep into complex functions and formulas. That's where the Quick Analysis tool comes into play. Continue reading

Power Query in Excel tutorial: how to get, use and auto-refresh

Here's the conundrum - how can we import, transform, and analyze data in Excel without spending hours on manual manipulations? The solution is Power Query, an invaluable tool for any data analyst, saving hours of time, reducing manual errors, and transforming an unruly informational chaos into a harmonious symphony of insights. Continue reading

Adding second axis in Excel: chart with two X or Y axes

In Excel graphs, you're used to having one horizontal and one vertical line to display your data. But things can get a bit tricky when you're dealing with different types of data, like numbers and percentages, or when you want to compare two sets of data that don't quite match up in terms of time or size. This is where a second axis comes into play. Continue reading

How to extract first line in Excel cell

In the world of data analysis, Excel stands as a powerful tool that offers various features to optimize complex tasks. One such task is extracting specific content from a cell, a technique that can prove invaluable in managing and presenting data efficiently. Continue reading

How to omit / remove the first line in Excel cell

When dealing with multi-line data in Excel, you may come across scenarios where you need to omit the first line of text from a cell. This could be to remove headers or unnecessary information from imported data, clean up data for analysis, or simply extract relevant information. Continue reading

How to undo in Excel: shortcut, multiple actions, not working

Whether you're a seasoned Excel user who has been navigating spreadsheets for years or just starting to explore its capabilities, knowing how to correct mistakes without unnecessary hassle is essential. Excel's Undo function is like a safety net, allowing you to backtrack and make adjustments without fear of losing vital information or wasting time. Continue reading

How to select alternate columns in Excel

Excel, the go-to spreadsheet software for data enthusiasts and professionals, offers several methods to select columns based on specific criteria. While many are familiar with the standard techniques, there exist lesser-known but more efficient variations to accomplish this task. Continue reading

Excel status bar not showing sum, average or count

Excel not displaying sum, average or count in the status bar can be a frustrating issue, especially when you rely on these calculations for your work. There are several potential causes for this problem, and in this article, we will explore the common issues and provide solutions to get the necessary calculations back on track. Continue reading

Excel status bar missing: how to get it back

When it comes to the analysis of various data sets, the Excel status bar emerges as a vital component, providing users with a wealth of essential information and seamless access to key features. However, there are situations where the status bar mysteriously disappears, leaving users puzzled and unable to access its features. Continue reading

How to calculate standard error of the mean in Excel

Whether you are a student, researcher, or data analyst, understanding the standard error of the mean can help you draw more accurate conclusions from your data and make more informed decisions. This article will show you a few quick ways to calculate the standard error in Excel. Continue reading

#NUM error in Excel - fixing number error in formulas

Are you staring at your computer screen, sipping on your coffee, and wondering why your Excel spreadsheet is suddenly showing a strange error message with the hashtag symbol? It is frustrating, confusing and downright annoying, but fear not! We're here to unravel the mystery of the #NUM error in Excel and help you fix it. Continue reading

Ablebits stands with Ukraine

What is really happening in Ukraine? On the orders of Putin, on February 24, 2022, Russian troops launched an all-out war in Ukraine. Since then, tens of thousands of civilians have been killed, tens of thousands of Ukrainian soldiers have … Continue reading