2 Excel 2007 Quick References and 45 Flashcards

PowerPoint 2007 Quick References, Flashcards, Practice Tests, and Learning Games

2 Word 2007 Quick References and 41 Flashcards

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 9:53 pm

Comments (0)

January 26, 2010

8 Excel 2007 Tutorials

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: 46% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 12:39 am

Comments (0)

January 12, 2010

4 Excel 2007 Tutorials

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: 26% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 9:19 pm

Comments (0)

October 17, 2009

11 Excel 2007 Tutorials

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: 27% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 9:19 pm

Comments (0)

August 31, 2009

Excel 2007 Course Tutorials

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: 14% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 5:42 pm

Comments (0)

July 30, 2009

4 Excel 2007 Tutorials

Here are four Excel 2007 Tutorials, hosted by the University of South Dakota. These Excel tutorials introduce you to this powerful analytic, organization, and data logging application. They are organized in a series of pdf documents that take you through and demonstrate various features, tools, and tips of Excel. The purpose of these Excel 2007 tutorials is to provide instructions on performing both basic and advanced Excel tasks and functions.

Excel Tutorial Part 1: Getting the Basics (877 Kb, 22 pages)
This first Excel tutorial focuses on the basic features of Excel like the ribbon, adding headers and footers, navigation, entering data in worksheet, and merging and splitting of cells. The Excel 2007 file used in the tutorial can be downloaded from here.

- First look into Excel
- Components of Excel
- The Ribbon
- Key Tips
- Using a Previous Version of Excel
- Inserting Columns
- Formatting Cells
- AutoSum
- Add Headers and Footers
- The New Workbook Window
- Navigation in Excel
- Modifying Cells
- Entering Data into a Worksheet
- Merge or Split cells
- Combine the contents of multiple cells into one cell
- How do I work with people who don’t have Excel 2007 yet?

Excel Tutorial Part 2: Charts and Graphs (346 Kb, 11 pages)
This Excel tutorial teaches you charts and graphs in Excel. The tutorial explains various chart and graph features like formatting chart titles, individual columns, moving and resizing tips, modifying the properties of your charts, and changing the axis scale. The Excel 2007 file used in the tutorial can be downloaded from here.

- Creating Charts in Excel
- Change the Chart
- Add Chart
- Change how your Chart
- Format Chart Titles
- Format Individual Columns
- Add your Chart to a PowerPoint Presentation
- Choosing a chart type
- Resize and move an embedded chart
- Moving and resizing tips
- Data of the Chart is Linked to the Chart
- Modify the properties of your charts
- Add a graphic to a chart
- Change the axis scale
- Freeze rows and columns in a List

Excel Tutorial Part 3: Conditional Formatting (614 Kb, 21 pages)
This tutorial introduces you to conditional formatting in Excel. The topics covered include creating conditional formula that results in a logical value, an overview of formulas, using array formulas and array constants. The three Excel 2007 files used in this tutorial can be downloaded from here: Grade Sheet, Loan Worksheet, and Tutorial Worksheet.

- Conditional Formatting in Excel
- Create conditional formulas
- Create a conditional formula that results in a logical value (TRUE or FALSE)
- Create a conditional formula using IF, AND, and OR
- Functions: A Quick Refresher
- Overview of formulas
- Using functions and nested functions in formulas
- The difference between absolute, relative and mixed references
- Using names in formulas
- Using array formulas and array constants

Excel Tutorial Part 4: Pivot Tables (535 Kb, 15 pages)
This tutorial handles the introduction of Excel pivot tables to your skill set. All the basic features that are related to pivot tables in Excel are covered here. Features that are explained include: inserting pivot tables, adding a report filter, filter the data, and using a custom calculation. The two Excel 2007 files used in the tutorial can be downloaded from here: PivotTable_II and PivotTable_III.

- Get your Data Ready
- Insert a Pivot Table
- Add a Report Filter
- Group the Dates
- Pivot the Report
- Filter the Data
- Filter by using Comparisons
- Filter by Date
- Change how Subtotals are Displayed
- Use a custom calculation
- The GETPIVOTDATA Function
- Change the Format of a PivotTable Report

