Free Microsoft Office Training and MS Windows Training
HOME  |  Premium Edition IT Training Courses  |  FAQs  |  Schools, Colleges & Computer Training Companies  |  Contact Us  | Terms  |  Link to Us 

Free computer tutorials & full computer training courses, inc. Microsoft Word training, Excel training & MS Project training.  Other IT training courses include Microsoft Windows.

 

FREE 
Online Computer Training Courses for Microsoft Office and Microsoft Windows

Excel 2007 Intermediate Tutorial

Microsoft Excel 2007
Manipulating Data & Named Ranges
      Paste Special Techniques
            Paste Special
            Transposing data
      Importing a text file and delimit by comma, space or tab
            Importing text and delimiting by space, comma or tab
      Named ranges
            What does naming a cell range mean?
            Rules for naming cells and ranges
            Naming cell range(s) in a worksheet
            Named ranges within formulas
            Navigating through workbooks using named ranges
            Creating named ranges automatically based on cell values
            Deleting named cells/ranges
      Sub-totaling
            Creating subtotals
            Removing subtotals
Templates
            Using templates
            Creating templates
            Opening and editing templates
Formatting & Display Techniques
      Cell Styles
            Formatting tables
      Table Styles
            Formatting tables using table styles
      Conditional Formatting
            Formatting cell ranges using conditional formatting
      Custom number formats
            Creating custom number formats
      Freezing row and column titles
            Freezing the top row
            Freezing the first column
            Freezing the top row and the first column at the same time
      Hiding and un-hiding rows and columns
            Hiding and un-hiding rows
            Hiding and un-hiding columns
      Hiding / un-hiding worksheets
            Hiding and un-hiding worksheets
Sorting and Querying Data
      Sorting data by multiple columns
            Sorting internal Excel databases
      Custom sorts
            Custom sort options
      Using AutoFilter
            Using AutoFilter to query data
            Multiple queries
            Removing filters
            Top 10 AutoFilter
      Using advanced query / filter options
            Filtering unique records
            Advanced Filter
Linking & Consolidating Data
      Linking data or a chart within a worksheet
            Linking individual cells within a worksheet
            Linking charts to data within a worksheet
      Linking data or a chart between worksheets [within a workbook]
            Linking a cell range on one worksheet to another worksheet (within the same workbook)
            Linking data on one worksheet to a chart in another worksheet (within the same workbook)
      Linking data or a chart between spreadsheets [workbooks]
            Linking data from one workbook to another
            Linking a chart from one workbook to another
      Linking data or a chart into a word processing document
            Copying data from Excel into a Word document
            Linking data from Excel into a Word document
            Copying a chart from Excel into a Word document
            Linking a chart from Excel into a Word document
      Consolidating data in adjacent worksheets using a 3D sum function
            Consolidating data over several worksheets or worksheet pages
Charts Formatting Techniques
            Changing the angle of pie chart slices
            Formatting the chart axis fonts
            Formatting the chart axis scales
            Formatting the chart axis text orientation
            Creating and positioning a chart title
            Re-positioning a chart legend
            Re-positioning chart data labels
            Exploding the segments within a pie chart
            Deleting a data series within a chart
            Adding a data series to a chart
            Modifying the chart type for a defined data series
            Widening the gap between columns / bars within a 2-D chart
            Inserting an image into a 2D chart (as a background)
            Inserting an image into a 2D chart (to format a column or bar of data)
Protection and Security
      Workbook password protection
            Specifying a password for opening a workbook
            Using the “read-only recommended” option
            Removing a password from an Excel workbook
      Protecting / un-protecting a worksheet with a password
            Protecting a worksheet or worksheet elements
            Removing workbook protection
            Allowing selective editing of a protected worksheet

    

FOR INDIVIDUAL USE ONLY – NOT TO BE DOWNLOADED
Copyright 'Best Computer Training Courses' - www.BestComputerTrainingCourses.com

Microsoft Excel Training Courses

Other Computer Tutorials

 
 

 
 

Free Microsoft Office & Microsoft Windows computer training courses inc. Microsoft Word training courses, Excel training courses, PowerPoint training courses.  Microsoft Office 2010 & Windows 7 manuals also available. 
© 2011 Best Computer Training Courses - Search Engine SEO by http://www.WebSiteSEOAustralia.com.au

  

www.BestComputerTrainingCourses.com