Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.

Microsoft Excel and Microsoft Access both store data used to write a financial report. However, Excel has more built-in options for quickly generating a report from a small amount of financial data.

It’s not for big data, but you can use Microsoft Excel to learn a lot more about analytics than you may realize. For many office workers, Microsoft Excel is simply the go-to spreadsheet application.