programming

Excel course for advanced data visualization

  • Requirements: Basic knowledge in statistics is required.
  • Modality: Online classes with practical sessions and room for doubts.
  • Duration: 10 horas.
  • Price: 250€.
  • Material: We provide all the material to download and reuse (presentations, codes and data).
  • Software: Excel.
  • Valid certificate of completion.
    Contact us

    Module 1 : Introduction to Excel

    • Excel sheets
    • Book Management
    • Cells and actions to manage them
    • Keyboard shortcuts

    45min.

    Module 2 : Data and formulas in Excel

    • Data types and formats
    • Formulas
    • Relative and absolute references
    • Ways to copy and paste
    • References

    45min.

    Module 3 : Format and aspect of the sheets

    • Formatting cells
    • Ways of presenting numbers and dates
    • Conditional formatting with rules
    • Conditional formatting with bars, icons, and color scale
    • Use of more advanced formats

    1hr.

    Module 4 : Excel charts

    • Recommended graphs
    • Creating a chart from scratch
    • Personalization
    • Minigraphs

    2hr.

    Module 5 : Page layout and printing

    • Color palettes
    • Themes
    • Printing

    1hr.

    Module 6: Essential functions in Excel

    • IF logic function
    • Extract text: RIGHT, EXTRACT, LONG
    • Purge data: SPACES, CLEAN, REPLACE
    • Concatenate texts
    • Dates: TODAY, NOW, DATEDIF
    • IF.JOINT, ROUND
    • Statistical functions: COUNT, AVERAGE
    • Search: VLOOKUP, XLOOKUP
    • Error handling: IF.ERROR
    • Filtering: FILTER
    • UNIQUE
    • SORT

    1hr. 30min.

    Module 7 : Tables in Excel

    • Table format
    • Sort and filter
    • Advantages of tables

    1hr.

    Module 8: Dynamic tables

    • Create a pivot table from scratch
    • Data pooling
    • Pivot Table Configuration
    • Dynamic graphics

    1hr. 30min.

    Module 9: Collaborate in Excel

    • Share files online
    • Comments
    • Protection of books, sheets and cell

    30min.

    Back to Training

    PhD. Elisa Cabana

    Instructor

    Elisa Cabana is a PhD in Mathematical Engineering, specialized in Statistics. She is also a researcher, data scientist and professor of data analysis at CUNEF University.

    View profile

    Available material

    Presentations, codes, data, and all the material available for reuse.

    Practical courses

    Classes focused on the practical aspect, with space to solve doubts.

    All ready to go?

    Talk to us without obligation to clarify all your doubts.

    Contact us