Then click on the AutoSum button in the Home ribbon, and your totals for the rows and columns will appear. See below for a screenshot showing you what to select and where the AutoSum button is located ...

Specifically, you can use Power Query to import a single dataset like an Excel workbook, a table from a website, or a database. Alternatively, you can import multiple datasets from worksheets in an ...