Popularity: 19% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 8:17 pm

Comments (0)

July 13, 2009

Excel 2007 Interactive Guide

Here is the Excel 2007 Interactive Guide at Microsoft Office Online. This Excel 2007 tutorial is for learning and self practicing all the basics of Excel. This is specially designed towards intermediate and advanced users. The tutorial takes users through the highest level of spreadsheet capabilities. The interactive guide can be downloaded and installed in your desktop so that you can have a real feel of MS Excel even if you are offline. The list of command equivalents are also listed neatly in an xls document linked along with this post. For a complete searchable list of command equivalents, download the Excel ribbon mapping workbook in Excel format. This Excel 2007 interactive guide can also download from here.

Popularity: 24% [?]

Related Posts:

Word 2007 Interactive Guide

PowerPoint 2007 Interactive Guide

Access 2007 Interactive Guide

Outlook 2007 Interactive Guide

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 10:19 pm

Comments (0)

June 25, 2009

23 Excel 2007 Tutorials

Here are 23 excellent Excel 2007 Tutorials at Microsoft Office Online that teach and explain important features of Excel with the help of webcasts. These detailed training webcasts presented by various MVPs demonstrate Excel Formulas, Excel Tips, Effective Data Management and creating charts and graphics. Also provided are video tips and mini-webcasts that show how to create and customize pivot tables, highlight and remove duplicate values, use data in Excel sheets effectively, and perform data analysis.

Excel Webcasts:
These Microsoft Excel webcasts teaches users to create attractive charts and graphics and analyzing data dynamically. Advanced tip teach users to access xml format documents in Office.

- Summarizing Data Effectively Using New Excel 2007 Formulas and Functions
- Top 10 Tips for Excel 2007 (Level 100)
- Tips and Tricks to Manage Data Effectively by Using Excel Tables (Level 200)
- Creating Attractive Charts & Graphics Using Excel 2007 (Level 200)
- Creating Effective Conditional Formats Using Excel 2007 (Level 300)
- Advanced Tips and Tricks: Breaking Into Your Office Open XML Format Documents (Level 300)
- Advanced Tips and Tricks: Using Visual Basic for Applications (VBA) Every Day Is Easier Than You Think (Level 300)
- Advanced Tips and Tricks: What You Can Really Do with Your Documents Across the 2007 Office Release (Level 300)
- Analyzing Data Dynamically Using Excel 2007 PivotTables

Excel Video tips:
These video tips imparts knowledge on the new and improved features of Microsoft Excel, how to format and apply conditions to data in tables.

- Customizing Conditional Formatting in Excel 2007 256k | 750k
- Customizing PivotTable Reports to Create Adjustable Charts and Graphs 256k | 750k
- Formatting with Conditional Filtering to Organize Data 256k | 750k
- Getting Started with PivotTable Reports 256k | 750k
- Highlighting and Removing Duplicate Table Values in Excel 256k | 750k
- New and Improved Features 256k | 750k
- Organizing and Grouping with PivotTable Reports 256k | 750k

Podcasts:
The podcasts here demonstrate some important tips when using Excel and improving data analysis when using Excel 2007.

- Summarizing Data Effectively Using New Excel 2007 Formulas and Functions
- Top 10 Tips for Microsoft Office Excel 2007
- Improving Data Analysis with Excel 2007 PivotTables and PivotCharts
- Top Tips for Excel 2007

Mini-webcasts:
These mini-webcasts introduce quick tips on what’s new and different and how to get the most out of Excel 2007.

- 5-Minute Excel Webcast
- Excel Side By Side: What’s New & Different
- Quick Tips for Getting the Most Out of Microsoft Office Excel 2007

Popularity: 16% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 8:22 pm

Comments (0)

May 14, 2009

11 Excel Tutorials

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: 20% [?]

16 Excel Video Tutorials

Free Microsoft Excel Video Training

Excel 2003 Tutorial from the University of Texas

4 Excel eBooks, 6 Access eBooks, and 1 Visio eBook

Tags for this post>> Excel | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 11:05 pm

Comments (0)

May 4, 2009

