Picture 1 of 9
Picture 1 of 9
Inside Out Microsoft Excel 2019 Ultimate in-depth Reference by Bill Jelen
US $6.99
or Best Offer
Condition:
“Please see pics for details.”
Last One1 sold
Shipping:
Located in: Oklahoma City, Oklahoma, United States
Delivery:
Estimated between Tue, Jun 25 and Fri, Jun 28 to 43230
Returns:
Payments:
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:266718067647
Item specifics
- Condition
- Good
- Seller Notes
- “Please see pics for details.”
- ISBN
- 9781509307692
- Subject Area
- Computers
- Publication Name
- Microsoft Excel 2019 inside Out
- Publisher
- Pearson Education
- Item Length
- 9.1 in
- Subject
- Desktop Applications / Suites, Desktop Applications / General, Desktop Applications / Spreadsheets
- Publication Year
- 2018
- Series
- Inside Out Ser.
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 2 in
- Item Weight
- 48.6 Oz
- Item Width
- 7.4 in
- Number of Pages
- 864 Pages
About this product
Product Identifiers
Publisher
Pearson Education
ISBN-10
1509307699
ISBN-13
9781509307692
eBay Product ID (ePID)
14038657510
Product Key Features
Number of Pages
864 Pages
Publication Name
Microsoft Excel 2019 inside Out
Language
English
Publication Year
2018
Subject
Desktop Applications / Suites, Desktop Applications / General, Desktop Applications / Spreadsheets
Type
Textbook
Subject Area
Computers
Series
Inside Out Ser.
Format
Trade Paperback
Dimensions
Item Height
2 in
Item Weight
48.6 Oz
Item Length
9.1 in
Item Width
7.4 in
Additional Product Features
Intended Audience
Scholarly & Professional
LCCN
2018-959530
Dewey Edition
23
Illustrated
Yes
Dewey Decimal
005.54
Table Of Content
Part I THE EXCEL INTERFACE 1 What's New in Excel 2019 and Office 365 2 Using the Excel Interface 3 Customizing Excel 4 Keyboard Shortcuts Part II CALCULATING WITH EXCEL 5 Understanding Formulas 6 Controlling Formulas 7 Understanding Functions 8 Using Everyday Functions: Math, Date and Time, and Text Functions 9 Using Powerful Functions: Logical, Lookup, Web, and Database Functions 10 Other Functions 11 Connecting Worksheets and Workbooks 12 Array Formulas and Names in Excel Part III DATA ANALYSIS WITH EXCEL 13 Transforming Data with Power Query 14 Summarizing Data Using Subtotals or Filter 15 Using Pivot Tables to Analyze Data 16 Using Slicers and Filtering a Pivot Table 17 Mashing Up Data with Power Pivot 18 Using What-If, Scenario Manager, Goal Seek, and Solver 19 Automating Repetitive Functions Using VBA Macros 20 More Tips and Tricks for Excel 2016 Part IV EXCEL VISUALS 21 Formatting Worksheets 22 Using Data Visualizations and Conditional Formatting 23 Graphing Data Using Excel Charts 24 Using 3D Maps 25 Using Sparklines 26 Formatting Spreadsheets for Presentation 27 Printing 28 Excel Online APPENDIXES A DAX Functions B Power Query M Functions
Synopsis
Conquer Microsoft Excel 2019-from the inside out Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. Enter formulas more efficiently, and fully control operators and dates Master the most widely-used functions in Excel Integrate external data from the web and other sources Easily transform complex datasets with Power Query Quickly summarize millions of records with Pivot Tables Perform ad hoc analyses with slicers and other filters Create advanced data mashups with Power Pivot Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver Automate repetitive tasks by editing recorded VBA code Demystify data with conditional formatting and other visualization techniques Use the newest maps, charts, and data types in Excel Show geographical changes over time with animated 3D maps Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE Find insights using Excel's new artificial intelligence Collaborate via Excel 2019's breakthrough CoAuthoring tools Publish Power BI Desktop dashboards based on Excel data, You're beyond the basics--so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Learn how the experts tackle Excel--and challenge yourself to new levels of mastery. Includes companion eBook and sample files. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel, This well-organized reference packs hundreds of timesaving solutions, tips, and workarounds-all students need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery., You're beyond the basics--so dive in and really put your spreadsheet skills to work This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Learn how the experts tackle Excel--and challenge yourself to new levels of mastery. Includes companion eBook and sample files. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel
LC Classification Number
HF5548.4.M523
ebay_catalog_id
4
Copyright Date
2019
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:266718067647
Shipping and handling
| Save on shipping. This seller offers shipping discounts on combined purchases for eligible items. |
Item location:
Oklahoma City, Oklahoma, United States
Ships to:
Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan Republic, Bahamas, Bahrain, Bangladesh, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Brazil, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde Islands, Cayman Islands, Central African Republic, Chad, Chile, China, Colombia, Comoros, Cook Islands, Costa Rica, Cyprus, Czech Republic, Côte d'Ivoire (Ivory Coast), Democratic Republic of the Congo, Denmark, Djibouti, Dominica, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Falkland Islands (Islas Malvinas), Fiji, Finland, France, Gabon Republic, Gambia, Georgia, Ghana, Gibraltar, Greece, Greenland, Grenada, Guam, Guatemala, Guernsey, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jersey, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Mauritania, Mauritius, Mayotte, Mexico, Micronesia, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Nepal, Netherlands, Netherlands Antilles, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Puerto Rico, Qatar, Republic of Croatia, Republic of the Congo, Romania, Rwanda, Saint Helena, Saint Kitts-Nevis, Saint Lucia, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, San Marino, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, South Korea, Spain, Sri Lanka, Suriname, Svalbard and Jan Mayen, Swaziland, Sweden, Switzerland, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, Uganda, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City State, Vietnam, Virgin Islands (U.S.), Wallis and Futuna, Western Sahara, Western Samoa, Worldwide, Yemen, Zambia, Zimbabwe
Excludes:
Barbados, French Guiana, French Polynesia, Germany, Guadeloupe, Libya, Martinique, New Caledonia, Reunion, Russian Federation, Ukraine, Venezuela
| Shipping and handling | To | Service | Delivery*See Delivery notes |
|---|---|---|---|
| US $6.85 | United States | Economy Shipping (USPS Media MailTM) | Estimated between Tue, Jun 25 and Fri, Jun 28 to 43230 |
| US $56.35 | United States | Expedited Shipping (USPS Priority Mail Express®) | Estimated between Tue, Jun 25 and Wed, Jun 26 to 43230 |
| Handling time |
|---|
| Will usually ship within 1 business day of receiving cleared payment. |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Sales Tax for an item #266718067647
Sales Tax for an item #266718067647
Seller collects sales tax for items shipped to the following states:
| State | Sales Tax Rate |
|---|
Return policy
| After receiving the item, contact seller within | Refund will be given as | Return shipping |
|---|---|---|
| 60 days | Money Back | Seller pays for return shipping |
Refer to eBay Return policyopens in a new tab or window for more details. You are covered by the eBay Money Back Guaranteeopens in a new tab or window if you receive an item that is not as described in the listing.
Payment details
Payment methods
Seller feedback (579)
s***4 (8)- Feedback left by buyer.
Past 6 months
Verified purchase
Quick shipping, packaged very well, as described, Great condition. Would buy again!! Fantastic seller!
r***g (65)- Feedback left by buyer.
Past month
Verified purchase
Item as described and arrived promptly. Excellent seller!
4***t (3534)- Feedback left by buyer.
Past 6 months
Verified purchase
as described securely wrapped & packaged. prompt shipping AAA+++
Product ratings and reviews
More to explore :
- Reference Reference Antiquarian & Collectible Books,
- Reference Antiquarian & Collectible Books,
- Reference Antiquarian & Collectible Books,
- Textbooks, Educational & Reference Books,
- Star Wars Insider Magazines,
- Dictionaries & Reference Books,
- Reference Nonfiction Books & Fiction,
- HarperCollins Dictionaries & Reference Books,
- Law Dictionaries & Reference Books,
- Hardcover Dictionaries & Reference Books