Picture 1 of 1
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) Jelen, Bill
Condition:
Postage:
Located in: Tennessee, United States
Delivery:
Estimated between Fri, 28 Jun and Mon, 1 Jul to 43230
Returns:
Coverage:
Read item description or contact seller for details. See all detailsSee all details on coverage
(Not eligible for eBay purchase protection programmes)
Shop with confidence
Seller information
- 99.6% positive feedback
Registered as a Business Seller
Seller assumes all responsibility for this listing.
eBay item number:276367566565
Item specifics
- Condition
- Brand New: A new, unread, unused book in perfect condition with no missing or damaged pages. See all condition definitionsopens in a new window or tab
- Book Title
- Microsoft Press
- ISBN
- 9780137521524
- Subject Area
- Computers, Business & Economics
- Publication Name
- Microsoft Excel Vba and Macros (Office 2021 and Microsoft 365)
- Publisher
- Pearson Education
- Item Length
- 9.1 in
- Subject
- Desktop Applications / General, Commerce, Desktop Applications / Spreadsheets
- Publication Year
- 2022
- Series
- Business Skills Ser.
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 1.4 in
- Item Weight
- 36 Oz
- Item Width
- 7.3 in
- Number of Pages
- 640 Pages
About this product
Product Identifiers
Publisher
Pearson Education
ISBN-10
0137521529
ISBN-13
9780137521524
eBay Product ID (ePID)
5050431715
Product Key Features
Number of Pages
640 Pages
Publication Name
Microsoft Excel Vba and Macros (Office 2021 and Microsoft 365)
Language
English
Publication Year
2022
Subject
Desktop Applications / General, Commerce, Desktop Applications / Spreadsheets
Type
Textbook
Subject Area
Computers, Business & Economics
Series
Business Skills Ser.
Format
Trade Paperback
Dimensions
Item Height
1.4 in
Item Weight
36 Oz
Item Length
9.1 in
Item Width
7.3 in
Additional Product Features
Intended Audience
Scholarly & Professional
LCCN
2022-930486
Dewey Edition
23
Illustrated
Yes
Dewey Decimal
005.54
Table Of Content
Introduction 1. Unleash the Power of Excel with VBA 2. This Sounds Like BASIC, So Why Doesn't It Look Familiar? 3. Referring to Ranges 4. Looping and Flow Control 5. R1C1-style Formulas 6. Creating and manipulating Names in VBA 7. Event Programming 8. Arrays 9. Creating Classes and Collections 10. Userforms: An Introduction 11. Data Mining with Advanced Filter 12. Using VBA to Create Pivot Tables 13. Excel Power 14. Sample User-Defined Functions 15. Creating Charts 16. Data Visualizations and Conditional Formatting 17. Dashboarding with Sparklines in Excel 18. Reading from the Web using M and VBA 19. Text File Processing 20. Automating Word 21. Using Access as a Back End to Enhance Multiuser Access to Data 22. Advanced Userform Techniques 23. Windows Application Programming Interface (API) 24. Handling Errors 25. Customizing the Ribbon to Run Macros 26. Creating Excel Add-Ins 27. An Introduction to Creating Office Add-ins 28. What's New in Excel 365 and What's Changed
Synopsis
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel and Excel in Office 365. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data, This book shows students how to make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help students instantly visualize information, so they can act on it... capture data from anywhere, and use it anywhere... automate Excel's best new features. Students will find simple, step-by-step instructions, real-world case studies, and workbooks packed with bonus examples, macros, and solutions--straight from MrExcel!, Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won''t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You''ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate PivotTables to summarize, analyze, explore, and present data Leverage more of Excel VBA''s power with classes, collections, and Advanced Filter Make the most of User-Defined Functions (UDFs), including new LAMBDA functions Build sophisticated UserForm custom dialogs to collect data from other Excel users Integrate data from the Internet, Access and SQL Server databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Extend Excel''s power by controlling other Office programs and Windows itself Create Office Add-ins to expand worksheet functionality or streamline retrieval of external information Get started creating brand-new TypeScript applications for Excel Online About This Book * For everyone who wants to get more done with Microsoft Excel in less time * For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
LC Classification Number
HF5548.4.M523
Copyright Date
2022
ebay_catalog_id
4
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:276367566565
Postage and handling
Item location:
Tennessee, United States
Post to:
Afghanistan, Albania, Algeria, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan Republic, Bahamas, Bahrain, Bangladesh, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Brazil, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde Islands, Cayman Islands, Central African Republic, Chad, Chile, China, Colombia, Costa Rica, Cyprus, Czech Republic, Côte d'Ivoire (Ivory Coast), Democratic Republic of the Congo, Denmark, Djibouti, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Fiji, Finland, France, Gabon Republic, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Mauritania, Mauritius, Mexico, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Nepal, Netherlands, New Zealand, Nicaragua, Niger, Nigeria, Norway, Oman, Pakistan, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Qatar, Republic of Croatia, Republic of the Congo, Romania, Rwanda, Saint Kitts-Nevis, Saint Lucia, Saint Vincent and the Grenadines, San Marino, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, South Africa, South Korea, Spain, Sri Lanka, Suriname, Swaziland, Sweden, Switzerland, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Uganda, United Arab Emirates, United Kingdom, United States, Uruguay, Uzbekistan, Vanuatu, Vatican City State, Vietnam, Wallis and Futuna, Western Samoa, Yemen, Zambia, Zimbabwe
Excludes:
Barbados, French Guiana, French Polynesia, Guadeloupe, Libya, Martinique, New Caledonia, Reunion, Russian Federation, Ukraine, Venezuela
Postage and handling | To | Service | Delivery*See Delivery notes |
---|---|---|---|
US $9.95 (approx PHP 585.23) | United States | Economy Shipping | Estimated between Fri, 28 Jun and Mon, 1 Jul to 43230 |
US $14.95 (approx PHP 879.31) | United States | Standard Shipping | Estimated between Fri, 28 Jun and Mon, 1 Jul to 43230 |
Handling time |
---|
Will usually post within 3 business days 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 #276367566565
Sales Tax for an item #276367566565
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 |
---|---|
30 days | Money Back |
The buyer is responsible for return postage costs.
Popular categories from this store
Seller feedback (12,591)
n***m (171)- Feedback left by buyer.
Past month
Verified purchase
Fast Shipping. Item just as described. Great seller!
o***y (37)- Feedback left by buyer.
Past month
Verified purchase
all fine
4***l (325)- Feedback left by buyer.
Past month
Verified purchase
great book, thanks so much. As promised.