Microsoft Excel 2021 Programming Pocket Primer
This book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. --
Saved in:
Online Access: |
Full text (MCPHS users only) |
---|---|
Main Author: | |
Format: | Electronic eBook |
Language: | English |
Published: |
Bloomfield :
Mercury Learning & Information,
2022
|
Series: | Computing Ser.
|
Subjects: | |
Local Note: | ProQuest Ebook Central |
MARC
LEADER | 00000cam a2200000uu 4500 | ||
---|---|---|---|
001 | in00000185228 | ||
006 | m o d | ||
007 | cr ||||||||||| | ||
008 | 221015s2022 xx o ||| 0 eng d | ||
005 | 20240702200527.9 | ||
020 | |a 9781683928911 | ||
020 | |a 1683928911 | ||
035 | |a (OCoLC)1348480583 | ||
035 | |a (OCoLC)on1348480583 | ||
040 | |a EBLCP |b eng |c EBLCP |d LIV |d EBLCP |d UKAHL |d K6U |d OCLCF |d OCLCQ |d OCLCO | ||
050 | 1 | 4 | |a HF5548.4.M523 |b .K67 2022 |
082 | 0 | 4 | |a 005.54 |2 23 |
100 | 1 | |a Korol, Julitta. | |
245 | 1 | 0 | |a Microsoft Excel 2021 Programming Pocket Primer |h [electronic resource]. |
260 | |a Bloomfield : |b Mercury Learning & Information, |c 2022. | ||
300 | |a 1 online resource (279 p.). | ||
490 | 1 | |a Computing Ser. | |
500 | |a Description based upon print version of record. | ||
500 | |a Creating a Function Procedure | ||
505 | 0 | |a Cover -- Title -- Copyright Page -- Contents -- Acknowledgments -- Introduction -- Chapter 1 Excel Macros: A Quick Start in Excel VBA Programming -- Macros and VBA -- Excel Macro-Enabled File Formats -- Macro Security Settings -- Enabling the Developer Tab in Excel -- Using the Built-In Macro Recorder -- Planning a Macro -- Recording a Macro -- Editing Recorded Macros -- Macro Comments -- Cleaning Up the Macro Code -- Running a Macro -- Testing and Debugging a Macro -- Saving and Renaming a Macro -- Printing Macro Code -- Improving Your Recorded Macros -- Creating a Master Macro | |
505 | 8 | |a Various Methods of Running Macros -- Running the Macro Using a Keyboard Shortcut -- Running the Macro from the Quick Access Toolbar -- Running the Macro from a Worksheet Button -- Summary -- Chapter 2 Excel Programming Environment: A Quick Overview of its Tools and Features (VBE) -- Understanding the Project Explorer Window -- Understanding the Properties Window -- Understanding the Code Window -- Setting the VBE Options -- Syntax and Programming Assistance -- List Properties/Methods -- List Constants -- Parameter Info -- Quick Info -- Complete Word -- Indent/Outdent | |
505 | 8 | |a Comment Block/Uncomment Block -- Using the Object Browser -- Locating Procedures with the Object Browser -- Using the VBA Object Library -- Using the Immediate Window -- Obtaining Information in the Immediate Window -- Working with Worksheet Cells and Ranges -- Using the Range Property -- Using the Cells Property -- Using the Offset Property -- Using the Resize Property -- Using the End Property -- Moving, Copying, and Deleting Cells -- Working with Rows and Columns -- Obtaining Information about the Worksheet -- Entering Data and Formatting Cells -- Returning Information Entered in a Worksheet | |
505 | 8 | |a Finding Out about Cell Formatting -- Working with Workbooks and Worksheets -- Working with Windows -- Working with the Excel Application -- Summary -- Chapter 3 Excel VBA Fundamentals: A Quick Reference to Writing VBA Code -- Excel Objects, Properties, and Methods -- Microsoft Excel Object Model -- Writing Simple and Complex VBA Statements -- Breaking Up Long VBA Statements -- Saving Results of VBA Statements -- Introducing Data Types -- Using Variables -- How to Create Variables -- How to Declare Variables -- Specifying the Data Type of a Variabl -- Assigning Values to Variables | |
505 | 8 | |a Forcing Declaration of Variables -- Understanding the Scope of Variables -- Procedure-Level (Local) Variables -- Module-Level Variables -- Project-Level Variables -- Lifetime of Variables -- Finding a Variable Definition -- Determining a Data Type of a Variable -- Using Constants -- Built-In Constants -- Converting between Data Types -- Using Static Variables in VBA Procedures -- Using Object Variables in VBA Procedures -- Using Specific Object Variables -- Summary -- Chapter 4 Excel VBA Procedures: A Quick Guide to Writing Function Procedures -- Understanding Function Procedures | |
520 | |a This book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. -- |c Edited summary from book. | ||
590 | |a ProQuest Ebook Central |b Ebook Central College Complete | ||
630 | 0 | 0 | |a Microsoft Excel (Computer file) |
650 | 0 | |a Electronic spreadsheets. | |
650 | 0 | |a Visual programming (Computer science) | |
776 | 0 | 8 | |i Print version: |a Korol, Julitta |t Microsoft Excel 2021 Programming Pocket Primer |d Bloomfield : Mercury Learning & Information,c2022 |z 9781683928928 |
830 | 0 | |a Computing Ser. | |
852 | |b E-Collections |h ProQuest | ||
856 | 4 | 0 | |u https://ebookcentral.proquest.com/lib/mcphs/detail.action?docID=30174223 |z Full text (MCPHS users only) |t 0 |
938 | |a Askews and Holts Library Services |b ASKH |n AH41156978 | ||
938 | |a ProQuest Ebook Central |b EBLB |n EBL30174223 | ||
947 | |a FLO |x pq-ebc-base | ||
999 | f | f | |s 69994a70-21aa-4234-8d40-a89611a47540 |i 26d944ac-8900-4229-b959-e7f08c926dbc |t 0 |
952 | f | f | |a Massachusetts College of Pharmacy and Health Sciences |b Online |c Online |d E-Collections |t 0 |e ProQuest |h Other scheme |
856 | 4 | 0 | |t 0 |u https://ebookcentral.proquest.com/lib/mcphs/detail.action?docID=30174223 |y Full text (MCPHS users only) |