Normal view MARC view ISBD view

Excel macros for dummies / by Michael Alexander

By: Alexander, Michael.
Publisher: Hoboken, N.J. : Wiley, 2017Edition: 2nd ed.Description: xiii, 294 p. : ill. ; electronic resource.ISBN: 9781119369240.Subject(s): Excel | Spreadsheets | Data processingOnline resources: Download as an eBook
Contents:
HOLY MACRO BATMAN!: Macro fundamentals -- Getting cozy with the visual basic editor -- The anatomy of macros. MAKING SHORT WORK OF WORKBOOK TASKS: Working with workbooks -- Working with worksheets. ONE-TOUCH DATA MANIPULATION: Feeling at home on the range -- Manipulating data with macros. MACRO-CHARGING REPORTS AND EMAILS: Automating common reporting tasks -- Sending emails from Excel -- Wrangling external data with macros. PART OF TENS: Ten handy visual basic editor tips -- Ten places to turn for macro help -- Ten ways to speed up your macros.
Summary: Explains how to use ready-made Excel macros to streamline your workflow. Offers over 70 macros and includes instructions on how to customise your applications. Reveals how to clean data, automate reporting and send emails from Excel.
Item type Home library Call number URL Status Notes Date due Item reserves
EBook EBook International
EBL Ebook (Browse shelf) Link to resource eBook Available as an ebook here
Total holds: 0

HOLY MACRO BATMAN!: Macro fundamentals -- Getting cozy with the visual basic editor -- The anatomy of macros. MAKING SHORT WORK OF WORKBOOK TASKS: Working with workbooks -- Working with worksheets. ONE-TOUCH DATA MANIPULATION: Feeling at home on the range -- Manipulating data with macros. MACRO-CHARGING REPORTS AND EMAILS: Automating common reporting tasks -- Sending emails from Excel -- Wrangling external data with macros. PART OF TENS: Ten handy visual basic editor tips -- Ten places to turn for macro help -- Ten ways to speed up your macros.

Explains how to use ready-made Excel macros to streamline your workflow. Offers over 70 macros and includes instructions on how to customise your applications. Reveals how to clean data, automate reporting and send emails from Excel.

© 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