Library - State Bank of Pakistan

EXCEL 2019 ALL-IN-ONE FOR DUMMIES

⇐ Back

Call No: 004.6 HAR

Accession No.100044
Accession Date:23-JUL-19
Author(s):GREG HARVEY
ImprintNEW JERSEY: FOR DUMMIES, 2019.
Subject(s):MICROSOFT EXCEL, ELECTRONIC SPREADSHEETS
ISBN:9781119517948
Pages:798
Language:ENGLISH

Contents

INTRODUCTION 1
BOOK 1: EXCEL BASICS 11
CHAPTER 1: THE EXCEL 2019 USER EXPERIENCE 13
CHAPTER 2: CUSTOMIZING EXCEL 2019
BOOK 2: WORKSHEET DESIGN 79
CHAPTER 1: BUILDING WORKSHEETS
CHAPTER 2: FORMATTING WORKSHEETS 133
CHAPTER 3: EDITING AND PROOFING WORKSHEETS 193
CHAPTER 4: MANAGING WORKSHEETS 241
CHAPTER 5: PRINTING WORKSHEETS 277
BOOK 3: FORMULAS AND FUNCTIONS 305
CHAPTER 1: BUILDING BASIC FORMULAS 307
CHAPTER 2: LOGICAL FUNCTIONS AND ERROR TRAPPING 347
CHAPTER 3: DATE AND TIME FORMULAS 371
CHAPTER 4: FINANCIAL FORMULAS 387
CHAPTER 5: MATH AND STATISTICAL FORMULAS 401
CHAPTER 6: LOOKUP, INFORMATION, AND TEXT FORMULAS 421
BOOK 4: WORKSHEET COLLABORATION AND REVIEW 445
CHAPTER 1: PROTECTING WORKBOOKS AND WORKSHEET DATA
CHAPTER 2: USING HYPERLINKS 469
CHAPTER 3: PREPARING A WORKBOOK FOR DISTRIBUTION 477
CHAPTER 4: SHARING WORKBOOKS AND WORKSHEET DATA 491
BOOK 5: CHARTS AND GRAPHICS 517
CHAPTER 1: CHARTING WORKSHEET DATA 519
CHAPTER 2: ADDING GRAPHIC OBJECTS 553
BOOK 6: DATA MANAGEMENT 583
CHAPTER 1: BUILDING AND MAINTAINING DATA LISTS 585
CHAPTER 2: FILTERING AND QUERYING A DATA LIST 609
BOOK 7: DATA ANALYSIS 647
CHAPTER 1: PERFORMING WHAT-IF SCENARIOS 649
CHAPTER 2: PERFORMING LARGE-SCALE DATA ANALYSIS 673
BOOK 8: MACROS AND VBA 719
CHAPTER 1: RECORDING AND RUNNING MACROS 721
CHAPTER 2: VBA PROGRAMMING 733