Course Outline

Signup Now!

• Creating and Naming Ranges
  • Creating Several Range Names at the Same Time
  • Moving to Ranges
  • Editing Range Names
  • Using Range Names in Formulas
• Editing Ranges
  • Formatting Ranges
  • Alicante hotel roomsCopying and Moving Ranges
  • Clearing Ranges
• Printing Ranges

Module 2: Using Functions in Formulas

• Using Functions to Compare Data
  • Using the IF and SUMIF Functions
• Creating Formulas with Nested Functions
  • IF, AND, OR Functions

Module 3: Annotating Worksheets and Automating Formatting

• Annotating Worksheets
  • Adding Text Boxes
  • Creating Cell Comments
• Using Styles
  • Creating Custom Styles
  • Changing a Style Definition
• Using AutoFormats
  • Creating Conditional Formulas

Module 4: Working with Templates

• Using Installed Templates
  • Creating Database Templates
• Saving Worksheets as Templates

• Creating Charts from Ranges
  • Creating Charts from Non-Adjacent Ranges
• Creating Charts on Chart Sheets
• Using Different Chart Types
  • Changing Chart Types
  • Setting a Default Chart
  • Creating and Using Custom Chart Types

Module 6: Modifying and Printing Charts

• Modifying Chart Elements
  • Creating Exploded Pie Charts
  • Showing Data with Graphics
  • Adding Trendlines and Error Bars
• Adding Data to a Chart
• Scaling Charts on Chart Sheets

Module 7: Reviewing Your Data

• hotels in BledChecking and Reviewing Data
  • Setting Data Validation Criteria
  • Setting an Error Alert
  • Find Cells Referred to in a Specific Formula
  • Find Formulas that Refer to Specific Cells
  • Tracing Errors in Formulas
• Previewing and printing Workbooks
  • Adding Page Breaks
  • Printing Workbooks

Module 8: Using Data Maps

• Displaying Geographic Data with DataMap
  • Modifying a Data Map