Manage data

Manage your data in Excel like a pro with this series of articles

Excel Extract Worksheet Name by formula

Discover the steps to extract worksheet name in Excel effortlessly with an easy formula combining CELL and TEXTAFTER functions.

Discover three easy ways to remove duplicate values in Excel. Our guide provides simple tools and formulas to streamline your data.

Learn how to make the formula bar font size larger in Excel and improve the readability on high-resolution monitors.

How to extract a sample of data random data? A combination of a random number and the function INDIRECT will return the result expected.

Discover how to enhance your workbooks with pictures by using their URLs. In that way, you can create dynamic dashboards

Discover the trick to connect a slicer to change Data Type entries in your dashboards. Follow our tutorial to learn the steps.

Working with Excel Tables offers several benefits that enhance data management, analysis, visualization, and also secret tricks

Master the use of the dollar sign 💲 in Excel formulas for precise calculations. Understand relative, absolute, and mixed references.

Learn how to move cells in Excel with the mouse quickly and easily, step-by-step. This guide is perfect for beginners and experts alike.

Learn three different techniques to copy formulas without the formatting in Excel and avoid destroying existing cell formats.

To avoid duplicate selections in dropdown lists, learn how to exclude previously selected items using the COUNTIF and FILTER functions.

Learn how to remove all the filters in Excel with just one click. This step-by-step guide will help you to improve your Excel skills

One of the most useful and powerful tool in Excel is the Filter. It's easy to use and it contains many incredible options.

Discover the tips and tricks to move or copy a worksheet in the same workbook or in a new one. All explanations with animated gif.

Master the F9 shortcut in Excel to perform formula audits. Quickly analyze each part of your formula to ensure accuracy.

Discover a playlist of videos to learn the best Excel shortcuts ever.

How to copy data and reuse them (paste) in other Excel cells? You can copy and paste text, numbers, and formula

Learn how to easily reuse cell values in Excel. Discover different techniques for referencing cells in the same or different worksheets.