Excel Skills | Excel 2010, 2007 & 2003 Training | Basic & Advanced Excel 2007 Training

This page contains a list of all our Excel 2007 tutorials in a Course based format. Click the orange links to view samples of some of the tutorials in a new browser window. The average video file size is 0.5MB and the average download time is less than 30 seconds. All our tutorials are based on a Flash video platform - if you experience any difficulty when attempting to view any of the sample videos, simply download the latest version of the Adobe Flash Player. Access to all our Excel training tutorials can be obtained by registering for an training membership and learning time can be verified by printing an online certificate. Our tutorials can also be listed in a category based format and a full range of Excel 2010 and Excel 2003 tutorials are also included in our training membership.


	Select Version:	Excel 2010	Excel 2007	Excel 2003	Select Layout:	Category Based	Course Based


	Basic Excel
	Get Familiar with Excel 2007 The Excel 2007 Environment Office Button Quick Access Toolbar Excel 2007 Ribbon (SAMPLE) Home Tab (SAMPLE) Insert Tab Page Layout Tab Formulas Tab Data Tab Review Tab View Tab Add-Ins Tab Help Icon	Using Excel 2007 Files Open Microsoft Excel 2007 Open a New Workbook Open an Existing Workbook Save a Workbook Copy a Workbook Convert to Excel 2003 File Convert from Excel 2003 File Close a Workbook Exit Excel Worksheet View Mode Change Worksheet Size Minimize / Maximize	Enter & Edit Data Enter Data Auto Complete Data Edit Data Move Cells Clear Cell Contents Undo and Redo Selecting Cells Insert Cells Insert Rows Insert Columns Delete Cells Delete Rows Delete Columns	Format Cells Format Font Format Text Size Bold / Italic / Underline Format Text Colour Format Cell Borders Format Cell Background Format Text Alignment Wrapping Text Merge / Unmerge Cells Format Numbers & Dates Other Formatting Features
	Format Rows & Columns Format Row Height Autofit Rows Format Column Width Autofit Columns Hide / Unhide Rows Hide / Unhide a Column	Formatting Themes & Styles About Themes (SAMPLE) Theme Colours Theme Fonts About Cell Styles Modify Cell Styles Create Custom Cell Styles Merge Cell Styles	Enter Formulas & Create Links Enter Formulas Create a Link Link to other Worksheets Relative & Absolute References Copy Links	Copy & Paste Data Copy Cells Paste Cells (normal) Paste Values Paste Formulas Paste Formats
	Worksheet Features Insert Delete Rename Copy Move Change Tab Color	Using Functions Insert a Function Select a Function Help with Functions Enter a Function Edit a Function Auto Sum Sum Values	Basic Date Functions Background on Dates Entering Dates & Times Current Date (SAMPLE) Date Components Convert Text to Dates Convert Dates to Month End Dates	Basic Text Functions Convert Text, Dates and Numbers Combine Text from Multiple Cells Text Display (upper/lower case) Remove Spaces from Text
	Basic Statistical Functions Counting Data (SAMPLE) Average Value Minimum Value Maximum Value	Page Layout & Printing Print a Worksheet Using Print Preview Set Page Orientation Select Paper Size Scale Worksheet to Printed Pages Set Print Margins Define Page Set-up	Window & Proofing Features Freeze Panes Switch Between Open Files Split Window Spelling Research Thesaurus Translation	Customize Excel 2007 Excel Ribbon Quick Access Toolbar (SAMPLE) Status Bar Windows Taskbar Properties Default Excel Settings

	Advanced Excel
	Enter, Edit & Copy Data Enter Data into Multiple Cells Selecting Multiple Cell Ranges Move Cells Between Worksheets Find Data Replace Data Paste Text Orientation Paste - Other Features Paste Options Button Office Clipboard Auto Fill	Edit & Maintain Links Copy & Paste to Create Links Link Cells to other Workbooks Update Links to other Workbooks Edit Links to other Workbooks Break Links Insert Hyperlink Remove Hyperlink	Workbook, Windows and Worksheet Features E-mail Excel Files Save Workbook as PDF Create New Windows Arrange Windows Hide / Unhide Workbooks Compare Side by Side Save Workspace (SAMPLE) Hide / Unhide Worksheets Select Multiple Worksheets	Page Layout & Printing Print a Selection Set Print Area Clear Print Area Repeat Rows on All Pages Repeat Columns on All Pages Print Multiple Worksheets Set Page Breaks Insert Header & Footer
	Formula Features Auditing Formulas Error Checking Evaluate Formulas Show Formulas Watch Cell Value Calculation Options	Using Named Ranges Define Named Ranges (SAMPLE) Create Multiple Names Paste Names into Formulas Enter Names in Formulas Edit Names of Ranges Edit Named Range Cells Apply Named Ranges Delete Named Ranges	Conditional Formatting Background (SAMPLE) Highlight Cells Top / Bottom Values Data Bars Colour Scales Icon Sets Identify Duplicate Values New Rules Using Formulas Clear Rules Manage Rules	Excel Charts Create a Chart (SAMPLE) Change Chart Type Move a Chart Format Chart Title Format Chart Legend Format Chart Plot Area Format Gridlines Format Axis Format Chart Area Edit Source Data Multiple Source Data Ranges Using a Secondary Axis Copy a Chart as a Bitmap
	Sort & Filter Data Sort Data on a Single Column Sort Data on Multiple Columns Apply a Data Filter Filter by Selected Cell Remove a Data Filter Sort Data with Filter Apply a Custom Filter Advanced Filter Removing All Filters	Data Tools Text to Columns Remove Duplicate Records Insert Data Validation Identifying Invalid Data Remove Data Validation Insert Drop-Down List Insert Subtotals Add Subtotal Level Remove Subtotals	Excel Tables About Excel Tables (SAMPLE) Insert Table Format as Table Remove Duplicate Records Insert Total Row Insert Calculated Column Convert Table to Cell Range Insert New Rows Insert New Columns Selecting Table Cells Structured Cell References	Pivot Tables & Pivot Charts Source Data Layout Create a Pivot Table (SAMPLE) Pivot Table Tools Tab Change Source Data Refresh a Pivot Table Change Pivot Table Layout Filter Pivot Table Data Pivot Table Data Drill-Down Pivot Table Format Values Pivot Table Field Settings Pivot Table Options Pivot Table Column Width Create a Pivot Chart
	Importing External Data About External Data Connections New Access Database Queries Using the Query Wizard Edit Database Queries Refresh Database Queries New Pivot Table Queries Edit Pivot Table Queries Refresh Pivot Table Queries	What-if Tools Using Goal Seek Data Table - One Variable Data Table - Two Variables Create Scenarios Show Scenarios Edit Scenarios Delete Scenarios Compare Scenarios	Protect & Share Workbooks Lock / Unlock Cells Protect Sheet Protect Workbook Control Workbook Access Share Workbook Track Changes	Comments & Objects Insert / Delete Comments Show / Hide Comments Insert Picture Insert SmartArt Object
	Functions - General * Wildcard Character ? Wildcard Character Common Formula Errors Analysis Toolpack	Math Functions Sum Filtered Data (SAMPLE) Absolute Values Rounding Values Integer Values Random Values Square Roots	Date Functions Using Month Names Using Weekdays Using Week Numbers Work Days Year Fractions	Text Functions Determine Text Length Extract Characters from Text Find Characters in Text Replace Characters in Text Search for Characters in Text
	Logical Functions IF Function Nesting IF Functions AND Function OR Function NOT Function	Lookup Functions Lookup Cell Values Lookup Cell Values by Column Lookup Cell Values by Row Link Cells and Change Orientation Offset Cell References Match Value in Cell Range Column Number Row Number	Information Functions Use Error Types Replace Blank Cells Replace Errors in Cells Replace #N/A Error (SAMPLE) Identify Logical Values Identify Numeric Values Identify Text Values Identify Non-Text Values Identify Data Type	Statistical Functions SUMIF Function COUNTIF Function SUMPRODUCT Function Sum Based on Multiple Criteria Median Value Mode Value
	Financial Functions Loan Repayment (SAMPLE) Loan Principle Amount Interest Rate Loan Period Principle Portion of Repayment Interest Portion of Repayment Cumulative Principle Repayment Cumulative Interest Repayment Future Value of Investment Savings Annuity Net Present Value Internal Rate of Return	Database Functions Syntax of Database Functions Count Records Average Field Value Maximum Field Value Minimum Field Value Single Record Values Sum Field Value Using Formulas in Sum Criteria

2012 © Excel-Skills.com. All rights reserved. \| Privacy Policy \| Submit Feedback


	Microsoft Excel Tutorials \| Excel 2007 \| Course Based This page contains a list of all our Excel 2007 tutorials in a Course based format. Click the orange links to view samples of some of the tutorials in a new browser window. The average video file size is 0.5MB and the average download time is less than 30 seconds. All our tutorials are based on a Flash video platform - if you experience any difficulty when attempting to view any of the sample videos, simply download the latest version of the Adobe Flash Player. Access to all our Excel training tutorials can be obtained by registering for an training membership and learning time can be verified by printing an online certificate. Our tutorials can also be listed in a category based format and a full range of Excel 2010 and Excel 2003 tutorials are also included in our training membership.	Links View the Excel 2007 video file specifications (PDF) More about the Features and Functions that are covered Try our Skills Test Training Membership Cost: R600 ($72 £46 €56) Register for a training membership