Welcome to Design world with 3dpirate.net. I'm sure you're visiting a wonderful website
3DPirate.net
- NEW DESIGN : BOOKDL.ME The best ebook & magazine site ever!!!

 

Microsoft® Excel® 2013: Working with Data Ranges and Tables


Microsoft® Excel® 2013: Working with Data Ranges and Tables by Napier-Rivers LLC
English | Apr 23, 2015 | ASIN: B00WMUXRRO | 204 Pages | AZW3/EPUB/PDF (conv) | 13.4 MB

Microsoft® Excel® 2013: Working with Data Ranges and Tables is a two-lesson intermediate level course that guides you through organizing, entering and validating worksheet data and then effectively sorting, filtering, subtotaling, and outlining the data. You also learn how to define well-organized data as an Excel table; then use Table features to work with the data.

In Lesson 1 you learn how to organize columns and rows of data into a range so that you can effectively sort, filter, subtotal, and outline the data. Then you learn how to protect the data from invalid data entry by setting data validation rules for specific cells. You learn how to copy these validation rules to other cells, how to remove validation rules from cells and how to use the Data Form dialog box to enter and locate data in a range.

Next you learn how to sort a data range on one column or on multiple columns and how to use a custom sort order, the Filter (AutoFilter) feature and the Advanced Filter feature to view data that meets specific criteria. Then you learn how to add and remove subtotals from a data range while viewing the data range in outline form. You also learn how to create a chart using an outline’s subtotals.

Finally, in Lesson 2 you explore the advantages of defining a range of data as an Excel 2013 table.

Prerequisites
The Napier & Rivers courses Microsoft® Excel® 2013: Getting Started with Excel and Microsoft® Excel® 2013: Creating and Formatting Charts or the equivalent experience working with Excel 2013 in the Windows operating system environment are prerequisites for this course.

Data Files
If you have not yet downloaded the data files, visit http://ebooksforoffice.com/datafiles, locate Microsoft® Excel® 2013: Working with Data Ranges and Tables book title, and then click the ‘Download data files’ link.

Learning Objectives

After completing this course you will be able to:
• identify the guidelines for a well-organized data range; select ways to create and test validation rules; select the Data Form for data entry,
• recognize ways to sort and filter a data range,
• identify the main differences between a data range and a table,
• select ways to add subtotals, a Grand Total and data grouping to a data range,
• identify multiple ways to define an Excel table using buttons on the HOME and INSERT tabs, the Quick Analysis feature, a keyboard shortcut and by formatting a data range as a table, and
• recognize ways to enter data and formulas in a table; change table formatting; resize a table; scroll, sort, filter and summarize a table; and convert a table to a data range

Lesson Summary

Lesson 1
In this lesson, you learn to:
• identify the guidelines for a well-organized data range,
• enter and test validation rules,
• copy validation rules,
• enter and locate data using the Data Form,
• search for data using the Data Form,
• remove validation rules,
• sort a data range on a single field,
• sort a data range on multiple fields
• apply a custom sort order to a data range,
• sort a data range by font or fill color
• use Filter (AutoFilter) to filter a data range,
• filter by one or more fields using the Filter feature,
• filter for the Top Items using the Filter feature,
• sort, copy and paste filtered data,
• create a custom filter,
• use Advanced Filter to filter a data range,
• add subtotals and an outline to a data range,
• expand and collapse the outline,
• create a chart from subtotals,
• insert nested subtotals, and
• outline data containing subtotals.

Lesson 2

In this lesson, you learn to:
• define and name an empty table,
• define a table using existing data,
• define a table using the Quick Analysis feature,
• format data as a defined table,
• enter data and expand the table vertically,
• enter and copy formulas in a table,
• use the Data Form with a table,
• resize a table using the mouse pointer, the Resize Table button and dynamically,
• select

Download

https://nitroflare.com/view/C452A3F378893C0/B00WMUXRRO.rar

or
http://rapidgator.net/file/68a3c4680fc6a6e08c499aeb43274c5a/B00WMUXRRO.rar.html

Download for Fullspeed

Got something to say? Go for it!

You must be logged in to post a comment.

 
eXTReMe Tracker