Here 8 Excel 2007 Tutorials, hosted by the University of the Incarnate Word. These Excel tutorials introduce and demonstrate many of the most important Excel features, including how to create charts, using vertical lookups, page setup, creating formulas, and using database functions. These Excel tutorials are well illustrated with screen shots, and include exercises that will help you remember what you are learning. The necessary documents for the exercises can be downloaded from here.


Excel 2007  3.37 MB, 69 pages
This presentation introduces Excel 2007’s new features, such as Quick Access Toolbar, MS Office Button, Mini Toolbar & Ribbon.

Excel 2003 & 2007 Comparison
This document explains the differences between Excel 2003 and Excel 2007 by comparing the Menus and toolbars in Excel 2003 with the Excel 2007 Button and Ribbon.

Formatting Excel Worksheets  1.26 Mb, 22 pages
This Excel tutorial teaches how to Format Excel Cells, Columns, Rows, Worksheets, and Workbooks.

Vertical Lookup in Excel  223 Kb, 4 pages
This tutorial presents the vertical look up feature available in Excel 2007.

Creating Excel Charts  535 Kb, 11 pages
This Excel Chart tutorial teaches how to create an attractive and useful chart in Excel 2007.

Page Setup and Other Functions  1.04 Mb, 16 pages
Learn how to setup Excel pages using the page break, margins, headers and footers.

Excel Database Functions  339 Kb, 7 pages
This Excel tutorial explains the database functions such as sort and auto filter.

Excel Formulas   794 Kb, 17 pages
Describes the a variety of tools available in the formula tab and how to use the formulas effectively in Excel worksheets.

Popularity: 54% [?]

Update: Here are 7 more Microsoft Office eBooks, covering Excel, Word, Access, PowerPoint, and Project. The first 3 are in Windows Help format (chm) and the last for are in pdf format.


 - Excel ebook

 - Word ebook

 - Microsoft Access ebook

 - Powerpoint 2003 ebook

 - Microsoft Project 2003 ebook

 - Microsoft Office 2003 ebook

 - Microsoft Office 2007 ebook

Here are 10 eBooks covering Microsoft Office, Excel, Access, and Project.


 - Excel 2003 ebook 1
 - Excel 2003 ebook 2
 - Excel 2003 Programming ebook 1
 - Excel Programming ebook 2

 - Microsoft Office 2003 ebook 1
 - Microsoft Office 2003 ebook 2

 - Microsoft Access 2003 ebook 1
 - Microsoft Access 2003 ebook 2
 - Microsoft Access 2003 ebook 3

 - Microsoft Project 2003 ebook

Popularity: 55% [?]

Here are 4 Video Excel Tutorials that demonstrate and teach some of the fundamental features of Excel, so you can get up to speed and start using this spreadsheet application quickly and effectively.


Screen display, cursors, worksheets (5:48 min.)
This video Excel tutorial deals with screen display, cursors and worksheets.

Formatting cells, inserting rows and columns (7:43 min.)
The features that are covered in this video Excel  tutorial are formatting cells and inserting rows and columns.

Formatting, sorting, and auto-filling data (5:01 min.)
This video Excel  tutorial shows how to do formatting, sorting, and auto-filling data.

Formulas and functions (1:34)
You will get to know about the usage of formulas and functions in this video tutorial.

Popularity: 23% [?]

Here are 4 Excel 2007 Tutorials, located at Orbit Computer Solutions. These Excel tutorials explain and cover several Excel features, including: creating a workbook, editing data in a spreadsheet, and modifying a worksheet. Each feature and scenario demonstrated is described with screenshots to help you understand how to do it yourself.


Getting Stated With Excel 2007
This Excel tutorial will give you an introduction to the world of Excel 2007.
 
 - The Microsoft Office Button  
 - The Ribbon  
 - Quick Access Bar


How To Create A Workbook
Here you will learn how to work with Workbooks in Excel 2007. Various functionalities like creating, saving, opening and entering data on a spreadsheet are explained here.
 
 - Working With A Workbook  
 - How To Create Workbook Using Template  
 - How To Save A Workbook  
 - How To Open An Existing Workbook  
 - How To Enter Data On A Spreadsheet


How To Edit Data In an Excel Spreadsheet
In this Excel tutorial you will learn how to edit data in a Spreadsheet.
 
 - Selecting Data, Cell, Columns  
 - How To Copy And Paste  
 - How To Cut And Paste  
 - How To Edit Cell Content  
 - How To Undo And Redo Changes  
 - How To Use Auto fill


Modifying A Worksheet
In this Excel tutorial, we are explaining how to modify data in a worksheet by inserting cells, rows and columns, using spell check and find replace tools.
 
 - How To Insert Cells, Rows, And Columns  
 - How To Use Find And Replace  
 - How To Use Spell Check

Popularity: 23% [?]

Here are two good video tutorials for 10 Excel Tips that Speed up Spreadsheets. Excel is a spreadsheet application from Microsoft that features calculations, graphing tools, pivot tables and a macro programming language called VBA. These two video tutorials explain various features in Excel, such as data entry; moving multiple cells, columns and rows; formatting, charting, inserting line breaks and graphics, and editing strings using functions.


10 Excel Tips to Make Your Life Easier – Part 1
This Excel video tutorial explains how to handle bulk data entry, inserting rows and columns, moving data and utilizing the format painter and format copy tool.

 - Master the Art of Bulk Entry
 - Quickly Inserting Rows & Columns
 - Moving Your Data Around in One Shot
 - Utilize the Format Painter & Format Copying
 - Taking the “Work” out of Worksheets


10 Excel Tips to Make Your Life Easier – Part 2
This video tutorial discusses the use of charts, working with repeated data, inserting line breaks, working with dates, inserting a picture and manipulating strings with functions.

 - Utilizing Quick Charts
 - Easily Remove Repeated Data
 - Inserting Line Breaks & Today’s Date in a Cell
 - Insert a Picture in a Comment
 - Manipulating Strings with Functions

