Expert

Take your Excel skills to the next level with our category dedicated to expert Excel users. Discover advanced techniques and complex formulas.

Become an Office Insider 😃👍

Discover how to become an Office Insider in order to have the newest features of Office with this simple trick.

Excel Calendar with Automatic Monthly Data Saving 📅

Discover our Excel calendar data saving method. With our user-friendly template, you can effortlessly track and save timesheet updates.

Enable the Developer Tab in Excel

Learn how to enable the developer tab in Excel and explore tools for automation, custom add-ins, and XML features.

Connect slicer with Data Type

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

Return Arrays with Excel’s LAMBDA Function

Master the Excel LAMBDA function to create array formulas effortlessly. Streamline your calculations and eliminate errors.

Splitting a text based on a pattern in Excel

Discover how to split text in Excel using the MID function and an array pattern. Simplify data manipulation and achieve better results.

Convert Binary Number to Decimal in Excel

Learn how to convert binary numbers to decimals in Excel using the BIN2DEC function or a custom function when there are more than 10 digits.

Test Excel for Expert users

You think Excel has no more secrets for you? Sure? So let's try this Excel quizz for experts and discover your result

Excel Dropdown list – Exclude Previously Selected Items

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

Formula to Calculate Quarter with Excel

Discover how to calculate quarters in Excel for any date, whether it's the current, next, or previous quarter, with these formulas.

Microsoft has blocked macros from running

Understanding why Microsoft blocks macros in Excel and how to adjust the security settings to enable macros safely.

Find duplicate values in Excel by formula?

Unlock the secrets of finding duplicate values in Excel effortlessly. Find out how to use FILTER and COUNTIF functions

How to create a chart Man & Woman in Excel?

Learn how to create an eye-catching man and woman chart in Excel. Follow this detailed guide to enhance your charting skills step by step.

How to do a Cube Root in Excel?

There is no cube root function in Excel. But there is a solution to perform a cube root calculation with another Excel function.

Dynamic SUM in Excel

Discover two powerful techniques for creating dynamic sums in Excel: Excel Tables and the SUM function with INDEX.

Generate a QR Code with Excel

Learn how to generate QR codes using Microsoft Excel with our step-by-step guide. Start creating QR codes today!

Keep your Last Updated Data

Keep the latest updated value for each client in Excel: UNIQUE lists the clients, MAXIFS finds the last date, FILTER returns the full row.

Calculate any Day of the Week Using These Excel Formulas

All the formulas to calculate any day in a week, like the first Monday of the month, the last one, the next Tuesday, ...

How to create a Gantt Chart with Excel?

A Gantt chart, helps you to visualize the time needed to realize actions. Learn how to build a Gantt chart with Excel steps by steps

Convert Numbers to Words in Excel

Convert Number to Words is now possible with Excel 365 and the LET function

How to use the INDIRECT function of Excel?

Discover how to use INDIRECT Excel for dynamic references and enhance your data management in Excel spreadsheets.

Excel as a sports coach

Do you know that Excel can be your new sports coach? No? But in reality, it's very easy. Copy for free the code and you will have your coach at home

Explanation of the VBA code for the calendar

Each lines of the VBA code for the automatic calendar explain in detail.

Update a Dropdown List automatically

Find out two techniques to create a dynamic dropdown list in Excel by using the power of the Excel Tables. 📌

Wildcard with COUNTIFS or SUMIFS

You can create complex criteria in your COUNTIFS or SUMIFS function with the wildcart.The wildcards are specials characters to replace one or more characters in your string

How to make automatic calendar in Excel

This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.

Expert

Categories

Expert