How to use the LOG10 functions in Excel. Enter your data or use existing data. Type into the cell where you want to place the result =LOG10(A4).; Press Enter to see the result.

How to create an Excel table. 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.