{"id":1938,"date":"2021-10-01T10:50:29","date_gmt":"2021-10-01T10:50:29","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?p=1938"},"modified":"2026-10-31T12:13:55","modified_gmt":"2026-10-31T12:13:55","slug":"basic-excel-course-guide","status":"publish","type":"post","link":"https:\/\/www.exceldepartment.com\/en\/basic-excel-course-guide\/","title":{"rendered":"Basic Excel Course: What You Learn and Who It Suits"},"content":{"rendered":"
\n

You avoid Excel whenever you can. Colleagues ask you for help and you panic. You have learned “on the fly” by googling problems as they appear, but you know there are huge gaps in your knowledge. That’s okay \u2013 most people have never had structured training in Excel.<\/p>\n

A basic Excel course takes 2 days and gives you skills that would take 6-12 months to learn on your own. This guide shows exactly what a basic course teaches, who it suits and what you can expect afterwards.<\/p>\n

Who is the basic Excel course for?<\/h2>\n<\/p>\n

A basic course is aimed at people who have never had proper training in Excel, or who have used the program sporadically without understanding the fundamentals.<\/p>\n

You should take a basic course if you<\/h3>\n

Feel unsure:<\/strong> – Get stressed when you have to open Excel – Avoid tasks that require Excel – Ask colleagues for help with “simple” things – Know you work inefficiently but not how to improve<\/p>\n

Have learned the wrong way:<\/strong> – Learned Excel “by doing” – Google the same thing over and over – Copy formulas without understanding them – Have developed complicated solutions that should be simple<\/p>\n

Are about to start using Excel:<\/strong> – A new role where Excel is used daily – A promotion to more analytical work – A manager who wants to understand what the team does – A switch from another tool to Excel<\/p>\n

Typical participant profiles<\/h3>\n

Administrative staff<\/strong> They use Excel for lists and simple data handling but lack an understanding of formulas and analysis.<\/p>\n

Sales staff and customer service<\/strong> Need to handle customer data, create reports and understand sales figures.<\/p>\n

Recent graduates<\/strong> May have had Excel at school but never learned professional use.<\/p>\n

Managers<\/strong> Want to understand what is possible in Excel so they can lead their teams more effectively.<\/p>\n

Finance assistants<\/strong> New in the role and need a solid foundation for budgeting and follow-up.<\/p>\n

What do you learn on a basic Excel course?<\/h2>\n<\/p>\n

A good basic course covers everything you need to work independently in Excel. No more, no less.<\/p>\n

Basic handling<\/h3>\n

Navigation and structure:<\/strong> – Understand workbooks, worksheets and cells – Quick keyboard shortcuts that save hours – Organise data logically from the start – Handle large amounts of data without getting lost<\/p>\n

This sounds basic, but the right structure from the start saves an enormous amount of time later.<\/p>\n

Formatting and presentation<\/h3>\n

Professional formatting:<\/strong> – Cell formatting (numbers, currency, dates, percentages) – Conditional formatting to highlight important information – Table formatting for clarity – Print handling (headers, page breaks, scaling)<\/p>\n

After the course your Excel files look professional \u2013 not like homemade amateur projects.<\/p>\n

Formulas and calculations<\/h3>\n

This is the core of Excel. You learn:<\/p>\n

Basic arithmetic:<\/strong> – SUM, AVERAGE, MAX, MIN, COUNT – The difference between relative and absolute references ($) – Building calculations that update automatically<\/p>\n

Logical functions:<\/strong> – IF functions for conditional calculation – AND\/OR for complex logic – Nesting several functions<\/p>\n

Text handling:<\/strong> – Combining text from several cells – Cleaning and formatting imported data – Extracting parts of text (first name, last name, etc.)<\/p>\n

Date and time:<\/strong> – Counting days between dates – Calculating working days – Handling time reporting<\/p>\n

Data analysis at a basic level<\/h3>\n

Sorting and filtering:<\/strong> – Quick filters to find information – Advanced filtering with several conditions – Sorting on several columns at once<\/p>\n

Pivot tables:<\/strong> – Create basic pivot tables – Summarise data quickly – Understand when a pivot table is the right tool<\/p>\n

Pivot tables are often a “game changer” for basic course participants. What took 2 hours manually takes 2 minutes with the right tool.<\/p>\n

Visualisation<\/h3>\n

Charts and graphs:<\/strong> – Choose the right chart type (bar, line, pie) – Create clear charts – Format charts professionally – Avoid common mistakes that make charts confusing<\/p>\n

Format and length<\/h2>\n

You can choose between classroom and online depending on what suits your situation.<\/p>\n

Classroom course (2 days)<\/h3>\n

Structure:<\/strong> – Day 1: 9:00-16:30 (handling, formatting, basic formulas) – Day 2: 9:00-16:30 (advanced formulas, pivot tables, charts) – A total of 12 hours of effective teaching<\/p>\n

Benefits:<\/strong> – Intensive learning – Direct feedback from the instructor – Network with other participants – Done in two days<\/p>\n

Suits you if you:<\/strong> – Can take two days away from work – Learn best in a classroom environment – Want quick results<\/p>\n

Online course (4\u00d72 hours)<\/h3>\n

Structure:<\/strong> – 4 sessions of 2 hours each – Spread over 2-4 weeks – The same content as the classroom course – Live with an instructor (not recorded)<\/p>\n

Benefits:<\/strong> – Combine with your regular work – No travel time – Time to practise between sessions – Often 20-30% cheaper<\/p>\n

Suits you if you:<\/strong> – Find it hard to take two days off – Are geographically far from course locations – Want to spread the learning over time<\/p>\n

Both formats give the same result. Choose based on what suits your situation.<\/p>\n

Price and what is included<\/h2>\n

Costs<\/h3>\n

Open course (individual registration):<\/strong> – Classroom: 3 500-4 500 SEK per person – Online: 2 800-3 500 SEK per person<\/p>\n

Company course (your own group, 8-12 people):<\/strong> – Classroom: 15 000-25 000 SEK in total – Online: 12 000-18 000 SEK in total<\/p>\n

A company course gives the best value with 5+ participants.<\/p>\n

Included in the price<\/h3>\n

All serious course providers include: – Complete course materials (digital and\/or printed) – Practical exercises based on real scenarios – A certificate after completing the course – 30 days of email support for questions – Coffee and light refreshments (classroom course)<\/p>\n

If the provider charges extra for materials or the certificate \u2013 look elsewhere.<\/p>\n

Hidden costs<\/h3>\n

Also count on: – Your working time (2 days’ pay) – Any travel\/accommodation – Lost production during the course<\/p>\n

A 3 500 SEK course can cost 10 000 SEK in total. But the ROI comes quickly.<\/p>\n

After the course you can<\/h2>\n

Most participants can do the following straight after the basic course:<\/p>\n

Practical skills:<\/strong> – Build and maintain budgets – Create professional reports with charts – Analyse sales data or customer lists – Automate calculations that were previously done manually – Handle timesheets and scheduling<\/p>\n

Time savings:<\/strong> – 2-5 hours per week through more efficient working methods – Tasks that took 2 hours take 20 minutes – Fewer errors thanks to automatic calculations<\/p>\n

Independence:<\/strong> – Stop googling the same thing every time – Solve your own problems without asking colleagues – Feel confident when you open Excel<\/p>\n

Participant, finance department, Malm\u00f6:<\/strong> \u201cAfter two days I could do in 20 minutes what used to take the whole morning. I didn’t even know Excel could do half of what we learned.\u201d<\/em><\/p>\n

Are you ready for a basic course?<\/h2>\n

You need to be able to<\/h3>\n