000 02094nam a2200337Ia 4500
001 355625
003 0000000000
005 20211104093414.0
008 180829t20192019njua 001 0 eng d
010 _a2018956684
020 _a9781119517948;111951794X
035 _a(OCoLC)on1031961377
035 _a20650869
040 _aYDX
_cYDX
_erda
050 _aHF 5548.4.M523
_b.H262a 2019
100 _aHarvey, Greg,
_968293
245 0 _aExcel® 2019 all-in-one for dummies /
_cby Greg Harvey, PhD.
264 _aHoboken, New Jersey :
_bJohn Wiley & Sons, Inc.,
_cC2019.
300 _axv, 798 pages :
_billustrations
_c24 cm
336 _atext;still image
_2rdacontent;rdacontent
337 _aunmediated
_2rdamedia
338 _avolume
_2rdacarrier
500 _a8 books in one--Cover.
500 _aIncludes index.
505 _aExcel basics -- Worksheet design -- Formulas and functions -- Worksheet collaboration and review -- Charts and graphics -- Data management -- Data anaysis -- Macros and VBA.
520 _aFrom basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources--
650 _aBusiness
_933704
650 _aElectronic spreadsheets
942 _cCIR
999 _c91931
_d91931