Excel® for Chemists: A Comprehensive Guide, Third Edition -- Contents -- Preface to the Third Edition -- Before You Begin -- PART I THE BASICS -- Chapter 1 Working with Excel 2007 or Excel 2010 -- What's New in Excel 2007 and Excel 2010 -- The Ribbon -- New File Formats -- A Much Larger Worksheet -- Larger Limits for Some Features -- New Worksheet Functions -- The Downside -- What's New in Excel 2010 -- The Excel 2007/2010 Document Window -- Hiding, Moving or Resizing a Document Window -- Working with Excel 2007/2010 -- The Office Button (Excel 2007) -- The File Tab (Excel 2010) -- The Excel Options Window -- The Ribbon: An Overview -- Shortcut Menus -- Keyboard Access to the Ribbon -- The Home Tab -- Navigating Around the Workbook -- Inserting or Deleting Worksheets -- Changing the Name of a Worksheet -- Rearranging the Order of Sheets in a Workbook -- Selecting Multiple Worksheets: [Group] Mode -- Changing the Color of Sheet Tabs -- Using Move or Copy Sheet or Delete Sheet -- Navigating Around the Worksheet -- Selecting a Range of Cells -- Selecting Non-Adjacent Ranges -- Extending a Selection -- Selecting a Block of Cells -- Entering Data in a Worksheet -- Entering Numbers -- How Excel Stores and Displays Numbers -- Entering Text -- Entering Formulas -- Editing Cell Entries -- The Order in Which Excel Performs Operations in Formulas -- Adding a Text Box -- Entering an Equation in a Text Box -- Entering a Cell Comment -- Opening, Closing and Saving Documents -- Opening or Creating Workbooks -- The List of Recently Used Files -- Using Close or Exit -- Using Save or Save As -- To Save a File for Use in Excel 2003 -- Editing a Worksheet -- Inserting or Deleting Rows or Columns -- Hiding Rows or Columns -- Using Cut, Copy and Paste -- Using Paste Special -- Using Paste Special to Transpose Rows and Columns -- Copying and Pasting a Picture of Cells.

Using Clear -- Copy, Cut or Paste Using Drag-and-Drop Editing -- Duplicating Values or Formulas in a Range of Cells -- Absolute, Relative and Mixed References -- Relative References When Using Copy or Cut -- Using AutoFill to Fill Down or Fill Right -- Using AutoFill to Create a Series -- The AutoFill Shortcut Menu -- Formatting Worksheets -- Using Column Width and Row Height -- Formatting Cells -- The Mini Toolbar -- The Format Cells Dialog Box -- Using Alignment -- Using Font -- The Alternate Character Set -- Entering Subscripts and Superscripts -- Using Border and Patterns -- Using the Format Painter Toolbutton -- Number Formatting -- Using the Number Formatting Toolbuttons -- Using Excel's Built-in Number Formats -- Custom Number Formats -- Custom Date Formats -- Time Formats -- Variable Number Formats -- Conditional Number Formats -- Formatting Numbers Using "Precision as Displayed" -- Conditional Formatting (Part I) -- Printing Documents -- Using Page Setup -- Using Print -- Printing a Selected Range of Cells in a Worksheet -- Using Set Print Area -- Printing Row or Column Headings for a Multi-Page Worksheet -- Protecting Data in Worksheets -- Protecting a Workbook -- Protecting a Workbook by Making It a Read-Only Workbook -- Hiding a Worksheet -- Protecting a Worksheet by Locking or Hiding Cell Contents -- Controlling the Way Documents Are Displayed -- Using New Window and Arrange -- Different Views of the Same Worksheet -- Using Split Screens -- Using Freeze Panes -- Using Zoom -- Easing the Transition from Excel 2003 to Excel 2007/2010 -- Customize the Quick Access Toolbar -- Use Shortcut Keys -- Display Classic Menus -- Excel 2007/2010 Workbook and Worksheet Specifications -- Chapter 2 Working with Excel 2003 -- The Excel 2003 Document Window -- Changing What Excel Displays -- Moving or Resizing Documents -- Navigating Around the Workbook.

