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 2003 Expert Training Course

Excel 2003
Functions and Formulas.
      Getting Help with Functions.
      Inserting the current time and date.
      Time & Date functions - TODAY.
      Time & Date functions - NOW.
      Time & Date functions - DAY.
      Time & Date functions - MONTH.
      Time & Date functions - YEAR.
      Mathematical functions - ROUND.
      Mathematical functions - ROUNDDOWN.
      Mathematical functions - ROUNDUP.
      Logical functions - IF.
      Logical functions - AND.
      Logical functions - OR.
      Mathematical functions - SUMIF.
      Statistical functions - COUNT.
      Statistical functions - COUNTA.
      Statistical functions - COUNTIF.
      Statistical functions - COUNTBLANK.
      Statistical functions - RANK.
      Text functions - LEFT.
      Text functions - RIGHT.
      Text functions - MID.
      Text functions - TRIM.
      Text functions - CONCATENATE.
      Financial functions - FV.
      Financial functions - PV.
      Financial functions - NPV.
       Financial functions - RATE.
      Financial functions - PMT.
      Lookup functions - VLOOKUP.
      Lookup functions - HLOOKUP.
      Database functions - DSUM.
      Database functions - DMIN.
      Database functions - DMAX.
      Database functions - DCOUNT.
      Database functions – DAVERAGE
      Nested functions.
      Consolidating data using a 3-D reference within a sum function.
      Mixed references within formulas.
Named Ranges.
      Naming cell ranges.
      Removing the name given to a cell range.
      Using named cell ranges within a function.
Security.
      Adding 'open' password protection to a workbook.
      Adding 'modify' password protection to a workbook.
      Removing an 'open' password from a workbook.
      Removing a 'modify' password from a workbook.
      Password protecting cells and worksheets.
      Hiding formulas.
      Un-hiding formulas.
Cell Formatting.
      AutoFormat.
      Conditional formatting.
      Custom number formats.
Manipulating Worksheets.
      Copying worksheets within a workbook.
      Moving worksheets within a workbook.
      Copying worksheets between workbooks.
      Moving worksheets between workbooks.
      Splitting a Window.
      Hiding rows.
      Hiding columns.
      Hiding worksheets.
      Un-hiding rows.
      Un-hiding columns.
      Un-hiding worksheets.
Templates.
      Using templates.
      Creating Excel templates.
      Editing templates.
Paste Special Techniques.
      Using Paste Special to add, subtract, multiply & divide.
      Using Paste Special “values’.
      Using Paste Special transpose option.
Pivot Tables.
      Creating and using a pivot table.
      Filtering and sorting data within a pivot table.
      Automatically grouping data in a pivot table and renaming groups.
      Manually grouping data in a pivot table and renaming groups.
Input Tables
      One-input data tables.
      Two-input data tables.
Charts.
      Creating a combined line and column chart.
      Adding a secondary axis to a chart.
      Changing the chart type for a particular data series.
      Adding a data series to a chart.
      Removing a data series from a chart.
      Re-positioning chart title.
      Re-positioning the chart legend.
      Moving and formatting chart data labels.
      Modifying chart axis scales.
      Formatting an axis to display using commas.
      Inserting images into chart columns.
      Inserting images to chart bars.
      Formatting the chart plot area using a picture.
      Formatting the chart area using a picture.
Hyperlinks
      Hyperlinks.
Linking & Embedding.
      What is embedding and linking?
      Linking data within a worksheet.
      Linking cells between worksheets within a workbook.
      Linking data between workbooks.
      Linking data from Excel to a Word document.
      Linking an Excel chart to a Word document.
      Updating, locking and breaking links.
Importing Text Files
       What is a delimited text file?
      Importing a delimited text file.
Sorting and Filtering Data.
      Sorting data by multiple columns at the same time.
      Applying a pre-installed custom sort.
      Creating a customized list and performing a custom sort.
      Removing a customized list.
      Using AutoFilter.
      Using AutoFilter to perform multiple queries.
      Top 10 AutoFilter.
      Removing all AutoFilters from a worksheet.
      Advanced Filter Criteria.
      Sub-totaling.
      Removing subtotals.
      Expanding and collapsing outline detail levels.
Tracking, sharing, comparing and merging worksheets.
      Enabling or disabling the 'tracking changes' feature.
      Sharing, comparing and merging worksheets.
Scenarios.
      Scenario Manager.
      Scenario summary reports.
Validating.
      Data validation - Whole number.
      Data validation - Decimal number.
      Data validation - List.
      Data validation - Date.
      Data validation - Time.
      Data validation - Text Length.
      Customizing a validation input message and error alert.
      Removing data validation.
Auditing.
      Tracing precedent cells (the hard way).
      Tracing precedent cells (the easy way).
      Tracing dependent cells.
      Identifying cells with missing dependents.
      Showing all formulas in a worksheet, rather than the resulting values.
      Inserting and viewing comments.
      Editing and deleting comments.
      Showing and hiding comments.
Macros.
      Macros and Security Considerations.
      Recording and running a macro to change the page set-up.
      Recording and running a macro to apply a custom number format.
      Recording and running a macro to apply AutoFormat to a cell range.
      Recording and running a macro to insert fields into the header or footer.
      Assigning a macro to a custom button on a toolbar.
      Removing a custom button from a toolbar.
      Deleting macros.

    

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