Tricks to Insert, Delete, Hide Rows and Columns

Efficiently manage columns and rows in Excel with this helpful tutorial. Discover how to insert, delete, and hide columns with the mouse 🧑‍🎓

Tutorial – Moving cells or columns with the mouse

🧑‍🎓 Master the art of moving and swapping rows and columns in your spreadsheets. Unlock new levels of productivity with these essential tips.

Excel Shortcuts Test: Ace Your Spreadsheet Skills

Take this Excel shortcuts test to level up your productivity. Learn new shortcuts and become a master of Excel in no time.

Tutorial – All Excel tricks to Copy-Paste

🧑‍🎓 Master Excel's copy-paste secrets with this tutorial. Learn how to use fill-handle techniques to enhance your workflow.

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 Advanced Test

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

Test Excel Keywords

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

Do you know the Excel functions?

The assessment consists of 10 questions drawn from a pool of 50, designed to assess your proficiency in Excel functions

Excel Training – Calculate the weekly profit

Improve your Excel skills with our training on calculating weekly profits using fundamental statistical functions SUM and AVERAGE.

Exercise to learn how to use the Dollar Sign in Excel

Master Excel: Optimize your formulas by learning the strategic placement of dollars in your formulae in our comprehensive training

Excel Training – Create an Invoice

Learn how to create an invoice in Excel with this comprehensive training. Master the calculations needed to manage sales and taxes.

Training Logical Test – Beginner Level

Master logical tests in Excel with beginner-friendly training. Learn essential skills for effective data analysis. Enroll now!

Training Logical Test – Advanced Level

Master Excel's logical tests with our intermediate-level training. Enhance your skills for smarter data analysis. Join now!

Training Logical Test – AND and OR functions

Master Excel logic with AND and OR operators in our training. Boost your skills, solve complex problems efficiently. Enroll now!

Manage the inventory of your product

Training to learn how to manage your inventory and adjust the prices of your goods according to the result of your logical test in Excel

Training with SUM, MIN, MAX and AVERAGE functions

Master essential Excel functions with our training. Learn key skills for efficient data management and analysis. Start your Excel journey now!

Excel Training – Build a nested IF

This training will explain to you how to use and build a formula with nested if. A nested if is when you write many if functions.

Test Your Skills with COUNTIF and COUNTIFS

Ready to master COUNTIF and COUNTIFS in Excel? Test your skills with this interactive quiz and get a detailed dashboard with your results.

Training with the SUMIF and SUMIFS functions

Improve your Excel skills with our training on SUMIF and SUMIFS formulas. Unlock the power of conditional summing for better data analysis.

Excel Ctrl Key Shortcuts: Boost Your Productivity

Boost your productivity in Excel with Ctrl key shortcuts. With these time-saving tips, you can navigate, format, manipulate data like a pro.

How to display Months in Letters in Excel?

Learn the simple trick to display months in letters instead of numbers in your Excel date. Clear instructions and examples

WordPress shortcuts, Improve your Productivity

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

Calculate the Number of Days between 2 dates in Excel

Learn how to calculate the number of days between any two dates using in Excel. Easy-to-follow guide with clear explanations and examples

The WEEKDAY function – Secrets and Errors

Master the Excel WEEKDAY function with this easy-to-follow guide. Learn how to use it to determine the day of the week for any date.

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.

Mastering the SORT Function in Excel

Learn how to sort your data dynamically in Excel using the SORT function. Sort single columns or entire tables with ease.

Extract text with AI in Excel with FlashFill

With Excel, you can extract a sub-string without writing formulas with the FlashFill. FlashFill is the first AI tool in Excel

Why there is dollar in the Excel formula

Master the use of the dollar sign 💲 in Excel formulas for precise calculations. Understand relative, absolute, and mixed references.

How to create a formula in Excel

Master Excel formulas effortlessly. Find out how to use the = sign, perform basic calculations, and understand the order of operations.

Move cells with the mouse in Excel (Easy Guide)

