WordPress shortcuts, Improve your Productivity

Unlock efficiency in WordPress with these essential shortcuts. Boost productivity and streamline your workflow with these time-saving tips.

Excel Table Secrets to increase your Data Manipulation

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

Tips and Tricks to Paste Data in Values

Master the art of pasting values in Excel to unlock its full potential. Discover four techniques for this task.

In Excel, How to highlight missing values?

Become an Excel master with this handy Excel trick to highlight missing values using conditional formatting and no formula.

Clear All Filters in Excel in one click.

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

How to copy a Worksheet to Another Workbook?

Learn how to effortlessly copy a worksheet from one workbook to another using a simple Drag & Drop technique.

How to Update your chart Series automatically?

Learn the trick to update your chart series automatically when you add new data to your source. No formula is needed.

Convert YYYYMMDD to DD/MM/YYYY with Excel

You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step

Increase the font size of the formula bar in Excel

Find out how to easily change the font size of the formula bar in Excel for enhancing readability and comfort

How to Fill Series Automatically with Excel

Excel can fill series of numbers or dates automatically. Three techniques can be used. Here are the explanations.

Add filter option for all your pivot table columns

Learn the trick to add filter options for all pivot table columns. Enable the Filter menu and access filtering and sorting for every column.

Dash for a zero in Excel automatically

How to display a dash ( - ) instead of a zero in Excel? Follow this step-by-step guide to learn how to customize your numbers.

How to Compare 2 Columns in Excel

Learn how to compare two columns in Excel efficiently using simple techniques. Easy-to-follow guide with clear explanations and examples.

How to keep the leading 0 in a cell?

Keep the leading 0 in Excel is important when you want to keep all the digits of your strings and to avoid mistakes

Tips to Move and Copy Worksheet in Excel

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.

How to create Dependent Drop down List in Excel?

This step-by-step guide will teach you how to create a dependent drop down list in Excel. You need to use the UNIQUE and FILTER functions.

Extract sample randomly in Excel

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

Add a slicer with Excel Online

Unlock the power of Excel with slicers. Find out how to add a slicer to your Pivot Table and simplify your data filtering process.

Ctrl+D: The Secret Shortcut of Excel

Unlock the power of secret Excel shortcuts. Discover how Ctrl + D can duplicate and align charts, images, or icons.

Add Emojis to your Excel charts or slicers

You can customize your Excel worksheets and create unique dashboards with emojis (icons) in your cells, formulas, charts or even slicers.

Draw your borders with the mouse

Learn how to draw borders in Excel using just your mouse. Save time and increase precision in your daily tasks.

How to become Office Insider

Discover how to become an Office Insider in order to have the newest features of Office

Do a calculation without the equal sign in Excel

In Excel, it's possible to make calculation without starting with the symbol equal. Just write your formula and Excel returns the result.