Tutorials for Excel 2003 and 2007

Here are several Excel Tutorials at spreadsheets.about.com covers and teaches various features of Excel, versions 2003 and 2007. Some of the topics covered by these Excel tutorials are: getting started with Excel, steps to create a basic spreadsheet, formulas, charting, and converting an Excel spreadsheet to an Access database. Also at this site are How to Use Excel Tutorials and Excel Formula Tutorials.

- Basic Excel 2003 Spreadsheet Tutorial
- Adding data to a spreadsheet
- Widening Columns in Excel
- Adding the Date and a Range Name
- Adding formulas
- Applying styles
- Changing data alignment in cells
- Number formatting – percent and currency
- Changing font color

Getting Started with Excel:
These tutorials are a beginner’s tour on Excel 2003 and Excel 2007. It deals with simple stuff like entering data in Excel.

- Beginner’s Guide to Excel 2003
- Beginners Guide to Excel 2007
- Entering Data in Excel

Excel 2007 Chart Tutorials:
These tutorials walk you through creating and formatting pie charts, column charts and line graphs using many of the common features available in Excel 2007.

- Excel 2007 Pie Chart Tutorial
- Excel 2007 Column Chart Tutorial
- Excel 2007 Line Graph Tutorial

How to Use Excel:
These tutorials covers how to create and use a basic formula in Excel 2007 by step by step examples. It also details out creating spreadsheets in MS Excel 2003 and MS Excel 2007.

- Excel 2007 Formulas Step by Step Tutorial
- Basic Excel 2003 Spreadsheet Tutorial
- Basic Excel 2007 Spreadsheet Tutorial

Related Articles:
This section deals with several related articles on MS Excel. The topics include converting an Excel spreadsheet to an MS Access 2007 database, Excel SUM and auto SUM functions

- Converting an Excel Spreadsheet to an Access 2007 Database
- Excel Tutorials – Free Excel Tutorials
- Excel SUM – Excel Auto SUM Function – Free Excel Tutorials
- Converting an Excel Spreadsheet to an Access Database
- Converting an Excel Spreadsheet to an Access Database

Popularity: 29% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

8 Excel 2007 Tutorials

Tags for this post>> Excel 2003 | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 8:04 pm

Comments (0)

April 21, 2009

Excel 2007 Tutorial

This excellent Excel 2007 Tutorial at Brown University discusses and teaches Excel 2007 in detail. Excel is a spreadsheet application from Microsoft’s Office Suite and is the most widely used spreadsheet application in the world. This Excel tutorial explains the new features of Microsoft Office 2007, and how it compares with its predecessors. The various definitions used in Excel, cell navigation and data manipulation which include editing, moving, copying and the Autofill feature in Excel is discussed in detail. For more advanced Excel users, Excel formulas, Natural Language Labels, Pivot table and Excel sheet printing is explained. As a footnote, a section on troubleshooting in Excel is also presented.

New In Office 2007:
This section talks about the new features added in the Office 2007.

Definitions In Excel 2007:
This section list out and define the different words used in Excel 2007.

Navigating Cells In Excel 2007:
This section talks about the different ways of navigations used in cell.

Data In Excel 2007:
- Editing, Moving, and Copying Data
- Inserting, Deleting, and Clearing Data
- Using Autofill
- Using Autofill with a text series
- Using Autofill with a numeric series
- Controlling Your View of the Data
- Sorting and Filtering Data

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

Using Natural Language Labels In Excel 2007:
This section talks about the labelling feature in Excel.

3-D References In Excel 2007:
This section explains how we can access the formulas from one sheet to another.

The Chart Wizard In Excel 2007:
This section explains the way to create different charts using the Chart Wizard in Excel.

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

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

Troubleshooting In Excel 2007:
This section details the common sources of the errors occurred in Excel.

Popularity: 18% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 8:56 pm

Comments (0)

March 21, 2009

Excel 2007 Data Analysis Tutorials

