Analyzing & Manipulating Data Entries in Excel for the Web
Excel for the Web
| Intermediate
- 10 videos | 37m 11s
- Includes Assessment
- Earns a Badge
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 13sExcel 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 50sThe 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
-
3. Sorting your data in Excel for the Web3m 51sThe 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
-
4. Filtering your data in Excel for the Web4m 10sExcel 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
-
5. Performing basic calculations in Excel for the Web3m 31sThe 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
-
6. Using the function library in Excel for the Web3m 10sExcel 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
-
7. Performing calculations using constant values in Excel for the Web5m 45sYou 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
-
8. Using data across multiple worksheets in Excel for the Web3m 12sIn 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
-
9. Grouping your data in Excel for the Web2m 52sGrouping 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
-
10. Inserting a dropdown menu in Excel for the Web3m 38sDropdown 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.
