Limit search to available items
Record 8 of 24
Previous Record Next Record
Book Cover
Author Frye, Curtis, 1968-

Title Microsoft Excel 2013 : step by step / Curtis D. Frye
Published Redmond, Washington : Microsoft, 2013
Online access available from:
Safari O'Reilly books online    View Resource Record  


Description 1 online resource (505 pages) : illustrations
Series Step by step
Step by step (Redmond, Wash.)
Contents Introduction; Who this book is for; How this book is organized; Download the practice files; Your companion ebook; Getting support and giving feedback; Errata; We want to hear from you; Stay in touch; Chapter 1: Getting started with Excel 2013; Identifying the different Excel 2013 programs; Identifying new features of Excel 2013; If you are upgrading from Excel 2010; If you are upgrading from Excel 2007; If you are upgrading from Excel 2003; Working with the ribbon; Customizing the Excel 2013 program window; Zooming in on a worksheet; Arranging multiple workbook windows
Adding buttons to the Quick Access ToolbarCustomizing the ribbon; Maximizing usable space in the program window; Creating workbooks; Modifying workbooks; Modifying worksheets; Inserting rows, columns, and cells; Merging and unmerging cells; Key points; Chapter 2: Working with data and Excel tables; Entering and revising data; Managing data by using Flash Fill; Moving data within a workbook; Finding and replacing data; Correcting and expanding upon worksheet data; Defining Excel tables; Key points; Chapter 3: Performing calculations on data; Naming groups of data
Creating formulas to calculate valuesSummarizing data that meets specific conditions; Working with iterative calculation options and automatic workbook calculation; Using array formulas; Finding and correcting errors in calculations; Key points; Chapter 4: Changing workbook appearance; Formatting cells; Defining styles; Applying workbook themes and Excel table styles; Making numbers easier to read; Changing the appearance of data based on its value; Adding images to worksheets; Key points; Chapter 5: Focusing on specific data by using filters; Limiting data that appears on your screen
Filtering Excel table data by using slicersManipulating worksheet data; Selecting list rows at random; Summarizing worksheets by using hidden and filtered rows; Finding unique values within a data set; Defining valid sets of values for ranges of cells; Key points; Chapter 6: Reordering and summarizing data; Sorting worksheet data; Sorting data by using custom lists ; Organizing data into levels; Looking up information in a worksheet; Key points; Chapter 7: Combining data from multiple sources; Using workbooks as templates for other workbooks
Linking to data in other worksheets and workbooksConsolidating multiple sets of data into a single workbook; Key points; Chapter 8: Analyzing data and alternative data sets; Examining data by using the Quick Analysis Lens; Defining an alternative data set; Defining multiple alternative data sets; Analyzing data by using data tables; Varying your data to get a specific result by using Goal Seek; Finding optimal solutions by using Solver; Analyzing data by using descriptive statistics; Key points; Chapter 9: Creating charts and graphics; Creating charts; Customizing the appearance of charts
Summary Experience learning made easy--and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace--building and practicing the skills you need, just when you need them! Includes links to downloadable practice files and examples. Discover how to: work with Excel 2013 in touch mode; write formulas, create macros, and organize data; present data visually and add images to worksheets; consolidate multiple sets of data into a single workbook; analyze data using the Quick Analysis Lens; collaborate with colleagues and present workbooks online. -- Edited summary from book
Notes Online resource; title from PDF title page (ebrary, viewed October 7, 2013)
Subject Electronic spreadsheets -- Computer programs.
Form Electronic book
ISBN 0735672040
0735672083 (e-book)
9780735672086 (e-book)