• 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 Intermediate Level 1

      Microsoft Excel 2016 Intermediate Level 1

      User Avatar
      Sarah
      IT & Software, Microsoft, Popular
      (0 review)
      Free
      Register for an account
      • Curriculum
      • Instructor
      • Reviews
      CoursesPopularMicrosoft Excel 2016 Intermediate Level 1
      • Getting started 10

        • Lecture1.1
          Selecting a data region
        • Lecture1.2
          Demystifying dates
        • Lecture1.3
          Creating a custom series
        • Lecture1.4
          Creating custom date formats
        • Lecture1.5
          Inserting comments – Part 1
        • Lecture1.6
          Inserting comments – Part 2
        • Lecture1.7
          Using Go To Special
        • Lecture1.8
          Transposing data
        • Lecture1.9
          Showing formulas
        • Lecture1.10
          Copying and pasting values of formulas
      • Naming Cells 15

        • Lecture2.1
          Introduction to naming cells and ranges
        • Lecture2.2
          Naming a cell or range using the Name Box
        • Lecture2.3
          Guidelines on naming a cell or range
        • Lecture2.4
          Naming a cell or range using the Define Name command
        • Lecture2.5
          Naming cells automatically using their labels
        • Lecture2.6
          Managing names using the Name Manager
        • Lecture2.7
          Using names for navigation
        • Lecture2.8
          Copying and pasting the names into a worksheet
        • Lecture2.9
          Using names in formulas – Part 1
        • Lecture2.10
          Using names in formulas – Part 2
        • Lecture2.11
          Creating named constants
        • Lecture2.12
          Names cells and ranges are absolute
        • Lecture2.13
          Absolute vs relative named cells and ranges
        • Lecture2.14
          Creating a relative named cell or range – Part 1
        • Lecture2.15
          Creating a relative named cell or range – Part 2
      • Linking Data 11

        • Lecture3.1
          Introduction to linking – Part 1
        • Lecture3.2
          Introduction to linking – Part 2
        • Lecture3.3
          Linking data within a sheet – Method 1 (Paste Link)
        • Lecture3.4
          Linking data within a sheet – Method 2 (Manual)
        • Lecture3.5
          Linking data between sheets – Method 1 (Paste Link)
        • Lecture3.6
          Linking data between sheets – Method 2 (Manual)
        • Lecture3.7
          Linking data between workbooks – Method 1 (Paste Link)
        • Lecture3.8
          Linking data between workbooks – Method 2 (Manual)
        • Lecture3.9
          Linking – Tip 1
        • Lecture3.10
          Linking – Tip 2
        • Lecture3.11
          Linking – Tip 3
      • Protecting Data 14

        • Lecture4.1
          Protecting data in “locked” cells
        • Lecture4.2
          Turning sheet protection on or off
        • Lecture4.3
          Unlocking cells – Part 1
        • Lecture4.4
          Unlocking cells – Part 2
        • Lecture4.5
          Protecting hidden columns and rows
        • Lecture4.6
          Hiding formulas
        • Lecture4.7
          Password protecting cells or ranges
        • Lecture4.8
          Turning workbook (worksheet structure) protection on or off
        • Lecture4.9
          Password protecting the file
        • Lecture4.10
          Applying “Read Only Recommended” to the workbook
        • Lecture4.11
          Applyng a “Password to Modify” to the workbook
        • Lecture4.12
          Applying all of the protection options
        • Lecture4.13
          Does protection really secure my Excel data?
        • Lecture4.14
          Data entry facilitation using sheet protection
      • Sorting a List (aka Recordset, Dataset) 11

        • Lecture5.1
          Introduction to Lists
        • Lecture5.2
          Guidelines on creating a list
        • Lecture5.3
          Sorting a list by a number field
        • Lecture5.4
          Sorting a list by a text field
        • Lecture5.5
          Sorting a list by a date field
        • Lecture5.6
          Sorting by a custom list – Part 1
        • Lecture5.7
          Sorting by a custom list – Part 2
        • Lecture5.8
          Sorting by a cell color
        • Lecture5.9
          Sorting by multiple cell colors
        • Lecture5.10
          Sorting by a font color
        • Lecture5.11
          Sorting by multiple font colors
      • AutoFiltering a List 29

        • Lecture6.1
          Introduction to filtering
        • Lecture6.2
          Introduction to AutoFilter
        • Lecture6.3
          Filtering by a field’s unique items
        • Lecture6.4
          Removing a filter from a field
        • Lecture6.5
          Filtering by multiple fields’ unique items
        • Lecture6.6
          Criteria syntax
        • Lecture6.7
          Comparison operators – Part 1
        • Lecture6.8
          Comparison operators – Part 2
        • Lecture6.9
          Single Criterion
        • Lecture6.10
          Multiple Criterion using the AND operator
        • Lecture6.11
          Multiple Criterion using the OR operator
        • Lecture6.12
          Multiple Criterion using a combination of the AND and OR operator
        • Lecture6.13
          Creating a custom AutoFilter for a text field
        • Lecture6.14
          Creating a custom AutoFilter for a number field
        • Lecture6.15
          Creating a custom AutoFilter for a date field
        • Lecture6.16
          Using the Between option for a number field
        • Lecture6.17
          Using the Between option for a date field
        • Lecture6.18
          Creating a custom AutoFilter from scratch
        • Lecture6.19
          Introduction to the asterisk (*) wildcard character
        • Lecture6.20
          Introduction to the question mark (?) wildcard character
        • Lecture6.21
          Introduction to the tilde (~) wildcard character
        • Lecture6.22
          Some important points about wildcard characters
        • Lecture6.23
          Creating a custom AutoFilter with an asterisk (*) wildcard character
        • Lecture6.24
          Creating a custom AutoFilter with multiple asterisk (*) wildcard characters
        • Lecture6.25
          Creating a custom AutoFilter with multiple question mark (?) wildcard characters
        • Lecture6.26
          Creating a custom AutoFilter with a tilde (~) wildcard character
        • Lecture6.27
          Creating a custom AutoFilter using all wildcard characters
        • Lecture6.28
          AutoFilter limitations – Part 1
        • Lecture6.29
          AutoFilter limitations – Part 2
      • Using Advanced Filter on a List 12

        • Lecture7.1
          Review of the comparison and logical operators
        • Lecture7.2
          Setting up the criteria range
        • Lecture7.3
          Using one criterion – Part 1
        • Lecture7.4
          Using one criterion – Part 2
        • Lecture7.5
          Using two criteria joined by the AND operator
        • Lecture7.6
          Using two criteria joined by the OR operator
        • Lecture7.7
          Using multiple sets of criteria
        • Lecture7.8
          Using multiple criterion joined by AND under the same field
        • Lecture7.9
          Using criteria with wild characters
        • Lecture7.10
          Copying filtered results to another location
        • Lecture7.11
          Finding unique records only
        • Lecture7.12
          Entering the “equals to” operator
      • Using Flash Fill in a List 1

        • Lecture8.1
          Using Flash Fill
      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%
      • Curriculum
      • Instructor
      • Reviews
      Free
      Register for an account
      • Share:

      You May Like

      Building Your Social Media Presence – Instagram Read More
      Georgia

      Building Your Social Media Presence - Instagram

      35
      0
      Free
      Build a Great Presentation in Microsoft PowerPoint Read More
      Dave

      Build a Great Presentation in Microsoft PowerPoint

      125
      0
      Free
      Conditional Analysis for Power Excel Users Read More
      Dave

      Conditional Analysis for Power Excel Users

      123
      0
      Free
      What-If Analysis for Power Excel Users Read More
      Dave

      What-If Analysis for Power Excel Users

      180
      0
      Free
      Lists and Pivot Tables for Power Excel Users Read More
      Dave

      Lists and Pivot Tables for Power Excel Users

      211
      1
      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?