• Home
  • Course Library
  • Contact
      • Cart

        0
    Have any questions?
    learn@ontracktv.com
    Login
    ontrackTVontrackTV
    • Home
    • Course Library
    • Contact
        • Cart

          0

      IT & Software

      • Home
      • All courses
      • IT & Software
      • Microsoft Excel 2016 Advanced Level 1

      Microsoft Excel 2016 Advanced Level 1

      User Avatar
      Sarah
      IT & Software, Microsoft
      (0 review)
      Free
      Register for an account
      • Overview
      • Curriculum
      • Instructor
      • Reviews

      So you think you know Excel? Challenge yourself by taking this advanced course with our master trainer and Excel guru, Lana. You’ll learn all about tables and structured references, formula auditing, and how to perform conditional/logical analyses using nested IF statements, and the famous IFS function, VLOOKUP function, and INDEX MATCH nested function. These are all important topics to learn if you want to become truly amazing at Excel!

      Course Features

      • Lectures 73
      • Quizzes 0
      • Duration 73 video lessons
      • Skill level All levels
      • Language English
      • Students 5360
      • Assessments Yes
      CoursesMicrosoftMicrosoft Excel 2016 Advanced Level 1
      • Tables and Structured References 25

        • Lecture1.1
          Introduction to table objects
        • Lecture1.2
          Converting a range into a table
        • Lecture1.3
          Inserting or deleting rows and columns
        • Lecture1.4
          Changing table styles
        • Lecture1.5
          Using the total row
        • Lecture1.6
          What is a structured reference?
        • Lecture1.7
          Elements in a structured reference
        • Lecture1.8
          Renaming a table
        • Lecture1.9
          Escaping special characters in a column identifier
        • Lecture1.10
          Special identifiers
        • Lecture1.11
          Syntax for referencing a table, column, or part
        • Lecture1.12
          Syntax for referencing a part of a column
        • Lecture1.13
          Syntax for referencing a single cell
        • Lecture1.14
          Syntax for referencing a column range
        • Lecture1.15
          Syntax for referencing a part of a column range
        • Lecture1.16
          Qualifying structured references – Part 1
        • Lecture1.17
          Qualifying structured references – Part 2
        • Lecture1.18
          Creating a calculated column
        • Lecture1.19
          Creating structured references using point-and-click
        • Lecture1.20
          Formula AutoComplete
        • Lecture1.21
          Structured references outside of the table
        • Lecture1.22
          Limitation with structured references
        • Lecture1.23
          Copying vs filling structured references
        • Lecture1.24
          Rearranging columns easily
        • Lecture1.25
          Converting a table to a normal range
      • Nested IF Functions (aka Nested IF Statements) 6

        • Lecture2.1
          Nested IF Functions – Part 1
        • Lecture2.2
          Nested IF Functions – Part 2
        • Lecture2.3
          Nested IF Functions – Part 3
        • Lecture2.4
          Nested IF Functions – Part 4
        • Lecture2.5
          Nested IF Functions – Part 5
        • Lecture2.6
          Tip: Inserting line breaks
      • IFS Function 6

        • Lecture3.1
          IFS Function – Part 1
        • Lecture3.2
          IFS Function – Part 2
        • Lecture3.3
          IFS Function – Part 3
        • Lecture3.4
          IFS Function – Part 4
        • Lecture3.5
          IFS Function – Part 5
        • Lecture3.6
          IFS Function – Part 6
      • VLOOKUP and IFERROR Function 19

        • Lecture4.1
          VLOOKUP Function – Part 1
        • Lecture4.2
          VLOOKUP Function – Part 2
        • Lecture4.3
          VLOOKUP Function – Part 3
        • Lecture4.4
          VLOOKUP Function – Part 4
        • Lecture4.5
          Boolean data type – Part 1
        • Lecture4.6
          Boolean data type – Part 2
        • Lecture4.7
          VLOOKUP Function – Part 5
        • Lecture4.8
          VLOOKUP Function – Part 6
        • Lecture4.9
          VLOOKUP Function – Part 7
        • Lecture4.10
          VLOOKUP Function – Part 8
        • Lecture4.11
          VLOOKUP Function – Part 9
        • Lecture4.12
          HLOOKUP Function
        • Lecture4.13
          VLOOKUP Function – Part 10
        • Lecture4.14
          VLOOKUP Function – Part 11
        • Lecture4.15
          IFERROR Function – Part 1
        • Lecture4.16
          IFERROR Function Part 2
        • Lecture4.17
          VLOOKUP Function – Part 12
        • Lecture4.18
          VLOOKUP Function – Part 13
        • Lecture4.19
          VLOOKUP Function – Part 14
      • INDEX MATCH Nested Function 7

        • Lecture5.1
          Index Match Nested Function – Part 1
        • Lecture5.2
          Index Match Nested Function – Part 2
        • Lecture5.3
          Index Match Nested Function – Part 3
        • Lecture5.4
          Index Match Nested Function – Part 4
        • Lecture5.5
          Index Match Nested Function – Part 5
        • Lecture5.6
          Index Match Nested Function – Part 6
        • Lecture5.7
          Index Match Nested Function – Part 7
      • Formula Auditing 10

        • Lecture6.1
          Introduction to formula auditing
        • Lecture6.2
          Tracing precedents
        • Lecture6.3
          More on tracing precedents
        • Lecture6.4
          Tracing dependents
        • Lecture6.5
          More on tracing dependents
        • Lecture6.6
          Evaluating formulas with F9
        • Lecture6.7
          More on evaluating formulas with F9
        • Lecture6.8
          Evaluating formulas with Evaluate Formula
        • Lecture6.9
          Error checking rules
        • Lecture6.10
          Error Smart Tag options
      author avatar
      Sarah
      Sarah has been teaching for over two decades in all areas spanning IT with a particular focus on data management and business intelligence. She is one of the most demanded instructors in the nation, and is reputed for her ability to share her deep knowledge in a clear, thorough, and engaging format. We promise you'll love her videos which students have evaluated as some of the best ones online!

      Reviews

      Average Rating

      0
      0 rating

      Detailed Rating

      5 Star
      0%
      4 Star
      0%
      3 Star
      0%
      2 Star
      0%
      1 Star
      0%
      • Share:

      You May Like

      Microsoft Excel Macros & VBA Beginner Level 1 Read More
      Sarah

      Microsoft Excel Macros & VBA Beginner Level 1

      4328
      0
      Free

      All Courses

      • Adobe
      • IT & Software
      • Microsoft
      • Popular
      • Social Media

      Latest Courses

      Microsoft Excel 2016 Intermediate Level 1

      Microsoft Excel 2016 Intermediate Level 1

      Free
      Microsoft Excel Macros & VBA Beginner Level 3

      Microsoft Excel Macros & VBA Beginner Level 3

      Free
      Microsoft Excel Macros & VBA Beginner Level 2

      Microsoft Excel Macros & VBA Beginner Level 2

      Free

      Copyright 2020 ontrackTV - A division of Quizam Media Corporation

      • Sign in

      Forgot your password?

      Lost your password? Please enter your email address. You will receive mail with link to set new password.

      Back to login

      Login with your site account

      Lost your password?