Course Excel 2 - Intermediate
The Excel for Intermediate Users course is intended for all interested participants who want to go deeper into the possibilities of Excel and learn to use this program effectively.
Minimum input knowledge
Experience with Excel: moving through a document, working with sheets, basics of formatting, copying content and format, basics of working with formulas. Experience with Excel is also sufficient.
Course dates Excel 2 - Intermediate
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 2 - Intermediate
Getting Familiar with Excel, New Features and Main Differences Compared with a Lower Version of Excel
- MS Excel working environment, option to customize the quick access toolbar and ribbon
- Cell formatting, creating a custom format
- AutoComplete function, data validation
Conditional Formatting, Combining Multiple Conditions
Writing Formulas in MS Excel
- Copying formulas, difference between relative, absolute and mixed cell reference
Structured References
Basics of Working with Functions, Function Syntax
- Different ways of inserting a function - their advantages and disadvantages
- Overview and examples of the most frequently used mathematical, statistical, time, logical and lookup functions
Sorting, Filtering and Summaries in Microsoft Excel
- Sorting by multiple levels, by color, by a custom list
- Number, text and date filters, custom filter, use of wildcard characters in text criteria
Simple Subtotals and Their Use in Practice
Pivot Table
- Creating a table, field settings, refreshing a table when data changes
Creating Charts in MS Excel
- Correct setting of source data, setting the format of different chart areas, adding elements, setting style and colors, filtering a chart, option to save a chart as a template and use the template
Pivot Chart
Printing
- Creating document header and footer, setting page breaks, selecting print area
Saving to PDF Format
Templates in Microsoft Excel
Working with a Template - Creating a Template, Using a Template
Discussion
Output knowledge
The graduate of the Excel intermediate level course will have a comprehensive overview of the options and functions of MS Excel. They will l...
The graduate of the Excel intermediate level course will have a comprehensive overview of the options and functions of MS Excel. They will learn to effectively create tables and charts and format them for professional presentation. They will be able to work with extensive data, create templates and tools for more effective work.
Recommended courses after completing Excel 2 - Intermediate
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 2 - Intermediate
Average rating