book

Microsoft Excel 2013 Plain & Simple

Name: Microsoft Excel 2013 Plain & Simple
Author: Curtis D. Frye
ISBN: 9780735672673

by Curtis D. Frye

April 2013

Beginner

368 pages

9h 12m

English

Microsoft Press

Read now

Unlock full access

Dedication
1. About this book
No computerese!Useful tasks......And the easiest way to do themA quick overviewA few assumptionsAdapting task procedures for touchscreensA final word (or two)
2. What’s new and improved in Excel 2013
Using Excel 2013 in Windows 8Launch Excel 2013 in Windows 8Analyzing data instantly by using the Quick Analysis toolSummarize data by using Quick AnalysisEntering data quickly by using Flash FillSeparate data by using Flash FillCreating the right chart by using chart recommendationsCreate a recommended chartFiltering Excel tables by using slicersAdd a slicerDefine a filter by using a slicerCreating a recommended PivotTableCreate a recommended PivotTableEditing a workbook in SkyDrive and the Excel Web AppEdit a file in the Excel Web AppFormatting charts by using the new tools interfaceChange a chart’s style
3. Getting started with Excel 2013
Surveying the Excel program windowWorking with the user interfaceWorking with galleriesStarting ExcelStart Excel 2013 in Windows 8Pin Excel 2013 to the taskbarAdding Excel 2013 to the Start screenAdd Excel 2013 to the Start screenStarting Excel 2013 in Windows 7Start Excel 2013 in Windows 7Opening existing workbooksOpen a workbookOpen a recently used workbookUsing file propertiesSet file propertiesDefine custom propertiesCreating a new workbookCreate a new workbookWorking with multiple workbooksSwitch between open workbooksShow more than one workbookSizing and viewing windowsResize a windowZooming in or out on a worksheetZoom in or outZoom in or out to a custom zoom levelSaving Excel workbooksSave a workbookSave a workbook with a new nameChanging the default file folderChange the default file folderClosing workbooks and exiting ExcelClose a workbookExit ExcelUsing the Excel Help systemGet Microsoft Excel HelpGet suggested commands from shortcut menusFinding Excel Help on the webGet help on the webSearching for a workbookSearch for a workbook
4. Building a workbook
Selecting cellsSelect a contiguous group of cellsSelect a noncontiguous group of cellsSelect rows or columnsSelect noncontiguous rows or columnsEntering text in cellsEnter text as one lineEnter text with forced line breaksEntering numbers in cellsEnter numbersEnter numbers using scientific notation and exponentsEntering dates and times in cellsEnter a dateEnter a timeEnter a date and timeEnter the current date and timeEntering data using fillsFill data using AutoFillUse AutoFill to enter a series of valuesEntering data by using Flash FillCombine data by using Flash FillSeparate data by using Flash FillEntering data with other shortcutsEnter data with AutoCompletePick data from a listCreating an Excel tableCreate an Excel tableAdd data to an Excel tableEditing an Excel TableRename an Excel tableResize an Excel tableSelect an Excel table columnEditing cell contentsEdit cell contents in the formula barEdit cell contents directly in the cellInserting a symbol in a cellAdd a symbol to a cellCreating hyperlinksAdd a hyperlink to filesAdd a hyperlink to another fileCreating hyperlinks to web and email resourcesAdd a hyperlink to a webpageAdd a mailto hyperlinkCutting, copying, and pasting cell valuesCut a cell valueCopy a cell valueUndoing or redoing an actionUndo or redo an actionPasting values with more controlPaste values with more controlClearing cell contentsClear a cellUsing the Office ClipboardDisplay the contents of the Office ClipboardPaste an item from the Office ClipboardClear an item from the Office ClipboardFinding and replacing textFind a word or valueReplace a word or valueChecking the spelling in your worksheetCheck spelling
5. Managing and viewing worksheets
Viewing and selecting worksheetsSelect multiple worksheetsRenaming worksheetsChange the name of a worksheetMoving worksheetsMove worksheets within the workbookMove worksheets to another workbookCopying worksheetsCopy worksheets within the workbookCopy worksheets to another workbookInserting and deleting worksheetsInsert a blank worksheetDelete one or more worksheetsHiding or showing a worksheetHide a worksheetUnhide a hidden worksheetChanging worksheet tab colorsColor a sheet tabInserting, moving, and deleting cellsInserting cells in a worksheetMove cells in a worksheetDelete cells in a worksheetInserting columns and rowsInsert a row in a worksheetInsert a column in a worksheetSetting insert optionsSet insert optionsDeleting rows or columnsDelete rows or columnsMoving rows or columnsMove one or more rowsMove one or more columnsHiding and unhiding columns and rowsHide rows or columnsUnhide rows or columnsEntering data and formatting on many worksheets at the same timeEnter and format data on several worksheets at one timeCopy cells from one worksheet to a group of worksheetsChanging how you look at Excel workbooksView different parts of one worksheet at the same timeView multiple workbooks at the same timeView multiple parts of a worksheet by freezing panesNaming and using worksheet viewsName the current view of the worksheetSwitch to another view of the worksheet
6. Using formulas and functions
Creating simple cell formulasBuild a formulaEdit a formulaAssigning names to groups of cellsCreate a named rangeGo to a named rangeDelete a named rangeRename a named rangeUsing names in formulasCreate a formula with a named rangeCreating a formula that references values in an Excel tableCreate a formula with an Excel table referenceCreating formulas that reference cells in other workbooksUse cells from other workbooks in a formulaBreak links to other workbooks and convert to valuesRefresh linksChanging links to different workbooksChange links to different workbooksAnalyzing data by using the Quick Analysis lensSummarize data by using Quick AnalysisSumming a group of cells without using a formulaSummarize data in a group of cellsFind the total, average, or other values of cell dataCreating a summary formulaCreate an AutoSum formulaSumming with subtotals and grand totalsCreate a subtotalRemove a subtotalExploring the Excel function libraryList functions available from the Excel libraryUse function ScreenTipsUsing the IF functionCreate an IF functionChecking formula referencesFind cell precedents and dependentsRemove tracer arrowsDebugging your formulasMonitor a formula for changesDelete a watchEvaluate parts of a formula
7. Formatting the cell
Formatting cell contentsChange font and font sizeChange text appearanceFormatting part of a cell’s contentsFormat part of a cell’s contentsFormatting cells containing datesSet a date formatFormatting cells containing numbersDisplay numerical values as currency and percentagesSet the number of decimal placesAdding cell backgrounds and shadingAdd background colorChange background shadingFormatting cell bordersDraw bordersFormat cell bordersDefining cell stylesApply a styleCreate a styleModifying and deleting cell stylesModify a styleDelete a styleAligning and orienting cell contentsChange text alignmentSet text orientation and wrappingFormatting a cell based on conditionsChange the format of a cell based on its valueChange the format of a cell based on the results of a formulaEditing and deleting conditional formatsEdit a conditional formatting ruleDelete a conditional formatting ruleChanging how conditional formatting rules are appliedStop when a condition is metChange the order of conditionsDisplaying data bar and icon set formatsDisplay data barsDisplay icon setsDisplaying color scales based on cell valuesDisplay color scalesDeleting conditional formatsDelete conditional formatsMerging or splitting cells or dataMerge several cells into oneSplit a merged cellCopying formats with Format PainterCopy styles with Format Painter
8. Formatting the worksheet
Applying workbook themesApply a workbook themeChange colors within a themeChanging theme fonts and effectsChange fonts within a themeChange effects within a themeCreating new workbook themesCreate a new workbook themeColoring sheet tabsColor a sheet tabChanging a worksheet’s gridlinesChange the color of cell gridlinesShow or hide cell gridlinesChanging row heights and column widthsResize a rowResize a columnResizing multiple rows or columnsResize multiple rows or columnsInserting rows or columnsInsert a row in a worksheetInsert a column in a worksheetSetting insert optionsSet insert optionsMoving rows and columnsMove one or more rowsMove one or more columnsDeleting rows and columnsDelete a row or columnGrouping and ungrouping worksheet rowsGroup worksheet rowsUngroup worksheet rowsHiding rows and columnsHide rows or columnsUnhide rows or columnsOutlining to hide and show rows and columnsHide grouped rows and columnsShow grouped rows and columnsProtecting worksheets from changesProtect a worksheetLocking cells to prevent changesLock cells
9. Printing worksheets
Previewing worksheets before printingDisplay a worksheet in Page Layout viewView and zoom worksheets in Backstage viewChange column widths and row heights in Page Layout viewPrinting worksheets with current optionsPrint multiple worksheets from the same workbookChoosing whether to print gridlines and headingsChoose to print gridlinesChoose to print headingsChoosing printers and paper optionsChoose a printerChoose the paperPrinting part of a worksheetSet a print areaRemove a print areaPrinting row and column headings on each pageIdentify the rows and columns to repeatSetting and changing print marginsSet page marginsAdjust page margins in Backstage viewSetting page orientation and scaleSet page orientationScale the printout to a fixed number of pagesCreating headers and footersAdd a premade header and footerAdd predefined text to the header or footerAdjust header and footer heightAdding graphics to a header or a footerInclude a graphic in a header or footerFormat a graphic in a header or footerSetting and viewing page breaksView current page breaksSet manual page breaksChange manual page breaks

