Microsoft Excel 2010: Introductory Skills
Preliminary Table of Contents
Microsoft Excel 2010: Introductory Skills
Preliminary Table of Contents
|
Lesson 1: Exploring Excel 2010 Presenting Excel 2010 Starting Excel Exploring the Excel Program Window Using Worksheets and Workbooks Mousing Around in Excel Scrolling Along in a Worksheet Navigating in a Worksheet Working with Tabs and Ribbons The Office Button The Quick Access Toolbar Displaying Tabs and Working with Ribbons Hiding the Ribbon Entering Data in Excel Data Types Completing Cell Entries The Enter and Cancel Buttons Deleting and Replacing Entries Long Text Entries Working with Numbers Number Formats Decimals and Negative Numbers Understanding Save Concepts The Save Command Save As Options Locating Workbooks Issuing Commands from the Keyboard Closing and Starting New Workbooks Exiting from Excel
|
Lesson 2: Editing, Viewing, and Printing Worksheets Opening Workbooks Editing Entries Replacing Entries Deleting Characters Selecting Cells and Ranges Excel Ranges Working with Cut, Copy, and Paste Marquee and Paste Options Button The Office Clipboard Moving and Copying Cells via Drag and Drop Editing Cells via Right-Dragging Using Undo and Redo Undoing Multiple Actions Clearing Cells Contents and Formats Using Auto Features Working with AutoFill AutoComplete vs. AutoFill Auto Fill Options Exploring the Many Views of Excel Working in Page Layout View Zooming the View Printing Worksheets Print Preview Print the Worksheet Printing Selections Editing Workbook Properties Standard Properties Advanced Properties
|
|
Lesson 3: Working with Formulas and Functions Working with Formulas and Functions Using AutoSum to Create a SUM Formula Status Bar Functions and Customization Creating Formulas Beginning Character in Formulas Cell Range References The Language of Excel Formulas “Please Excuse My Dear Aunt Sally” Using Cell References in Formulas Relative Cell References Point Mode Absolute Cell References Mixed References Using the F4 Function Key What-If Analysis Modifying and Copying Formulas Modifying Formulas Copying Formulas Displaying and Printing Formulas Using Formula AutoComplete Functions Defined Using Insert Function Creating Formulas with the IF Function IF Function Syntax How the IF Function Works
|
Lesson 4: Formatting the Contents of Cells Formatting Worksheets Formatting Entries with the Ribbon Using the Mini Toolbar Live Preview Using Excel’s Alignment and Indent Features Aligning Entries Indenting Cell Entries Using Excel’s Text Control Options Merging and Splitting Cells Wrapping Text Shrinking Text to Fit Within a Cell Formatting Numbers Using the Number Command Group Using Accounting and Currency Styles Applying the Percent Style How Numbers Display in Cells Adjusting Decimal Places Displaying Negative Numbers Using the Format Cells Dialog Box Applying Borders and Fills to Cells Applying Borders Applying Fill Colors and Patterns Working with Format Painter and Quick Styles The Format Painter Tool Applying Quick Styles to Cells Formatting with Themes Inserting Date Functions and Formatting Working with Dates Date Serial Numbers Entering Dates Inserting Date and Time Functions Creating Custom Formats Working with Conditional Formatting Using Presets and Multiple Conditions Creating a Conditional Formatting Rule Formatting with Graphics The Conditional Formatting Rules Manager
|
|
Lesson 5: Changing the Appearance of Worksheets Managing Worksheets Inserting and Deleting Worksheets Rearranging, Copying, Renaming, and Coloring Worksheet Tabs Hiding and Unhiding Worksheets Modifying Columns and Rows Column Widths and Row Heights Standard Column Widths and Row Heights AutoFit Inserting and Deleting Columns, Rows, and Cells Inserting and Deleting Rows and Columns Inserting and Deleting Cells Hiding Columns and Rows Formatting All Cells in a Column or Row Simultaneously Hiding Columns and Rows Unhiding Columns and Rows Changing Vertical Alignment and Rotating Text Setting Vertical Alignment Rotating Text Using Excel’s Find and Replace Commands Replacing Cell Formats Using AutoCorrect Expanding AutoCorrect Entries Undoing AutoCorrect Entries Creating and Editing AutoCorrect Entries
Lesson 6: Charting and Transmitting Worksheet Data Creating Charts in Excel Integrated Chart Engine Creating New Charts Choosing the Proper Data Source Chart Types Column Charts and Bar Charts Category Axis and Value Axis Chart and Axis Titles The Chart Tools Moving and Sizing Embedded Charts Moving Embedded Charts Sizing Embedded Charts Deleting Charts Exploring Other Chart Types Line Charts Pie Charts Modifying Existing Charts Changing the Chart Type Reselecting Data Modifying Chart Elements Formatting Chart Elements Applying Layouts and Styles to Charts Formatting Attributes Controlled by the Selected Style Viewing All Available Layouts and Styles for a Chart Type Previewing and Printing Charts Emailing a Workbook Attaching a Workbook Inserting a Worksheet in an Email Message Importing Data into Excel via a Web Query
|
Lesson 7: Working with Large Worksheets: Sorting Worksheet Data Sorting by a Single Column Sorting Selected Rows Sorting by Multiple Columns Using Flexible Worksheet Views Freezing Rows or Columns Splitting the Worksheet Window Viewing Worksheets in Multiple Windows Printing Multipage Worksheets Setting Print Format in Page Layout View Page Layout Ribbon Applying a Worksheet Background Sizing Options Headers and Footers Adding a Watermark Image Applying a Worksheet Background Setting Title Rows and Columns Sheet Options Working with Page Breaks
Lesson 8: Managing Multiple-Sheet Workbooks Using Multiple Worksheets Modifying the Default Number of Sheets Selecting Multiple Sheets Linking Cells and Formulas Why Link Cells? Linking Formulas Copying Worksheets The Move or Copy Dialog Box Copying Formats between Worksheets Naming Cells and Ranges Naming Rules Creating Defined Names Using Defined Names Modifying and Deleting Defined Names Creating Hyperlinks Types of Hyperlinks Insert Hyperlink Dialog Box Editing and Removing Hyperlinks Printing Multiple-Sheet Workbooks Applying Page Setup Options to Multiple Sheets Printing All Sheets in a Workbook Printing Selected Sheets
Glossary Index |