Free Microsoft Excel Data Analysis Training

Microsoft Excel 2003 | 2007 | 2010

John Donovan, consultant and instructor at www.TeachMSOffice.com has an innate ability to take very complex Microsoft Excel topics and make them easy and simple to understand.

Intermediate and Advanced Microsoft Excel 2007 | 2010

NOTE: If your IT department restricts access to YouTube, you will have difficulty reviewing these tutorials.

Data Analysis in Microsoft Excel

Excel Data Analysis 1 - Move Data from Rows to Columns - Transpose Data in Excel
Excel Data Analysis 2 - Import CSV Files into Excel
Data Analysis in Excel 3 - Filter Large Data Sets to Display Only Specific Information

Data Analysis in Excel 4 - Sort Large Data Sets to Display Ordered Information
Data Analysis in Excel 5 - Remove Duplicate Entries from Data Sets in Excel
Data Analysis in Excel 6 - Fix Broken Links in Excel Check Data Connections to Other Files

Data Analysis in Excel 7 - Quickly Import XML Files and Data into Excel
Data Analysis in Excel 8 - Import XML Maps and Pull Selected Columns Values into Excel
Data Analysis in Excel 9 - Filter Data Based on The First, Last, or Middle Values in a Cell in Excel
 


Free Computer Training Videos Available 24/7/365

INTRODUCTION TO COMPUTERS
Basics: Computers 101
Introducing Windows 8

THE INTERNET

Google Search Tips
Free Google Tools
YouTube Tips
Facebook
Twitter

SALES & ACCOUNTING

ACT!
QuickBooks 2013
QuickBooks 2006 to 2012

MICROSOFT OFFICE
2007 & 2010

The Ribbon & more
Microsoft Word
Microsoft Outlook
Microsoft PowerPoint

EXCEL

Microsoft Excel: Introduction
Microsoft Excel: Advanced
Excel Dates
Excel Charts & Graphs
Excel VBA & Macros
Excel Finance Basics
Excel Data Analysis
Excel Data Validation
Excel Printing
Excel Functions & Formulas
Excel Formatting
Excel Lookup & Search
Excel VLookup & HLookup

ACCESS & PUBLISHER

Microsoft Access
Microsoft Publisher

WEB DESIGN
Microsoft Expression
Photoshop

MICROSOFT OFFICE 2003
Microsoft Word 2003
Microsoft Excel 2003
Microsoft Outlook 2003
Microsoft PowerPoint 2003

APPLE IPHONE TRAINING

iPhone Tips and Tricks

FREE RESOURCES
Khan Academy