book

Microsoft® Excel® 2013 QuickSteps, 3rd Edition

by John Cronan, Marty Matthews

April 2013

Beginner to intermediate

288 pages

9h 25m

English

McGraw-Hill

Read now

Unlock full access

Cover
About the Author
Title Page
Copyright Page
Contents at a Glance
Contents
Acknowledgments
Introduction
Conventions Used in This Book
Chapter 1: Stepping into Excel
Start and Explore ExcelOpen ExcelUsing TouchExplore the Excel WindowBecome Familiar with the RibbonWork with File ViewCustomize the RibbonCustomize the Quick Access ToolbarGet HelpOpen HelpUse the Excel Help WindowUnderstanding Versions of Office 2013Use WorkbooksCreate a New WorkbookOpen an Existing WorkbookChange the Appearance of New WorkbooksSave a WorkbookUnderstanding Excel’s XML File FormatsUnderstanding Excel File CompatibilityAdd Identifying InformationExit an Excel Session
Chapter 2: Entering and Editing Data
Understanding Data TypesEnter DataEnter TextComplete an EntryEnter Numeric DataEnter DatesFormat NumbersUnderstanding Excel Dates and TimesUse TimesAdd Data QuicklyEdit DataEdit Cell DataRemove Cell ContentsSelect Cells and RangesCopy and Paste DataUse the Office ClipboardFind and Replace DataVerify SpellingModify Automatic Corrections

Chapter 3: Formatting a Worksheet
Work with Cells, Rows, and ColumnsAdd and Remove Rows, Columns, and CellsAdjust Row HeightAdjust Column WidthHide and Unhide Rows and ColumnsChange Cell BordersAdd a CommentFormat CommentsUnderstanding Excel FormattingApply FormattingApply ThemesCreate Custom ThemesSearch for ThemesUse Cell StylesChange FontsChange Alignment and OrientationAdd a BackgroundCopy FormattingArrange and Organize WorksheetsLock Rows and ColumnsSplit a WorksheetView Worksheets from Multiple WorkbooksCompare WorkbooksWork with Worksheets
Chapter 4: Using Formulas and Functions
Reference CellsChange Cell ReferencesUnderstanding Cell Referencing TypesChange to R1C1 ReferencesName CellsGo to a Named CellUsing Cell Reference OperatorsUse the Name ManagerBuild FormulasCreate a FormulaAdding a Symbolic FormulaEdit a FormulaUse FormulasMove FormulasCopy FormulasRecalculate FormulasUse External References in FormulasUnderstanding the Trust CenterFormat ConditionallyUse FunctionsUsing Functions QuicklyEnter a FunctionEnter a Sum in Columns or Rows QuicklyFind and Correct ErrorsCheck for ErrorsTrace Precedent and Dependent CellsWatch a CellEvaluate a Formula in Pieces
Chapter 5: Viewing and Printing Data
Understanding Excel ViewsLay Out a WorksheetAdd Headers and FootersAdd Content to Headers and FootersAdd Pictures to Headers and FootersChange MarginsSelect Page OrientationWork with ZoomUse Headings as Page TitlesPrint the DataChoose Worksheet Print OptionsChange the Order in Which Pages PrintPrint CommentsChoose What to PrintUse Print AreasPreview the Print JobScale Your Data Before PrintingOutput the Print JobSave and View Custom Views
Chapter 6: Charting Data
Create and Design a ChartBuild a ChartChoose a Chart TypeSelecting Data for ChartingChoose a Chart LocationModify How the Data Is PlottedApply a Chart LayoutChange a Chart’s StyleModify Chart ElementsSelect Chart ElementsAdd TitlesShow or Hide AxesAdd or Remove GridlinesIdentifying Chart ElementsShow or Hide a LegendAdd Data LabelsDisplay the Data TableCreate Your Own Chart TypeUse Chart TemplatesCreate a Combo ChartFormat Chart ElementsChange Column and Bar ShapesUse ChartsWork with ChartsAdd Charts ElsewhereAnalyze ChartsPrint a ChartCreate SparklinesWork with Sparklines
Chapter 7: Working with Illustrations
Understanding IllustrationsAdd IllustrationsAdd ShapesWork with CurvesAdd TextUse SmartArtChanging SmartArtInsert PicturesUsing PicturesTake ScreenshotsWork with IllustrationsSelect, View, and Delete IllustrationsUse Handles and Borders to Change IllustrationsCrop PicturesPosition IllustrationsCombine Illustrations by GroupingFormat Illustrations and TextUse StylesApply Styling Elements to PicturesChange a Picture’s AttributesChange a Shape’s FillAdd WordArt Styling to TextMake Detailed Formatting Changes
Chapter 8: Managing Data
Understanding Excel TablesBuild TablesCreate a TableChange Rows and Columns in a TableAdd a Total RowApply Styles to a TableWork with TablesValidate DataLocate Validation DataOrganize DataSort Data by Columns and RowsCreate an AutoFilterRemove FiltersUse Advanced FilteringSetting Up Criteria and Extract RangesOutline Data AutomaticallyUse OutlinesOutline Data by Manually GroupingAdd Subtotals
Chapter 9: Analyzing and Sharing Data
Get the Results You WantUse Goal SeekCompare Alternatives Using ScenariosUse a One-Variable Columnar Data TableUse Multiple Variables to Provide a ResultExplaining the Solver ExampleSave Solver Results and SettingsChange Solver SettingsWork with PivotTablesCreate a PivotTableUnderstanding PivotTable TermsCreate the PivotTable LayoutUse PivotTablesUse SlicersStyle a PivotTableCreate a PivotTable ChartWork with Other UsersPreparing to Share WorkbooksProtect Workbooks with PasswordsShare a WorkbookWork with Changes in a Shared WorkbookProtect a Shared WorkbookDiscontinue Sharing a WorkbookMerging WorkbooksWork with ViewsProtect Worksheet and Workbook Elements
Chapter 10: Extending Excel
Acquire DataConvert Text to DataAdd a Table from an Access DatabaseGet Data from the WebAdd External Data from Existing ConnectionsSet External Data Range PropertiesManage ConnectionsUse Excel with Web TechnologyUnderstanding the Difference Between Save and PublishSave a Workbook as a WebpagePublish Workbook Items as a WebpageUnderstanding SkyDrive and SharePointUse HyperlinksAutomate ExcelUse Recorded MacrosEdit a Macro
Index

Content preview from Microsoft® Excel® 2013 QuickSteps, 3rd Edition

Contents at a Glance

Chapter 1 Stepping into Excel

Start Excel, review the File tab, use the ribbon, get help, open and save workbooks, understand file formats, exit Excel

Chapter 2 Entering and Editing Data

Enter text, enter numeric data, format numbers, edit cells, copy and paste data, use the Office Clipboard, verify spelling

Chapter 3 Formatting a Worksheet

Add and remove rows, columns, and cells; add comments; use themes and styles; ...

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

Microsoft® Office 2013 QuickSteps, 3rd Edition

Publisher Resources

ISBN: 9780071805896

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Excel® 2013 QuickSteps, 3rd Edition

by John Cronan, Marty Matthews

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.