You will learn
On this Excel Basic course, you will learn how to use the most important and commonly used features in Microsoft Excel. The course gives you a solid foundation for working more efficiently with spreadsheets, calculations, formatting, charts and data.
The course is suitable for beginners, but also for users who already work with Excel and want to strengthen their basic skills and discover smarter ways of completing everyday tasks.
Through practical exercises, you will become more confident using Excel and learn techniques that can help you work faster and more efficiently.
After the course, you will be able to:
- Build worksheets from scratch, insert comments, copy and move cells, use Search and Replace and work with the fill handle.
- Build formulas, use some of Excel's built-in functions and work with relative and absolute cell references using $ signs.
- Prepare worksheets for printing, adjust them to fit pages and use page headers and footers.
- Work with multiple worksheets, including copying, moving and entering data in several sheets at the same time.
- Create and adjust charts to present data graphically.
- Organize larger lists using sorting and filtering.
You can find a complete overview of the topics covered under Course Details further down the page.
See also our full selection of Excel courses.
You get
Before the course
- The opportunity to speak with an instructor who can help you determine whether this is the right course for you.
During the course
- Training by an experienced instructor team with many years of experience in Excel.
- Practical training that combines theory with hands-on exercises.
- Course material that you can use as a reference after the course, as well as course exercises.
- Training in our classrooms in central Copenhagen.
- Full catering including breakfast, freshly brewed coffee, tea, fruit, soft drinks, lunch at a nearby restaurant, cake and sweets.
- A course certificate documenting your participation and new skills.
After the course
- Access to our free hotline for up to one year, where you can contact us with questions about the topics covered during the course.
- Our satisfaction guarantee, giving you extra reassurance that you will get the full benefit of your course.
Get the best benefit from the course
This Excel Basic course is suitable for anyone who wants to learn the fundamentals of Excel or become more confident using the program.
You do not need any previous experience with Excel to participate, making the course suitable for complete beginners as well as users who want to strengthen their basic Excel skills.
The course is taught in English and is part of our selection of English conducted courses.
Course Details
Module 1: Getting started with Excel
In this module, you will learn the fundamentals of Excel and become familiar with the program's interface and basic structure.
The following topics will be covered:
- Workbooks, worksheets, columns, rows and cells
- The Ribbon - finding your tools easily
- Quick Access Toolbar - adding your own commands
- Zooming in and out
Module 2: Important tools
In this module, you will learn how to navigate worksheets, select cells and enter and edit text and numbers. You will also work with copying cells and using the fill handle.
The following topics will be covered:
- Comments - inserting comments into cells
- How to insert rows and columns and move rows, columns and cells
- Search and Replace
- Using the fill handle to copy cells and create series of numbers, dates, months and weekdays
- Using Flash Fill to extract or combine content from different columns
Module 3: Formulas and calculations
In this module, you will learn how to perform basic calculations in Excel. You will work with formulas using numbers, cell references and named ranges.
You will also be introduced to some of the most commonly used functions in Excel. Practical exercises throughout the module will help you become familiar with the different calculations and functions.
The following topics will be covered:
- Calculation operators and calculation rules - essential when creating formulas
- Building your own formulas
- Copying formulas in several ways
- Introduction to built-in functions - including AutoSum, statistical functions and logical functions (the IF function)
- Using relative and absolute cell references in formulas with $ signs
- Using names in formulas
Module 4: Formatting
In this module, you will learn how to format your data and improve the appearance of your worksheets. You will work with fonts, sizes, colors and other formatting options that can help make information easier to read.
The following topics will be covered:
- Formatting cells - fonts, sizes, borders, colors etc.
- Formatting numbers, dates and percentages
- Clearing formats
- Format Painter - an easy way to copy formatting to other cells
Module 5: Printing and Page Layout
In this module, you will learn how to prepare your worksheets for printing. You will work with page layout settings such as margins, orientation and paper size and learn how to scale your worksheet to fit a specific number of pages.
The following topics will be covered:
- Previewing the sheet before printing
- Adjusting the page layout
- Printing the worksheet or workbook
- Page headers and footers - repeating text or information on all pages
Module 6: Using multiple sheets
In this module, you will learn how to organize and work with multiple worksheets in the same workbook.
You will work with managing and navigating between sheets as well as entering data and working with formulas across multiple sheets.
The following topics will be covered:
- Creating, managing and entering data in multiple sheets
- Navigation between sheets
- Formulas on multiple sheets
Module 7: Charts
In this module, you will learn how to present your data graphically using charts. You will work with different chart types and learn how to adjust the settings and formatting of chart elements.
The following topics will be covered:
- How to create charts based on your data
- Different chart types - and what types of data they are suitable for representing
- Adding and removing chart elements: titles, legends, axes, gridlines and labels
- Editing your charts: frames, fill colors, object placement and number formats
Module 8: Lists
In this module, you will learn how to organize larger amounts of data in Excel. You will work with sorting data and using filters to display only the information that meets specific criteria.
You will also look at the advantages of converting lists into Excel tables.
The following topics will be covered:
- Organizing data using lists
- Creating lists, sorting lists and filtering data
- Creating tables and using table styles - data ranges that can change in size
Module 9: Keyboard Shortcuts
In this module you will get an overview of keyboard shortcuts.
The following will be covered:
- Excel standard keyboard shortcuts
Vælg dato, by og deltagere
Længde
2 dage
Pris
8,500 kr.
ex moms
Sted
System.Collections.Generic.List`1[System.String]
27-10-2026
Kl: 09:00-16:00
Hvad siger vores kunder om os?
Siden 1991 har 4D Academy hjulpet virksomheder og specialister med at omsætte viden til målbare resultater. Vores kursister belønner os med en gennemsnitlig rating på 4,8 ud af 5 på Trustpilot, Google og Facebook, og det gør os stolte.
Se hvorfor både nye og erfarne fagfolk vælger os, når de vil løfte deres kompetencer.
Hold dig opdateret med vores nyhedsbrev
Her bor vi
Læderstræde 22, 2. sal, 1201 København K
Tueager 5, 8200 Aarhus
Ørbækvej 350, 5220 Odense
Tirsdag: 08.00 - 16.00
Onsdag: 08.00 - 16.00
Torsdag: 08.00 - 16.00
Fredag: 08.00 - 16.00
