Microsoft Office Excel 2016 Basic and 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.
26 students enrolled
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.
26 students enrolled
Last updated 12/2015
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
Requirements
  • Passion to learn about basic excel 2016
  • Computer with Internet connection
  • Basic Computer Knowledge
Description

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
    Curriculum For This Course
    Expand All 85 Lectures Collapse All 85 Lectures 09:05:18
    +
    Overview
    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
    04:23

    Data entry in excel continued
    07:33
    +
    Populating the Case Study in Excel
    1 Lecture 08:34
    Populating the Case Study in Excel
    08:34
    +
    Calculations
    1 Lecture 07:48
    Calculations
    07:48
    +
    Formulas
    2 Lectures 16:52
    Formulas- SUM MAX MIN AVERAGE
    08:25

    Formulas continued
    08:27
    +
    Formatting
    1 Lecture 10:19
    Formatting- Number Formats
    10:19
    +
    Formatting Table formats
    1 Lecture 09:43
    Formatting Table formats
    09:43
    +
    Updating a Calculation
    1 Lecture 04:04
    Updating a Calculation
    04:04
    26 More Sections
    About the Instructor
    Naps Tecnologia Academy Inc
    3.9 Average rating
    356 Reviews
    2,841 Students
    10 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
    • TOP SECRET

    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.