Analyzing & Manipulating Data Entries

Excel for the Web
  • 10 Videos | 42m 11s
  • Includes Assessment
  • Earns a Badge
Likes 6 Likes 6
Excel for the Web includes a wide variety of options for locating, displaying, and analyzing data entries. To start working with the data in a worksheet, use the sorting and filtering options for choosing what is the data displayed. You can also use the grouping tools to create groups and subgroups within a worksheet. In this course learn how to use the Find and Replace tools to quickly locate and change data values in a data range or worksheet. Another option to easily insert values in a cell is using dropdown menus. The power of Excel for the Web is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM, CHOOSE, and INDEX to quickly get totals or reference data and values. Also discover how to insert cell references to use data across multiple worksheets.

WHAT YOU WILL LEARN

  • find items or jump to a specific location in a worksheet
    replace cell contents in a worksheet
    sort data in a worksheet
    use filter buttons to filter data in a worksheet
    perform basic calculations and configure calculation options
  • access and discover the Function library
    use cell references to perform calculations
    use data across multiple worksheets to reference data for formulas
    group and ungroup data in a worksheet
    use data validation to insert drop-down menus

IN THIS COURSE

  • Playable
    1. 
    Finding items in a worksheet
    4m 13s
    UP NEXT
  • Playable
    2. 
    Replacing data
    2m 50s
  • Locked
    3. 
    Sorting your data
    3m 51s
  • Locked
    4. 
    Filtering your data
    4m 10s
  • Locked
    5. 
    Performig basic calculations
    3m 31s
  • Locked
    6. 
    Using the function library
    3m 10s
  • Locked
    7. 
    Performing calculations using constant values
    5m 45s
  • Locked
    8. 
    Using data across multiple worksheets
    3m 12s
  • Locked
    9. 
    Grouping your data
    2m 52s
  • Locked
    10. 
    Inserting a dropdown menu
    3m 38s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Managing Data
Likes 25 Likes 25  
Likes 3 Likes 3