10. Customizing Excel to the way you work
Opening ready-to-use workbook templatesCreate a workbook from a templateSaving a workbook as a templateSave a workbook as a templateModify a templateAdding commands to the Quick Access toolbarAdd a command to the Quick Access toolbarRemove a command from the Quick Access toolbarMoving the Quick Access toolbarMove the Quick Access toolbarRemoving a ribbon elementRemove a ribbon elementAdding and reordering ribbon elementsAdd a command to a ribbon tabReorder commands on a ribbon tabCreating new ribbon tabs and groupsCreate a custom ribbon tabAdd a new group to a ribbon tabRenaming a ribbon elementRename a ribbon elementChoosing the color Excel uses to display errorsSelect the color that Excel uses to display errorsHiding and displaying ribbon tabsHide a ribbon tabRedisplay a hidden ribbon elementControlling which error messages appearChoose which error messages appearReset ignored errorsDefining AutoCorrect entriesCreate an AutoCorrect entryDelete an AutoCorrect entryControlling AutoFormat rulesControl AutoFormat rules
11. Sorting and filtering worksheet data
Sorting worksheet dataSort data in ascending or descending orderCreate a multicolumn sortCreating a custom sort listDefine a custom list of valuesSort using a custom listFiltering data quickly with AutoFilterCreate a selection filterCreate a filtering ruleFiltering data with a search filterCreate a search filterClearing a filterClear a filter from a columnClear all active filtersCreating an advanced filterBuild an advanced filterRemove an advanced filterFiltering Excel tables visually by using slicersAdd a slicerDefine a filter using a slicerClearing and removing slicersClear a slicer filterRemove a slicerValidating data for correctness during entryCreate a validation ruleValidating data using a listValidate data according to a list in a worksheet rangeCreating a recommended PivotTableCreate a recommended PivotTablePivot a PivotTable
12. Summarizing data visually using charts
Creating a chartCreate a chartCreate a recommended chartChanging a chart’s layout and styleChange a chart’s layoutChange a chart’s styleChanging a chart’s appearanceChange a chart’s typeChange the formatting of a chart elementFormatting chart legends and titlesShow or hide a chart legendAdd titlesAdding and removing data labels and grid linesAdd and remove data labelsShow or hide chart grid linesFormatting chart axesChange the scale on the value axisChange the scale on the category (X) axisChanging a chart’s data sourceChange the source data for your chartAdding and deleting data seriesAdd a new seriesRemove a seriesFiltering chartsFilter a chartRemove a chart filterManipulating pie chartsPull a slice out of a pie chartCreate a 3-D pie chartCreating a stock chartCreate a stock chartAdding a trendline to a chartAdd a trendline to a data seriesSummarizing data using sparklinesCreate a line or column sparklineCreate a win/loss sparklineFormatting and deleting sparklinesFormat a sparklineDelete a sparkline
13. Enhancing your worksheets with graphics
Adding drawing objects to a worksheetAdd a simple shapeAdding graphics to worksheetsAdd a pictureDelete a pictureAdding text to a shapeAdd text to any shapeFormat text in a shapeApplying shape stylesApply a shape styleChanging a shape’s fill color or imageApply a fillFill an object with a pictureAdding effects to drawing objectsAdd or edit an object’s shadowRotate an object in three dimensionsResizing and rotating pictures and objectsResize a picture or objectRotate a picture or objectRemoving the background from an imageRemove the background from a pictureAligning and grouping drawing objectsAlign objectsGroup or ungroup objectsUsing WordArt to create text effects in ExcelAdd WordArt textChange WordArt text colorsInserting clip art into a worksheetAdd clip artInserting and changing a diagramInsert a diagramChange the style of a diagramCreating an organization chartCreate an organization chartAdd a shapeChanging the layout and design of a SmartArt graphicAlter the layout of your organization chartChange the design of your organization chartAdding an equation to a shapeAdd a model equationAdd a custom equationReordering objectsChange the order of objects
14. Sharing Excel data with other programs
Linking and embedding other filesEmbed a file in a worksheetLink to a fileExchanging table data between Excel and WordPaste Word data into ExcelCopy Excel data to WordCopying Excel charts and data into PowerPointMove Excel data to PowerPointCopy an Excel chart to PowerPointExchanging data between Access and ExcelPaste Access table data into an Excel worksheetSend Excel data to AccessImporting a text filePaste text into Excel
15. Using Excel in a group environment
Sharing workbooks in ExcelTurn on workbook sharingAdding and viewing cell commentsAdd a commentView a commentEditing and deleting commentsEdit a commentDelete a commentTracking changes in workbooksTurn on Track ChangesAccepting or rejecting changesView a changeReview changesMaintaining a change historyCreate a change historySaving worksheets to the webSave a workbook to the webDynamically updating worksheets published to the webUpdate worksheets published to the webRetrieving web data using ExcelRetrieve data from web pagesCopying web data to ExcelCopy data from the web to ExcelModifying web queriesSchedule web query data refreshesSaving data to the cloud using SkyDriveSave a file to SkyDriveInteracting over the web using XMLSave a workbook as a Strict Open XML Spreadsheet fileImport an XML spreadsheet fileEditing a workbook in the Excel Web AppEdit a file in the Excel Web AppOpen a file in the Excel desktop applicationSharing Excel workbooks on the webEmbed a workbook in a webpageMaking workbooks available on the webMake a workbook available on the web
A. About the Author
Index
About the Author
Copyright

Overview

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.

Here’s WHAT You’ll Learn

Manage your data quickly and efficiently

Filter, sort, summarize, and crunch your numbers

Use formulas and functions to do the heavy lifting

Bring data to life with charts and graphics

Share data between Microsoft Office documents

Work as a team, online and in the cloud

Here’s HOW You’ll Learn It

Jump in wherever you need answers

Follow easy STEPS and SCREENSHOTS to see exactly what to do

Get handy TIPS for new techniques and shortcuts

Use TRY THIS! exercises to apply what you learn right away

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780735672673Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills