ExcelRoadMap.com

Search in ExcelRoadMap

Functions:

Text Functions:

REGEXEXTRACT Tutorial
REGEXREPLACE Tutorial
REGEXTEST Tutorial
TEXTSPLIT Tutorial
TEXTJOIN Tutorial
VALUETOTEXT Tutorial

Lookup and Reference Functions:

CHOOSECOLS Tutorial
CHOOSEROWS Tutorial
WRAPCOLS Tutorial
WRAPROWS Tutorial
DROP Tutorial

Logical Functions:

BYCOL Tutorial
BYROW Tutorial

Statistical Functions:

SCAN Tutorial
SMALL Tutorial

Uncategorised Functions:

LET Tutorial
PERCENTOF Tutorial

Basics:

Interface:

Understanding the Basic Layout of Excel
How to Customize Quick Access Toolbar
How to Collapse and Expand the Excel Ribbon
Creating Hyperlinks to Navigate Between Sheets in Excel

Data Type:

General Data Type of Excel Cells
Numeric Data Types of Excel Cells
Date and Time Data Types of Excel Cells

Cell:

Relative and Absolute References in Excel Cells
A Comprehensive Guide to Excel Paste Options
Unlocking Excel Autofill: Tips and Tricks for Efficient Data Entry

Row & Column:

Maximum Number of Rows and Columns in a Microsoft Excel Worksheet
How to Freeze the Top Row and Left Column in Excel
How to Hide and Unhide Rows and Columns in Excel
Essential Excel Print Settings for Everyday Use

Tricks:

Automatically Format Phone Number Input in Cells
How to Enter Multiple Lines of Content in an Excel Cell
Use Focus Cell to Highlight Specific Cells
Excel Clipboard Tutorial
Auto Adjusting Cell Width and Height (AutoFit) in Excel
Use Flash Fill to Extract Emails from Text
Common Regular Expressions for Excel Users
How to Correctly Paste CSV Data into a Worksheet