Learn how to move cells in Excel with the mouse quickly and easily, step-by-step. This guide is perfect for beginners and experts alike.

How AI can be used in Excel for your data?

Discover how AI tools can automate tasks, identify trends, and make predictions to enhance your Excel experience

Copy the formula without the formatting in Excel

Learn three different techniques to copy formulas without the formatting in Excel and avoid destroying existing cell formats.

How to Highlight Min and Max values in Excel

How to highlight the min and the max with a specific color in Excel? This step-by-step guide will explain the technique.

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.

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.

Conditional Formatting – Color scale

A color scale is an option for the conditional formatting of Excel. It's a useful way to present the similarity of your data.

Function MOD (Modulo) of Excel

The MOD function of Excel is beneficial in many situations, and you can use it as a result, as a logical test, or with conditional formatting

Round nearest 10, 25, or 50 cents with Excel

How to round up by 10, 25 or 50 in Excel? This article gives you all the formulae to do this job with Excel.

Meaning of the sign & in Excel?

What does mean the sign & in Excel? This sign is very important in many situation to link 2 cells together.

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.

Beginner Excel Exercise: Mastering Basic Calculations

Learn essential Excel calculations with this beginner exercise. Perform arithmetic, use cell references, and apply built-in functions.

Display negative time in Excel

Learn how to handle negative hours in Excel with these 3 simple methods. From formatting cells to using formulas, all explanations here.

Calculate Monday Previous Week with Excel

Learn how to find the date of the previous Monday using Excel. Streamline your scheduling and data analysis with this handy formula.

Calculate the Previous Monday with Excel

Formula to calculate the previous Monday with Excel, from TODAY or any date.

Calculate Monday in 2 weeks with Excel

Learn how to find the Monday in 2 weeks in Excel effortlessly. Boost efficiency and streamline workflows with this easy-to-use formula.

Calculate the Next Monday with Excel

Master the technique to find the next Monday effortlessly in Excel. Say goodbye to manual counting and hello to efficient date calculations.

Formula First Monday of the month with Excel

Formula to calculate the first Monday of the month with Excel

Calculate Monday 2 weeks ago with Excel

Formula to calculate Monday 2 weeks ago with Excel, from TODAY or any date.

How to Unstack Data using Excel?

Easily unstack data in Excel with this simple guide. Learn how to quickly rearrange your data for better analysis and visualization.

Microsoft has blocked macros from running

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

Formula to Remove the VAT in Excel

How to remove VAT? To solve this, you don't need a specific Excel function. A combination of additions and divisions do the job.

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

Beginner Excel Test

Looking for an Excel test for beginners? Take our beginner Excel test and challenge your knowledge of Excel basics.

Build a Logical Test in Excel

A logical test Is very important in Excel because it's the starting point for a lot of functions to create dynamic dashboards.

Percentage Data Label in Your Excel Chart

Learn how to add percentage chart labels in Excel with this simple tutorial. Improve your data visualization skills today!

Convert a Text Date to a Number Date

Learn how to convert a text date, like '1 January 2023', to a number date format using Excel. Easily convert text dates to numerical values.

Tutorial – How to make calculations in Excel

🧑‍🎓 Learn how to do a calculation in Excel by using numbers or directly the contain of cells with this step-by-step guide.

Tutorial – Adjust the Size of rows and columns

🧑‍🎓 Master Excel: Quick tutorial on adjusting column width for efficient data presentation. Many secrets reveal.

Tutorial – Excel keywords

Master Excel with our tutorial on keywords! Quick, practical learning of Excel secrets. Start excelling today! 🧑‍🎓

How to Create a Running Total in Excel?

Calculate a running total in Excel with ease. Follow our step-by-step guide and learn three different methods to analyze cumulative data.

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 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.

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.

How to round in k$ with Excel?

Discover 3 techniques to round numbers in k in Excel. Learn how to use Paste Special, divide by formula, and create custom number formats.

Highlight the Date outside the deadline in Excel

How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.

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!

How to find the column number in Excel?

