Course Excel in Practice
The Excel in Practice course is focused on solving practical examples in Microsoft Excel. The course is suitable for participants who need to gain an overview in a short time, orient themselves and solve common spreadsheet tasks and calculations in MS Excel.
Minimum input knowledge
Standard computer operation, experience with Windows. Basic knowledge of working in Excel: copying and moving cells, setting cell format, automatic format, automatic functions (sum, average, count, maximum, minimum).
Course dates Excel in Practice
Daily courses (1 day): 09:00 - 15:00
Course price: 150.00 / 184.50 EUR
without VAT / incl. VAT
The manual is included in the training price.
Training syllabus Excel in Practice
Overview of Options and Settings in the Program
- Main menu, toolbars, working environment settings and similar.
Creating Formulas
- Rules for writing formulas, relative and absolute cell reference, reference to a cell in another sheet or document, copying cells, sequences and series, use of the Paste Special function, swapping columns for rows and vice versa, definition of custom sequences, copy formatting function
Working with Data
- Sorting, filtering data using the automatic filter function, simple and compound subtotals, basics of working with a pivot table
Working with Large Tables
- Splitting the window, freezing panes, splitting, merging, finding, replacing, go to, options for printing large tables
Page Setup
- Appearance, margins, numbering, scaling before printing, creating a custom header and footer, repeated printing of first rows and columns
Security Principles
- Creating a password for file access, locking a cell and worksheet (preventing edits in a document)
Creating a Chart
- Chart format settings, creating a chart from non-continuous data ranges, creating and using a custom chart type
Linking an Excel Table
- To documents of other Microsoft Office programs, updating the link
Output knowledge
Practical mastery and use of Excel options. More efficient work with the program in various most commonly used areas.
Recommended courses after completing Excel in Practice
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 in Practice
Average rating