Microsoft Excel Level 2
Microsoft Excel is a spreadsheet program in the Microsoft Office suite developed and distributed by Microsoft. Microsoft Excel allows you to enter different types of data into cells in a table format. It allows you to use simple or complex calculation functions for data analysis while integrating graphical representations.
In this training course, you will learn how to use the advanced functions of the Microsoft Excel spreadsheet program. This course corresponds to the advanced level content of the ECDL (European Certificate of Digital Literacy) Spreadsheet module. Link to the Syllabus.
The training is given on the Office 365 (Microsoft 365) version, which is compatible with Microsoft Office 2019.
Prérequis
Have completed the Excel 1 course or have equivalent knowledge.
Knowledge of English at level B1: understand everyday texts and write in a simple and coherent manner. Be able to interact in different situations and deal skillfully with everyday problems.
Description
Public
Anyone wishing to improve their Excel skills or take the corresponding ECDL (European Certificate of Digital Literacy) exam.Objectifs
Be able to use the program's advanced features independently. Pass the ECDL (European Certificate of Digital Literacy) Advanced Spreadsheet module.Contenu
Essentiel
- Formatting
- Predefined styles / automatic table formatting Conditional formatting. Creating custom number formats.
- Worksheet management
- Copying and moving worksheets
- Splitting a worksheet. Showing and hiding rows, columns and worksheets.
Functions
- Use functions: TODAY, NOW, DAY, MONTH, YEAR.
- Mathematical functions: ROUND, SUM.IF, SUM.IFS
- Statistical functions: COUNT
- Text functions: LEFT, RIGHT, TRIM, CONCAT.
- Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
- Create nested functions.
- Use mixed references in formulas.
Charts
- Create a combination chart. Manage secondary axes. Change the chart type for a data series. Change the scale and units of the y-axis. Chart formatting
- Sorting, filtering
- Sort data based on multiple columns.
- Create a custom list and perform a custom sort. AutoFilter and advanced filters.
- Subtotals, expand, collapse subtotal data levels.
Pivot Tables
- Create and modify a pivot table/data driver. Modify the data source and refresh the pivot table.
- Filter and sort.
Méthode et supports
The teaching method used by the trainers is highly participatory and requires significant personal involvement. Between each training session, personal study time equivalent to 50 to 100% of the course time (depending on the learner's needs) is strongly recommended.
- During the training, Ifage provides one PC per person for use during training sessions.
- Course materials provided to learners at the start of the training.