000			04151nam a2200601 i 4500
001			11398740
003			CaPaEBR
005			20241023114853.0
006			m eo d
007			cr cn |||m|||a
008			170630s2017 nyua foa 001 0 eng d
020			_a9781631579448 _qe-book
035			_a(BEP)4877998
035			_a(OCoLC)992466985
035			_a(CaBNVSL)swl00407530
040			_aCaBNVSL _beng _erda _cCaBNVSL _dCaBNVSL
050		4	_aHF5548.4.M523
100	1		_aSingal, Anurag, _eauthor.
245	1	0	_aMS Excel : _blet's advance to the next level / _cAnurag Singal.
246	3		_aMicrosoft Excel : _blet's advance to the next level
250			_aFirst edition.
264		1	_aNew York, New York (222 East 46th Street, New York, NY 10017) : _bBusiness Expert Press, _c[(c)2017.]
300			_a1 online resource (xi, 87 pages) : _billustrations.
336			_atext _btxt _2rdacontent
337			_acomputer _bc _2rdamedia
338			_aonline resource _bcr _2rdacarrier
347			_adata file _2rda
490	1		_aQuantitative approaches to decision making collection, _x2163-9582
500			_aIncludes index.
505	0		_a#0101-0109: Super Essential Keyboard Shortcuts -- _t#0201: Used in Financial Modeling and Tax Computation -- _t#0202: Used in Pricing Discovery Processes -- _t#0203-0204: For Rounding Numbers -- _t#0205: For Counting -- _t#0206-0207: For Weighted Average and Compounding/Discounting -- _t#0301-0302: Formatting Tricks Incl. Special Custom Formats [Shortcut: Ctrl 1. -- _t#0303-#0304: Using CELL STYLES for Automating Formatting for MIS Reporting and Financial Models -- _t#0305-#0307: Cell Drag-n-Drop Auto Fill Options -- _t#0308 Paste Special- Transpose vs. TRANSPOSE() -- _t#0401-0402: Absolute and Relative Referencing Using
506			_aAccess restricted to authorized users and institutions.
520	3		_aThis book is an attempt to take you to the next orbit of competence in this fascinating world. It is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities. MS Excel offers to make life easier for a data analyst. Thus, it will be of relevance to students, academicians, the ones pursuing corporate careers as well as entrepreneurs preparing business plans for their startups. The book explains a wide array of complex functions, ranging from V-LOOKUP to MATCH/INDEX and Pivot Tables in very practical, simple, and implementable manner. Also the segments on Conditional Formatting and printing tricks will help you better present the output to stakeholders. Do try the features Excel has on offer for controlling data input as well as creating checks and balances to ensure cell/sheet/file-level security. You will get the most out of this book if you can use this as a workbook and simultaneously practice the functions on the computer. It is for this purpose that we have appended screenshots for each function. Take each function as a mini case study and try to analyze how you can apply it in making more sense of the enormous data at your disposal. Once you are through all the modules, I am sure, you will emerge as a more efficient person on the work-front.
530			_a2 _ub
530			_aAlso available in printing.
538			_aMode of access: World Wide Web.
538			_aSystem requirements: Adobe Acrobat reader.
588			_aTitle from PDF title page (viewed on June 30, 2017).
630	0		_aMicrosoft Excel (Computer file)
653			_aAdvanced Excel Formulas
653			_aBig Data processing
653			_aMicrosoft Excel Basics
653			_aMicrosoft Excel Latest Version
653			_aMicrosoft Office Excel Worksheet
653			_aMicrosoft Office
653			_aMS Excel Keyboard Shortcuts
653			_aMS Excel
655		0	_a[genre]
655		0	_aElectronic books.
776	0	8	_iPrint version: _z9781631579431
830		0	_aQuantitative approaches to decision making collection. _x2163-9582
856	4	0	_uhttps://go.openathens.net/redirector/ciu.edu?url=https://portal.igpublish.com/iglibrary/search/BEPB0000625.html
942			_2lcc _bCIU _cOB _eBEP _QOL _zBEP11398740
999			_c74039 _d74039
902			_c1 _dCynthia Snell