Analyzing & Manipulating Data Entries in Excel for the Web

Excel for the Web    |    Intermediate
  • 10 videos | 37m 11s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 27 users Rating 4.4 of 27 users (27)
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

  • 4m 13s
    Excel for the Web offers a variety of different tools for finding different types of data in your worksheet. You can use the Name Box and Go To tools to jump quickly to locations and specific elements, and the Find tool to perform basic search queries on your data. FREE ACCESS
  • 2m 50s
    The Replace tools are a great way of finding and replacing specific terms in your worksheet. See how to create a search query and customize your replacement parameters in Excel for the Web. FREE ACCESS
  • Locked
    3.  Sorting your data in Excel for the Web
    3m 51s
    The Excel for the Web sorting options can be used to organize and order the data in your table. You have the option of sorting columns into alphabetical order or from smallest to largest value. You will also learn how to customize the sort options. FREE ACCESS
  • Locked
    4.  Filtering your data in Excel for the Web
    4m 10s
    Excel for the Web allows you to filter your data in multiple ways. You can apply number and text filters or filter your data by item. In this way, you can gradually refine your content and concentrate on the data that you need. FREE ACCESS
  • Locked
    5.  Performing basic calculations in Excel for the Web
    3m 31s
    The cells in your Excel for the Web worksheet can be thought of as little calculator spaces. You can use these individual cells to perform simple and complex calculations. In this video you will also learn how to configure your calculation options. FREE ACCESS
  • Locked
    6.  Using the function library in Excel for the Web
    3m 10s
    Excel for the Web's function tool can help you locate and insert the formulas you need. Formulas are grouped by category. Once you've selected the formula that you'd like to use, Excel for the Web can guide you through the arguments that you need to calculate specific values. FREE ACCESS
  • Locked
    7.  Performing calculations using constant values in Excel for the Web
    5m 45s
    You will often use constant data values in Excel for the Web when calculating values such as sales tax, commission or other fixed rates. If one of your formulae uses a fixed value, it is helpful to calculate using the value's cell reference, rather than the value itself. This avoids mistakes and the need to make manual edits to each formula if your fixed value needs to be changed. This can save you a lot of time in the long run. FREE ACCESS
  • Locked
    8.  Using data across multiple worksheets in Excel for the Web
    3m 12s
    In Excel for the Web you can use data from one worksheet in another, without having to copy and paste those values. Reference your data selection and worksheet name in your formula to ensure that values from a different worksheet are included in your calculations. FREE ACCESS
  • Locked
    9.  Grouping your data in Excel for the Web
    2m 52s
    Grouping rows and columns in Excel for the Web is a great way of summarizing data and adding structure to your data tables. You can create multiple groups, across rows and columns, and collapse and hide them at will to control the amount of data you see at any one time. FREE ACCESS
  • Locked
    10.  Inserting a dropdown menu in Excel for the Web
    3m 38s
    Dropdown menus are very useful if you want to limit the data values that can be inserted into a cell. They are also very useful if you want to speed up your data entry. In Excel for the Web, you can create a dropdown menu via the Data Validation menu. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)
Course CompTIA Data+: Data Analysis Types & Techniques
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started in Excel 365
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Course Using Basic Formulas in Excel 2019 for Windows
Rating 4.5 of 1052 users Rating 4.5 of 1052 users (1052)
Course Finding and analyzing data with formulas in Excel 365
Rating 4.5 of 449 users Rating 4.5 of 449 users (449)