Bonus tip: With basic formulas, the AutoSum button is the top choice. It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) and press Enter.

There you have it — a basic guide to using Excel as a beginner. But there is much more to learn! For setting up a spreadsheet, look at how to add an Excel column .

At their most basic, Excel formulas can perform basic math functions and display a solution. For example, the formula "=2+2" will display "4" in the cell.

Once you enter your prompt, you choose whether this formula will be implemented in Excel or Sheets, since the two tools have different commands. Hit “Generate,” and the AI will spit out the ...