Picture 1 of 1
Stock photo
Picture 1 of 1
Stock photo
Business Skills Ser.: Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) by Tracy Syrstad and Bill Jelen (2022, Trade Paperback)
S
Sk1drow Books (2041)
94.3% positive Feedback
Price:
US $45.99
Approximately£34.72
+ $29.14 postage
Returns:
30 days return. Buyer pays for return postage. If you use an eBay delivery label, it will be deducted from your refund amount.
Condition:
Thanks for viewing our Ebay listing! If you are not satisfied with your order, just contact us and we will address any issue. If you have any specific question about any of our items prior to ordering feel free to ask.
- Buy it nowMicrosoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills,
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
About this product
Product Identifiers
PublisherPearson Education
ISBN-100137521529
ISBN-139780137521524
eBay Product ID (ePID)5050431715
Product Key Features
Number of Pages640 Pages
LanguageEnglish
Publication NameMicrosoft Excel Vba and Macros (Office 2021 and Microsoft 365)
SubjectDesktop Applications / General, Commerce, Desktop Applications / Spreadsheets
Publication Year2022
TypeTextbook
AuthorTracy Syrstad, Bill Jelen
Subject AreaComputers, Business & Economics
SeriesBusiness Skills Ser.
FormatTrade Paperback
Dimensions
Item Height1.4 in
Item Weight36 Oz
Item Length9.1 in
Item Width7.3 in
Additional Product Features
Intended AudienceScholarly & Professional
LCCN2022-930486
Dewey Edition23
IllustratedYes
Dewey Decimal005.54
Table Of ContentIntroduction 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
SynopsisRenowned 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 NumberHF5548.4.M523
All listings for this product
Be the first to write a review
