To create a general ledger in excel, the businessman must first set up a worksheet. The worksheet contains various formulas that he can use, to sum up, transactions into the appropriate accounts. He can also use the excel pivot table features to summarize his journal data and build a general ledger.