Excel 2019 for dummies / by Greg Harvey
By: Harvey, Greg.Publisher: Hoboken, N.J. : Wiley, 2018Description: 478 p. : ill. ; electronic resource.ISBN: 9781119513322.Subject(s): Excel | Spreadsheets | Data communications | AnalyticsOnline resources: Download as an eBook
|Item type||Home library||Call number||URL||Status||Notes||Date due||Item reserves|
|EBook||International||EBL Ebook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
GETTING STARTED WITH EXCEL 2019: THE EXCEL 2019 USER EXPERIENCE: Excel's ribbon user interface -- Launching and quitting Excel -- Help is on the way. CREATING A SPREADSHEET FROM SCRATCH: So what ya gonna put in that new workbook of yours? -- Doing the data-entry thing -- It takes all types -- Fixing those data entry flub-ups -- Taking the drudgery out of data entry -- How to make sure your formulas function even better -- Making sure that the data is safe and sound -- Saving the workbook as a PDF file -- Document recovery to the rescue. EDITING WITHOUT TEARS: MAKING IT ALL LOOK PRETTY: Choosing a select group of cells -- Using the format as table gallery -- Cell formatting from the home tab -- Formatting cells close to the source with the mini-bar -- Using the format cells dialog box -- Calibrating columns -- Futzing with the fonts -- Altering the alignment -- Doing it in Styles -- Fooling around with the Format Painter -- Conditional formatting. GOING THROUGH CHANGES: Opening your workbooks for editing -- Much ado about undo -- Doing the old drag-and-drop thing -- Copying formulas with AutoFill -- Cut and paste, digital style -- Let's be clear about deleting stuff -- Staying in step with insert -- Stamping out your spelling errors -- Eliminating errors with text to speech. PRINTING THE MASTERPIECE: Previewing pages in page layout view -- Using the backstage print screen -- Printing the current worksheet -- My page was set up! -- From header to footer -- Solving page break problems -- Letting your formulas all hang out. GETTING ORGANISED AND STAYING THAT WAY: MAINTAINING THE WORKSHEET: Zooming in and out -- Splitting the worksheet into window panes -- Fixed headings with freeze panes -- Electronic sticky notes -- The range name game -- Seek and ye shall find -- Replacing cell entries -- Doing your research with Smart Lookup -- Controlling recalculation -- Putting on the protection. MAINTAINING MULTIPLE WORKSHEETS: Juggling multiple worksheets -- Don't short-sheet me! -- Opening Windows for your worksheets -- Comparing Worksheets side by side -- Shifting sheets to other workbooks -- Summing stuff on different worksheets. DIGGING DATA ANALYSIS: DOING WHAT-IF ANALYSIS: Playing what-if with data tables -- Playing what-if with Goal Seeking -- Making the case with Scenario Manager. PLAYING WITH PIVOT TABLES: Data analysis and Pivot Tables -- Formatting Pivot Tables -- Sorting and filtering Pivot Tables -- Modifying Pivot Tables -- Creating Pivot Charts. LIFE BEYOND THE SPREADSHEET: CHARMING CHARTS AND GORGEOUS GRAPHICS: Making professional-looking charts -- Adding great-looking graphics -- Controlling how graphic objects overlap -- Printing just the charts. GETTING ON THE DATA LIST: Creating data lists -- Sorting data lists -- Filtering data lists -- Importing external data. LINKING, AUTOMATING AND SHARING SPREADSHEETS: Using Office Add-ins -- Using Excel Add-ins -- Adding hyperlinks to a worksheet -- Automating commands with macros -- Sharing your worksheets -- Editing worksheets in Excel Online. THE PART OF TENS: Top ten beginner basics -- The ten commandments of Excel 2019 -- Top ten ways to manage your data -- Top ten ways to analyze your data.
Explains how to use Excel 2019, describing how the updates and changes are best utilised. Instructs on how to format cells, enter formulas, create and edit charts and design graphics. Describes how to use the data analysis tools and streamline Excel processes. Written for use on any device.