Microsoft Excel VBA and Macro (Office 2021 and Microsoft 365)

By: Jelen Bill Contributor(s): Syrstad Tracy Language: English Publication details: Chennai Pearson India Education Services Pvt Ltd 2022 Description: xxxv,597pISBN: 9788119847006Subject(s): Computer programming, programs, & dataDDC classification: 005.369

Contents:

1. Unleashing the Power of Excel with VBA 2. This sounds like BASIC, 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

Summary: Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excels most useful functions in your everyday work. Features – Improve business analyses by adding intelligence and knowledge to their models Replace cumbersome formulas with convenient predefined functions Radically simplify complex calculations with Office 365's new dynamic arrays Use conditional formatting to reveal anomalies, problems, or opportunities Calculate loan payments, interest costs, terms, and amortization schedules Project the future value of investments, and plan to achieve investment goals Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return Sort, filter, and analyze tabular data, from customers to inventory Easily analyze huge data sets with PivotTable calculations"

Average rating: 0.0 (0 votes)

Holdings ( 1 )
Title notes ( 2 )
Comments ( 0 )

Holdings
Item type	Home library	Collection	Call number	Status	Date due	Barcode
Books	Sateri Pissani Education Society's Shri Gopal Gaonkar Memorial College Goa Multi - Faculty College, Dayanandnagar, Dharbandora SPE-Department of IT & Computer Applications	SPE-IT & Computer Applications	005.369 JEL-SYR (Browse shelf(Opens below))	Available		SPE-4238

1. Unleashing the Power of Excel with VBA
2. This sounds like BASIC, 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

Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excels most useful functions in your everyday work.

Features –

Improve business analyses by adding intelligence and knowledge to their models
Replace cumbersome formulas with convenient predefined functions
Radically simplify complex calculations with Office 365's new dynamic arrays
Use conditional formatting to reveal anomalies, problems, or opportunities
Calculate loan payments, interest costs, terms, and amortization schedules
Project the future value of investments, and plan to achieve investment goals
Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return
Sort, filter, and analyze tabular data, from customers to inventory
Easily analyze huge data sets with PivotTable calculations"

There are no comments on this title.

to post a comment.