Professional Techniques Used in Excel and Excel VBA Techniques

Cheng-Few Lee, John Lee, Jow-Ran Chang and Tzu Tai
Additional contact information
Cheng-Few Lee: Rutgers University, Department of Finance
John Lee: Center for PBBEF Research
Jow-Ran Chang: National Tsing Hua University, Department of Quantitative Finance
Tzu Tai: Mezocliq, LLC

Chapter Chapter 24 in Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses, 2016, pp 763-800 from Springer

Abstract: Abstract In this chapter we will discuss Excel and Excel VBA techniques that I find useful and are not usually discussed or pointed out in Excel and Excel VBA books. These techniques come from my experience as an Excel professional.

Keywords: Current region; Offset; Resize; Go To; Locals window; Immediate pane; Global workbook names; Local workbook names; Dynamic ranges; File search object (search for similar items in EconPapers)
Date: 2016
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-3-319-38867-0_24

Ordering information: This item can be ordered from
http://www.springer.com/9783319388670

DOI: 10.1007/978-3-319-38867-0_24

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().