Description
This course focuses on the basic functionalities of MS Excel. We'll start with the fundamental principles you need to set up an efficient spreadsheet. You'll learn how to enter, modify and delete data, and how to copy and move information. In addition, we cover cell selection and rapid navigation techniques.
Next, we'll dive into the use of formulas and functions, as this is the core of MS Excel. In addition to simple calculations, we also cover a few basic functions. The course also explains how to apply relative and absolute cell references.
We'll also cover how to work with multiple worksheets and workbooks at the same time. You'll also learn how to use the extensive range of formatting options to create a visually appealing, well-structured, and printable worksheet.
Finally, you'll get an introduction to creating dynamic tables and graphs, so you can present your data in an even more effective way.
Audience
This course is designed for those with little or no experience with MS Excel, as well as those who already use existing workbooks and want to learn more about the underlying principles of these spreadsheets. The program is also suitable for people who want to create and manage spreadsheets independently.
Methods
Classroom or virtual training with attention to individual guidance: using exercises, the student can put the possibilities of the program into practice.
Contents
Introduction
An exploration of the Excel screen
File Management
- Save a workbook
- Open a workbook
- Create a new workbook
Working in an Excel spreadsheet
- Move around in an Excel spreadsheet
- Selecting cells
- Data entry, modification and deletion
- Insert cells, rows, and columns
- Move, copy, and insert data
- Create automatic data series
Formulas and functions
- Distinction between a formula and a function
- How to enter, change, and delete a function or formula
- Overview of some basic features
- Copying formulas and functions: relative and absolute cell references
Spreadsheet Management in Excel
- Set the default number of worksheets in Excel
- Select, Insert, Delete, Rename Worksheets
- Copy and move worksheets
- Linking worksheets to formulas
Window Management in Excel
- Place multiple worksheets on the screen
- Place multiple workbooks on the screen
- Linking workbooks to formulas
Layout
- Cell formatting
- Column and row layout
- Copy layout
- Page layout and printing
Create and Manage a Dynamic Table
Create and manage a simple chart
Certification
A participation certificate