Popularity: 65% [?]

Here are some very good tutorials on Word, Excel, and MS Office, hosted by University of Florida. These Word, Excel, and Office tutorials discuss and demonstrate the important features of Microsoft Word, Excel and Office that combine together to provide users with a powerful word editing application and a spreadsheet program. These Office tutorials can be downloaded (doc and ppt formats) and saved for later reference.


Microsoft Office: Word and Excel 531 Kb, 22 pages)
This Word and Excel tutorial discusses features such as tables, toolbars, cell addresses, splitting cells and complex cell manipulation.

 - Word Tables
 - Word Tables and Borders Toolbar
 - Math in Word Tables
 - Math in Excel
 - Order of Operations
 - Cell Addresses
 - Splitting Cells in Microsoft Word
 - Dealing with Complex Cells in Microsoft Word
 - Splitting Cells in Microsoft Excel (Text to Columns)
 - Dealing with Complex Cells in Microsoft Excel


Microsoft Office 2003: Word and Excel  (538 Kb, 23 pages)
This Word and Excel tutorial explains features in Microsoft Office 2003, including math functions in Word and Excel, splitting cells, complex cell manipulation and the creation of tables.

 - Creating Tables
 - Tables and Borders Toolbar
 - Math in Word Tables
 - Math in Excel
 - Functions
 - Splitting Cells in Microsoft Word
 - Dealing with Complex Cells in Microsoft Word
 - Splitting Cells in Microsoft Excel (Text to Columns)
 - Dealing with Complex Cells in Microsoft Excel


Microsoft Office: Drawing Toolbar  (372 Kb, 15 pages)
This tutorial discusses the drawing toolbar in Microsoft Office with its autoshapes, the draw menu, wrapping text around objects and tips and tricks for drawing objects.

 - Drawing Toolbar
 - AutoShapes
 - The Draw Menu
 - Wrapping Text Around Objects in Word 97
 - Wrapping Text Around Objects in Word 2000
 - Tips and Tricks for Graphics and Drawing Objects


Microsoft Office Overview  (719 Kb, 23 slides)
This PowerPoint presentation is a handout of the features of Microsoft Office and its applications.


Microsoft Office Overview  (2.7 Mb, 23 slides)
This PowerPoint presentation provides an in-depth overview of Microsoft Office and its applications.

 - Word
 - Excel
 - PowerPoint
 - Access

Popularity: 62% [?]

Here are 11 excellent Excel 2007 Tutorials, at the University of Florida, that discuss and present many of Excel’s important features. These Excel turorials, as handouts and notes, cover calculations, navigation, graphing and charting, pivot tables, printing, and sorting and filters. They are in pdf format, and can be downloaded and saved for later reference.


Charts Handout  (918 Kb, 15 pages)
This is a handout that discusses how and why charts are created and used for communicating and presenting things.

Charts Notes  (31 Kb, 3 pages)
This Word document contains important notes on Excel charts and how they are used to represent important details.

Math & Fun Handout  (194 Kb, 11 pages)
This handout discusses math functions used in Excel to carry out calculations from raw data.

Mult Handout  (348 Kb, 11 pages)
This handout demonstrates to users how to use multiple spreadsheets and worksheets.

Mult Notes  (28 Kb, 3 pages)
This Word document provides users with notes and tips on how to use multiple worksheets in Excel.

Nav & Form Handout  (446 Kb, 21 pages)
This handout discusses the navigation and formatting, including moving between cells and editing data.

Nav & Form Notes  (58 Kb, 7 pages)
This Word document provides important notes for users regarding navigation and formatting in Excel 2003.

Pivot Tables Handout  (324 Kb, 14 pages)
This handout explains to users what Pivot tables, how to create them and how they work.

Print Handout  (603 Kb, 16 pages)
This handout explains to users how the Print function works in Excel 2003 and how printing can be customized to suit ones needs.

Print Notes  (44 Kb, 5 pages)
These notes on printing in Excel 2003 offer users quick tips and trick that can be used to suit their printing styles.

Sorting & Filters  (203 Kb, 9 pages)
This tutorial imparts knowledge on how sorting is done in Excel 2003 and how filters can be applied on raw data to get the desired results.

Popularity: 38% [?]

Here are 14 excellent Excel Tutorials, hostsed by the University of Florida. These tutorial handouts and notes discuss and teach many important features of Excel 2003, including calculations, graphing tools, pivot tables, printing, sorting and filters, and macros. These Excel 2003 tutorials are in .doc format, and can be downloaded and saved for later reference.


14 Microsoft Excel 2003 Tutorials:

 - Charts Handout 339 Kb, 14 Pages
 - Forms Handout 120 Kb, 7 pages
 - Macros Handout 145 Kb, 10 Pages
 - Macros Notes 35 Kb, 3 Pages
 - Math & Fun Handout 170 Kb, 11 Pages
 - Math & Fun Notes 73 Kb, 10 Pages
 - Mult Handout 177 Kb, 10 Pages
 - Mult Notes 29 Kb, 2 Pages
 - Navigation & Forms Handout 289 Kb, 17 Pages
 - Navigation & Forms Notes 57 Kb, 7 Pages
 - Pivot Tables Handout 377 Kb, 13 Pages
 - Print Handout 292 Kb, 14 Pages
 - Print Notes 39 Kb, 4 Pages
 - Sorting & Filters Handout 179 Kb, 8 Pages

Popularity: 42% [?]

Here are some excellent Excel Course Tutorials, at the University of Minnesota, that provide information on the new features of Excel 2007, its uses, its advantages over the existing versions of Excel, working with Excel charts in Word or PowerPoint, the different formulae used in Excel cells and how to effectively manage and analyze data. The first three tutorials below are in pdf format.


Excel New Features Tutorial  (761 Kb, 7 pages)
This document discusses the new features of Excel 2007 such as formatting itemized lists, creation of charts, using conditional formats and creating pivot tables.


Excel Treasure Hunt  (240.54 Kb, 2 pages)
This 2 page pdf document allows users to guess the features that users have learned so far and this is done using a clue for each feature of Excel.


