Excel Pro Tips
How to Calculate Hours Between Two Times after Midnight in Excel
Learn how to calculate hours between two times after midnight in Excel using formulas, helper columns, and proper time formatting.
Read article
Excel Pro Tips
555 articles
Excel Pro Tips
How to Calculate Years and Months Between Two Dates in Excel
Learn how to calculate years and months between two dates in Excel using a helper column and the DATEDIF function.
Read article
Excel Pro Tips
How to Fix All Numbers Stored as Text in Excel (3 Quick Solutions)
Learn how to fix numbers stored as text in Excel by changing number format, using a multiplication trick, and applying a helper column.
Read article
Excel Pro Tips
How to Find the Last Occurrence of a Character in a String in Excel
Learn how to find the last occurrence of a character in a string in Excel using different string manipulation formulas and VBA code.
Read article
Excel Pro Tips
Combine Multiple Cells into One Separated by Comma in Excel
Learn how to combine multiple cells into one in Excel, separated by commas, using CONCAT, TEXTJOIN, ampersand (&) and VBA code.
Read article
Excel Pro Tips
Lookup in One Column & Return Value of Another Column in Excel
Learn how to look up a value in one column and return a value from another in Excel using VLOOKUP, XLOOKUP, INDEX-MATCH, or LOOKUP functions.
Read article
Excel Pro Tips
How To Mail Merge from Excel to Outlook (with Step by Step Guide)
Learn how to mail merge from Excel to Outlook with easy steps: create Excel data, prepare Word file, import, merge fields, and you're done.
Read article
Excel Pro Tips
How to Convert Military Time to Standard Time in Excel (3 Ways)
Convert military time to standard time in Excel using the TIME function, advanced tips, and formatting methods for different time units.
Read article
Excel Pro Tips
How to Remove Rows Containing Identical Transactions in Excel
Learn how to remove rows with identical transactions in Excel using built-in tools, IF-COUNTIF and by copying unique data.
Read article
Excel Pro Tips
How to Print Excel Sheet with Rows and Columns: 2 Simple Ways!
This article covers two different ways to print Excel sheet with rows and columns: to print default Excel's column headings and print titles.
Read article
Excel Pro Tips
How to Apply Conditional Formatting to the Selected Cells (5 Ways)
This article shows 5 ways to apply conditional formatting to selected non-adjacent cells, two columns, with formulas, & data bars option
Read article
Excel Pro Tips
How to Write 001 in Excel (4 Easy Methods to Keep Leading Zeros)
Learn how to write 001 in Excel by using custom formatting, text format & different Excel functions to keep leading zeros for codes, IDs etc.
Read article