Learn how to quickly find the column number in Excel using these two easy methods. No more guessing or manual counting!

Add Days Excluding the Weekend in Excel

How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.

How to Calculate the Week Number in Excel?

In Excel the way to return the week number is based on the American system. But most of countries use the ISO system. What is the technique to avoid mistakes.

Split your text on a delimiter – TEXTSPLIT Function

Discover the new TEXTSPLIT function in Excel 365 that allows you to split cell content using specified delimiters easily.

How to display hours over 24 in Excel?

Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.

Exchange rate in Excel 🏛️

With the new feature of Office 365, Data Type, you can easily collect the last Exchange Rate between 2 currencies

The TRIM function of Excel

Clean up your Excel data with the TRIM function. Learn how to remove extra spaces before and after strings to ensure data accuracy.

Excel Trick: Calculate Without the Equal Sign!

Discover the trick to calculate without equal sign in Excel. Simplify your calculations effortlessly with our guide.

Roman numerals with Excel

Learn how to easily convert numbers to Roman numerals in Excel using the ROMAN function. Ideal for titles, outlines, and more.

How to display Min and Max in an Excel chart?

How to display the min and the max bars in an Excel chart? This step-by-step guide will explain the technique and it's very simple.

TOP 10 Most Useful Statistical Functions for Data Analysis

Learn the top 10 most useful Excel statistical functions for data analysis, with clear explanations and examples.

Waterfall chart in Excel

A waterfall chart is very helpful to visualize the impact of each product on the overall total. With Excel, it's easy to do.

Keep your Last Updated Data

In some cases, remove duplicate doesn't help you to keep the last value. This tutorial will show you how you can solve this.

How to build your dynamic dates in Excel

With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.

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.

Copy a Conditional formatting rule

You can now copy a conditional formatting rule with Excel 365. This option has been added for Excel 365 only.

Functions LEFT – RIGHT – MID

Excel functions LEFT, RIGHT, and MID allow you to pull specific parts of text, making them powerful tools for organizing and analyzing data. They are among the Top 10 Excel Functions You Must Know. These functions are especially useful when working with structured codes, like phone number, zipcode, barcode .... Study Case: Let's split a VIN A VIN (Vehicle Identification Number) is a unique 17-character code that identifies every vehicle. It’s divided into three main sections: The following document contains a list of Car manufacturers, the vehicle's model, and the VIN. Let's use the functions LEFT, RIGHT, and MID to extract each part of the VIN. LEFT Function to Extract the WMI Code The WMI (World Manufacturer Identifier) represents the first 3 characters of the VIN, identifying the vehicle’s country and manufacturer. To extract these initial characters in Excel, use the LEFT function. Here’s how: RIGHT Function to Extract the […]

Count Words in an Excel cell

Want to count words in Excel? Check out these two techniques using the TEXTSPLIT function and the COUNTA function.

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 use the INDEX function in Excel?

Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.

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.

Time Format in Excel to avoid mistakes

Master time formatting in Excel. Learn how to display dates and times accurately, customize formats, and avoid common mistakes.

Change the Color of Weekends in Excel 🗓️🎨

Change the color of weekends in Excel with conditional formatting. Quick and easy with this step-by-step guide.

How to calculate VAT in Excel?

How to calculate VAT in Excel? It's very easy and doesn't need a specific function. Many examples in this article.

Create a weekly calendar with just one formula in Excel

Unlock the potential of Excel by learning how to create a weekly calendar with just one formula. Step-by-step guide in this article.

Shortcuts – Function Key Excel

The function keys in Excel (or the f key) are very useful and save a lot of time in many situations. Here is the list of the action you can do

Study Case with Excel Statistics functions

How to use Excel statistics functions? In this study case, we will analyze the wages of all the employees and what is the result.

Population Pyramid with Excel

This tutorial is a step-by-step guide to creating a population pyramid in Excel. In only 6 steps, you will create your population pyramid.

Use Filter for your data in Excel

One of the most useful and powerful tool in Excel is the Filter. It's easy to use and it contains many incredible options.