Intermediate Excel Skills: Tutorials and Articles

Take your Excel skills to the next level with intermediate techniques. Learn how to use conditional functions, lookup functions, and advanced formatting.

Searchable Dropdown List in Excel

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

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.

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.

Excel Test for IF, IFS & IFERROR functions

Challenge yourself with an Excel test on IF, IFS, and IFERROR functions. Test your knowledge and improve your skills.

Top 10 Excel Functions You Must Know

Discover the top 10 Excel functions you should know. From SUM to IF and COUNTIF, learn how to boost your productivity in Excel.

How to Create an Alphabet Series in Excel

Learn how to create an alphabet series in Excel using the ADDRESS and SEQUENCE functions. Step-by-step guide included!

Discover Data Type in Excel

Discover the power of Excel's Data Type feature for gathering information about countries or stock exchanges.

Excel on your mobile for free

Excel can be downloaded on your mobile for free and you will have all the features to update your Excel files

Minutes to Hours converter with Excel

Need to convert minutes to hours in Excel? Find out how to do it effortlessly using specific functions and formulas.

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

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.

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.

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

How to keep the leading 0 in a cell?

Keep the leading 0 in Excel is important when you want to keep all the digits of your strings and to avoid mistakes

XLS vs XLSX file format?

Understand the difference between XLS and XLSX file formats in Excel. Learn how to convert and save files for optimal compatibility.

SUMIFS Function in Excel

Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets

Custom Start of Excel (font, color, format)

Learn how to start Excel with custom parameters. Step-by-step guide for beginners and experts to optimize your Excel experience.

Create an online survey with Excel

Create and share online surveys easily with Excel Online. Learn how to create surveys using cloud technology.

Intermediate Excel Skills: Tutorials and Articles

Categories

Intermediate Excel Skills: Tutorials and Articles