Course Excel 1 - Basics
Do you want to discover the world of Excel and start using its possibilities fully? This course is an ideal start for yo...
Do you want to discover the world of Excel and start using its possibilities fully? This course is an ideal start for you. The Excel course for beginners is intended for everyone who has not yet worked with Excel or has only minimal experience and wants to gain solid basics in working with this powerful tool. During the course you will learn how to efficiently create and edit tables, perform simple calculations, work with data and create clear charts. Everything is under the guidance of an experienced lecturer who will help you master each function step by step. Join us and open the door to the world of Excel, where you will have everything under control.
Minimum input knowledge
Basics of working with a computer.
Course dates Excel 1 - Basics
Daily courses (2 days): 09:00 - 15:00
Evening courses (3 days): 16:30 - 19:00
Weekend courses (2 days): 09:00 - 15:00
Course price: 162.60 / 200.00 EUR
without VAT / incl. VAT
The manual is included in the training price.
Training syllabus Excel 1 - Basics
MS Excel Working Environment
- Introduction to the Excel working environment - title bar, quick access toolbar, ribbon, tabs, groups, working area, status bar, name box, formula bar.
- Names of rows, columns and cells.
- Effective use of help.
Working with Files and Worksheets
- Adding, removing, renaming and moving worksheets.
- Creating a new workbook from scratch.
- Opening and saving existing workbooks.
Working with Cells and Cell Formatting
- Entering text and numeric data into cells.
- Formatting text and cells for better clarity.
- Copying cells and using the "Paste Special" option.
- Selecting a continuous and non-continuous range of cells.
- Working with basic number formats.
- Formatting cells as a table.
- Creating automatic series for quick data entry.
Formulas and Functions
- Using basic formulas for calculations - addition, subtraction, multiplication and division.
- Automatic functions: sum, average, count of numbers, maximum, minimum.
- Copying formulas and functions for efficient work.
Sorting and Filtering Data
- Sorting data by different criteria.
- Filtering data using the automatic filter.
Charts
- Creating different types of charts.
- Basic settings and customization of charts.
- Moving charts within a workbook.
Printing
- Print preview for correct output settings.
- Page setup for printing.
- This syllabus covers all basic aspects of working with Excel that are necessary for beginner users.
Output knowledge
After completing the Excel course for beginners, the participant will be able to: Create simple tables - knowledge of working with cells wil...
After completing the Excel course for beginners, the participant will be able to:
- Create simple tables - knowledge of working with cells will enable the participant to efficiently enter and format text and numeric data.
- Use basic formulas and functions - the participant will be able to create basic formulas and use key functions such as sum, average, count, maximum and minimum for processing data in a table.
- Edit tables - acquired formatting skills will enable the participant to adapt the appearance of a table as needed so that it is ready for printing or presentation.
- Sort and filter data - the participant will be able to sort and filter data efficiently in order to quickly find relevant information.
- Create charts - the ability to create and customize basic charts will enable the participant to visualize data and present it in a clear form.
- Prepare tables for printing - the participant will be able to set up the page and table so that the document is ready for printing, including checking the appearance through print preview.
This knowledge will enable the participant to work efficiently with Excel at a basic level, which is necessary for everyday office tasks.
Recommended courses after completing Excel 1 - Basics
Show all courses from category Excel courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Excel 1 - Basics
Average rating