book

Microsoft® Excel® 2010 Plain & Simple

Name: Microsoft® Excel® 2010 Plain & Simple
Author: Curtis D. Frye
ISBN: 9780735647459

by Curtis D. Frye

June 2010

Beginner

288 pages

6h 56m

English

Microsoft Press

Read now

Unlock full access

Dedication
Acknowledgments
1. Introduction: About This Book
No Computerese!Useful Tasks……And the Easiest Way to Do ThemA Quick OverviewA Few AssumptionsA Final Word (or Two)
2. What’s New and Improved in Excel 2010
Managing Excel Files and Settings in Backstage ViewPreviewing Data Using Paste PreviewCustomizing the Excel 2010 User InterfaceSummarizing Data Using More Accurate FunctionsSummarizing Data Using SparklinesVisualizing Data Using Improved Conditional FormatsCreating and Displaying Math EquationsEditing Pictures Within Excel 2010
3. Getting Started with Excel 2010
Surveying the Excel Program WindowWorking with the User InterfaceWorking with GalleriesStarting ExcelStart Excel with a Blank WorkbookOpen an Existing WorkbookFinding and Opening Existing WorkbooksOpen a WorkbookOpen a Recently Used WorkbookSearch for a Workbook by Name and Open ItUsing 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 LevelViewing a Worksheet in Full-Screen ModeTurn Full-Screen Mode OnTurn Full-Screen Mode OffSaving and Closing an Excel WorkbookSave a WorkbookSave a Workbook with a New NameChange the Default File FolderClose a WorkbookExit ExcelUsing the Excel Help SystemGet Microsoft Excel HelpGet Suggested Commands from Shortcut MenusGet Help on the Web
4. Building a Workbook
Understanding How Excel Interprets Data EntryNavigating the WorksheetNavigate Your Workbook Using the KeyboardSelecting 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 with Other ShortcutsEnter Data with AutoCompletePick Data from a ListCreating an Excel TableCreate an Excel TableAdd Data to 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 a Place in the Same FileAdd a Hyperlink to Another FileAdd a Hyperlink to a Web PageAdd a Mailto HyperlinkCutting, Copying, and Pasting Cell ValuesCut a Cell ValueCopy a Cell ValuePasting 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 ClipboardUndoing or Redoing an ActionUndo or Redo an ActionFinding and Replacing TextFind a Word or ValueReplace a Word or ValueChecking the Spelling of 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 or Unhide 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, Moving, and Deleting Columns and RowsInsert a Row in a WorksheetInsert a Column in a WorksheetSet Insert OptionsDelete 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 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
Understanding Formulas and Cell References in ExcelCreating 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 LinksChange Links to Different WorkbooksSumming 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 AppearanceFormat Part of a Cell’s ContentsFormatting Cells Containing NumbersDisplay Numerical Values as Currency and PercentagesSet the Number of Decimal PlacesFormatting Cells Containing DatesSet a Date FormatAdding Cell Backgrounds and ShadingAdd Background ColorChange Background ShadingFormatting Cell BordersDraw BordersFormat Cell BordersDefining Cell StylesApply a StyleCreate a StyleModify 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 FormulaEdit a Conditional Formatting RuleDelete a Conditional Formatting RuleChanging How Conditional Formatting Rules Are AppliedStop When a Condition Is MetChange the Order of ConditionsDisplaying Data Bars, Icon Sets, or Color Scales Based on Cell ValuesDisplay Data BarsDisplay Icon SetsDisplay Color ScalesDeleting Conditional FormatsDelete Conditional FormatsCopying Formats with Format PainterCopy Styles with Format PainterMerging or Splitting Cells or DataMerge Several Cells into OneSplit a Merged Cell
8. Formatting the Worksheet
Applying Workbook ThemesApply a Workbook ThemeChange Colors Within a ThemeChange Fonts Within a ThemeChange Effects Within a ThemeCreate 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 ColumnResize Multiple Rows or ColumnsInserting Rows or ColumnsInsert a Row in a WorksheetInsert a Column in a WorksheetSet Insert OptionsMoving Rows and ColumnsMove One or More RowsMove One or More ColumnsDeleting Rows and ColumnsDelete a Row or ColumnOutlining to Hide and Show Rows and ColumnsGroup Rows and ColumnsUngroup Rows and ColumnsHide Grouped Rows and ColumnsShow Grouped Rows and ColumnsHiding Rows and ColumnsHide Rows or ColumnsUnhide Rows or 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 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 ToolbarMove the Quick Access ToolbarModifying the Ribbon User InterfaceAdd a Command to a Ribbon TabReorder Commands on a Ribbon TabRemove a Ribbon ElementCreate a Custom Ribbon TabAdd a New Group to a Ribbon TabRename a Ribbon ElementHide a Ribbon ElementRedisplay a Hidden Ribbon ElementControlling Which Error Messages AppearChoose Which Error Messages AppearReset Ignored ErrorsSelect the Color in Which Excel Displays ErrorsDefining AutoCorrect and AutoFormat EntriesCreate an AutoCorrect EntryDelete an AutoCorrect EntryControl 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 RuleCreate a Search FilterClear a Filter from a ListCreating an Advanced FilterBuild an Advanced FilterRemove an Advanced FilterValidating Data for Correctness During EntryCreate a Validation RuleValidate Data According to a List in a Worksheet Range
12. Summarizing Data Visually Using Charts
Displaying Data GraphicallyCreating a Chart QuicklyCreate a ChartChange 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 TitlesAdd and Remove Data LabelsChanging the Body of a ChartShow or Hide Chart GridlinesChange the Scale on the Value AxisChange the Scale on the Category (X) AxisCustomizing Chart DataChange the Source Data for Your ChartAdd a New SeriesDelete a SeriesWorking with Common ChartsPull a Slice Out of a Pie ChartCreate a 3-D Exploded Pie ChartChange the Way You View 3-D ChartsWorking with Uncommon ChartsCreate a Stock ChartAdding a Trendline to a ChartAdd a Trendline to a Data SeriesSummarizing Data Using SparklinesCreate a Line SparklineCreate a Column SparklineCreate a Win/Loss SparklineFormat a SparklineDelete a Sparkline
13. Enhancing Your Worksheets with Graphics
Working with Graphics in Your WorksheetsAdding Graphics to WorksheetsAdd a PictureDelete a PictureAdding Drawing Objects to a WorksheetAdd a Simple ShapeAdd Text to Any ShapeFormat Text in a ShapeAdding Fills to Drawing ObjectsApply a Shape StyleApply a FillFill an Object with a PictureAdding Effects to Drawing ObjectsAdd or Edit an Object’s ShadowRotate an Object in Three DimensionsCustomizing Pictures and ObjectsResize a Picture or ObjectRotate a Picture or ObjectRemove the Background from a PictureAligning and Grouping Drawing ObjectsAlign ObjectsGroup or Ungroup ObjectsChange the Order of 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 ShapeAlter the Layout of Your Organization ChartChange the Design of Your Organization ChartAdding an Equation to a ShapeAdd a Model EquationAdd a Custom Equation
14. Sharing Excel Data with Other Programs
Introducing Linking and EmbeddingLinking and Embedding Other FilesEmbed a File in a WorksheetLink to a FileExchanging Table Data Between Excel and WordBring 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 ExcelBring Access Table Data into an Excel WorksheetSend Excel Data to AccessImporting a Text FileBring Text into Excel
15. Using Excel in a Group Environment
Sharing Workbooks in ExcelTurn on Workbook SharingCommenting in CellsAdd a CommentView a CommentEdit a CommentDelete a CommentTracking Changes in WorkbooksTurn on Track ChangesAccepting or Rejecting ChangesView a ChangeReview ChangesCreate a Change HistorySaving Worksheets to the WebSave a Workbook to the WebDynamically Update Worksheets Published to the WebUpdate Worksheets Published to the WebRetrieving Web Data Using ExcelRetrieve Data from Web PagesCopy Data from the Web to ExcelModifying Web QueriesSchedule Web Query Data RefreshesIntroducing XMLInteracting over the Web Using XMLSave a Workbook as an XML SpreadsheetImport Spreadsheet XML
Index
About the Author
Copyright

Content preview from Microsoft® Excel® 2010 Plain & Simple

Acknowledgments

A book is a team effort. I’d like to extend my sincere thanks to Kristen Borg, who shepherded this book through the production process;, Mark Reddin, who provided a rigorous technical edit; John Pierce, who copyedited the text; Robert Romano, who served as our graphic artist; Nellie McKesson, who laid out the pages; and Ginny Munroe, who prepared the index.

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® PowerPoint® 2010 Plain & Simple

Publisher Resources

ISBN: 9780735647459Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Excel® 2010 Plain & Simple

by Curtis D. Frye

Acknowledgments

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.