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 postA 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 postThese three tools all promise to organize your work, but they are good at different jobs. Notion is a flexible workspace, Airtable is a database that looks friendly, and Monday.com is built to manage people and deadlines. Here is how to match the tool to the team.
Read the postGrowth early on comes from being findable and being consistent, not from posting more. Here is what to fix first, what to ignore, and how long it realistically takes.
Read the postThe skills that appear in entry-level data analyst listings, split into the ones you need before applying and the ones you can learn on the job. Plus the one most people skip.
Read the postSelect 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 postLocking cells does nothing until you protect the sheet. Here is the two-step order, how to leave the input cells editable, and what sheet protection is not.
Read the postA realistic route: two tools, three projects, and one honest CV. Here is the order that works, roughly how long it takes, and the shortcut most people miss.
Read the postYou 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 postWhat actually gets first orders on Fiverr: a narrow service, a gig page written for the buyer, and enough delivered work to escape page nine. No income promises here.
Read the postA 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 postView, Freeze Panes, Freeze Top Row. That is the common case. Here is the rule that explains all three options, so you can freeze any combination without guessing.
Read the postLearn the one your workplace uses. If nobody is deciding for you: Sheets for collaboration and cost, Excel for depth, large data and job listings. The skills transfer either way.
Read the postA certification is a structure and a signal, not a hiring decision. Here is who genuinely benefits, what employers actually check, and what to build alongside it.
Read the postIt 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 postMost slide decks fail before the design stage, because the point was never decided. Here is the order that fixes it, plus the six formatting habits that do the rest.
Read the postWant to go deeper than reading? Explore the Business & Productivity courses