Excel Course

Banner Master's Degree in research in Clinical Medicine

 

Conditions: Updated Web browser (latest versions of Explorer, Chrome or Firefox recommended), Flash Player updated and system for audio (speakers or headphones).

To watch the classes of the course follow the links indicated or copy them in your browser:

  1. Concepts of Excel and the file formats https://connect.umh.es/p61137643/

  2. Specify, edit data, apply formatting and structure to spreadsheets https://connect.umh.es/p41405670/

  3. Formulas and functions https://connect.umh.es/p92001730/

  4. Statistic functions I https://connect.umh.es/p90385762/

  5. Statistic functions II https://connect.umh.es/p87175441/

  6. Tables  https://connect.umh.es/p99392469/

  7. Layouts  https://connect.umh.es/p40541317/

  8. Graphics https://connect.umh.es/p44806010/

  9. Order and filter https://connect.umh.es/p32969559/

PRESENTATIONS

01_Concepts_and_file_format.pdf

02_Format_and_structure.pdf

03_Formulas_and_functions.pdf

04_Statistic functions I.pdf

05_Statistic functions II.pdf

06_Tables_lists.pdf

07_Layouts.pdf

08_Graphics.pdf

09_Filter_order.pdf

PRACTICES

P1 - statement concepts and file formats.pdf

P2 – statement conditional format.pdf

P3.1 – statement function searchv and searchh.pdf

P3.2 – statement practical function add if.pdf

P4 – statement practice statistics functions I.pdf

P5 – statement practice statistics functions II.pdf

P6 – statement practice tables.pdf

P7 – statement practice Layout.pdf

P8.1 – statement practical graphics.pdf

P8.2 – statement practical graphics II.pdf

P9 – statement practice sorting and filtering.pdf

searchv and searchrh.xlsx

cuartiles.xlsx

standard deviation.xlsx

Layout.xlsx

conditional formats.xlsx

Statistics functions II.xlsx

graphics.xlsx

MEDIUM.xlsx

TABLE_expenses_building_UMH.xlsx

variance.xlsx

concepts and file formats.xlsx

Add if.xlsx

PRACTICAL SOLUTIONS

practical master’s degree solutions excel.xlsx