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.
23 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 85
  • Length 9 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course 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
  • What are the requirements?

    • Passion to learn about basic excel 2016
    • Computer with Internet connection
    • Basic Computer Knowledge

    What am I going to get from this course?

    • 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

    What is the target audience?

    • Students
    • Professionals
    • Business Persons

    What you get with this course?

    Not for you? No problem.
    30 day money back guarantee.

    Forever yours.
    Lifetime access.

    Learn on the go.
    Desktop, iOS and Android.

    Get rewarded.
    Certificate of completion.

    Curriculum

    Section 1: Overview
    Introduction
    Preview
    02:00
    Section 2: Getting Started
    Opening an Excel Worksheet
    Preview
    02:54
    Ribbons and Quick Access Toolbar
    11:00
    Ribbons and Quick Access Toolbar continued
    Preview
    04:46
    Section 3: Case Study
    Case Study
    Preview
    03:23
    Section 4: Data Entry
    Data entry in excel
    04:23
    Data entry in excel continued
    07:33
    Section 5: Populating the Case Study in Excel
    Populating the Case Study in Excel
    08:34
    Section 6: Calculations
    Calculations
    07:48
    Section 7: Formulas
    Formulas- SUM MAX MIN AVERAGE
    08:25
    Formulas continued
    08:27
    Section 8: Formatting
    Formatting- Number Formats
    10:19
    Section 9: Formatting Table formats
    Formatting Table formats
    09:43
    Section 10: Updating a Calculation
    Updating a Calculation
    04:04
    Section 11: Percentages and Absolute References
    Percentages and Absolute References
    06:33
    Section 12: Conditional Formatting
    Conditional Formatting
    09:23
    Section 13: IF Function
    IF Function
    10:32
    Section 14: COUNTIF and SUMIF Function
    COUNTIF and SUMIF Function
    08:41
    Section 15: Graphs & Charts
    Graphs & Charts
    09:12
    Graphs & Charts part 2
    08:33
    Graphs & Charts part 3
    05:16
    Section 16: Pie Chart
    Pie Chart
    05:55
    Section 17: Sorts
    Sort Function
    04:07
    Section 18: Filter Function
    Filter Function
    05:49
    Section 19: Pivot table
    Pivot table
    06:11
    Pivot table part 2
    07:14
    Section 20: Freeze & Split
    Freeze & Split
    04:48
    Section 21: Presentation
    Table Formats
    07:05
    Indents and Formatting Charts
    05:05
    Section 22: Print
    Printing the Worksheet and Print Layout
    12:16
    Section 23: Shortcuts
    Shortcuts in excel
    05:13
    Navigation
    06:00
    Workbook Basics
    07:10
    Selection
    03:25
    Working with Data
    04:10
    Formula
    02:33
    Section 24: Common errors
    Common errors
    03:20
    Section 25: Practice files
    Practice files
    Preview
    Article
    Section 26: Advanced Excel 2016
    Useful Excel Functions: Paste Special
    05:12
    Logical functions – IF AND OR
    09:36
    Arithmetic functions MAX MIN ABS etc
    11:17
    COUNT COUNTIF COUNTA COUNTBLANK
    05:08
    Cell Information ISERROR ISBLANK etc
    09:24
    Section 27: Data Functions
    CHOOSE Function
    04:39
    VLOOKUP Function
    11:29
    HLOOKUP Function
    03:37
    MATCH and INDEX
    04:58
    Database functions DSUM DAVERAGE DCOUNT
    08:10
    OFFSET- Example 1
    05:52
    OFFSET Function- Dynamic
    04:50
    Section 28: WhatIfAnalysis
    One Dimensional Data Tables
    07:51
    Two dimensional Data Tables
    06:38
    Solver
    08:24
    Goal Seek
    07:00
    Section 29: Arrays
    Array Function Example 1
    05:34
    Array Function Example 2
    05:53
    Array functions rows and columns
    05:36
    TRANSPOSE
    06:42
    Frequency
    04:13
    Section 30: Functions for working with Text
    PROPER UPPER LOWER LEFT RIGHT MID
    05:26
    FIND CLEAN REPT CONCATENATE
    08:00
    Section 31: Pivot Tables
    Pivot Table Slicer
    05:43
    Pivot Charts
    06:07
    Section 32: Names and Dynamic Range
    Naming a Cell and a Range
    06:11
    Naming Dynamic Ranges
    04:33
    Section 33: Auditing and Trouble Shooting formulas
    Naming a Cell and a Range
    06:11
    Naming Dynamic Ranges
    04:33

    Students Who Viewed This Course Also Viewed

    • Loading
    • Loading
    • Loading

    Instructor Biography

    Naps Tecnologia Academy Inc, 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.

    Ready to start learning?
    Take This Course