Frédéric LE GUEN

Sum a whole table in one click with Quick Analysis

Quick Analysis is the name given to the icon that appears after making a selection in your spreadsheet.  The sum of all columns is instantly calculated and added to the row below the selected range. Same trick for rows Now, if you want to sum all the cells of the same row, the technique is the same. The result is as follows.
Get Excel For Free

Use Excel Online for Free

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

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 […]
CHOOSECOLS function Excel

CHOOSECOLS function in Excel

Discover the power of CHOOSECOLS and how it works with FILTER and GROUPBY functions to enhance data management.
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 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 […]
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 […]
Cover TRUE and FALSE to 0 and 1

Convert TRUE/FALSE to 1/0 in Excel

Learn how to convert TRUE or FALSE to 1 or 0 in Excel. Discover two simple techniques for transforming logical test results effortlessly.
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.
Show cards of Data Type

Discover Data Type in Excel

Discover the power of Excel's Data Type feature for gathering information about countries or stock exchanges.
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.
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.
Dynamic VLOOKUP cover

Create a Dynamic VLOOKUP function

Learn how to create a dynamic VLOOKUP with the MATCH function and customize your search criteria to return accurate results in Excel.
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.
1 2 3

Categories

Microsoft MVP 2024

Frédéric LE GUEN