Excel Skills | Excel 2010, 2007 & 2003 Training | More than 340 practical Excel 2010 tutorials

This page contains a list of all our Excel 2010 tutorials in a Category 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 course based format and a full range of Excel 2007 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


	Get Familiar with Excel 2010 The Excel 2010 Environment Quick Access Toolbar Excel 2010 Ribbon (SAMPLE) File Tab Home Tab (SAMPLE) Insert Tab Page Layout Tab Formulas Tab Data Tab Review Tab View Tab Add-Ins Tab Help Icon	Using Excel 2010 Files Open Microsoft Excel 2010 Open a New Workbook Open an Existing Workbook Save a Workbook Copy a Workbook Convert to Excel 2003 File Convert from Excel 2003 File Save Workbook as PDF Close a Workbook E-mail Excel Files Exit Excel	Customize Excel 2010 Excel Ribbon Quick Access Toolbar (SAMPLE) Default Excel Settings Worksheet View Mode Change Worksheet Size Minimize / Maximize Status Bar Windows Taskbar Properties	Enter Data / Select Cells Enter Data Enter Data into Multiple Cells Auto Complete Data Enter Formulas Selecting Cells Selecting Multiple Cell Ranges
	Edit Data Edit Data Clear Cell Contents Move Cells Move Cells Between Worksheets Undo and Redo Find Data Replace Data	Insert / Delete Data Insert Cells Insert Rows Insert Columns Delete Cells Delete Rows Delete Columns	Copy & Paste Data Copy Cells Paste Cells (normal) Paste Values Paste Formulas Paste Formats Paste Text Orientation Paste - Other Features Paste Options Button Office Clipboard Auto Fill	Format Cells Format Font Format Text Size Bold / Italic / Underline Format Text Colors Format Cell Borders Format Cell Background Format Text Alignment Wrapping Text Merge / Unmerge Cells Format Numbers & Dates Other Formatting Features
	Themes, Styles & Pictures About Themes (SAMPLE) Theme Colours Theme Fonts About Cell Styles Modify Cell Styles Create Custom Cell Styles Merge Cell Styles Insert Picture Insert SmartArt Object	Row / Column Formatting Format Row Height Autofit Rows Format Column Width Autofit Columns Hide / Unhide Rows Hide / Unhide a Column	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	Formulas & Links Create a Link Relative & Absolute References Copy Links Link to other Worksheets 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
	Worksheets Insert Delete Rename Copy Move Hide / Unhide Change Tab Color Select Multiple Worksheets	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	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	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

	Sparklines Insert a Sparkline (SAMPLE) Insert a Sparkline Group Copy Sparklines Group Sparklines Change Sparkline Type Change Sparkline Data Format Sparklines Sparkline Axis Options Switch Rows / Columns Hidden & Empty Cells Delete Sparklines	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	Pivot Table Slicers Create a Slicer (SAMPLE) Create Multiple Slicers Using Slicers Format Slicers Slicer Settings Share Slicers Disconnect Slicers Delete Slicers	Page Layout / Printing Print a Worksheet Using Print Preview Set Page Orientation Select Paper Size Scale Worksheet to Printed Pages Set Print Margins Repeat Rows on All Pages Repeat Columns on All Pages Set Page Breaks Define Page Set-up Print Multiple Worksheets Print a Selection Set Print Area Clear Print Area Insert Header & Footer
	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	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	What-if Tools Using Goal Seek Data Table - One Variable Data Table - Two Variables Create Scenarios Show Scenarios Edit Scenarios Delete Scenarios Compare Scenarios	Proofing & Comments Spelling Research Thesaurus Translation Insert / Delete Comments Show / Hide Comments
	Protect / Share Workbooks Lock / Unlock Cells Protect Sheet Protect Workbook Control Workbook Access Share Workbook Track Changes	Window Options Freeze Panes Switch Between Open Files Create New Window Arrange Windows Hide / Unhide Workbooks Compare Side by Side Split Window Save Workspace (SAMPLE)	Formula Options 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
	Using Functions Insert a Function Select a Function Help with Functions Enter a Function Edit a Function * Wildcard Character ? Wildcard Character Common Formula Errors	Math Functions Auto Sum Sum Values Sum Filtered Data (SAMPLE) Absolute Values Rounding Values Integer Values Random Values Square Roots	Date Functions Background on Dates Entering Dates & Times Current Date (SAMPLE) Date Components Convert Dates to Month End Dates Using Month Names Using Weekdays Using Week Numbers Convert Text to Dates Work Days Year Fractions	Text Functions Convert Text, Dates and Numbers Combine Text from Multiple Cells Text Display (upper/lower case) Remove Spaces from Text 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 Counting Data (SAMPLE) Average Value Minimum Value Maximum Value 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 2010 \| Category Based This page contains a list of all our Excel 2010 tutorials in a Category 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 course based format and a full range of Excel 2007 and Excel 2003 tutorials are also included in our training membership.	Links View the Excel 2010 video file specifications (PDF) More about the Features and Functions that are covered Try our Skills Test Training Membership Cost: R600 ($79 £50 €60) Register for a training membership