Here are several well written Excel 2007 Data Analysis Tutorials that will assist you in analyzing economic data. These tutorials help explain Excel’s power and give you insight into Excel’s analysis tool set. Advanced Excel topics covered include data inspection, and statistical inference for univariate, bivariate and multivariate expressions. Each of these Excel tutorials is complemented with visual examples to better explain the concepts presented. As a quick crash course, also included is a ‘Getting Started’ tutorial as well. These Excel tutorials are hosted by the University of California at Davis.

Excel 2007 Getting-Started Tutorial:
- Excel: Tutorial (covers first half of below)

Excel 2007 Basics:
- Excel 2007: Access and Activating the Data Analysis Add-in
- Excel 2007 : The Windows 2007 Fluent Interface
- Excel 2007 : Workbooks and Worksheets
- Excel 2007 : Data Types and Data Input
- Excel 2007 : Data Manipulation
- Excel 2007: Formatting, Saving, Printing and Copying Results
- Excel 2007 : Sample text data set (carsdata.txt)
- Excel 2007 : Sample comma-separated values text data set (carsdata.csv)
- Excel 2007 : Sample Excel worksheet (carsdata.xls)

Excel 2007 Univariate: Visual Data Inspection:
- Excel 2007: Histogram
- Excel 2007: Charts (column, pie, line)

Excel 2007 Univariate: Data Summary and Statistical Inference:
- Excel 2007: Descriptive Statistics
- Excel 2007: Statistical Inference for univariate data
- Excel 2007: DIST, TINV, NORMSDIST and NORMSINV

Excel 2007 Bivariate: Visual Data Presentation:
- Excel 2007: Two-way Plots
- Excel 2007: Two-plots with nonlinear trend (logarithmic, exponential, power, polynomial)

Excel 2007 Bivariate: Data Summary and Statistical Inference:
- Excel 2007: Correlation and covariance
- Excel 2007: Two-Variable Regression using Data Analysis Add-in
- Excel 2007: Statistical Inference for Two-Variable Regression
- Excel 2007: Two-Variable Regression using Excel function LINEST

Excel 2007 Multivariate: Data Summary and Statistical Inference:
- Excel 2007: Multiple Regression

Popularity: 37% [?]

Related Posts:

Excel Ebooks

23 Excel 2007 Tutorials

Tags for this post>> Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 11:25 pm

Comments (0)

February 10, 2009

6 Free Excel 2007 Classes

Here 6 Free Excel 2007 Classes, courtesy of HP’s Learning Center. These online Excel courses cover several important features of this spreadsheet application, such as filtering data, linking data between workbooks, learning the interface, making PivotTables, creating web queries, and creating macros and VBA scripts. These Excel classes are found in this site’s section offering 28 Free Software Classes. Free registration is required.

Microsoft Excel 2007: Extreme
Learn how to push the limits of Microsoft Excel 2007 by learning essential VBA programming, ActiveX controls and web queries.

Microsoft Excel 2007: Filter Data
This animated demonstration shows you how to filter data in Microsoft Excel 2007.

Microsoft Excel 2007: Link and Unlink Content between two Workbooks
This animated demonstration shows you how to link and unlink information between Microsoft Excel workbooks.

Microsoft Excel 2007: Record a Simple Macro and Edit It in VBA
This animated demonstration shows you how to record a simple macro in Excel and edit it in VBA.

Microsoft Excel 2007: Take a Tour of the Interface and Learn Basic Skills
This animated demonstration introduces you to the new Microsoft Excel 2007 interface, which is very different from earlier versions.

Microsoft Excel 2007: Create a PivotTable
This step-by-step demonstration shows you how to summarize a large amount of data to glean some meaning from it using PivotTables in Microsoft Excel 2007.

Popularity: 32% [?]

Related Posts:

4 Free Word 2007 Classes

Microsoft Excel Workshop Training Handouts

Tags for this post>> Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 12:01 am

Comments (0)

August 24, 2008

12 Step-by-Step Excel Tutorials

Here are 12 Excel Tutorials from mstipsandtricks.com that show and teach you how to use Excel with these features and tasks: Formatting Cells and Sheets, Styles, Formulas, Importing Data, Graphics, Charting, Macros, Pivot Tables, and creating spreadsheets in Excel 2007. These Excel tutorials use screen shots and numbered steps to help you master the topics covered.

