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
Blog
1285 articles
Advanced Excel
How to Calculate Exponential Moving Average in Excel (with Quick Steps)
Learn how to calculate exponential moving average in Excel with simple steps for a stock price data over a time frame.
Read article
Advanced Excel
Convert Degrees Minutes Seconds to Decimal Degrees in Excel
Learn how to convert degrees, minutes, and seconds to decimal degrees in Excel using TEXT functions, formulas and VBA code.
Read article
Advanced Excel
How To Extract Data from Website to Excel Automatically
Learn how to extract data from a website into Excel automatically using Get & Transform feature, VBA scripts and browser extensions.
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 Charts
How to Change Chart Color Based on Value in Excel
Step-by-step guide to change Excel chart color based on value using formulas for creating dynamic, visually impactful data visualizations.
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 Charts
How to Add Vertical Line in Excel Graph (Step-by-Step Guide)
A step-by-step guide to add a vertical line in an Excel graph using error bars and combo charts for highlighting benchmarks.
Read article
Google Sheets Basics
How to Remove Time from Date in Google Sheets (6 Easy Ways)
Learn how to remove time from date in Google Sheets using formatting, text splitting, rounding, or the DATE function.
Read article
Excel Charts
How to Left Align a Chart in Excel
Learn how to left-align a chart in Excel: Align charts to cells, multiple charts together, or chart elements with easy steps.
Read article