Microsoft Excel Level 1
Microsoft Excel is a spreadsheet software 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 Microsoft Excel spreadsheet program and its basic functions. This course corresponds to the basic level of the Spreadsheet module of the ECDL (European Certificate of Digital Literacy).
The training course is given on the Office 365 (Microsoft 365) version, which is compatible with the Microsoft Office 2019 version.
Prérequis
Introductory computer course or equivalent knowledge.
Knowledge of English at level B1: understanding everyday texts and writing in a simple and coherent manner. Ability to interact in different situations and deal skillfully with everyday problems.
Description
Public
Anyone who wants to use a spreadsheet program. Anyone who wants to take the corresponding ECDL (European Certificate of Digital Literacy) exam.Objectifs
Be able to use a spreadsheet independently for everyday tasks. Pass the Spreadsheet module of the ECDL (European Computer Driving License).Contenu
? Excel, concepts of workbooks and spreadsheets? Creating, saving, closing, and opening a workbook
? Saving a workbook in a different format
? Entering, selecting, deleting, and modifying cell content
? Managing columns, rows, and cells
? Formatting text, numbers, and dates (font and alignment)
? Cells borders and fill colors
? Incremental copying
? Recognizing standard error values and knowing how to fix them
? Find and replace
? Managing sheets in a workbook
? Arithmetic calculations (+, -, /,*) and percentages
? Functions: sum, average, count, max, min, today, round, if
? Relative and absolute cell references
? Copying and moving cells within the same workbook, between different sheets, and between different workbooks
? Freezing row and column headers
? Sheet layout: margins, orientation, fit, header and footer, repeating rows and columns on all pages
? Print preview and print options
? Sorting
? Charts: histogram, bar, curve, and pie
Méthode et supports
The teaching method used by the trainer 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.