If you already have a basic understanding of how spreadsheets work, you're ready to dive in and get started. You can review one of our other spreadsheet tutorials to learn more: But before you begin, you'll want to have a basic understanding of how to navigate your spreadsheet program.

If you've never created a formula before, that's OK! This tutorial starts with the absolute basics of creating formulas and gradually works up to to some more advanced formulas. OpenOffice Calc: Macro Recorder Start recording: to start recording a Macro, go to the menu bar, click tools -> macros -> record Macro. However, keep in mind that we'll be using Excel 20 throughout this tutorial, so you may notice some slight differences if you're using a different program. These skills will work in Google Sheets, LibreOffice, OpenOffice, and many other spreadsheet programs. Welcome to our Excel Formulas tutorial! If you want to learn more about using formulas and functions in Excel or another spreadsheet application (such as Google Sheets), you've come to the right place! Whether you're new to spreadsheets or are a more advanced spreadsheet user, this tutorial is designed to show you how to use different formulas and functions to solve real-life problems.įormulas work almost exactly the same way in most spreadsheet programs, so you can work along with this tutorial even if you don't have Excel.

Openoffice excel tutorial