12 Illustrated, Step-by-Step Excel Tutorials:

How to Configure Excel’s Options
This Excel tutorial shows you how to configure Excel’s general options.

Formatting Cells and Sheets
This tutorial teaches you how to apply formatting options to cells and prepare the sheet for printing.

Styles in Microsoft Excel
This Excel tutorial describes how to manage styles in Microsoft Excel.

Working with Excel Formulas
Excel can do many mathematical operations and work with numbers in a variety of ways. Learn how to insert and use formulas to do this easily.

Advanced Excel Formulas
In this tutorial, you will learn how to use and write Excel formulas.

Consolidate Data using Excel
Find out how to consolidate data In this Excel tutorial.

Working with Data in Excel
This Excel tutorial will show you how to connect with another data source so you can display and use it in your current sheet.

Working with Graphics in Microsoft Excel
This tutorial explains how to use and work with graphics in Excel.

Create Charts in Excel
Learn how to create and work with Graphs in Excel. With a graph, the data of spreadsheet can be transformed to show comparisons, patterns and tendencies.

Excel Macros Tutorial
In this tutorial, you will learn how to create and use Excel’s macros.

Pivot Tables using Excel
Pivot tables are as easy method to view the same data in Excel in differents layouts giving the user a greater understanding of the information.

Creating Excel 2007 Files
If you have Excel 2007, you may need to learn how the user interface works and how to create spreadsheet files. This tutorial will help you do that.

Popularity: 9% [?]

34 Free Microsoft Office Ebooks

Tutorials for Excel 2003 and 2007

Free Books on Microsoft Office, Excel, Project, and FrontPage

Tags for this post>> Excel | Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 9:15 pm

Comments (0)

August 19, 2008

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Here are reference guides or cheat sheets for Word 2007, Excel 2007, and PowerPoint 2007 from tmcc.edu. These are aimed at users of Office 2003, to guide and show them the new Office 2007 interface and how it differs from the previous versions of these applications. These three learning documents are in pdf format.

Word 2007 Cheat Sheet

This 10-page Word 2007 reference guide (314kb) takes you through the following topics:

Get the Lay of the Land
Learn the Ribbon
The Office Button and Quick Access Toolbar
Five Tips for Working with Word 2007
New Features in Word 2007
Word 2007 Quick Reference Charts

Excel 2007 Cheat Sheet

The Excel 2007 interface represents a big change in the look and feel of this spreadsheet application. Whether youâ€™re opening a file or cheating charts or even design - you’ll find things have changed. This 13-page reference guide (476kb) will help you learn how to use Excel’s functionality using the new interface.

Get the Lay of the Land
Learn the Ribbon
The Office Button and Quick Access Toolbar
Six tips for working with Excel 2007
New features in Excel 2007
Excel 2007 quick reference charts
Excel 2007 image gallery

PowerPoint 2007 Cheat Sheet

This PowerPoint 2007 reference guide (16 pages, 918kb) reviews the commands and tasks you need to perform for creating slide presentations using the new user interface. It consists of the following three sections:

Navigation tips about getting around in PowerPoint 2007.
New location of buttons from the old Standard, Drawing, and Formatting toolbars.
New locations of the old menu items.

Popularity: 35% [?]

Related Posts:

PowerPoint 2007 Interactive Guide

Word 2007 Interactive Guide

7 PowerPoint 2007 Tutorials

Word 2007 Slide Presentation

Tags for this post>> Excel 2007 | Powerpoint | Word 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 10:04 pm

Comments (0)

July 14, 2008

78 Free Excel 2007 Tutorial Videos

Here are 78 Free Excel 2007 Tutorial Videos (in Flash format) from Officesessions.com. These are well done training tutorials for the following functionality in Excel 2007: Add-Ins Tab, Data Tab, Formulas Tab, Home Tab, Insert Tab, View Tab, Inspect and Encrypt the worksheet, Edit Fonts, Formta Cells, Find and Replace, Spell Check, Using the Thesaurus, Protect Sheets and Workbooks, Insert Pictures, Insert Clipart, Insert Shapes, Create Charts, Create Headers and Footers, Update the Theme, Display Sum of Cells, Change the Background, Undo and Redo, and the Quick Access Bar..

