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 Advanced Training Course

Microsoft Excel 2007
Functions
            Excel 2007 Functions
            Getting help about using a particular function
            Using date and time functions: TODAY
            Using date and time functions: DAY
            Using date and time functions: MONTH
            Using date and time functions: YEAR
            Using mathematical functions: SUMIF
            Using mathematical functions: ROUND
            Using statistical functions: COUNT
            Using statistical functions: COUNTA
            Using statistical functions: COUNTIF
            Using text functions: PROPER
            Using text functions: UPPER
            Using text functions: LOWER
            Using text functions: CONCATENATE
            Using financial functions: FV
            Using financial functions: NPV
            Using financial functions: PMT
            Using financial functions: PV
            Using financial functions: RATE
            Using lookup and reference functions: HLOOKUP
            Using lookup and reference functions: VLOOKUP
            Using logical functions: IF
            Using logical functions: AND
            Using logical functions: OR
            Using logical functions: ISERROR
            Using database functions: DSUM
            Using database functions: DMIN
            Using database functions: DMAX
            Using database functions: DCOUNT
            Using nested functions
Using one-input or two-input Data tables / What-if tables
            Using a one input Data Table command
            Using a two input data table command
A first look at Pivot Tables
            Creating a PivotTable
            Dropping data into the Pivot Table
            Modifying data and refreshing the Pivot Table
            Grouping data within a Pivot table
Scenarios
            Scenario Manager - an example
            Showing a scenario
            Viewing an alternative scenario
            Create a scenario summary
Auditing
            Tracing precedent cells
            Tracing the dependants of a cell
            Displaying all formulas within a worksheet
            Adding comments
            Displaying comments
            Removing comments
            Editing comments
Macros
            Displaying the Developer tab
            Recording and running macros
            Lowering your macro security level
            Customizing the Quick Access Toolbar
            Changing the Quick Access Toolbar Macro icon
            Removing a macro icon from the Quick Access Toolbar
            Raising your macro security level

    

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