How To Use Excel?

Open Excel

Choose a blank workbook or a template

Click a cell to enter data

Type values directly into cells

Use Enter to move to the next row, or Tab to move to the next column

Format cells (Home tab → Font, Alignment, Number)

Set number formats (Home → Number → Currency/Percent/Number)

Create a table (Insert tab → Table)

Apply table styles (Table Design tab)

Enter formulas (type `=` in a cell)

Use common formulas (e.g., `=SUM(range)`, `=AVERAGE(range)`, `=IF(condition, value_if_true, value_if_false)`, `=VLOOKUP(…)`, `=XLOOKUP(…)`)

Reference cells in formulas (e.g., `=A1+B1`)

Copy formulas (select the cell with the formula → drag the fill handle)

Sort data (Data tab → Sort)

Filter data (Data tab → Filter)

Create charts (Insert tab → choose chart type)

Select data for the chart (highlight range before inserting)

Add chart labels and titles (Chart Design/Format tabs)

Create pivots (Insert tab → PivotTable)

Refresh pivot data (PivotTable Analyze tab → Refresh)

Save the file (File tab → Save As)

Rename sheets (double-click sheet tab)

Move or copy sheets (right-click sheet tab → Move or Copy)

Protect a worksheet (Review tab → Protect Sheet)

Freeze panes (View tab → Freeze Panes)

Set print settings (File tab → Print → adjust options)

Print (File tab → Print → Print button)

Export (File tab → Export → Change File Type)

Suggested for You

Trending Today