Excel 2007 Video Tutorials:

1.About the Add-Ins Tab
2. About the Data Tab
3. How to Delete a Cell
4. How to Delete a Column
5. How to Delete a Row
6. About the Formulas Tab
7. About the Home Tab
8. About the Insert Tab
9. How to Create a Document
10. How to Open a Document
11. About the Page Layout Tab
12. How to Print a Document
13. How to Use the Print Preview
14. How to Use the Quick Print
15. About the Review Tab
16. How to Save a Document
17. How to Use the Save As
18. How to Save as a Binary Document
19. How to Save for Excel 97-2003
20. How to Save as a Macro-Enabled
21. About the View Tab
22. Properties
23. Inspect Document
24. Encrypt Document
25. Mark as Final
26. Turn Mark as Final Off
27. Run Compatibility Checker
28. Change Font
29. Change Font Size
30. How to Put Text in Italics
31. How to Bold Text
32. How to Underline Text
33. How to Change the Text Color
34. How to Change the Cell Color
35. How to Center, Left or Right Justify
36. How to Change a Cell to Dollars
37. How to Change a Cell to Other Currencies
38. How to Put a Cell Into Percentage
39. How to Increase Decimal Places
40. How to Find Something On the Sheet
41. How to Replace Found Text
42. How to Use the Autosum Feature
43. How to Cut Something
44. How to Paste Something
45. How to Use the Spell Check
46. How to Use the Research Function
47. How to Use the Thesaurus
48. How to Use the Translate Function
49. How to Protect a Sheet
40. How to Create a Table
51. How to Zoom In/Out
52. How to Insert a Picture
53. How to Insert Clipart
54. How to Insert Shapes
55. How to Insert Smart Art
56. How to Create a Column Chart
57. How to Create a Line Chart
58. How to Create a Pie Chart
59. How to Create a Bar Chart
60. How to Create a Scatter Chart
61. How to Create a Area Chart
62. How to Add Hyperlinks
63. How to Insert a Text Box
64. How to Create a Header
65. How to Create a Footer
66. How to Insert Word Art
67. How to Insert a Object
68. How to Decrease Decimal Places
69. Into to Excel
70. How to Copy Something
71. How to Change the Theme
72. How to Display Sum of Cells
73. How to Change the Background
74. How to Protect a Workbook
75. How to Add a Sheet
76. How to Use the Undo Function
77. How to Use the Redo Function
78. About the Quick Access Bar

Popularity: 25% [?]

Related Posts:

17 Access 2007 Database Tutorials

Free Training Videos for Microsoft Office Applications

Tags for this post>> Excel 2007

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 9:19 pm

Comments (0)

March 18, 2008

6 Excel 2007 Tutorials

These are 6 Excel 2007 Tutorials, from brainbell.com, that teach you how to create spreadsheets, use formulas and functions, work with charts and graphs, analyze data, and work with VBA and macros.

Worksheet Basics
Learn what Excel is used for, parts of Excel’s window, Ribbon user interface, shortcut menus, dialog boxes and how to navigate Excel worksheets.

Formulas and Functions
Formulas and worksheet functions are essential to manipulating data and obtaining useful information from the Excel workbooks. This tutorial present a wide variety of formula examples that uses many of Excel’s functions.

Charts and Graphics
Learn how to use Excel’s graphics capabilities to display your data in a chart and how to use Excel’s other drawing tools to enhance a worksheets.

Data Sharing
Learn how to protect workbooks and worksheets and how to extract data from a database or xml file and analyze it with Excel 2007, and save excel worksheets or workbook for the web so people can browse it.

Analyze Data
Learn how to obtain and analyze data with powerful and easy to use Excel capabilities.

VBA and Macros
Learn how to: automate routine operations with macros and VBA, use the macro recorder, how macros work, and where Excel stores them. Learn how to use Visual Basic editor, important code techniques, and few useful macros.

Popularity: 23% [?]

Related Posts:

Guides for Word 2007, Excel 2007, and PowerPoint 2007