lunes, 4 de septiembre de 2017

LESSON 1: INTRODUCCTION I

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

Activities:

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

LESSON 2: EXCEL BASICS

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

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 

    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:

    Resultat d'imatges de graphs

    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:

    • E 3: SPARKLINES
    • E 4: CONDITIONAL FORMATTING