Excel Hyperlink: how to create, change and remove
| | |

Excel Hyperlink: how to create, change and remove

BySumit Shrimal

This tutorial shows you three easy ways to add hyperlinks in Excel. You will learn how to insert, change, and remove hyperlinks in your worksheets. It also explains how to fix links that don’t work.
Hyperlinks are often used on the internet to move between websites. In Excel, you can create links like that too. You can make a link to another cell, a different sheet, or even another workbook. You can also link to open a new Excel file or start an email message. This guide will show you how to do all of this in Excel 2016, 2013, 2010, and older versions.

Advance Filter in Excel – how to create and use
| | |

Advance Filter in Excel – how to create and use

BySumit Shrimal

This guide explains the basics of Excel’s Advanced Filter and shows you how to use it to find records that match one or more complicated conditions.
If you’ve read our previous guide, you know that Excel’s regular filter offers different options for filtering text, numbers, and dates. These options work well for many situations, but not all. When the regular filter isn’t enough, you can use the Advanced Filter to set up custom criteria that fit your exact needs.
Excel’s Advanced Filter is especially useful for finding data based on two or more complex conditions. For example, you can use it to find matches and differences between two columns, filter rows that match another list, or find exact matches with the same uppercase and lowercase letters.
Advanced Filter is available in all Excel versions from 365 to 2003. Click the links below to learn more.

How to color alternate rows in Excel: highlight every other row
| | |

How to color alternate rows in Excel: highlight every other row

BySumit Shrimal

This tutorial shows you how to change the row colors in Excel to automatically highlight every other row or every nth row or column in your worksheets. You will also learn how to use Excel’s banded rows and columns and find some helpful formulas to shade rows based on value changes.
Using alternating colors for rows in Excel is a common way to make data easier to read. While it’s simple to manually highlight rows in a small table, it can be very time-consuming in larger tables. A better approach is to automatically alternate the colors of rows or columns, and this article will show you how to do it quickly

Excel Nested IF statement: examples, best practices and alternatives
| |

Excel Nested IF statement: examples, best practices and alternatives

BySumit Shrimal

This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.

How to use Goal Seek in Excel for What-If analysis
| |

How to use Goal Seek in Excel for What-If analysis

BySumit Shrimal

This tutorial shows how to use Goal Seek in Excel 365 – 2010 to get the result you want by changing an input value.
What-If Analysis is one of Excel’s most powerful but least understood features. Simply put, it lets you try out different scenarios and see possible outcomes. In other words, it helps you see how changes affect your data without actually changing the real data. In this tutorial, we’ll focus on one of Excel’s What-If Analysis tools—Goal Seek

How to Sort Data Using Power Query in Excel: A Step-by-Step Guide

How to Sort Data Using Power Query in Excel: A Step-by-Step Guide

Byexcelsirji

This article unveils the magic of Power Query, a built-in Excel tool that simplifies data organization. Learn how to sort by single or multiple columns, create layered sorts for complex needs, and even reverse your data order entirely. Power Query puts you in control, transforming your data into a well-structured format for effortless analysis.

Effortlessly Merge Columns in Power Query: A Step-by-Step Guide

Effortlessly Merge Columns in Power Query: A Step-by-Step Guide

Byexcelsirji

In this tutorial, learn how to merge columns using Power Query. Follow this step-by-step guide to convert data into a table, merge columns seamlessly, and customize separators. Whether you’re a beginner or an advanced user, this tutorial will enhance your data manipulation skills and streamline your workflow. Master Power Query and optimize your data management processes effortlessly.