Pasting Excel Charts in Word or PowerPoint  (117.20 Kb, 2 pages)
This Excel tutorial explains how to use and embed Excel charts and worksheet data in Word and PowerPoint.


Class Files (.zip)
This section contains downloadable zip files that contain spreadsheet that will help you learn spreadsheet basics, and how to manage and analyze data using Excel.

 - Excel 2007: Managing and Analyzing Data
 - Excel 2007: Spreadsheet Basics

Popularity: 18% [?]

Here are 9 Excel Tutorials at California Polytechnic State University that discuss various features of Excel that make it such a useful spreadsheet application. These features include chart creation, application of formulas, creating functions, cell formatting, effectively using the IF function, and working with templates and spreadsheets. Each of these Excel tutorials are in pdf format, so they can be downloaded for later reference and use.


9 Excel Tutorials:

Excel Tutorial 1 - Introduction  (208 Kb, 8 pages)
This tutorial introduces Excel’s features, how to chart values, keyboard shortcuts and working with worksheets. All these features are explained with appropriate diagrams.

Excel Tutorial 2 - Simple Formulas & Absolute/Relative Cell References  (103 Kb, 5 pages)
This tutorial provides users with information about formulas, the operators that can be used in formulas, and their related functions with absolute and relative cell references.

Excel Tutorial 3 – Data Forms and Creating Charts  (113 Kb, 4 pages)
This tutorial discusses the use data forms, how to create them and use them effectively. Chart creation and its implementation are also discussed.

Excel Tutorial 4 - Formatting and Formulas  (306 kb, 10 pages)
This tutorial explains how to work with formulas and formatting them to calculate values provided in the cells. Also discussed are triggers that cause certain actions on the screen when the result of the formula matches an expected result.

Excel Tutorial 5 - Formulas and Functions  (167 Kb, 6 pages)
This tutorial teaches the use of functions to perform calculations by using specific values passed to them. These values are the function’s parameters and the calculations are carried out based on their values.

Excel Tutorial 6 - nVision  (290 Kb, 10 pages)
This tutorial explains the nVision concept which can be achieved by splitting the view in Excel to hold many views with calculations. This provides a multi-dimensional approach when viewing multiple cells.

Excel Tutorial 7 – Using the IF and Nested IF Function  181 Kb, 8 pages)
This tutorial describes the IF function with its related operators and conditions. Also discussed are the nested IF function where multiple IF statements are used to sift between available options.

Gradebook Template  (28 Kb)
This simple template created in Excel is for users to work with when working on calculations. This template is that of a class record with student name and their marks in different exams

Grading Spreadsheet  (22 Kb)
This spreadsheet template uses calculates the grades of various students based on the marks obtained in various subjects. This is a simple template for users to work on and learn the basics of Excel.

Popularity: 28% [?]

These 5 Microsoft Excel 2003 Tutorials from the University at Albany explain the power of Excel by discussing its important features such as data manipulation, formulas and efficiency, formatting, page setup and print options. These features, along with filtering, sorting and presentation have made Excel the de-facto spread sheet application to work with. (these tutorials are in .doc format)


5 Excel Tutorials:

Excel 2003 I : Introduction, Menus, Toolbars & Selections
This tutorial teaches Excel’s menus, toolbars and selections along with rows, columns, cells, and formulas.

Excel 2003 II : Data, Formulas & Efficiency
This Excel tutorial explains spreadsheet components, their purposes and properties which include formulas, functions, problem solving and workbooks.

Excel 2003 III : Multi Sheet Workbook Creation
This Excel tutorial describes workbook creation, design, maintenance and usability. Workbooks are primarily used as an analysis tool to decide performance, growth, sales etc.

Excel 2003 IV : Design and Formatting
This tutorial teaches the design and formatting of the spreadsheet which includes colors, borders, shading, alignment and fonts.

Excel 2003 V : Page Set Up, Print Area, Options & Security, Filtering and Sorting, and Presentation Charts
This Excel tutorial demonstrates printing options, the page layout, filtering and sorting of the spreadsheet data.

Popularity: 28% [?]

Here are 11 Excel Tutorials at nicetutz.blogspot.com that cover several Excel features, including Excel 2007 and Excel XP templates, working with spreasheet files, protecting data, and creating charts. These Excel tutorials also show how to print and manage workbooks in Excel 2007; navigating, searching, and formatting spreadsheets; the top new features in Excel 2007; shortcut keys for Excel; and tips for using Excel 2007.  Most of these tutorials are for Excel 2007.


What are Templates in Excel 2007
These Excel tutorials teach you templates in Excel 2007. Some of the topics covered here are workbook tem;plates, custom Excel templates, working with default templates, print setting using template, creating custom templates, creating and using a chart template.

 - What are Templates
 - Exploring Excel Files
 - Working with Workbook Templates
 - Understanding Custom Excel Templates
 - Working with Default Templates
 - Print Setting Using Template
 - Creating Custom Templates
 - Ideas for Creating Templates
 - Sharing Templates with Others
 - Controlling Styles with Templates
 - Locking Formula Cells in Template File
 - Creating and Using a Chart Template


What are Templates in Excel XP
These tutorials cover topics such as creating templates, workbook templates, creating default workbook template, creating custom templates, locking formula cells etc.

 - What are Templates
 - How to Create Templates
 - Working with Workbook Templates
 - Understanding Custom Excel Templates
 - Creating a Default Workbook Template
 - Changing Default Print Setting Using a Template
 - Creating Custom Templates
 - Learn About Style
 - Locking Formula Cells in Template File


Working with Excel 2007 Files
These tutorials on Excel explain working with Excel 2007 files. The various topics covered here are select commands with keyboard, quick access toolbar button, saving a workbook, using auto recover, specifying workbook properties and password, renaming a file etc.

 - Working with Excel Files
 - Open and Explore Excel
 - Select Commands with Keyboard
 - Quick Access Toolbar Button
 - Change Status Bar Indicators
 - Create New Excel File
 - Save a Workbook
 - Using AutoRecover
 - Open an Existing Excel File
 - Opening Workbooks Automatically
 - Rename a File
 - Specify Workbook Properties
 - Specify a Password
 - Safeguarding your Work


