000			04284nam a22003017a 4500
003			ZW-GwMSU
005			20230724113747.0
008			230630b |||||||| |||| 00| 0 eng d
020			_a9781509307692
020			_a1509307699
040			_arda _bEnglish _cMSULIB _erda
050	0	0	_aHF5548.4.M523 JEL
100	1		_aJelen, Bill, _eauthor.
245	1	0	_aMicrosoft Excel 2019 : _binside out / _ccreated by Bill Jelen.
246	3	0	_aMicrosoft Excel 2019
264		1	_bPearson Education, Inc., _c2019.
300			_axxxi, 829 pages : _billustrations ; _c24 cm
336			_atext _2rdacontent
336			_astill image _2rdacontent
337			_aunmediated _bn _2rdamedia
338			_avolume _bnc _2rdacarrier
504			_aIncludes index.
505			_aIntro Title Page Copyright Page Dedication Page Contents at a Glance Table of Contents About the Author Introduction Who This Book Is For How This Book Is Organized About the Companion Content Acknowledgments Support and Feedback Part I The Excel Interface Chapter 1 What's New in Excel 2019 Office 365 Is the Future Forward-Looking Features in Excel 2019 Power Query Is Still the Best New Feature in Excel 2019 Co-Authoring Allows Multiple People to Edit the Same Workbook at the Same Time Improvements to PivotTables New Calculation Functions in Excel 2019 Two New Charts in 2019 Inserting Icons and 3D Models Using the Inking Tools in Excel 2019 Suggesting Ideas to the Excel Team Accessibility Improvements Across Office Changes to the Ribbon and Home Screen Collecting Survey Data in Excel Using Office 365 Future Features Coming to Office 365 Dynamic Array Functions in Office 365 Chapter 2 Using the Excel Interface Using the Ribbon Using the Quick Access Toolbar Using the Full-Screen File Menu Using the New Sheet Icon to Add Worksheets Navigating Through Many Worksheets Using the Controls in the Lower Left Using the Mini Toolbar to Format Selected Text Expanding the Formula Bar Zooming In and Out on a Worksheet Using the Status Bar to Add Numbers Switching Between Normal View, Page Break Preview, and Page Layout View Modes Chapter 3 Customizing Excel Performing a Simple Ribbon Modification Adding a New Ribbon Tab Sharing Customizations with Others Questions About Ribbon Customization Using the Excel Options Dialog Box Options to Consider Five Excel Oddities Chapter 4 Keyboard Shortcuts Using Keyboard Accelerators Using the Shortcut Keys Using My Favorite Shortcut Keys Using Excel 2003 Keyboard Accelerators Part II Calculating with Excel Chapter 5 Understanding Formulas Getting the Most from This Chapter Introduction to Formulas Entering Your First Formula Three Methods of Entering Formulas Entering the Same Formula in Many Cells Use the Table Tool to Copy a Formula Chapter 6 Controlling Formulas Formula Operators Understanding Error Messages in Formulas Using Formulas to Join Text Copying Versus Cutting a Formula Automatically Formatting Formula Cells Using Date Math Troubleshooting Formulas Chapter 7 Understanding Functions Working with Functions Getting Help with Excel Functions Using AutoSum Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions Math Functions Date and Time Functions Text Functions Examples of Math Functions Examples of Date and Time Functions Examples of Text Functions Chapter 9 Using Powerful Functions: Logical, Lookup, and Database Functions Examples of Logical Functions Examples of Information Functions
520			_aDive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organised reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analysing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customisations to advanced analysis, visualisations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. Enter formulas more efficiency
630	0	0	_aMicrosoft Excel (Computer file)
650		0	_aElectronic spreadsheets _xComputer programs.
942			_2lcc _cB
999			_c162842 _d162842