Frédéric LE GUEN

Auto Refresh Power Query on Workbook Open

Discover how to enable power query refresh open in Excel and keep your data updated each time you open your workbook.

Remove accents with Power Query in Excel

Power Query Function to Remove Accents in Excel

Master Power Query to remove accents and ensure your text is clean for joins, searches, and URL slugs effortlessly.

Use Excel Online for Free

Learn how to use Excel Online free in your browser. Access your spreadsheets anytime, anywhere with ease and flexibility.

Identifying Weekdays and Weekends with Excel

Learn how to manage weekdays weekends with Excel, using the WEEKDAY function to streamline your scheduling tasks.

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.

How to Round Numbers to 0.99 in Excel

In retail and pricing, it’s common to round prices so they end with 0.99 — for example, turning 10 into 9.99. This trick helps making price lists that look consistent and appealing. Why Use 0.99 Instead of Whole Numbers? Prices ending in .99 are a common marketing technique known as psychological pricing. Customers tend to focus on the first digit of a price. So, $9.99 feels cheaper than $10.00, even though the difference is just one cent. This small adjustment can influence buying decisions and improve sales, especially in stores, catalogs, and online shops. Formula to Round Up to 0.99 To round any number up so it ends with 0.99, the formula is quite simple. The following picture shows you a series of prices rounded to 0.99. Format as Price To show your audience that the content of the cells is a price, you can apply the Currency format from […]

Group Data per 15 Minute Interval in Excel

Explore techniques to group your time data in Excel with 15-minute intervals for enhanced analysis and reporting.

Eight functions to round numbers in Excel explained

Rounding Numbers in Excel: 8 Functions Explained

Explore the different ways of rounding numbers in Excel. Discover functions that can enhance your spreadsheet skills.

CHOOSECOLS function in Excel

Discover the power of CHOOSECOLS and how it works with FILTER and GROUPBY functions to enhance data management.

Who Gets the Lowest and Highest Values with Excel

Find out how to easily locate lowest highest values using Excel's MIN and MAX functions. Get insights on working times!

Searchable Dropdown List in Excel

Discover how to build a searchable dropdown list in your Excel workbooks with the FILTER and SEARCH functions.

GROUPBY vs SUMIF in Excel

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

Nested IF and IFS Functions in Excel

Learn how to use nested if functions in Excel to create complex logical tests beyond simple true or false outcomes.

Calculate Week Number Excel: A Quick Guide

Discover the methods to calculate week number Excel. Understand the differences between North American and ISO rules to avoid errors.

Week number in Excel: Avoid Mistakes

Improve your Excel skills by understanding week number calculation. Dive into the WEEKNUM and ISOWEEKNUM functions and their nuances.

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 offer simple tips to save time, avoid mistakes, and work more efficiently with Excel. You will learn useful shortcuts, easy formulas, and smart tricks to organize data. Each tip helps you work more efficiently and effectively. 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 […]

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:

Solve SUMIF Exercise: Answer Fun Questions

Level up your Excel skills with this SUMIF exercise. From basic questions to advanced logic, learn how to calculate totals like a pro.

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 […]

How to Use the SUMIF Function in Excel

Learn how to correctly set the SUMIF function in Excel and avoid mistakes. Analyze data efficiently with this powerful function.

Remove Duplicates in Excel: Tools and Formulas

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

GROUPBY function: The future of COUNTIF SUMIF

Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.

COUNTIF Function in Excel: A Must-Know Function

Master the COUNTIF function: Learn how to analyze and count data with this essential Excel function quickly.

COUNTIFS Function: Mastering Multi-Criteria Counting

Learn how to use the powerful COUNTIFS function in Excel. Count rows that meet multiple conditions for accurate data analysis.

Master Conditional Formatting in Excel

Discover how to master conditional formatting in Excel. Learn its benefits, types, and tips for accurate data analysis.

Select the Top 5 Values with TAKE function

Learn how to find the top 5 values or the last 5 values from a list in Excel using the TAKE function and SORT function.

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.

Write Months in Any Language in Excel

Discover the trick to displaying months in any language in Excel. Learn how to customize the date format and automate month names in Excel.

Icons with Conditional Formatting in Excel

Learn how to use icon conditional formatting in Excel to visualize your data and create dynamic dashboards.

Change Formula Bar Font Size in Excel

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

Progress Bar in Excel with Conditional Formatting

Discover how to create and customize progress bars in Excel using Conditional Formatting. Track progress with ease.

Compare Two Columns in Excel Easily

Find out how to compare columns in Excel and identify missing values or return only missing values with efficient formulas.

Excel TEXTSPLIT Function: Easily Split Text into Parts

The TEXTSPLIT function in Excel 365 helps split text dynamically based on delimiters, saving time and effort.

How to Use the VLOOKUP Function in Excel

Get a comprehensive understanding of the VLOOKUP function in Excel. Learn how to perform efficient searches in your tables.

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.

Why Excel Formulas Use Comma or Semi-Colon

Excel formulas: comma or semi-colon? Understand why Excel uses different delimiters and how to change this setting.

Easily Create a Running Total in Excel (No formula)

Discover Excel AI-powered features and tools can simplify Running Totals and make complex data easier to understand.

VLOOKUP Left Lookup Using INDEX or XLOOKUP

Explore advanced Excel techniques to overcome VLOOKUP limitations and retrieve data from the left with XLOOKUP or INDEX/MATCH.

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 […]