• 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
      • Lists and Pivot Tables for Power Excel Users

      Lists and Pivot Tables for Power Excel Users

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

      Generally applicable to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 365

      Join this recorded live class as Master Trainer, Dave, covers the must-knows around lists and pivot tables.

      Course Features

      • Lectures 16
      • Quizzes 0
      • Duration 15 video lessons (Total time: 63 minutes)
      • Language English
      • Students 307
      • Assessments Yes
      CoursesPopularLists and Pivot Tables for Power Excel Users
      • Must-Knows for List (Recordset) Management 5

        • Lecture1.1
          Downloadable Lesson File(s)
        • Lecture1.2
          Automatic Outlining
        • Lecture1.3
          Manually Outlining
        • Lecture1.4
          Sorting
        • Lecture1.5
          Subtotaling
      • Must-Knows for Pivot Tables 9

        • Lecture2.1
          Turning a List Range into a Table Object
        • Lecture2.2
          Looking at the Pivot Table Tabs and Field List
        • Lecture2.3
          Building out the Pivot Table
        • Lecture2.4
          Changing the Value Fields
        • Lecture2.5
          Filtering a Pivot Table
        • Lecture2.6
          Changing the layout and style options
        • Lecture2.7
          Refreshing a Pivot Table
        • Lecture2.8
          Drilling Down
        • Lecture2.9
          Changing How Values Are Calculated and Displayed
      • Bonus Lessons 2

        • Lecture3.1
          Using the Concatenate Function
        • Lecture3.2
          Using Flash Fill
      author avatar
      Dave

      Reviews

      Average Rating

      5
      1 rating

      Detailed Rating

      5 Star
      100%
      4 Star
      0%
      3 Star
      0%
      2 Star
      0%
      1 Star
      0%
      • Sue Kanciar

        Great energy to keep you interested while covering all the bases.

        I appreciated the repetition and speed at which we covered the material, and I was glad I could follow along and play around with the same spreadsheet. The extra tips and tricks were also a bonus.

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

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

      Build a Great Presentation in Microsoft PowerPoint

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

      Conditional Analysis for Power Excel Users

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

      What-If Analysis for Power Excel Users

      276
      0
      Free
      Working with Dates in Microsoft Access Queries Read More
      Sarah

      Working with Dates in Microsoft Access Queries

      341
      0
      Free

      Leave A Reply Cancel reply

      Your email address will not be published. Required fields are marked *

      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?