Excel macros for dummies
(eBook)
Author
Published
[Place of publication not identified] : Wiley, [2015].
Format
eBook
ISBN
1119089352, 9781119089353
Physical Desc
1 online resource (1 volume) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
Date of publication from resource description page.
Description
Ready-made Excel macros that will streamline your workflow Excel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find the most effective Excel macros for solving common problems, and explanations of why and where to use each one, plus invaluable guidance and step-by-step instruction for applying them effectively. Learn how to customize your applica.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Alexander, M. (2015). Excel macros for dummies . Wiley.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Alexander, Michael, 1972-. 2015. Excel Macros for Dummies. Wiley.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Alexander, Michael, 1972-. Excel Macros for Dummies Wiley, 2015.
MLA Citation, 9th Edition (style guide)Alexander, Michael. Excel Macros for Dummies Wiley, 2015.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
b16c7f73-f6a3-47e6-a35f-9bef3d6d510a-eng
Grouping Information
| Grouped Work ID | b16c7f73-f6a3-47e6-a35f-9bef3d6d510a-eng |
|---|---|
| Full title | excel macros for dummies |
| Author | alexander michael |
| Grouping Category | book |
| Last Update | 2024-09-06 16:31:08PM |
| Last Indexed | 2024-09-28 04:04:40AM |
Marc Record
| First Detected | Jul 29, 2024 04:05:00 PM |
|---|---|
| Last File Modification Time | Sep 06, 2024 04:40:32 PM |
MARC Record
| LEADER | 04522cam a2200469 i 4500 | ||
|---|---|---|---|
| 001 | on1128107238 | ||
| 003 | OCoLC | ||
| 005 | 20240830103855.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 191120s2015 xx a o 000 0 eng d | ||
| 020 | |a 1119089352 | ||
| 020 | |a 9781119089353 | ||
| 020 | |z 9781119089346 | ||
| 035 | |a (OCoLC)1128107238 | ||
| 037 | |a CL0501000084|b Safari Books Online | ||
| 040 | |a UMI|b eng|e rda|e pn|c UMI|d OCLCF|d OCLCO|d CZL|d OCLCQ|d OCLCO|d OCLCQ|d OCLCO|d OCLCL | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a HF5548.4.M523 | |
| 082 | 0 | 4 | |a 005.54 |
| 100 | 1 | |a Alexander, Michael,|d 1972-|e author.|1 https://id.oclc.org/worldcat/entity/E39PCjvFBYmTVbcjhrfXYFGQHK|0 http://id.loc.gov/authorities/names/n2005074553 | |
| 245 | 1 | 0 | |a Excel macros for dummies /|c Michael Alexander. |
| 264 | 1 | |a [Place of publication not identified] :|b Wiley,|c [2015] | |
| 300 | |a 1 online resource (1 volume) :|b illustrations | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 490 | 1 | |a For dummies | |
| 500 | |a Date of publication from resource description page. | ||
| 505 | 8 | |a Storing macros in your personal macro workbookAssigning a macro to a button and other form controls; Placing a macro on the Quick Access toolbar; Examples of Macros in Action; Building navigation buttons; Dynamically rearranging pivot table data; Offering one-touch reporting options; Chapter 2 Getting Cozy with Visual Basic Editor; Working in Visual Basic Editor; Understanding VBE components; Working with the Project Window; Adding a new VBA module; Removing a VBA module; Working with a Code Window; Minimizing and maximizing windows; Getting VBA code into a module | |
| 505 | 8 | |a Customizing the VBA EnvironmentThe Editor tab; The Editor Format tab; The General tab; The Docking tab; Chapter 3 The Anatomy of Macros; An Overview of the Excel Object Model; Understanding objects; Understanding collections; Understanding properties; Understanding methods; A Brief Look at Variables; Understanding Event Procedures; Worksheet events; Workbook events; Error Handling in a Nutshell; On Error GoTo SomeLabel; On Error Resume Next; On Error GoTo 0; Part II Making Short Work of Workbook Tasks; Chapter 4 Working with Workbooks; Creating a Workbook from Scratch; How the macro works | |
| 505 | 8 | |a How the macro worksHow to use the macro; Determining Whether a Workbook Exists in a Directory; How the macro works; How to use the macro; Closing All Workbooks at Once; How the macro works; How to use the macro; Printing All Workbooks in a Directory; How the macro works; How to use the macro; Preventing the Workbook from Closing Until a Cell Is Populated; How the macro works; How to use the macro; Creating a Backup of a Current Workbook with Today's Date; How the macro works; How to use the macro; Chapter 5 Working with Worksheets; Adding and Naming a New Worksheet; How the macro works | |
| 520 | |a Ready-made Excel macros that will streamline your workflow Excel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find the most effective Excel macros for solving common problems, and explanations of why and where to use each one, plus invaluable guidance and step-by-step instruction for applying them effectively. Learn how to customize your applica. | ||
| 588 | 0 | |a Online resource; title from cover (Safari, viewed November 18, 2019). | |
| 630 | 0 | 0 | |a Microsoft Excel (Computer file)|0 http://id.loc.gov/authorities/names/n86025775 |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 fast |
| 650 | 0 | |a Electronic spreadsheets|x Computer programs.|0 http://id.loc.gov/authorities/subjects/sh86007613 | |
| 650 | 0 | |a Macro instructions (Electronic computers)|0 http://id.loc.gov/authorities/subjects/sh85079429 | |
| 758 | |i has work:|a Excel macros for dummies (Text)|1 https://id.oclc.org/worldcat/entity/E39PCFpRWBVJg46CbwXqQW8Cry|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version:|a Alexander, Michael, 1972-|t Excel macros for dummies.|d Hoboken, New Jersey : For Dummies, a Wiley Brand : John Wiley & Sons, Inc., [2015]|z 9781119089346|w (DLC) 2015940824|w (OCoLC)898530453 |
| 830 | 0 | |a --For dummies.|0 http://id.loc.gov/authorities/names/n92122684 | |
| 856 | 4 | 0 | |u https://www.aclib.us/OReilly |