LESSON 1: INTRODUCCTION I

Open the following file and pay attetion to the teacher,s explanations:

• GETTING TO KNOW EXCEL

Activities:

•  TASK 1.1 Read the EXCEL DEFINITION and do the DICTIONARY.
• TASK 1.2: Excel Vocabulary 1 and Excel Vocabulary 2

Links:   

• To learn more about Excel you can read the following document and make the recommended tasks. EXCEL USER GUIDE

• QUIZLET PAGE

LESSON 2: EXCEL BASICS

Open the following file and pay attention to the teacher´s instructions:

• EXCEL BASICS

Activities:

Download the file  TASK 2  and follow the instructions given in the video:

          TASK 2.1: Modifying columns, cells and rows (sheet 1)

          TASK 2.2: Formating cells (sheet 2)

To learn more:   

• See the next file, read it and pay attention on the main mostly used commands or options in EXCEL. Look for the words you don't understand in a dictionary when need it and afterwards do the exercices your teacher suggests  MOST USED COMMANDS IN EXCEL 

• Follow the instructions given in the next file and do the exercise such as told by your teacher. COPY AND PASTE CELLS AND FILES.

LESSON 3: BASIC FORMULAS

Open the most powerful featuresin Excel is the ability to calculate numerical information using formulas.

The next video shows you how to create simples formulas with Excel.

Activities:

Download the file  TASKS 3  and do the five activities.

LESSON 4: CHARTS

Open the following file and pay attetion to the teacher,s explanations:

• CHARTS

Activities:

Download the file  TASKS 4  and do the activities.

LESSON 5: DRAWING WITH EXCEL

Activity:

TASK 5. In this activity we will use the spreadsheet to do a funny picture.

EXTRA ACTIVITIES:

• EXTRA TASKS To the activities download the follow file .

• E 3: SPARKLINES

• E 4: CONDITIONAL FORMATTING