Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Create a Table in Excel: Format as Table, Structured References and Total Row

An Excel table is a range of data that Excel treats as one object. It grows when you add rows, copies formulas down by itself, keeps the header row in view, and gives you filter buttons, banded rows and a total row with one click. Tables also make formulas easier to read, because you can

Standard

How to Make a Gantt Chart in Excel: Stacked Bar Method Step by Step

A Gantt chart shows a project as a set of horizontal bars on a timeline. Each bar starts on the date a task begins and has a length equal to the task duration, so you can see at a glance what happens when, what overlaps and what is late. Excel has no ready-made Gantt chart

Standard

How to Create a Named Range in Excel: Name Box, Name Manager and Formulas

A named range gives a cell or a group of cells a short, readable name, such as TaxRate or Sales. Instead of writing =B2*Sheet2!$C$5 you write =B2*TaxRate, which is easier to read, easier to check and harder to break. Named ranges also make formulas easier to copy, since the name always points to the same

Standard

How to Insert a Slicer in Excel: Filter Tables and PivotTables With Buttons

A slicer is a set of buttons that filters your data with one click. Instead of opening a drop-down and ticking boxes, you click a button such as North, Q2 or Laptop, and the table or PivotTable shows only matching rows. Slicers also show the current filter at a glance, which makes them popular in