Comparte si te a gustado:

Microsoft Excel Training: From Zero to Hero in 8 Hours

Publicado en 30 Apr 2021

Udemy UK


Lo que aprenderás


  • Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting.

  • Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges.

  • Excel Formatting: Adjusting fonts, colors, adding pictures, shapes and borders, inserting SmartArt, built-in styles and creating and using templates.

  • Printing: Inserting headers and footers, generating PDFs.

  • Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek and using the scenario manager in excel.

  • Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.

  • Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.

  • Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.

  • Macros: Understanding, recording, using and editing a macro.

  • Requisitos


  • Nothing! This course assumes you are a beginner to Excel.

  • Descripción


    Welcome to Microsoft Excel 2016 Training course.


    If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.


    Learning Excel will become very easy if you do it the right way. First you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.


    In this Excel course, I have focused on the following subjects: Worksheet basics, Formulas, Formatting, Printing, Data Analysis, Charts, PivotTables and PivotCharts, Macros.


    Enjoy and happy learning.


    ¿Para quién es este curso?


  • Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course.

  • Debes tener en cuenta que los cupones duran maximo 4 dias o hasta agotar 1000 inscripciones,pero puede vencer en cualquier momento. Obten el curso con cupon haciendo clic en el siguiente boton:

    (Cupón válido para las primeras 1000 inscripciones): FREEAPRIL2
    Udemy UK
    Tags:
    • #Microsoft Excel

    Articulos Relacionados

    content

    Universidad Excel - Básico, Intermedio y Avanzado!

    Master en Excel más completo. Incluye Tablas Dinámicas, Gráficos, Dashboards, Macros y VBA a profundidad!

    Ir al Curso
    content

    Fórmulas y funciones en Microsoft Excel

    Aumenta tu productividad y amplia tus herramientas de análisis

    Ir al Curso
    content

    EXCEL para principiantes enfocado a los negocios

    Curso completo de excel para productividad en los negocios.

    Ir al Curso
    Suscríbete a nuestro boletín
    Reciba los últimos Cupones y promociones (Solicitar Cupón)