Changing the Name of a Worksheet -- Changing the Color of Sheet Tabs -- Rearranging the Order of Sheets in a Workbook -- Selecting Multiple Worksheets: [Group] Mode -- Navigating Around the Worksheet -- Selecting a Range of Cells on the Worksheet -- Selecting Non-Adjacent Ranges -- Extending a Selection -- Selecting a Block of Cells -- Entering Data in a Worksheet -- Entering Numbers -- How Excel Stores and Displays Numbers -- Entering Text -- Entering Formulas -- Editing Cell Entries -- Adding a Text Box -- Entering a Cell Comment -- Using the Equation Editor -- Excel's Menus: An Overview -- Shortcut Menus -- Menu Commands or Toolbuttons? -- Opening, Closing and Saving Documents -- Opening or Creating Workbooks -- Using Move or Copy Sheet... or Delete Sheet -- Using Close or Exit -- Types of Excel Document -- Using Save or Save As -- Using Save Workspace -- Editing a Worksheet -- Inserting or Deleting Rows or Columns -- Using Cut, Copy and Paste -- Copying and Pasting Multiple Items -- Using Paste Special -- Using Paste Special to Transpose Rows and Columns -- Using Clear -- Using the Insert Menu -- Copy, Cut or Paste Using Drag-and-Drop Editing -- Duplicating Values or Formulas in a Range of Cells -- Absolute, Relative and Mixed References -- Relative References When Using Copy and Cut -- Using AutoFill to Fill Down or Fill Right -- Creating a Series -- Using AutoFill to Create a Series -- The AutoFill Shortcut Menu -- Formatting Worksheets -- Using Column Width... and Row Height -- Formatting Cells -- Using Alignment -- Using Font -- The Alternate Character Set -- Entering Subscripts and Superscripts -- Using Border and Patterns -- Using the Format Painter Toolbutton -- Number Formatting -- Using Excel's Built-in Number Formats -- Custom Number Formats -- Date Formats -- Time Formats -- Variable Number Formats -- Conditional Number Formats.

Using the Number Formatting Toolbuttons -- Formatting Numbers Using "Precision as Displayed" -- Using Conditional Formatting (Part I) -- Printing Documents -- Using Page Setup -- Using Print Preview -- Using Print -- Printing a Selected Range of Cells in a Worksheet -- Printing Row or Column Headings for a Multi-Page Worksheet -- Protecting Data in Worksheets -- Protecting a Workbook -- Protecting a Workbook by Making it a Read-Only Workbook -- Hiding a Worksheet -- Protecting a Worksheet by Locking or Hiding Cell Contents -- Controlling the Way Documents Are Displayed -- Viewing Several Worksheets at the Same Time -- Using New Window and Arrange -- Different Views of the Same Worksheet -- Using New Window -- Using Split Screens -- Using Freeze Panes -- Opening Excel 2007/2010 Documents in Excel 2003 -- Excel 2003 Workbook and Worksheet Specifications -- Chapter 3 Excel Formulas and Functions -- The Elements of a Worksheet Formula -- Constants -- Operators -- References: Absolute, Relative and Mixed -- R1C1 Reference Style -- Creating and Using External References -- Creating an External Reference by Selecting -- Creating an External Reference by Using Paste Link -- The External Reference Contains the Complete Directory Path -- Updating References and Re-Establishing Links -- Creating and Using 3-D References -- Worksheet Functions: An Overview -- Function Arguments -- Nested Functions -- New Functions Introduced in Excel 2007 -- Changes to Functions in Excel 2010 -- Using Insert Function -- A Shortcut to a Function -- Using Formula AutoComplete (Excel 2007/2010 Only) -- Math and Trigonometric Functions -- Trigonometric Functions -- Functions for Working with Matrices -- Statistical Functions -- Logical Functions -- The IF Function -- Nested IF Functions -- AND, OR and NOT -- Using IFERROR (Excel 2007/2010 Only) -- Using COUNTIF -- Using SUMIF.

Using AVERAGEIF (Excel 2007/2010 Only) -- Using COUNTIFS, SUMIFS and AVERAGEIFS (Excel 2007/2010 Only) -- Using Conditional Formatting (Part II) -- Date and Time Functions -- How Excel Keeps Track of the Date and Time -- Date and Time Arithmetic -- Creating Date Series -- Using Date and Time Functions -- Examples of Date and Time Formulas -- Text Functions -- The LEN, LEFT, RIGHT and MID Functions -- The UPPER, LOWER and PROPER Functions -- The FIND, SEARCH, REPLACE, SUBSTITUTE and EXACT Functions -- The FIXED and TEXT Functions -- The VALUE Function -- The CODE and CHAR Functions -- Lookup and Reference Functions -- Information Functions -- Creating "Megaformulas" -- Advantages and Disadvantages of Megaformulas -- The Order in Which Excel Performs Operations in Formulas -- Formula and Function Specifications -- Chapter 4 Excel 2007/2010 Charts -- Chart Types -- Creating a Chart -- Chart Tools in the Ribbon -- Activating, Resizing and Moving an Embedded Chart -- The SERIES Function -- Chart Elements -- Selecting Chart Elements -- Formatting Chart Elements -- Creating Column or Bar Charts -- Creating Line Charts -- Creating Pie Charts -- Creating Radar Charts -- Creating Surface Charts (3-D Charts) -- Creating XY Charts -- Switching Between Chart Types -- Formatting the Elements of an XY Chart -- Formatting Chart Elements by Using the Mini Toolbar -- Formatting a Data Series -- Formatting Chart Elements with Color -- Modifying an Axis Scale -- Changing the Number Format of an Axis Scale -- Changing the Dimensions of a Chart -- When the X-Values of a Category Chart Are Dates -- Tutorial on Creating Scientific Charts -- Excel 2007/2010 Chart Specifications -- Chapter 5 Excel 2003 Charts -- Chart Types -- Creating a Chart -- Creating a Chart Using the ChartWizard -- Chart Elements -- The SERIES Function -- Creating Column or Bar Charts.

Creating Line Charts.