000 02295nam a22003615i 4500
999 _c17343
_d17343
001 20805273
003 KPTM
005 20200728094550.0
008 190109s2019 cau 000 0 eng
010 _a 2019930661
020 _a9781509306190
040 _aDLC
_beng
_erda
_cDLC
042 _apcc
050 _aHF5548.4.M523
_b.M478 2019
100 1 _aMcFedries, Paul.
_eAuthor
_98875
245 1 0 _aMicrosoft excel 2019 formulas and functions /
_cPaul McFedries.
250 _a1st edition.
260 _a[New York] :
_bPearson Education,
_c2019.
263 _a1902
264 1 _aSan Francisco, CA :
_bMicrosoft Press,
_c2019.
300 _axxvi, 478 pages :
_billustration ;
_c24 cm.
336 _atext
_btxt
_2rdacontent
337 _aunmediated
_bn
_2rdamedia
338 _avolume
_bnc
_2rdacarrier
500 _aIncludes index
505 _aPart 1-Mastering Excel Ranges and Formulas Chapter 1-Getting the Most Out of Ranges Chapter 2-Using Range Names Chapter 3-Building Basic Formulas Chapter 4-Creating Advanced Formulas Chapter 5-Troubleshooting Formulas Part 2-Harnessing the Power of Functions Chapter 6-Using Functions Chapter 7-Working with Text Functions Chapter 8-Working with Logical and Information Functions Chapter 9-Working with Lookup Functions Chapter 10-Working with Date and Time Functions Chapter 11-Working with Math Functions Chapter 12-Working with Statistical Functions Part 3-Building Business Models Chapter 13-Analyzing Data with Tables Chapter 14-Analyzing Data with PivotTables Chapter 15-Using Excel's Business Modeling Tools Chapter 16-Using Regression to Track Trends and Make Forecasts Chapter 17-Solving Complex Problems with Solver Part 4-Building Financial Formulas Chapter 18-Building Loan Formulas Chapter 19-Building Investment Formulas Chapter 20-Building Discount Formulas
520 _a"Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets. Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers."--
650 _aBusiness
_xComputer programs.
_92068
650 _aElectronic spreadsheets.
_93838
906 _a0
_bibc
_corignew
_d2
_eepcn
_f20
_gy-gencatlg
942 _2lcc
_cBK