Frédéric LE GUEN

GROUPY function cover

GROUPBY vs SUMIF in Excel

Discover how the GROUPBY function simplifies Excel data analysis by replacing complex COUNTIF and SUMIF formulas effortlessly.
Remove gridlines cover

Remove Gridlines in Excel Easily

Why remove gridlines in Excel? Gridlines help during editing but can make spreadsheets look cluttered. Removing them creates cleaner, more professional templates perfect for presentations or printing 😎 How to Remove Gridlines Follow these simple steps to hide Excel gridlines: Alternatively: These methods work seamlessly for any spreadsheet, saving you time and effort. Why Avoid Coloring Borders? You can achieve professional results without unnecessary effort by using the correct method described above. Related Articles Want to improve your Excel skills? These articles share simple tips to save time, avoid mistakes, and work faster with Excel. You will learn useful shortcuts, easy formulas, and smart tricks to organize data. Each tip helps you work better and faster. Discover how to format cells, filter data, and use Excel functions. Learn how to avoid errors and make your work easier. These tricks are great for beginners and advanced users. Start exploring these articles […]
When to use the LEN function of Excel

Excel LEN Function Explained

Learn how to use the LEN function in Excel to count characters in a string, data validation, and conditional formatting.
Trick to Copy a sheet to another workbook

How to Copy a Worksheet to Another Workbook in Excel

Did you know you can easily copy a worksheet from one workbook to another in Excel using drag and drop? 😲 In this article, all the tips and tricks to simply this action and save a lot of time in your daily job 😉👍 Steps to Copy a Worksheet to Another Workbook in Excel Why use this method? Copying worksheets between workbooks allows you to transfer data across multiple projects without errors quickly. It saves time by avoiding manual re-entry, ensuring consistency in your data management, and streamlining your workflow for better productivity. The Steps in Video Move a Worksheet to Another Workbook To move a worksheet instead of copying it, just follow the same steps, but do not press the Control key. Related Articles Here are some useful Excel tips and tricks to help improve your data management:
Woman office training excel

Step-by-step guide for SUMIF function

This step-by-step guide will help you learn the SUMIF function in Excel. Understanding the SUMIF function is essential for building accurate and advanced Excel dashboards. This exercise will help you practice and improve your skills step by step. Mastering this function can save time and help you avoid common mistakes in Excel. Content of the SUMIF function guide This exercise is designed for learners of all levels. Even if you’re new to the SUMIF function, don’t worry—you can repeat the exercise as many times as you need. Take your time, and by the end, you’ll feel more confident using SUMIF in your Excel work!. Click on the following button to start the SUMIF function guide Related Articles Excel-Tutorial.com, your training partner. The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you're a beginner or an advanced user, our […]
Change the language of Microsoft 365

Change Excel Language Easily

Learn how to change the language in Excel easily. Follow our step-by-step guide and quickly download and apply a new language to Excel.
VLOOKUP NA error cover

Why VLOOKUP Returns #N/A Error

Discover why the VLOOKUP function returns an #N/A error in Excel. Learn the common causes and how to quickly fix VLOOKUP errors.

Search in 2 Columns with VLOOKUP & XLOOKUP

How do you search in 2 columns in Excel? Why Search Two Columns? When working with dates and currencies, each date has different values for each currency. The currency code repeats daily. To get accurate results, we must build a unique identifier by combining the Date and Currency columns. VLOOKUP Isn't Ideal VLOOKUP only searches in the first column 😡. This is how the function has been developed. Now, if you need to search in 2 columns, you must transform the table and concatenate the two columns to create a new column. After that, you create your VLOOKUP function by using the column as the first column of your reference table. XLOOKUP Is Better If you work with Excel 365, Excel Online, and Excel 2021, it's better to use the XLOOKUP function. This function has been developed to remove the limitations of VLOOKUP. This includes performing a search in two […]
XLOOKUP function cover

Master XLOOKUP function in Excel

Learn how the XLOOKUP function in Excel 365 simplifies data lookup in tables. Find out how it improves VLOOKUP and handles errors better.
Intelligent filters in Excel

Intelligent Filters with Excel

Take your data analysis to the next level with intelligent filters in Excel. Find out how Slicers can improve efficiency, and accuracy.
extract random sample data

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.
Demo Slicer and Data Type

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.
Sudoku not solved

Sudoku for Excel for Free

Play Sudoku for Excel and have fun solving puzzles. Download the free app and choose from different difficulty levels.
Live Stock with Excel

Live Quotes Stock in Excel

Get real-time stock quotes in Excel for free with Microsoft 365. Learn how to connect to the Stock database and add live stock prices.
Bollinger Bands in Excel new Cover

Bollinger Bands with Excel

Discover how to create and interpret Bollinger Bands in Excel for stock price analysis. Improve your trading strategies.
Date Picker Excel

Date Picker in Excel

Discover how to use the Date Picker feature in Excel Online to select dates accurately and efficiently. Many situations explained
TIME function in Excel cover

The TIME function in Excel

Discover the power of the TIME function in Excel. Easily create time values and perform calculations using hours, minutes, and seconds.
Expert Cover

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
picto condition

Excel Advanced Test

Test your data analysis skills and prove you're a spreadsheet master. Challenge accepted? Take the quiz and join the Excel elite!
picto condition

Test Excel Keywords

Before to start to work with Excel, it's important to master the Excel Keywords. This assessment will gauge your level.
1 2 3

Categories

Microsoft MVP 2024

Frédéric LE GUEN