Protecting Excel 2007 Data
The below Excel tutorials discuss protecting Excel 2007 data. The topics covered here are quickly hiding an opened workbook, making a file read-only, hide and unhide columns and rows, unlocking cells, using digital signatures etc.

 - Protecting Excel Data
 - Quickly Hide an Open Workbook
 - Make a File Read-Only
 - Mark a Workbook as Final
 - Inspecting a Workbooks
 - Hide and Unhide Columns and Rows
 - Unlock Cells
 - Protect Worksheets
 - Restrict User Data Entry
 - Assign a File Password
 - Hide Cell Formulus
 - Protecting a Workbook’s Structure
 - Using a Digital Signature
 - Signing a Workbook


Creating Charts in Excel 2007
These tutorials deal with creating charts in Excel 2007. The various topics which are covered here are creating basic charts, formatting chart elements, inserting charts, chart styles, adjusting chart locations, adding text links, enhancing a 3-D chart, creating and using chart template etc.

 - Creating Charts in Excel 2007
 - What is Chart?
 - Creating Basic Charts
 - Formatting a Chart Elements
 - Insert Chart
 - Chart Styles
 - Change the Chart Type
 - Adjust Chart Location
 - Display Chart Title
 - Customize Chart Legend
 - Displaying Data Table in Chart
 - Select Chart Color Style
 - Change Axis Options
 - Adding Text Links
 - Enhance a 3-D Chart
 - Place a Picture in Data Series
 - Adjust Chart Data
 - Handling Missing Data or Charting Hidden Data
 - Selecting a Chart Elements
 - Creating and Using Chart Template
 - Working with Charts
 - Tips


Printing Workbooks in Excel 2007
These tutorials show how to manage printing workbooks in Excel 2007. The topics covered here are spell checking, preview before printing, adding a manual page break, setting a specific area to print, setting page margins, adding a standard header or footer, printing worksheets and charts, inserting watermarks, emailing a workbook etc.

 - Printing Workbooks
 - Spell Check
 - Preview Before Printing
 - Add a Manual Page Break
 - Changing your Page View
 - Set a Specific Area to Print
 - Adjust the Paper Orientation and Size
 - Make Worksheet Fit Better on a Page
 - Set Page Margin
 - Specify Repeating Rows and Columns
 - Printing Gridlines and Rows and Columns Headings
 - Add a Standard Header or Footer
 - Creating Custom Header or Footer
 - View Other Header and Footer Options
 - Print Worksheets and Charts
 - Inserting Watermark
 - Changing Default Print Setting Using a Template
 - Email a Workbook
 - Letting Your Formulus All Hang Out


Managing Workbooks in Excel 2007
These tutorials cover managing workbooks in Excel 2007. The topics covered here are creating an empty workbook, inserting additional worksheets, saving files, using workspace files, inserting hyperlinks, arranging windows automatically, opening nonstandard files, working with workbook templates etc.

 - Managing Workbooks
 - Creating an Empty Workbook
 - Insert Additional Worksheets
 - Protecting and Unprotecting a Workbook
 - Saving Files
 - Switching Among Open Workbooks
 - Using a Workspace File
 - Work with Worksheets
 - Insert a Hyperlink
 - Arranging Windows Automatically
 - Changing the Default File Location
 - Closing a Workbook
 - Comparing Two Workbooks Side by Side
 - Creating Multiple Windows Views for a Workbook
 - Opening Nonstandard Files
 - Opening a Workbook
 - Working with Workbook Templates


The Basics of Spreadsheets: Numbers, Labels, and Formulas
These tutorials teach the basics of Excel spreadsheets. The topics covered here are storing data in spreadsheet, formatting numbers and labels, navigating a spreadsheet, editing a spreadsheet etc.

 - Understanding Spreadsheets
 - Storing Stuff in Spreadsheet
 - Formatting Numbers and Labels
 - Navigating a Spreadsheet
 - Searching a Spreadsheet
 - Editing a Spreadsheet
 - Clearing Data


Top New Features in Excel 2007
This tutorial shows the new features in Excel 2007. This tutorial teaches you style galleries, ribbon, page layout, zoom slider and other new features.


Some Basics in Excel 2007
This tutorial deals with some of the basic features in Excel 2007 which teach you all the fundamental skills required to use Excel 2007.


Excel Shortcut Keys
This document lists Excel’s shortcut keys which will come handy for the frequent users.

 - Moving Through a Worksheet (Shortcut Keys)
 - Moving within a Range Selection (Shortcut Keys)
 - Other Shortcut Keys


Tips for Using Excel 2007
These tutorials provide various tips with using Excel 2007. The tips covered here are: organizing spreadsheet data in different worksheet, generating new workbooks from templates, using range names, preventing data entry errors with data validation, controlling display of data in tables through outlines etc.

 - Organizing Spreadsheet Data on Different Worksheet
 - Generating New Workbooks from Templates
 - Freezing Column and Row Headings
 - Creating Data Series with Autofil
 - Using Range Names
 - Preventing Data Entry Errors with Data Validation
 - Saving Memory by Using Array Formulas
 - Trapping Error Values in their Original Formulas
 - Controlling Display of Data in Tables Through Outlines
 - Using View Side by Side to Work with Two Workbooks

Popularity: 28% [?]

Here are two excellent Excel Tutorials at Brown University. Excel is a spreadsheet application from Microsoft’s Office Suite and is the most widely used spreadsheet application in the world.


Excel Tutorial
This Excel tutorial covers the terminology used in Excel and its basic components such as Toolbars and Cell Navigation. The tutorial then moves onto data management that includes editing, inserting, deleting, copying and moving data between cells, not to mention sorting and filtering. One of the lesser known aspects of Excel is Natural Language Formulas which is switched off by default. Natural Language Formulas allows the use of column and row labels in formulas, rather than cell references, and this section covers this topic in depth.

