Post Sitemap
279 articles · 21 topics
No article matches. Try another word.
Practice
Tutorials16 articles
Tutorial – Excel keywords
Tutorial – Adjust the Size of rows and columns
Tutorial – Number Format in Excel
Tutorial – How to make calculations in Excel
Tutorial – All Excel tricks to Copy-Paste
Excel Tutorial – Creating a dropdown menu
Tricks to Insert, Delete, Hide Rows and Columns
Tutorial – Moving cells or columns with the mouse
Learn how to use the SUM function in Excel
FlashFill : Manipulate Text in Excel without formula
Tutorial – Excel Alignment text tips
Learn how to use the Dollars in an Excel formula
Learn the secrets of Sorting Data with Excel
Tutorial for the Excel Functions AVERAGE, MIN, and MAX
Excel Tutorial – Filtering your data
- Sum a whole table in one click with Quick Analysis
Training15 articles
Excel Training – Create an Invoice
Training with SUM, MIN, MAX and AVERAGE functions
Training Logical Test – Beginner Level
Beginner Excel Exercise: Mastering Basic Calculations Exercise to learn how to use the Dollar Sign in Excel
Excel Training – Calculate the weekly profit
Training Logical Test – Advanced Level
Training Logical Test – AND and OR functions
Test Your Skills with COUNTIF and COUNTIFS
Manage the inventory of your product
Excel Test for IF, IFS & IFERROR functions
Solve SUMIF Exercise: Answer Fun Questions
Training with the SUMIF and SUMIFS functions
Excel Training – Build a nested IF
Step-by-step guide for SUMIF function
Quizzes8 articles
By topic
Date48 articles
How to make automatic calendar in Excel
Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel
Date Format in Excel
Excel Split Date and Time
Change the default Date format in Excel
Identifying Weekdays and Weekends with Excel
How to display hours over 24 in Excel?
First day – Last day in Excel
Change the Color of Weekends in Excel 🗓️🎨
Calculate Public holidays with Excel 📆
Add Days Excluding the Weekend in Excel
Title with Text and Date in the same cell
Calculate Week Number Excel: A Quick Guide
Time Format in Excel to avoid mistakes
The DATEDIF function in Excel
Function DATE – YEAR – MONTH – DAY
Create a weekly calendar with just one formula in Excel
Date Picker in Excel
Calculate Seniority in Excel
DATEDIFF for POWER QUERY
How to Highlight a Birthday Reminder in Excel
Display negative time in Excel
TODAY and NOW function in Excel
How to Calculate the Week Number in Excel?
How to build your dynamic dates in Excel
Displaying Date and Time in the Same Cell
How to Display Tenths, Hundredths with Excel
Write Months in Any Language in Excel
Calculate any Day of the Week Using These Excel Formulas
Convert a Text Date to a Number Date
Formula to Calculate Quarter with Excel
Excel Calendar with Automatic Monthly Data Saving 📅
How to display Months in Letters in Excel?
Group Data per 15 Minute Interval in Excel
Calculate Monday in 2 weeks with Excel
Calculate Monday 2 weeks ago with Excel
Formula First Monday of the month with Excel
Calculate the Previous Monday with Excel
Calculate the Next Monday with Excel
Minutes to Hours converter with Excel
Displaying Days in Letters in Excel
Week number in Excel: Avoid Mistakes
Calculate Monday Previous Week with Excel
Calculate the Number of Days between 2 dates in Excel
Highlight the Date outside the deadline in Excel
Unlocking the Secrets of Excel’s DATE Function
The WEEKDAY function – Secrets and Errors
The TIME function in Excel
Statistical functions25 articles
Displaying Negative Numbers in Parentheses in Excel
Dynamic SUM in Excel
How to Round a Number to the Nearest 10, 100 in Excel
Return a Value Between Two Values in a Range
How to round in k$ with Excel?
Function MOD (Modulo) of Excel
The SUM function – All Tricks
How to Create a Running Total in Excel?
Basic calculations with Excel
Select the Top 5 Values with TAKE function
Calculate Percentage Change in Excel
Rounding Numbers in Excel: 8 Functions Explained
Understand the Standard Deviation
Round nearest 10, 25, or 50 cents with Excel
TOP 10 Most Useful Statistical Functions for Data Analysis
3D Formula in Excel
What is the Most Common Value in your Excel document.
How to Round Numbers to 0.99 in Excel
Study Case with Excel Statistics functions
Calculate Moving Average in Excel
Who Gets the Lowest and Highest Values with Excel
GROUPBY function: The future of COUNTIF SUMIF
Quickly Calculate Percentages in Excel Without Formulas
How to do a Cube Root in Excel?
Easily Create a Running Total in Excel (No formula)
Tips and Tricks21 articles
Dash for a zero in Excel automatically
Add Emojis to your Excel charts or slicers
Add filter option for all your pivot table columns
How to Fill Series Automatically with Excel
Add a slicer with Excel Online
Change Formula Bar Font Size in Excel
Ctrl+D: The Secret Shortcut of Excel
Become an Office Insider 😃👍
Tips to Move and Copy Worksheet in Excel
How to create Dependent Drop down List in Excel?
Tips and Tricks to Paste Data in Values
Excel Trick: Calculate Without the Equal Sign!
Extract sample randomly in Excel
Clear All Filters in Excel in one click.
Draw your borders with the mouse
In Excel, How to highlight missing values?
How to keep the leading 0 in a cell?
How to Copy a Worksheet to Another Workbook in Excel
WordPress shortcuts, Improve your Productivity
Excel Table Secrets to increase your Data Manipulation
How to Update your chart Series automatically?
Manage data18 articles
How to Reuse Cell Values in Excel: A Complete Guide
Remove Duplicates in Excel: Tools and Formulas
Change Formula Bar Font Size in Excel
Tips to Move and Copy Worksheet in Excel
How to Copy and Paste in Excel?
Why there is dollar in the Excel formula
Extract sample randomly in Excel
Clear All Filters in Excel in one click.
Use Filter for your data in Excel
Connect slicer with Data Type
Excel Extract Worksheet Name by formula
Excel Dropdown list – Exclude Previously Selected Items
Move cells with the mouse in Excel (Easy Guide)
Copy the formula without the formatting in Excel
Audit a Formula with F9
The Excel Shortcuts everyone must know
The IMAGE Function in Excel: A Quick Overview
Excel Table Secrets to increase your Data Manipulation
Text functions18 articles
Extract only the numbers of a cell in Excel
Roman numerals with Excel
Capitalize the first letter in Excel (Camel Case)
- Functions LEFT – RIGHT – MID
Find Items That Appear Only Once
Mastering TEXTBEFORE and TEXTAFTER in Excel
Excel LEN Function Explained
Excel TEXTSPLIT Function: Easily Split Text into Parts
Split Text on a Delimiter without Formula
The TRANSLATE function of Excel
Count Words in an Excel cell
How to keep the leading 0 in a cell?
Extract text with AI in Excel with FlashFill
The TRIM function of Excel
The SEARCH function in Excel: return character’s position
Meaning of the sign & in Excel?
Splitting a text based on a pattern in Excel
Split your text on a delimiter – TEXTSPLIT Function
Conditional Formatting18 articles
Displaying Negative Numbers in Parentheses in Excel
Dash for a zero in Excel automatically
Change the Color of Weekends in Excel 🗓️🎨
Change the color according to the value in Excel
Icons with Conditional Formatting in Excel
Highlight Top / Bottom values with the conditional formatting
Progress Bar in Excel with Conditional Formatting
Change the color of holidays
How to Highlight a Birthday Reminder in Excel
Create a progress bar with icons
Color Row Conditional Formatting in Excel 🎨
How to Highlight Min and Max values in Excel
Conditional Formatting – Color scale
Master Conditional Formatting in Excel
In Excel, How to highlight missing values?
Highlight the Date outside the deadline in Excel
Copy a Conditional formatting rule
How to have 2 different highlight colors in Excel?
Lookup functions14 articles
Master XLOOKUP function in Excel
Compare Two Columns in Excel Easily
Anonymize your data
How to Use the VLOOKUP Function in Excel
VLOOKUP Left Lookup Using INDEX or XLOOKUP
Return a Value Between Two Values in a Range
- Search in 2 Columns with VLOOKUP & XLOOKUP
Create a Lookup Offset
How to use the INDEX function in Excel?
Create a Dynamic VLOOKUP function
How to use the MATCH function in Excel?
Transform List to Matrix like Distance Table 🚗
Why VLOOKUP Returns #N/A Error
Find duplicate values in Excel by formula?
Conditional12 articles
COUNTIFS Function: Mastering Multi-Criteria Counting
SUMIFS Function in Excel
Convert TRUE/FALSE to 1/0 in Excel
Excel IF Function Explained with Examples
Wildcard with COUNTIFS or SUMIFS
Build a Logical Test in Excel
COUNTIF Function in Excel: A Must-Know Function
Nested IF and IFS Functions in Excel
How to Use the SUMIF Function in Excel
Functions AND – OR with Excel
GROUPBY vs SUMIF in Excel
Function XOR in Excel
Excel Charts11 articles
Add Emojis to your Excel charts or slicers
Population Pyramid with Excel
Sunburst Chart with Excel
Percentage Data Label in Your Excel Chart
How to create a Gantt Chart with Excel?
How to create a chart Man & Woman in Excel?
How to display Min and Max in an Excel chart?
Waterfall chart in Excel
Radar chart in Excel
Bollinger Bands with Excel
How to Update your chart Series automatically?
Intermediate Excel Skills: Tutorials and Articles11 articles
Top 10 Excel Functions You Must Know
Why Excel Formulas Use Comma or Semi-Colon
Change Excel Language Easily
XLS vs XLSX file format?
Create an online survey with Excel
Excel on your mobile for free
Custom Start of Excel (font, color, format)
Searchable Dropdown List in Excel
How to Unstack Data using Excel?
How to Create an Alphabet Series in Excel
Discover Data Type in Excel
Browse the “Intermediate Excel Skills: Tutorials and Articles” page →
Pivot Table10 articles
Add filter option for all your pivot table columns
How to do Percentage in a Pivot Table in Excel?
Split report to many sub-reports automatically
Add a slicer with Excel Online
What is a Pivot Table in Excel?
Connect slicer to multiple Pivot Tables
How to Hide Unused Slicer Items in Excel
GROUPBY function: The future of COUNTIF SUMIF
How AI can be used in Excel for your data?
Intelligent Filters with Excel
Dynamic Arrays10 articles
UNIQUE Function – Remove duplicates with formulas
Extract only the numbers of a cell in Excel
What is the SPILL error in Excel?
How to return multiple rows with VLOOKUP
The FILTER Function in Excel
Find Items That Appear Only Once
Mastering the SORT Function in Excel
How to create Dependent Drop down List in Excel?
CHOOSECOLS function in Excel
Adding Headers to Tables Built with Dynamic Arrays
Expert10 articles
Convert Numbers to Words in Excel
Explanation of the VBA code for the calendar
- Keep your Last Updated Data
Update a Dropdown List automatically
How to use the INDIRECT function of Excel?
Excel as a sports coach
Microsoft has blocked macros from running
Convert Binary Number to Decimal in Excel
Enable the Developer Tab in Excel
Return Arrays with Excel’s LAMBDA Function