Excel Pro Tips
Separate First and Last Names with Space in Excel Formula
Learn how to separate first and last names with space in Excel using formulas like LEFT, RIGHT, FIND, TEXTSPLIT, TEXTBEFORE, and TEXTAFTER.
Read article
Blog
1285 articles
Excel Pro Tips
How to Convert Text to Columns with Line Break in Excel
Learn how to convert text to columns in Excel using line breaks with Text to Columns, TEXTSPLIT, and Power Query for easy data splitting.
Read article
Excel Pro Tips
How to Extract Specific Numbers from a Cell in Excel
Learn how to extract specific numbers from a cell in Excel using functions like MID, TEXTJOIN, REGEX, Power Query, VBA, and more.
Read article
Excel Pro Tips
How to Separate Date in Excel Using Formula (3 Suitable Methods)
Easily separate date in Excel using formulas like DAY, MONTH, YEAR, TEXT, INT, TRUNC, ROUNDDOWN, and LEFT to extract specific date parts.
Read article
Excel Pro Tips
How to Translate Multiple Cells in Excel (4 Effective Ways)
Learn how to translate multiple cells in Excel using built-in tools, Word, Microsoft 365 functions, and Power Query with Google API.
Read article
Excel Pro Tips
How to Make a Venn Diagram in Excel (2 Easy Methods)
Learn how to make a Venn diagram in Excel using the SmartArt feature or by customizing shapes manually for more flexible designs.
Read article
Google Sheets Functions
How to Use VLOOKUP from Another Sheet in Google Sheets
Learn how to use VLOOKUP from another sheet in Google Sheets within the same workbook or between workbooks using IMPORTRANGE.
Read article
Excel Pro Tips
How to Create a Timeline in Excel with Dates (6 Different Ways)
Learn how to create a timeline in Excel using templates, SmartArt, PivotTables, scatter plots, Gantt charts, and manual design tools.
Read article
Excel Pro Tips
How to Convert Text File to Excel Automatically (5 Simple Ways)
Learn how to automatically convert a text file to Excel using file extension tricks, Power Query, VBA, and Excel’s built-in import tools.
Read article
Excel Pro Tips
How to Paste Comma Separated Values into Excel (4 Easy Ways)
Learn how to paste comma-separated values into Excel using Text to Columns, From Text/CSV, Power Query, and the TEXTSPLIT function.
Read article
Excel Pro Tips
How to Convert XML to Excel Table (3 Suitable Methods)
Learn how to convert XML to Excel table using built-in import tools, Power Query, and VBA for handling simple to complex XML data.
Read article
Excel Pro Tips
How to Send Bulk Email from Outlook Using Excel
Learn how to send bulk emails from Outlook using Excel with a VBA macro or Mail Merge, plus tips to avoid spam and manage sending limits.
Read article