Definitions:
This section goes over the defenition of terms used in Excel.

Toolbars:
This section explains about the toolbars in Excel.

Navigating Cells:
This section explains about the navigation of cells in Excel.

Data Mangemnet In Excel:
 - Editing, Moving, and Copying Data
 - Inserting, Deleting, and Clearing Data
 - Using Autofill
 - Controlling Your View of the Data
 - Sorting and Filtering Data

Formulas In Excel:
 - Autofill with Formulas
 - Cell References
 - AutoSum
 - Functions
 - The Function Wizard
 - AutoCalculate

Using Natural Language Labels In Excel:
This section reviews this convenient labeling feature in Excel.

3-D References In Excel:
This section explains how formulas on one worksheet to access data on another worksheet.

The Chart Wizard In Excel:
This section explains the Chart Wizard in Excel.

Pivot Table In Excel:
 - Arranging data on the table.

Printing In Excel:
 - What if you want to print only part of the spreadsheet?
 - Not able to highlight the region you wanted to print?

Troubleshooting:
Common sources of errors occured in Excel explained here.


Riveting, Pivoting Tables Tutorial
Riveting and Pivoting tables are tables that summarize large volumes of data – this Excel tutorial covers the intricacies of Pivot and Rivet Tables including changing, formatting and grouping of data.

 - Pivot Tables In Excel
 - The Pivot Table Wizard In Excel
 - Changing Pivot Tables In Excel
 - Pivot Table Options In Excel
 - Drilling down
 - Formatting
 - Grouping Data

Popularity: 30% [?]

Here are 25 Excel Tutorials at bukisa.com that cover diverse and complex topics such as sorting, importing and exporting data to and from Excel. The below Excel Tutorials explain table formatting, applying conditional formulas, automatically totalling values in cells, and exchanging data between Word and Excel. These Excel tutorials also provide several quick tips that are sure to come in handy; and a small segment on working with Excel in Mac OS X.


25 Excel Tutorials:

 - How to Add Export to Microsoft Excel to the Right Click Menu in IE.
 - How to Export HTML Table to Excel
 -  How To Create an Excel Spreadsheet to Manage Your Articles (or Anything)
 - Sorting Data in an Excel Spreadsheet Column
 - How to Add Microsoft Excel Toolbar Buttons – Insert and Delete Rows and Columns
 - Microsoft Excel Quick Tip – Merging Cells on a Spreadsheet
 - Creating a Microsoft Excel 2008 Automator Workflow in Mac OS X
 - How to Use Excel - “Automatically Total Amounts” – Easy Excel Series – EE2
 - How to keep a Food Diary in Microsoft Excel
 - How to Combine MS Word and MS Excel Spreadsheets into One Document
 - Learn Excel from MrExcel Episode 921 – Workbook Sheets
 - MrExcel’s Learn Excel #911 – WIIW – Equals
 - MrExcel’s Learn Excel #914 – Selection Color
 - MrExcel’s Learn Excel #923 – Icon Set Alignment
 - MrExcel’s Learn Excel #915 – Partially Bold
 - Learn Excel from MrExcel Episode 920 – 2003 Dialogs
 - How to compare and match two files using Excel VLOOKUP?
 - MrExcel’s Learn Excel #952 – Mouse to End
 - MrExcel’s Learn Excel #953 – Ctrl+N Compatibility Mode
 - MrExcel’s Learn Excel #944 – Excel to Word
 - MrExcel’s Learn Excel #933 WIIW – Conditional Formula
 - MrExcel’s Learn Excel #934 – Table Formatting
 - Learn Excel from MrExcel Episode 917 – Chart Background
 - MrExcel’s Learn Excel #927 – Pivot Compare            
 - Import Contacts from Excel to Outlook

Popularity: 34% [?]

Here is my second post of the Excel Tutorials and Tips at excel.tips.net that cover a host of Excel features as detailed in the links below, which are what we have judged to be the best ones for each topic. To help you become a better Excel user, these Excel tutorials and tips assist you with creating lists of transactions, then using those list to create charts and other analysis tools. (Here is my part 1 post of the Excel learning material from this site.)


Excel Tools:
Various application components can be implemented in Excel. These components include Combo Box and Drop Down Lists. These tutorials explain how to implement them in you worksheet.
 - Adding and Using a Combo Box
 - Adding Buttons to Your Worksheet
 - Creating Dependent Drop-Lists
 - Tracing Errors
 - Creating Scenarios
 - Understanding Auditing
 - Comparing Lists for Duplicates
 - Goal Seeking
 - Hiding Outline Symbols
 - Inserting a Voice Annotation in Your Worksheet

Sorting in Excel:
Sorting data in a worksheet based on certain criteria is paramount to achieving user-understandable data. And these tutorials below explain the sorting process
 - Controlling Sorting Order
 - Creating a Sort Order
 - Determining Sorting Criteria
 - Fixing Odd Sorting Behavior
 - Ignoring Selected Words when Sorting
 - Non-standard Sorting
 - Sorting Data Containing Merged Cells
 - Sorting Dates by Month
 - Sorting Worksheets
 - Sorting while Ignoring Leading Characters

Excel Workbooks:
Workbooks in Excel are the files themselves. And each workbook can hold multiple worksheets. The tutorials below explain the intricacies of working with Workbooks.
 - Accessing a Problem Shared Workbook
 - Creating a Workbook Clone
 - Calculating Only the Active Workbook
 - Making Changes in a Group of Workbooks
 - Merging Many Workbooks
 - Opening a Workbook to a Specific Worksheet
 - Sharing Your Workbook
 - Updating Links in Copied Files
 - Using a Single Password for Multiple Workbooks
 - Automatically Protecting After Input

