Course (4-1) Microsoft Excel

zoom

pre 1 of 1 next

Location: Los Angeles

Date posted: June 21, 2013

Price: Please contact

Ad ID: 91849

Views: 9

Reply by email

  • 1. Getting to Know Excel 2007
    • 1.1. Excel Basics
      • 1.1.1. Formulas
      • 1.1.2. Active cell and ranges
    • 1.2. Familiarizing Yourself with the Excel 2007 Window
      • 1.2.1. Moving, resizing, and closing windows
      • 1.2.2. Exiting Excel
    • 1.3. Navigating with the Mouse and Keyboard
      • 1.3.1. Mousing around
      • 1.3.2. Using the keyboard
    • 1.4. Introducing the Ribbon
      • 1.4.1. Dissecting the parts of the Ribbon
      • 1.4.2. Sizing up the Ribbon
      • 1.4.3. Tipping off your keyboard
      • 1.4.4. Hiding the Ribbon commands
    • 1.5. Introducing the Quick Access Toolbar
    • 1.6. Introducing the Office Menu
    • 1.7. Previewing Your Formatting Live
    • 1.8. Formatting with Themes
    • 1.9. Soliciting Help
  • 2. Managing Workbooks
    • 2.1. Activating a Workbook
    • 2.2. Arranging Windows Automatically
    • 2.3. Changing the Default File Location
    • 2.4. Closing a Workbook
    • 2.5. Comparing Two Workbooks Side by Side
    • 2.6. Creating an Empty Workbook
    • 2.7. Creating Multiple Windows (Views) for a Workbook
    • 2.8. Opening Nonstandard Files
    • 2.9. Opening a Workbook
    • 2.10. Protecting and Unprotecting a Workbook
      • 2.10.1. Safeguarding your workbook from unauthorized users
      • 2.10.2. Protecting and unprotecting a workbook structure or window
    • 2.11. Saving Files
      • 2.11.1. Saving a workbook
      • 2.11.2. Saving a workbook under a different name
      • 2.11.3. Saving a workbook in a different or earlier file format
    • 2.12. Switching among Open Workbooks
    • 2.13. Using a Workspace File
      • 2.13.1. Opening a workspace file
      • 2.13.2. Saving a workspace file
    • 2.14. Working with Workbook Templates
      • 2.14.1. Creating a workbook template
      • 2.14.2. Creating a workbook from a template
      • 2.14.3. Creating a default workbook template
  • 3. Working with Worksheets
    • 3.1. Activating a Worksheet
    • 3.2. Adding a New Worksheet
    • 3.3. Changing a Worksheet’s Name
    • 3.4. Coloring a Worksheet Tab
    • 3.5. Copying a Worksheet
    • 3.6. Deleting a Worksheet
    • 3.7. Freezing Row or Column Titles
    • 3.8. Grouping and Ungrouping Worksheets
      • 3.8.1. Grouping worksheets
      • 3.8.2. Ungrouping worksheets
    • 3.9. Hiding and Unhiding a Worksheet
    • 3.10. Moving a Worksheet
    • 3.11. Protecting a Worksheet
    • 3.12. Publishing Your Worksheet Data to the Web
    • 3.13. Splitting Panes
    • 3.14. Turning Off Gridlines
    • 3.15. Using Full-Screen View
    • 3.16. Zooming a Worksheet
  • 4. Entering and Editing Worksheet Data
    • 4.1. Copying Cells and Ranges
      • 4.1.1. Copying a cell to another cell or a range
      • 4.1.2. Copying a range to another range
      • 4.1.3. Copying data to another worksheet or workbook
      • 4.1.4. Copying multiple cells or ranges to another range
    • 4.2. Deleting Entire Rows and Columns
    • 4.3. Editing the Contents of a Cell
    • 4.4. Entering Data into a Range
      • 4.4.1. Entering data into a specific range
      • 4.4.2. Entering the same data into a range of cells
    • 4.5. Entering Dates and Times
      • 4.5.1. Entering specific dates and times
      • 4.5.2. Entering the current date or time
    • 4.6. Entering Formulas
      • 4.6.1. Entering formulas manually
      • 4.6.2. Entering formulas by pointing
    • 4.7. Entering Text
      • 4.7.1. Entering text into cells
      • 4.7.2. Completing text entries by using AutoComplete
    • 4.8. Entering Values
      • 4.8.1. Entering values into cells
      • 4.8.2. Entering fractions
    • 4.9. Erasing Data in Cells and Ranges
    • 4.10. Filling a Series
      • 4.10.1. Entering a series of incremental values or dates
      • 4.10.2. Entering a series of text
    • 4.11. Inserting Entire Rows and Columns
    • 4.12. Moving Cells and Ranges
      • 4.12.1. Moving data to a new location in the same worksheet
      • 4.12.2. Moving data to a different worksheet or workbook
    • 4.13. Replacing the Contents of a Cell
    • 4.14. Searching for Data to Replace
    • 4.15. Selecting Cells and Ranges
      • 4.15.1. Selecting a cell
      • 4.15.2. Selecting a range
      • 4.15.3. Selecting noncontiguous ranges
      • 4.15.4. Selecting entire rows and columns
      • 4.15.5. Selecting a multisheet (3-D) range
    • 4.16. Transposing a Range
    • 4.17. Undoing Changes and Mistakes
    • 4.18. Validating Data Entry
  • 5. Using Formulas and Functions
    • 5.1. Absolute, Relative, and Mixed References
    • 5.2. Basic Formula Essentials
    • 5.3. Changing When Formulas Are Calculated
    • 5.4. Converting Formulas to Values
    • 5.5. Editing Functions in Formulas
    • 5.6. Entering Functions in Formulas
      • 5.6.1. Entering functions manually
      • 5.6.2. Using the AutoSum tool
      • 5.6.3. Using the Function Library
    • 5.7. Modifying a Range Reference Used in a Function
    • 5.8. Referencing Cells or Ranges in Other Worksheets
  • 6. Creating and Using Names
    • 6.1. Advantages to Naming Cells and Ranges
    • 6.2. Applying Names to Existing Cell References
    • 6.3. Creating Names
      • 6.3.1. Creating a name using the New Name dialog box
      • 6.3.2. Creating a name using the name box
      • 6.3.3. Creating names from row and column labels
      • 6.3.4. Creating sheet-level names
      • 6.3.5. Creating multisheet names
    • 6.4. Deleting Names
    • 6.5. Editing Names
    • 6.6. Managing Names
    • 6.7. Naming Constants and Formulas
    • 6.8. Pasting Names into a Formula
  • 7. Auditing Your Work
    • 7.1. Checking for Specific Worksheet Errors
      • 7.1.1. Checking for errors in the background
      • 7.1.2. Checking for errors manually
    • 7.2. Checking Your Spelling
    • 7.3. Creating a Table of Names
    • 7.4. Displaying Formulas in a Worksheet
    • 7.5. Evaluating Parts of a Formula
    • 7.6. Finding Specific Data
    • 7.7. Handling Circular References
    • 7.8. Locating Errors by Selecting Special Cells
    • 7.9. Tracing Cell Relationships
      • 7.9.1. Tracing precedents and dependents
      • 7.9.2. Tracing formula error values
    • 7.10. Understanding Formula Error Values
    • 7.11. Using Cell Comments
      • 7.11.1. Adding a cell comment
      • 7.11.2. Editing a cell comment
      • 7.11.3. Viewing cell comments
    • 7.12. Using the Watch Window
      • 7.12.1. Displaying and adding cells to the Watch window
      • 7.12.2. Removing cells from the Watch window
  • 8. Formatting Your Data
    • 8.1. Adding Borders to a Cell or a Range
    • 8.2. Aligning Cell Contents
    • 8.3. Changing the Appearance of Cell Contents
    • 8.4. Copying Formats
    • 8.5. Formatting Based on the Contents of a Cell or Range
      • 8.5.1. Formatting based on individual cell values
      • 8.5.2. Formatting based on values in a range
      • 8.5.3. Applying multiple conditional formats to a cell or range
      • 8.5.4. Editing or deleting a conditional format
    • 8.6. Formatting a Number
      • 8.6.1. Using Excel’s built-in number formats
      • 8.6.2. Creating custom number formats
    • 8.7. Formatting a Range Using Visualizations
      • 8.7.1. Using a visualization to compare values in a range
      • 8.7.2. Modifying the visualization for a range
    • 8.8. Hiding Cell Contents
    • 8.9. Hiding and Unhiding Columns and Rows
      • 8.9.1. Hiding columns and rows
      • 8.9.2. Unhiding columns and rows
    • 8.10. Modifying Cell Size
      • 8.10.1. Changing column width
      • 8.10.2. Changing row height
    • 8.11. Using Cell Styles
      • 8.11.1. Applying a predefined cell style
      • 8.11.2. Modifying an existing style
      • 8.11.3. Creating a custom cell style
      • 8.11.4. Copying (merging) cell styles from another workbook
  • 9. Printing Your Work
    • 9.1. Adjusting Margins and Centering Printed Output
    • 9.2. Changing Default Print Settings Using a Template
    • 9.3. Changing the Worksheet Display Mode
    • 9.4. Controlling Page Settings
      • 9.4.1. Changing page orientation
      • 9.4.2. Selecting paper size
      • 9.4.3. Scaling your printed output
      • 9.4.4. Specifying the beginning page number
    • 9.5. Handling Page Breaks
      • 9.5.1. Inserting manual page breaks
      • 9.5.2. Removing manual page breaks
      • 9.5.3. Previewing and adjusting page breaks
    • 9.6. Inserting a Header or Footer
      • 9.6.1. Selecting a predefined header or footer
      • 9.6.2. Creating a custom header or footer
      • 9.6.3. Using multiple headers and footers in your reports
    • 9.7. Previewing Your Work
    • 9.8. Printing with Quick Print
    • 9.9. Selecting a Printer
    • 9.10. Setting Sheet Printing Options
      • 9.10.1. Printing gridlines or row and column headings
      • 9.10.2. Printing row or column data labels on each page
      • 9.10.3. Selecting miscellaneous sheet printing options
    • 9.11. Setting the Print Area
    • 9.12. Specifying What You Want to Print
  • 10. Charting Your Data
    • 10.1. Anatomy of a Chart
    • 10.2. Activating a Chart
    • 10.3. Adding a New Data Series to a Chart
    • 10.4. Adding a Title to a Chart
    • 10.5. Changing the Axes for a Data Series
    • 10.6. Changing the Chart Type for an Existing Chart or Data Series
    • 10.7. Creating a Chart
    • 10.8. Creating and Using a Chart Template
    • 10.9. Displaying a Data Table in a Chart
    • 10.10. Displaying Data Labels in a Chart
    • 10.11. Formatting a Chart Element
    • 10.12. Handling Missing Data or Charting Hidden Data
    • 10.13. Inserting and Modifying Chart Legends
      • 10.13.1. Adding a legend to a chart
      • 10.13.2. Changing the names (titles) on a chart legend
    • 10.14. Modifying a Chart Axis
    • 10.15. Resizing, Moving, Copying, and Deleting an Embedded Chart
    • 10.16. Resizing, Moving, and Deleting a Chart Element
    • 10.17. Selecting a Chart Element
    • 10.18. Updating the Source Data Range for a Chart or a Data Series
    • 10.19. Using and Changing the Default Chart Type
  • 11. Working with Tables
    • 11.1. Anatomy of a Table
    • 11.2. Converting a Table to a Range
    • 11.3. Creating a Table
    • 11.4. Filtering Data in a Table
      • 11.4.1. Filtering based on individual column entries
      • 11.4.2. Filtering based on column data type
      • 11.4.3. Filtering based on cell color
    • 11.5. Formatting a Table
      • 11.5.1. Applying a new style to a table
      • 11.5.2. Formatting based on cell or column content
    • 11.6. Inserting a Totals Row in a Table
    • 11.7. Inserting and Deleting Table Rows and Columns
      • 11.7.2. Adding and deleting table rows
      • 11.7.2. Adding and deleting table columns
    • 11.8. Referencing Table Data in a Formula
      • 11.8.1. Referencing table data outside the table
      • 11.8.2. Referencing table data using a calculated column
    • 11.9. Removing Duplicate Values from a Table
    • 11.10. Selecting Table Areas
    • 11.11. Sorting Data in a Table
      • 11.11.1. Sorting a single column based on column values
      • 11.11.2. Sorting multiple columns based on column values
      • 11.11.3. Sorting based on a custom sort order
      • 11.11.4. Sorting based on color or conditional formatting icons
  • 12. Goal Seeking and What-If Analysis
    • 12.1. Creating Data Input Tables
      • 12.1.1. Creating a one-input table
      • 12.1.2. Creating a two-input table
    • 12.2. Finding Input Values that Produce the Desired Output
    • 12.3. Using Scenario Manager
      • 12.3.1. Creating a named scenario
      • 12.3.2. Creating a scenario summary report
      • 12.3.3. Displaying a named scenario
  • 13. Analyzing Data with PivotTables
    • 13.1. Anatomy of a PivotTable
    • 13.2. Changing the Summarization of a Value Field
    • 13.3. Creating a PivotTable Report
    • 13.4. Filtering a PivotTable Report
      • 13.4.1. Filtering a PivotTable based on individual field items
      • 13.4.2. Filtering a PivotTable based on field data type
      • 13.4.3. Pre-filtering a PivotTable
      • 13.4.4. Clearing PivotTable filters
    • 13.5. Formatting a PivotTable Report
      • 13.5.1. Applying a new style to a PivotTable
      • 13.5.2. Formatting based on data values
      • 13.5.3. Changing the number format of a PivotTable field
    • 13.6. Grouping PivotTable Items
      • 13.6.1. Creating a date group
      • 13.6.2. Creating a number group
      • 13.6.3. Creating a text group
    • 13.7. Modifying a PivotTable Report
      • 13.7.1. Modifying a report layout
      • 13.7.2. Modifying a report structure
      • 13.7.3. Displaying and hiding subtotals and grand totals
      • 13.7.4. Expanding and collapsing field item levels
    • 13.8. Refreshing a PivotTable Report
Online LIVE Training Programming Course offered by INCAPROG ONLINE - www.incaprog.com - contacto@incaprog.com - Phone : (954) 727-3141
  • Share this ad: pictute pictute pictute pictute
  • Print: pictute
  • Add to favorites: pictute
  • Report: pictute