Returning After a Career Break: What Should I Relearn First?

One unfamiliar tool can make everything feel out of date

Imagine an administrator returning after several years away. They used to prepare weekly figures and answer customer questions. Now an advert mentions Excel PivotTables and a CRM—a system for managing customer information.

“Maybe I need to start from zero” feels like a reasonable conclusion. But the advert contains several different questions: can you still communicate clearly, can you produce the report, and do you know this particular system? They do not necessarily have the same answer.

The example below is fictional, not evidence that every employer wants these skills. Use your own target advert in its place.

1. Separate the required work from the unfamiliar names

Suppose the advert says:

Work or requirement	Your actual experience	What needs checking
Answer customers and follow up missing information	You handled this before your break	Can you still write a clear update?
Produce a weekly Excel summary; PivotTables required	You used spreadsheets, but not PivotTables	Can you summarise figures by category?
Experience with the employer’s CRM preferred	You used a different customer system	What training is available on this system?

The CRM name may be the most intimidating line. Here, however, it is described as preferred, while PivotTables are required for a named task. That makes the report a stronger first learning candidate—not because Excel matters most in every job, but because of this advert.

Do not silently turn “preferred” into “mandatory,” or assume every requirement is optional. If the advert only says “good Excel skills,” ask:

“For the weekly report, would I be updating an existing template or building summaries myself? Which Excel functions do you expect someone to use on arrival?”

You may not get a reply. Until you do, keep the uncertainty visible rather than buying a long course to cover every possibility. Check genuine entry requirements, including any required professional registration, separately; a spreadsheet exercise cannot replace them.

2. Check what you can still do before deciding what to study

Spend your first short session trying a familiar task with invented information. For the customer-update line, write a message that explains what is missing, who needs to respond, and when you will follow up.

If you can do that clearly, you have a reason not to begin with a general communication course. This does not prove you are ready for every customer situation; it simply gives you better evidence than “I have been away, so I must have forgotten everything.”

Now try the report. If you can organise the data but cannot make the required summary, write the gap precisely:

“I need to use a PivotTable to total amounts by category and check the result.”

That is a teachable task. “I need to get good at computers again” is not yet specific enough to choose a lesson.

3. Learn the missing operation and produce something you can check

For this fictional report, make a small practice sheet with two columns: Category and Amount. Enter three rows: A—20, A—30, and B—10. These are invented numbers, not customer data.

Your target output is A—50, B—10, with a total of 60. Follow Microsoft’s PivotTable guide for your version of Excel. Put the category in Rows and the amount in Values, using Sum.

If the result is A—2 and B—1, you are counting records rather than adding amounts. Check the summary setting and whether the amounts are stored as numbers. Do not call the exercise finished just because a table appeared.

Then build it again from the same small sheet, using your notes if needed. Explain aloud why A totals 50. The useful result is a report you can explain and check, not a certificate or a memorised sequence of clicks.

This tiny exercise only checks the first operation. Real reports may involve dates, filters, missing records, and larger datasets. Use the actual role’s needs to choose the next exercise; do not treat three correct rows as proof of full job readiness.

Choose a lesson that ends with the work you need

In this example, start with a focused PivotTable lesson, not an entire “return to work” programme or an unrelated AI course. Free documentation may be enough. If you need guided exercises, compare the syllabus and practice tasks before paying. The Coursera guide can help you check course access and costs, but buying a course is not the goal.

If your own advert requires a different task, your first lesson should be different too. A CRM task can take priority when it is essential and you cannot perform it; the ranking above belongs to the fictional advert, not to software brands.

What to do with the advert you have open

Write down three things: the required task, the part you can already do, and the smallest missing operation you can practise with a checkable result.

For our returning administrator, that becomes: “Weekly Excel summary; I can organise rows; I will learn a PivotTable that totals categories correctly.”

You do not have to repair your entire career before taking a next step. This is a way to choose learning alongside your job search, not a new rule that you must finish another course before you apply.