Data Entry in Excel:
These Data Entry tutorials deal with the shortcuts used to enter data quickly in an Excel worksheet.
 - Entering Dates in Excel
 - Entering Dates Without Separators
 - Entering Large Time Values
 - Jumping to the Start of the Next Data Entry Row
 - Modifying Default Year for Dates
 - Quickly Entering Dates and Times
 - Recording a Data Entry Time
 - Using Early Dates
 - Adding Pop-Up Documentation to a Cell
 - Specifying a Data Validation Error Message

Excel Data Validation:
Validating data in an Excel sheet is as important as data entry itself and these tutorials teach you to validate the data in an Excel sheet.
 - Adding Pop-Up Documentation to a Cell
 - Changing Fonts in Data Validation Drop-Down Lists
 - Ensuring Unique Values in a Column
 - External Data Validation
 - Limiting Entries to Numeric Values
 - Limiting Input to a Format
 - Setting Data Validation Input Messages
 - Specifying a Data Validation Error Message
 - Triggering a Macro for Drop-Down List Changes

Excel Charts:
We now move onto the visual aspect of Excel. Charts help evaluate values in two columns and display them as charts. The tutorials below have an in-depth coverage of Charts in Excel.
 - Changing Chart Size
 - Changing Elements in Lots of Charts at One Time
 - Deleting a Chart
 - Excel Charts in PowerPoint
 - Labeling X-Y Scatter Plots
 - Moving a Chart’s Legend
 - Positive and Negative Colors in a Chart
 - Reordering the Display of a Data Series
 - Unlocking Charts
 - Using Go To to Jump to a Chart Sheet

Excel Graphics:
As with any application in Microsoft’s Office suite, graphics can be inserted in Excel as well. These tutorials deal with creating autoshapes as well as inserting image files.     
 - Creating an AutoShape
 - Displaying Images based on a Result
 - Formatting the Border of a Legend.
 - Inserting from a Camera or Scanner
 - Moving Drawing Objects
 - Placing Textbox Text Into a Worksheet
 - ScreenTip for an Image
 - Smoothing Out Data Series
 - Styles for Lines, Dashes, and Arrows
 - Watermarks in Excel

Excel PivotTables:
One of the most powerful features of Excel is Pivot Tables which is a reporting tool works independent of the data layout in the Excel sheet. To further explore the power of Pivot Tables, the tutorials will help you.
 - Bogging Down with Calculated Items
 - Changing the Default PivotTable Functions
 - Editing PivotTables without Underlying Data
 - Excluding Zero Values from a PivotTable
 - Maintaining Formatting when Refreshing PivotTables
 - Missing PivotTable Data
 - Reducing File Sizes for Workbooks with PivotTables
 - Suppressing Zero Values in PivotTables
 - Text Truncated in PivotTable
 - Weighted Averages in a PivotTable

Excel Files:
The section below explain the different files in Excel and their uses.
 - Adding a File Path and Filename
 - Aligning Cells when Importing from CSV
 - Appending to a Non-Document Text File
 - Avoiding Scientific Notation on File Imports
 - Comma-Delimited Differences for PC and Mac
 - Converting from SuperCalc
 - Correctly Saving Delimited Files
 - Creating a CSV File
 - Faster Text File Conversions
 - How Excel Treats Disk Files

Excel Add-Ins:
An Excel Add-In is a file that loads when Excel starts. This file can contain additional functionality to Excel, and the tutorials below explain how Excel Add-Ins work.
 - Automatically Loading Add-ins
 - Excluding a Specific Add-In at Startup
 - Removing Add-ins
 - The EDATE Function
 - Understanding Add-Ins
 - Using Custom Add-Ins
 - Converting Units
 - Finding the Analysis ToolPak Add-In
 - Adding a Report
 - Using the Report Manager

Online and Web:
The tutorials below explain Excel’s ability to interface with the web, including generating a web page with it.
 - Automatic Text in an E-mail
 - Extracting URLs from Hyperlinks
 - Get Rid of Web Stuff
 - Linking to a Specific Page in a PDF File
 - References to Hyperlinks Aren’t Hyperlinks
 - Retrieving Web Query Data without Interruption
 - Connecting To a Discussion Server
 - Filtering Web Discussions
 - Adding Excel Information to a Web Page
 - Generating a Web Page

Working with Other Programs:
Excel can also interface with other applications such as AutoCAD and Lotus 1-2-3, thereby allowing users to exchange data between them. Thee tutorials further explain this concept.
 - Exporting from Excel to AutoCAD
 - File Formats that Include Field Formats
 - Ignoring Other Applications
 - Importing Huge Data Files
 - Working with Lotus 1-2-3 Spreadsheets
 - Preparing Data for Import into Access
 - Snapshots of Excel Worksheets for PowerPoint
 - Working with Imperial Linear Distances
 - Embedding Fonts in Excel
 - Word Documents from Excel Macros

General Excel Tutorials:
The tutorials below follow a general theme of interacting with Excel providing file properties and editing custom dictionaries.
 - A Ruler in Excel
 - Additional Ways of Displaying a Hidden First Column
 - Backing Up Your AutoCorrect Entries
 - Changing Error Checking Rules
 - Changing Excel’s Starting Date
 - Controlling Display of Page Breaks
 - Determining Your Version of Excel
 - Editing Custom Dictionaries
 - Embedding Fonts in Excel
 - Finding Commands in Excel 2007

Popularity: 24% [?]

Here is my first post of the Excel Tutorials and Tips at excel.tips.net that cover many topics that will help make you a professional at Excel. Excel is a spreadsheet application from Microsoft’s Office suite that creates and manages business transactions that deal with accounting. The below Excel tutorials and tips are a good place to explore  and learn the basics and also some advanced features of Microsoft Excel. These are the best ones in each topic from our review of this site. (Here is my part 2 post of the Excel learning material from this site.)


