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
|Item type||Home library||Call number||URL||Status||Notes||Date due||Item reserves|
|EBook||International||EBL Ebook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
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.