Skip to content

Business & Productivity · Blog

The office

Techniques, workflows and honest advice from the Business & Productivity school, written for people learning the craft.

Guide5 min read

How to wrap text in Excel

Alt+H+W wraps text in the selected cells. Then comes the part that trips people: making the row height follow along, and knowing when to use a line break instead.

Read the post
Guide6 min read

How to remove duplicates in Excel

Three ways to clear duplicate rows: the Remove Duplicates button for a permanent clean-up, Advanced Filter when you want a copy, and UNIQUE when you want the list to stay live.

Read the post
Guide7 min read

How to make a presentation that actually lands

A good presentation is not a good-looking slide deck. It is a clear argument, delivered by a person, with slides that stay out of the way. Here is how to build one in that order, and how PowerPoint and AI actually help.

Read the post
Guide6 min read

How to learn Excel from scratch

A realistic order to learn Excel in, how long each stage takes, and the single habit that separates people who get good from people who keep googling the same formula.

Read the post
Guide6 min read

How to create charts in Excel

Select your data, press Alt+F1, then fix the three things that make a chart readable: the chart type, the axis, and the labels. Here is the whole process, including which chart to pick.

Read the post
Guide8 min read

Excel formulas everyone should actually know

You do not need three hundred Excel functions. You need about a dozen you can reach for without thinking. Here are the ones that carry most real spreadsheets, what each is actually for, and the moment a pivot table quietly wins instead.

Read the post
Guide6 min read

Pivot tables explained for beginners

A pivot table is a summary you build by dragging field names into four boxes. Ten minutes here replaces a lot of manual adding up, and it is easier than its reputation suggests.

Read the post
Career5 min read

Is an Excel certification worth it?

It depends what you want it to do. A certification gets you past a filter and gives you a finish line. It does not prove you can build the thing your job actually needs.

Read the post

Want to go deeper than reading? Explore the Business & Productivity courses