Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office Excel 2016 Basic and Advanced to your Wishlist.

Add to Wishlist

Microsoft Office Excel 2016 Basic and Advanced

Course where you will be learning in-depth about the Microsoft Excel 2016. You will be learning basics & advanced
3.9 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
24 students enrolled
Last updated 12/2015
$15 $25 40% off
30-Day Money-Back Guarantee
  • 9 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

Everyone should have all the knowledge of excel concepts and functions if they want to get their work done faster.

Excel is used everywhere, hence we want that everyone should have the knowledge of advanced as well as the basic excel concepts. Through this training on Excel 2016 Training you will get access to video tutorials, pdf documents, excel sheets on excel 2016. For understanding all the concepts we have taken help of different examples in excel 2016.

Each calculation will be solved in detail and this step by step understanding of the examples after the concepts will help you understand each function and formula in much detail. So before starting with the course let’s see what exactly is Excel 2016 and why we use it and what are the benefits. Microsoft Excel 2016 is thoroughly used in almost all fields be it finance, statistics, marketing, engineering, human resources and hence it is the basic thing that everyone should know. It is especially used for the businesses which deal with large amounts of data (numbers, statistics). Hence getting to know some advanced excel functions will be quite beneficial for anyone who wants to get the work done faster and in an easiest way available.

Benefits of the Basic Excel 2016 Training

  • Learn Excel 2016 basics from Scratch using an Excel examples Approach that will help you to understand each example in a very easy way.
  • Get a very good understanding of the smart features like Charts and Graphs in this course of excel 2016
  • Learn to Gain command over powerful features and functions in Excel 2016 through this Excel 2016 Training
  • Become Awesome in excel 2016 by this Excel 2016 Training

  • About Advanced Excel 2016

    Join the Advance Excel 2016 course and learn advance functions in Advanced Excel 2016 and learn to work with data more effectively. You will learn how to use data functions, work with texts, pivot tables, important excel tools and new charts option in Advanced Excel 2016.

    The tutorials will help you learn about

  • How to apply useful excel functions such as paste special, logical functions, arithmetic functions, cell information functions
  • Use data functions such as Choose function, VLOOKUP, HLOOK UP, Match and index, database function, offset, forecast function
  • Understand what if analysis using one dimensional, two dimensional data tables, solver and goal seek.
  • Learn how to use and apply array function, transpose and frequency
  • We also see how to work with functions for working with text, pivot tables, names and dynamic range, Auditing and Trouble Shooting formulas, Form Controls.
  • We shall learn about various important excel tools such as Text to Columns, Grouping Tabs, Subtotal Function, Hyperlinks, Data Validation, Random Numbers, Custom View etc
  • The final section deals with charts wherein you get to learn about the New charts in Excel 2016 such as the waterfall chart, box & whisker chart, tree map chart and sun burst chart
  • Who is the target audience?
    • Students
    • Professionals
    • Business Persons
    Students Who Viewed This Course Also Viewed
    What Will I Learn?
    Get a very good understanding of the smart features like Charts and Graphs in this course of excel 2016
    Become Awesome in excel 2016 by this Excel 2016 Training
    Learn to Gain command over powerful features and functions in Excel 2016
    Master Microsoft Excel 2016
    View Curriculum
    • Passion to learn about basic excel 2016
    • Computer with Internet connection
    • Basic Computer Knowledge
    Curriculum For This Course
    Expand All 85 Lectures Collapse All 85 Lectures 09:05:18
    1 Lecture 02:00
    Getting Started
    3 Lectures 18:40
    Case Study
    1 Lecture 03:23
    Data Entry
    2 Lectures 11:56
    Data entry in excel

    Data entry in excel continued
    Populating the Case Study in Excel
    1 Lecture 08:34
    Populating the Case Study in Excel
    1 Lecture 07:48
    2 Lectures 16:52

    Formulas continued
    1 Lecture 10:19
    Formatting- Number Formats
    Formatting Table formats
    1 Lecture 09:43
    Formatting Table formats
    Updating a Calculation
    1 Lecture 04:04
    Updating a Calculation
    26 More Sections
    About the Instructor
    3.7 Average rating
    325 Reviews
    2,680 Students
    8 Courses
    Master, MCSA, MCSE ,MCP, MCDST, A+, Network+, Security+

    Naps Tecnologia Academy Inc - Formaciones en Linea, ahora pasa ser una academia de instructores Certificados en varias áreas de IT, Seguridad, Información, Proyectos y mucho mas! Disponemos de Cursos en categorías de Financias, Mobile Apps, Diseño y Multimedia, Redes, entre otros incluyendo cursos tanto en español como en ingles!

    Responsable: CEO Juan Carlos Rodríguez García
    Empresa: Naps Tecnologia Inc - Formaciones en Línea
    Web: (En remodelación)

    Certificaciones del CEO: MCT, MCSA, MCSE ,MCP, MCDST, A+, Network+, Security+, MVP 2010, MCITP y otras….

    Experiencia del CEO:
    Cuento con más de 15 años de experiencia en el campo de las computadoras y sistemas de información. Poseo un Bachillerato de la Universidad del Turabo y más de 30 certificaciones en el área de Servidores, Ethical Hacking, Windows Server y otras.

    Autor de los libros:

    • El Arte del Hacking
    • Conviértete en un Ethical Hacker
    • Aprende Redes y Servidores
    • Aprende Joomla!
    • Aprende Windows 8

    En el año 2010 fui elegido MVP “Microsoft Value Professional” en el área de Windows Experience. Este galardón se lo entrega Microsoft a diferentes profesionales en diferentes plataformas a nivel mundial. Me desempeño como Instructor y está certificado como: Microsoft Certified Trainer.

    Actualmente dirijo la corporación del Colegio de Informática y Tecnología de Puerto Rico, institución licenciada por el Consejo de Educación de Puerto Rico.

    Report Abuse