Conditional Formatting in Excel:
Conditional formatting allows you to set rules for cell formatting. If the rules are met, then the formatting is applied. The tutorials below explain how Conditional formatting work.
 - Conditional Formatting
 - Adding Ordinal Notation to Dates
 - Applying Conditional Formatting to Multiple Worksheets
 - Conditional Formats that Distinguish Blanks and Zeroes
 - Conditionally Formatting for Multiple Date Comparisons
 - Shading a Cell Until Something is Entered
 - Highlighting Cells Containing Specific Text
 - Counting Colors from Conditional Formats
 - Sorting or Filtering by Conditional Format Results
 - Conditional Formatting with Data Imported from Access

Customizing Excel:
Excel makes it easy for you to personalize and customize the menus and toolbars to suit each individuals way of working. The tutorials below explain the level of customization a user can achieve.
 - Adding a Little Animation to Your Life
 - Colors and Fonts for Worksheet Tabs
 - Creating Superscript and Subscript Buttons
 - Specifying the Behavior of the Enter Key
 - Adding Your Own Menu Items
 - Removing Items from a Context Menu
 - Buttons for Workbooks
 - Customizing a Toolbar
 - Renaming a Toolbar
 - Saving Valuable Toolbar and Screen Space

Excel’s Custom Views:
Many of us would also like to extend the level of customization to having pur own Views and these tutorials below explain how to do just that.
 - Arranging Workbook Windows
 - Additional Ways of Displaying a Hidden First Column
 - Arranging Workbook Windows
 - Changing the Size of Spreadsheet Panes
 - Displaying a Hidden First Column
 - Getting Rid of Spreadsheet Panes
 - Splitting Your Spreadsheet Window Into Panes
 - Working With Multiple Workbooks

Editing in Excel:
While editing a sentence may seem easy, editing in Excel takes on a whole new approach. The links below explain editing in Excel.
 - Automatically Breaking Text
 - Checking for a Value in a Cell
 - Combining Multiple Rows in a Column
 - Counting Words
 - Easily Entering Dispersed Data
 - Easily Entering Dispersed Data
 - Transposing Your Data
 - Making AutoComplete Work for an Entire Column
 - Using an Input Mask
 - Ranges on Multiple Worksheets

Excel Filtering:
Excel provides filters to quickly find data in an Excel sheet. Filtering does not change data in an Excel sheet, and all data appears the same as before as soon as the filter is removed. The tutorials below provide an in-depth coverage of filters.
 - Counting Filtered Rows
 - Removing Duplicates Based on a Partial Match
 - Extracting Targeted Records from a List
 - Performing Calculations While Filtering
 - More Than Two Conditions for Custom AutoFiltering
 - Suppressing Zero Values in PivotTables
 - Sorting or Filtering by Conditional Format Results
 - Advanced Filtering
 - Limits to Filtering
 - Using AutoFiltering

Find and Replace in Excel:
Find and Replace is a common tool used in most applications, and Excel is no exception. The tutorials given below explain how to use the Find and Replace tool effectively in Excel.
 - Checking for Messages in Cells
 - Finding and Deleting Links
 - Limiting Searching to a Column
 - Searching for Leading Apostrophes
 - Searching for Line Breaks
 - Searching for Wildcards
 - Using Find and Replace to Pre-Pend Characters
 - Wildcards in ‘Replace With’ Text

Formatting in Excel:
To better understand raw data, it must be formatted to some specific criteria. The tutorials below explain how formatting can be applied to cells in an Excel sheet.
 - Formatting Raw Data
 - Partially Blocking Social Security Numbers
 - Removing All Formatting
 - Understanding Date and Time Formatting Codes
 - Making All Occurrences Bold
 - Drawing Borders
 - Automatically Breaking Text
 - Displaying Negative Percentages in Red
 - Matching Formatting when Concatenating
 - Understanding Cell Indenting

Excel Formulas:
Data available in Excel sheets can be manipulated using Formula. Different cells can be grouped together to have their values computed in any fashion. The links below explain how to work with Formula.
 - Activating the Formula Bar with the Keyboard
 - Entering Formulas in Excel
 - Automatically Numbering Rows
 - Calculating Statistical Values on Different-Sized Subsets of Data
 - Calculating the Median Age of a Group of People
 - Complex Lookup Formulas
 - Counting Consecutive Negative Numbers
 - Dealing with Circular References
 - Determining “Highest Since” or “Lowest Since”
 - Saving Common Formulas

Excel Macros:
A macro is usually a set of instructions that are grouped together to carry out small, repetitve tasks. Macros can also be created and used extensively in Excel and these tutorials explain how they work.
 - Adding a Macro to a Toolbar
 - Understanding Functions in Macros
 - Editing Macros
 - Comparing Strings
 -  Creating and Naming a Worksheet Using a Macro
 -  Developing Reciprocal Conversion Formulas
 -  Displaying Messages When Automatic Data Changes
 -  Getting Rid of the “Enable Macros” Notice
 - Macros in Template Files
 - Putting an X in a Clicked Cell

Page Setup:
Put simply, a page in a spreadsheet application can be setup to print values in the landscape or the portrait mode. The page setup also includes page breaks, headers and footers and inserting page numbers. These tutorials explain all these concepts detail.
 -  Changing Paper Size for a Complete Workbook
 - Multiple Line Headers and Footers
 - Forcing a Page Break
 - Turning Headers On and Off
 - Dynamic Headers and Footers
 - Putting a Graphic in a Header or Footer
 - Inserting the Saved Date In a Header or Footer
 - Recognizing a Header Row when Sorting
 - Adding Page Numbers
 - Changing Page Orientation

Printing:
An Excel sheet can be setup to be printed in ways that suit a user. An Excel sheet can even be printed without opening it. These and more printing related tutorials can be found below.
 - Automatically Printing a Range
 - Conditional Printing
 - Hiding Errors on Printouts
 - Printing a Portion of a Worksheet
 - Printing Based on Cell Contents
 - Printing Comments
 - Printing without Opening
 - Protecting Print Settings
 - Repeating Rows at the Bottom of a Page
 - Setting Print Titles

