• 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 2

      Microsoft Excel 2016 Intermediate Level 2

      User Avatar
      Sarah
      IT & Software, Microsoft, Popular
      (0 review)
      Free
      Register for an account
      • Curriculum
      • Instructor
      • Reviews
      CoursesPopularMicrosoft Excel 2016 Intermediate Level 2
      • Outlining 8

        • Lecture1.1
          What is outlining?
        • Lecture1.2
          Identifying groups of data
        • Lecture1.3
          Identifying summary vs detail rows and columns
        • Lecture1.4
          Using Auto Outline – Part 1
        • Lecture1.5
          Using Auto Outline – Part 2
        • Lecture1.6
          Manually outlining – Part 1
        • Lecture1.7
          Manually outlining – Part 2
        • Lecture1.8
          Manually outlining – Part 3
      • Subtotaling 8

        • Lecture2.1
          Introduction to subtotaling
        • Lecture2.2
          Activating subtotals
        • Lecture2.3
          Removing subtotals
        • Lecture2.4
          Creating multiple subtotal rows
        • Lecture2.5
          Creating subtotal rows for groups within a group
        • Lecture2.6
          Inserting subtotals above each group
        • Lecture2.7
          Copying and pasting only subtotal rows
        • Lecture2.8
          Formatting only subtotal rows
      • Charts 21

        • Lecture3.1
          Introduction to charts
        • Lecture3.2
          Chart terminology – Part 1
        • Lecture3.3
          Chart terminology – Part 2
        • Lecture3.4
          Setting up your data for a chart
        • Lecture3.5
          Creating a chart
        • Lecture3.6
          Moving a chart
        • Lecture3.7
          Switching the data series and categories
        • Lecture3.8
          Changing the chart type
        • Lecture3.9
          Applying a quick layout
        • Lecture3.10
          Modifying chart elements
        • Lecture3.11
          Applying a chart style and changing colors
        • Lecture3.12
          Using themes – Part 1
        • Lecture3.13
          Using themes – Part 2
        • Lecture3.14
          Using themes – Part 3
        • Lecture3.15
          Using themes – Part 4
        • Lecture3.16
          Using themes – Part 5
        • Lecture3.17
          Changing the source data
        • Lecture3.18
          Showing or hiding the data series and categories
        • Lecture3.19
          Useful shortcut buttons
        • Lecture3.20
          The Format pane for elements
        • Lecture3.21
          Popular changes to chart elements
      • Sparklines 12

        • Lecture4.1
          Introduction to sparklines
        • Lecture4.2
          Creating sparklines
        • Lecture4.3
          Switching row/column chart type
        • Lecture4.4
          Showing value points
        • Lecture4.5
          Changing styles and colors
        • Lecture4.6
          Showing the horizontal axis
        • Lecture4.7
          Plotting data in the opposite direction
        • Lecture4.8
          Using the date axis
        • Lecture4.9
          Changing the minimum value on the vertical axis
        • Lecture4.10
          Changing the maximum value on the vertical axis
        • Lecture4.11
          Handling empty cells
        • Lecture4.12
          Grouping and ungrouping sparklines
      • Formulas and Functions 12

        • Lecture5.1
          A thorough refresher
        • Lecture5.2
          Refresher on function syntax
        • Lecture5.3
          Relative vs absolute cell referencing
        • Lecture5.4
          Using Auto Fill to fill down
        • Lecture5.5
          Using Auto Fill to fill across
        • Lecture5.6
          AVERAGE function
        • Lecture5.7
          COUNT Function
        • Lecture5.8
          MAX function
        • Lecture5.9
          MIN function
        • Lecture5.10
          Using Auto for the AVERAGE, COUNT, MAX, and MIN functions
        • Lecture5.11
          COUNTA function
        • Lecture5.12
          Viewing the totals in the status bar
      • IF, AND, OR Functions 13

        • Lecture6.1
          Introduction to the IF function
        • Lecture6.2
          Syntax of the IF function
        • Lecture6.3
          Logical comparison argument
        • Lecture6.4
          Technically speaking on the logical comparison argument
        • Lecture6.5
          The valueiftrue and valueiffalse arguments
        • Lecture6.6
          Using the IF function – Example 1
        • Lecture6.7
          Using the IF function – Example 2
        • Lecture6.8
          Using the IF function – Example 3
        • Lecture6.9
          Using the IF function – Example 4
        • Lecture6.10
          Smarter data setup – Part 1
        • Lecture6.11
          Smarter data setup – Part 2
        • Lecture6.12
          AND function
        • Lecture6.13
          OR function
      • Nested Functions (aka Nested Statements) 6

        • Lecture7.1
          Introduction to nested functions
        • Lecture7.2
          Nesting an OR function within an IF function – Part 1
        • Lecture7.3
          Nesting an OR function within an IF function – Part 2
        • Lecture7.4
          Nesting an OR function within an IF function – Part 3
        • Lecture7.5
          Nesting an OR function within an IF function – Part 4
        • Lecture7.6
          Nesting an OR function within an IF function – Part 5
      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?