02186nam a22003971i 4500 175349 175349 OSt 20191210100658.0 191209t20192019njua|||er|||| 001 0 eng d 9781119517948 RM 201.35 paperback PPAK eng PPAK rda 23 005.54 005.54 HAR R Harvey, Greg, author. Excel® 2019 ALL - IN - ONE / by Greg Harvey, PhD. Excel® 2019 all-in-one for dummies Microsoft Excel® 2019 all-in-one for dummies Microsoft Office Excel® 2019 all-in-one for dummies 5th edition. Hoboken, New Jersey : John Wiley & Sons, Inc., 2019 ©2019 xv, 798 pages : illustrations ; 24 cm. text rdacontent still image rdacontent unmediated rdamedia volume rdacarrier For dummies Includes index. "8 books in one"--Cover. "From 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"-- Microsoft Excel (Computer file) Electronic spreadsheets Computer programs. Business Computer programs Handbooks and manuals. lcgft For dummies. ddc B 0 1 SP R 2019-12-22 R 005.54 HAR A01622993 2019-12-22 00:00:00 B 0 1 JT R 2019-12-22 R 005.54 HAR A01622994 2019-12-22 00:00:00 B 0 1 KM R 2019-12-22 R 005.54 HAR A01622995 2019-12-22 00:00:00 B 0 1 LW R 2019-12-22 R 005.54 HAR A01622996 2019-12-22 00:00:00 B 0 1 BL R 2019-12-22 R 005.54 HAR A01622997 2019-12-22 00:00:00 B 0 1 BB R 2019-12-22 R 005.54 HAR A01622998 2019-12-22 00:00:00 B 0 1 MR R 2019-12-22 R 005.54 HAR A01622999 2019-12-22 00:00:00 B