Excel Shortcut Keys:
As with an application, Excel too has a lot of shortcut keys that permit quick and easy navigationn on a worksheet. You can find all Excel shortcuts in these tutorials.
 - A Shortcut for Switching Focus
 - Canceling a Command
 - Changing Font Size Using a Shortcut Key
 - Closing All Open Workbooks
 - Defining Shortcut Keys for Symbols
 - One Shortcut for Two Macros.
 - Shortcut to Merge Cells

Subtotals in Excel:
Subtotals of a column can be calculated and stored for quick reference. The tutorials below help understand Subtotals better.
 - Copying Subtotals
 - Counting with Subtotals
 - Formatting Subtotal Rows
 - Moving Subtotals
 - Problems with Nested Subtotals
 - Subtotals Option Grayed Out.
 - Using Subtotals and Totals

Worksheet Functions:
In Excel worksheets, functions can be implemeted on the data. These functions include database functions, date and time functions and text functions to name a few. The tutorials help explain the concept of worksheet functions.
 - Calculating Fractions of Years
 - Counting Unique Values with Functions
 - Functions Within Functions.
 - Looking Up Names when Key Values are Identical
 - Determining Columns in a Range
 - Counting with Two Criteria
 - Exiting a For … Next Loop Early
 - Understanding the VLOOKUP Function
 - Using the IF Worksheet Function
 - Calculating Business Days

Excel Worksheets:
A single Excel file can hold multiple worksheets. The tutorials below explain the manipulations that can be carried out on Excel worksheets.
 - Condensing Multiple Worksheets Into One
 - Ordering Worksheets Based on a Cell Value
 - Saving Versions
 - Protecting Worksheets.
 - Sheets for Days
 - Functioning Check Boxes in a Protected Worksheet
 - Changing Excel’s Background Color
 - Synchronized Workbook and Worksheet Names
 - Hiding and Unhiding Worksheets
 - Determining a Worksheet’s Number

Excel’s Environment and Interface:
The folowing tutorials help you to get accustomed to Excel’s Environment and Interface.
 - Getting Rid of the Startup Spreadsheet
 - I Hate the Excel 2007 User Interface
 - Precision and Number Display
 - Precision in Excel
 - Saving Non-Existent Changes
 - Where is Toolbar Customization Information Stored?
 - Changing the Size of Spreadsheet Panes
 - Getting Rid of Spreadsheet Panes
 - Keep Your Headings in View
 - Splitting Your Spreadsheet Window Into Panes

Popularity: 27% [?]

Here is an excellent one-page Word and Excel Macro Tutorial from Brown University. This will help you understand when to use and how to create macros for Word and Excel.

According to Microsoft, “If you perform a task repeatedly in Word, you can automate the task by using a macro. A macro is a series of Word commands and instructions that you group together as a single command to accomplish a task automatically. Instead of manually performing a series of time-consuming, repetitive actions in Word, you can create and run a single macro, in effect, a custom command, that accomplishes the task for you.

Here are some typical uses for macros:

 - To speed up routine editing and formatting
 - To combine multiple commands; for example, inserting a table with a specific size and borders
 - To automate a complex series of tasks.


Macro Tutorial Objectives:

 - Understand what a macro is and how it works
 - Learn how to conceptualize and record your own macros
 - Learn how to run them simply and efficiently via shortcut keys
 - Learn how to install pre-written macros
 - Learn how to save and embed them into your documents

Popularity: 54% [?]

Here is a quick 5-Lesson Excel 2003 Tutorial, from Wesleyan University. It provides instructions on how to perform the fundamentals of using Excel, including entering  your data, formatting and editing data with the cells, creating and using formulas, and using charts.


Contents of Excel 2003 Tutorial:

 - Introduction and Orientation

 - Entering Data

 - Formatting and Editing Data

 - Using Formulas

 - Creating Charts

Popularity: 44% [?]

Here are several good Excel Tutorial Videos at free-training-tutorial.com that will help you master using important Excel features, such as editing cells, rows, and columns; using the sum, average, countif, and VLOOKUP functions; using Excel formulas; creating charts and graphs; and working with filters and pivot tables. They give you step-by-step and easy-to-follow directions for managing and presenting your data with Excel. Each of the links below contain several Excel video training tutorials.


Excel Basics:
 - Formatting Cells
 - Worksheets
 - Edit Cells
 - Rows and Columns
 - Find and Replace
 - The Fill Handle

Excel Calculations:
 - Sum, Average, Countif Functions
 - Quick Functions
 - The IF Statement
 - VLOOKUP Function
 - Excel Formulas

Special Excel Features:
 - Charts and Graphs
 - Sort Data
 - Filter Data
 - Conditional Formatting
 - Pivot Table  
 - First Aid

Popularity: 65% [?]

Here are some good technical Excel 2003 Tutorials and Articles from Microsoft. These will help you learn the technical side of Excel, including how to use XML functionality with Exel, Map Data, use Windows Forms, create a Report Templare, and write macros using Visual Basic for Applications (VBA). Also, here is Chapter 20: Creating Advanced User Forms, from the book “Microsoft Office Excel 2003 Programming Inside Out”.


 - Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET
 - Creating Charts in Microsoft Office Excel 2003 Using Visual Basic for Applications Code
 - Creating XML Mappings in Excel 2003
 - Different Ways of Using Web Queries in Microsoft Office Excel 2003
 - How Excel 2003 Infers XSDs When Importing XML Data
 - Microsoft Office Excel 2003 Preview
 - Part 1: Automating the XML Data Mapping Process in Excel 2003
 - Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003
 - Part 3: Replicating Excel 2003 Formulas to SQL Server
 - Populating an Excel 2003 Worksheet with Multiple Related Records from a Windows Form
 - Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
 - Understanding Security for Add-ins and VBA Macros in Excel 2003
 - Using the Excel 2003 XML Tools Add-in Version 1.1
 - Using the Excel XML Toolbox for Microsoft Office Excel 2003
 - Using Visual Basic and ASP with XML to Generate Excel 2003 Workbooks
 - XML and Microsoft Office Excel 2003: Creating an Expense Report Template

Popularity: 82% [?]