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.

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.

Classroom or virtual training with attention to individual guidance: using exercises, the student can put the possibilities of the program into practice.

‍

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

‍