## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# Playing with Excel formulae

We take a very simple example to demonstrate the use of formulae in Excel sheets.

For this recipe, we will use the same `xlsxwriter` module and add formulae to the cells. There are numerous operations that are supported by Excel sheets, such as getting standard deviation of data, logarithm, getting trends among others, so it's worth spending time to understand the majority of available operations.

## How to do it...

You need to perform the following step:

We work with a simple example, wherein we add a list of numbers with the  `SUM()` formula and store the sum to the cell A1:

` import xlsxwriter workbook = xlsxwriter.Workbook('formula.xlsx') worksheet = workbook.add_worksheet() worksheet.write_formula('A1', '=SUM(1, ...`

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required