Excel for beginners: the 20 skills to learn first
The twenty things that cover most spreadsheet work, in the order they make sense. Nothing here needs a paid add-in, a macro or a mouse with extra buttons.
Read the postBusiness & Productivity · Blog
Techniques, workflows and honest advice from the Business & Productivity school, written for people learning the craft.
The twenty things that cover most spreadsheet work, in the order they make sense. Nothing here needs a paid add-in, a macro or a mouse with extra buttons.
Read the postAlt+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 postNotion is a page that can hold databases. Once that clicks, the rest is easy. Here is a one-hour setup that stays useful, and the mistake that makes people quit in week two.
Read the postData validation turns a column of typos into a column of choices. Here is the five-click version, plus how to build a list that grows on its own and how to add dependent lists.
Read the postAI is good at the first draft and bad at knowing what matters. Used in that order it genuinely halves the work. Used the other way round it produces confident, forgettable decks.
Read the postFiverr sells packaged services and buyers come to you. Upwork sells your time and you apply for jobs. That difference decides which one suits your work, and your temperament.
Read the postThree 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 postA 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 postMerge and Center keeps only the top-left value and quietly deletes the rest. Here is how to merge safely, how to combine text properly, and the alternative that breaks nothing.
Read the postJob listings say advanced Excel and mean about ten specific things. Here they are, with what each one is for and roughly how long it takes to get comfortable.
Read the postConditional formatting shows duplicates in one click, COUNTIF counts them, and a helper column finds duplicates across several columns at once. Look before you delete.
Read the postStart freelancing as a side experiment, not a leap: one specific service, three pieces of proof, one platform done properly. Revenue first, resignation letter much, much later.
Read the postWant to go deeper than reading? Explore the Business & Productivity courses