How to Convert Capital Letters to Lowercase in Excel . The LOWER function does exactly what you’d expect—it converts all letters to lowercase.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...