Normal view MARC view ISBD view

Excel 2016 formulas / by Michael Alexander and Dick Kusleika

By: Alexander, Michael.
Contributor(s): Kusleika, Dick.
Publisher: Indianapolis, IN : John Wiley & Sons, 2016Description: xxxii, 782 p. : ill. ; 24 cm.ISBN: 9781119067863.Subject(s): Excel | Spreadsheets | Computer softwareOnline resources: Download as an eBook
Contents:
UNDERSTANDING FORMULA BASICS: The Excel user interface in a nutshell -- Basic facts about formulas -- Working with names. LEVERAGING EXCEL FUNCTIONS: Introducing worksheet functions -- Manipulating text -- Working with dates and times -- Counting and summing techniques -- Using Lookup functions -- Working with tables and lists -- Miscellaneous calculations. FINANCIAL FORMULAS: Borrowing and investing formulas -- Discounting and depreciation formulas -- Financial schedules. ARRAY FORMULAS: Introducing arrays -- Performing magic with array formulas. MISCELLANEOUS FORMULA TECHNIQUES: Importing and cleaning data -- Charting techniques -- Pivot tables -- Conditional formatting -- Using data validation -- Creating megaformulas -- Tools and methods for debugging formulas. DEVELOPING CUSTOM WORKSHEET FUNCTIONS: Introducing VBA -- VBA programming concepts -- Function procedure basics -- VBA custom function examples. APPENDIXES: Excel function reference -- Using custom number formats.
Summary: Presents a comprehensive guide to leveraging formulas to optimise productivity in Excel 2016. Includes how to perform financial and statistical analyses, work with pivot tables and create your own custom functions using VBA.
Item type Home library Call number URL Status Notes Date due Item reserves
Book Book Australia
276 ALE 2016 (Browse shelf) Available
Book Book Australia
276 ALE 2016 (Browse shelf) Available
EBook EBook International
EBL Ebook (Browse shelf) Link to resource eBook Available as an ebook here
Book Book New Zealand
Available
Book Book New Zealand
276 EXC (Browse shelf) Available
Book Book New Zealand
276 EXC (Browse shelf) Available
Total holds: 0

UNDERSTANDING FORMULA BASICS: The Excel user interface in a nutshell -- Basic facts about formulas -- Working with names. LEVERAGING EXCEL FUNCTIONS: Introducing worksheet functions -- Manipulating text -- Working with dates and times -- Counting and summing techniques -- Using Lookup functions -- Working with tables and lists -- Miscellaneous calculations. FINANCIAL FORMULAS: Borrowing and investing formulas -- Discounting and depreciation formulas -- Financial schedules. ARRAY FORMULAS: Introducing arrays -- Performing magic with array formulas. MISCELLANEOUS FORMULA TECHNIQUES: Importing and cleaning data -- Charting techniques -- Pivot tables -- Conditional formatting -- Using data validation -- Creating megaformulas -- Tools and methods for debugging formulas. DEVELOPING CUSTOM WORKSHEET FUNCTIONS: Introducing VBA -- VBA programming concepts -- Function procedure basics -- VBA custom function examples. APPENDIXES: Excel function reference -- Using custom number formats.

Presents a comprehensive guide to leveraging formulas to optimise productivity in Excel 2016. Includes how to perform financial and statistical analyses, work with pivot tables and create your own custom functions using VBA.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha