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

Related Posts:

Free Books: Microsoft Office 2003 Word, Excel, PowerPoint, Outlook, Access

Microsoft Excel Workshop Training Handouts

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

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

Related Posts:

20 Office 2007 eBooks

PowerPoint 2007 Interactive Guide

Word 2007 Interactive Guide

Quick Reference Cards for Office 2007 Apps and more

7 PowerPoint 2007 Tutorials

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

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

Related Posts:

17 Access 2007 Database Tutorials

20 Office 2007 eBooks

Free Excel 2007 Course from Dell

Free Training Videos for Microsoft Office Applications

6 Excel 2007 Tutorials

Tags for this post>> Excel 2007

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

Related Posts:

20 Office 2007 eBooks

Excel 2007 Tutorial

Excel 2007 Data Analysis Tutorials

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Free Excel 2007 Course from Dell

Tags for this post>> Excel 2007

Here are Office 2007 Training Handouts and Slides for helping you make the switch to Office 2007, from Kansas University. These Office 2007 tutorials and slides cover Office 2007 in general, along with Access, Excel, Outlook, and Word. These will show you how to use the Ribbon, which is a new user interface feature that takes some practice using to get used to. These documents are in pdf format.


Office 2007: Making the Switch
This introductory session offers an overview to the main features in Office 2007

Office 2007: Making the Switch Handout
An excellent introduction to Microsoft Office 2007 and Vista

Access 2007: Making the Switch
Access 2007: Making the Switch is designed for experienced Microsoft Access users who have worked with earlier versions of Microsoft Access and who have upgraded to Microsoft Access 2007.

Excel 2007: Making the Switch
Excel 2007 has a new design that makes your work easier, faster, and more efficient. The new Ribbon puts the commands you use most often in plain sight on your work surface instead of hidden in menus or dialog boxes. Ready-made cell styles let you quickly format your worksheet to make it easier to read and interpret. The new Page Layout view shows how your printed worksheet will look as you’re creating it. Get familiar with the new design, and to see for yourself that you won’t have to learn Excel all over again.

Outlook 2007: Making the Switch
Find commands on the Ribbon and do the things you do every day: read and send e-mail, work with appointments and meetings, and use your contacts.

Word 2007: Making the Switch
Word 2007 has been redesigned to make your work easier, faster, and more efficient. It introduces a new feature, the Ribbon, which brings the most popular commands to the forefront. See how this new workspace will enable you to create and edit documents quickly and smoothly. Get familiar with what’s new and see for yourself that you won’t have to learn Word all over again.

Popularity: 32% [?]

Related Posts:

13 Access 2007 Tutorials

Excellent PowerPoint Tutorials

Microsoft Office Workshop Tutorial Training Handouts

PowerPoint 2007 Interactive Guide

PowerPoint 2003 and PowerPoint XP Tutorials

Tags for this post>> Access 2007 | Excel 2007 | Outlook 2007 | Word 2007

Here are 5 Excel 2007 Tutorials that demonstrate how to use the following features using Excel 2007: Excel’s new interface, format tables, create and use formulas, autosum function, autoformat function, concatenate function, Sum If function, and the Vlookup and Hlookup functions. These Excel tutorials are in pdf format.


The New Interface in Excel 2007

• Navigate the New Interface
• Explore Interface Tabs
• Customise Quick Access Toolbar
• Explore the New Office Button
• Explore the mini toolbar
• Customise Excel
• Format Tables
• Save worksheet in a different Version

Formatting Tables with Excel 2007

• Insert, Columns Rows &Tables, Delete, Rename, Add, Worksheets
• Adjust size of Columns and Rows
• Use Set Formats for Tables
• Freezing Rows &Columns
• Modifying Rows and Columns
• Formatting Fonts
• Use Colour
• Apply and Remove Filters
• Format Cells(set condition of cells)

Formulas in Excel 2007

• Basic Formulas
• Order of Preference
• Relative Referencing
• Absolute Referencing
• Formula Ribbon

Basic Functions with Excel 2007

• Explore the Function Tools
• Use AutoSum Functions – Add & Max
• Turn off AutoFormat Settings
• Use Text Functions Trim, Left & Upper

Advanced Functions with Excel 2007

• Concatenate Function
• Sum If Function
• Vlookup & Hlookup Functions
• If Functions

Popularity: 22% [?]

Related Posts:

20 Office 2007 eBooks

6 Excel 2007 Tutorials

Excel 2007 Tutorial

Excel 2007 Data Analysis Tutorials

Guides for Word 2007, Excel 2007, and PowerPoint 2007

Tags for this post>> Excel 2007

Microsoft has made many modifications to the user interface for all Office 2007 applications, and that means relearning how to use most Excel features in Excel 2007. All menus and toolbars have been replaced with a new “Ribbon” interface and Tabs. These Ribbon and Tabs are located horizontally across the screen and graphically depict groups of features and functionality.

Here are Four Free Training Resources for Learning How to Use Excel 2007. The first one is an online course that will help you learn how to use the Ribbon, find familiar features, and understand and use the new XML file format. The second one is a reference for the locations of Excel 2003 commands in Excel 2007. The third learning resource is a 3 page Excel 2007 Charting tutorial. The fourth document is a spreadsheet that maps all Excel 2003 menu and toobar items to Excel 2007′s ribbon interface.


1) Free Excel 2007 Online Course: Up to Speed with Excel 2007

Learn how to use the new user interface of Microsoft Excel 2007, and find out how to do the everyday tasks that you normally do in Excel.

Length: 30–40 minutes

Course Goals:

• Get a handle on the new look of Excel.
• Find everyday commands on the Ribbon: Cut, Copy, Paste, Insert Sheet Rows, Insert Sheet Columns, and Sum.
• Save workbooks in the new Excel file formats.

This course includes:

• Three self-paced lessons and two practice sessions for hands-on experience. Practices require Excel 2007.
• A short test at the end of each lesson; tests are not scored.
• A Quick Reference Card you can take away from the course.

Excel 2007 Course Contents:

Overview

What’s changed, and why

• What’s on the Ribbon?
• More commands, but only when you need them
• More options, if you need them
• Put commands on your own toolbar
• What about my favorite keyboard shortcuts?
• A new view
• Different screen resolutions can change what you see
• Practice
• Test yourself

Get to work in Excel

• Open your file
• Insert a column
• Format and edit data
• Enter a formula
• Add headers and footers
• Print
• The New Workbook window
• Practice
• Test yourself

A new file format

• How do I work with people who don’t have Excel 2007 yet?
• Benefits of the new format
• New file formats, new options when you save
• Test yourself

Feedback

Quick Reference Card


2) Reference: Locations of Excel 2003 commands in Excel 2007

This tutorial describes the items of the new Microsoft Office Fluent user interface that are in Microsoft Excel 2007. It also shows you commands which you may already know how to use in Microsoft Excel 2003, and explains how to do the same tasks or features in Excel 2007.

• Introducing the new interface
• Adding commands to the Quick Access Toolbar
• New locations of familiar commands

3) Excel 2007 Tips for Creating Functional and Attractive Charts

This article explains the Top Ten Tips and Tricks for Excel 2007 Charts. Excel charts have been given a makeover in Excel 2007 and the Chart Wizard of earlier versions is now gone. Find out how to create functional and attractive charts using Excel 2007.

Excel Charting Tips – Pages 2 and 3:

• Top Ten Tips and Tricks for Excel 2007 Charts
• More Tips and Tricks for Creating Excel 2007 Charts

4) Excel 2007 Ribbon Mapping from Excel 2003

This spreadsheet (.xls) maps all of the menu and toolbar features and options in Excel 2003 to the equivalent in Excel 2007 for each of the following:

• Standard toolbar
• Formatting toolbar
• PivotTable toolbar
• Chart Toolbar toolbar
• Reviewing
• Forms
• Stop Recording
• External Data
• Formula Auditing
• Circular Reference
• Visual Basic
• Web
• Control Toolbox
• Exit Design Mode
• Watch Window
• Borders
• Protection
• Text to Speech
• List
• Compare Side by Side
• Drawing toolbar
• WordArt
• Pictures
• Organization Chart
• Diagram
• Ink Drawing and Writing
• Ink Annotations
• Shadow Settings
• 3D Settings
• File Menu
• Edit Menu
• View Menu
• Insert Menu
• Format Menu
• Tools Menu
• Data Menu
• Chart Menu
• Windows Menu
• Help Menu

Popularity: 5% [?]

Related Posts:

20 Office 2007 eBooks

Free Excel 2007 Course from Dell

Guides for Word 2007, Excel 2007, and PowerPoint 2007

6 Excel 2007 Tutorials

Excel 2007 Course Tutorials

Tags for this post>> Excel 2007

Here is a free Excel course from Dell, titled What’s New in Microsoft Excel 2007. This free Excel course shows and demonstrates for you the new Office user interface and application navigation to access the common Excel features you need to use. To start the free Excel 2007 course on Dell’s web page, click on the “Launch Your Free Course Now!” link or the course’s title. (Your pop-up blocker must be disabled and free registration is required.)


Excel 2007 Course Overview: Modules & Lessons:

• Course Overview
• Navigation Overview
• What’s New in Microsoft Office Excel 2007
• Exploring the New Interface
• The Ribbon
• Tasks and Tabs
• The Enhanced Workbook
• Self Test
• Organizing Business Information
• How to Insert and Format Tables
• External Sources of Business Information
• New Formula Features
• How to Create Professional-Looking Reports
• Self Test
• Analyzing Business Information
• How to Analyze Data Using Conditional Formatting
• New Chart Features
• Create PivotTables and PivotCharts
• Analysis of Business Information Using Office Excel Services
• Self Test
• Sharing and Managing Business Information
• Benefits of Publishing Spreadsheets
• Different Ways to Interact with a Spreadsheet in a Browser
• User Permissions in Office Excel 2007
• What Are Business Intelligence Dashboards?
• What Are Snapshots?
• Self Test
• Module Summary
• Glossary
• Next Steps

Popularity: 13% [?]

Related Posts:

Free Visio 2007 Course from Dell

Free Word 2007 Course from Dell

Free PowerPoint 2007 Course from Dell

Free Access 2007 Course from Dell

Free Outlook 2007 Course from Dell

Tags for this post>> Excel 2007

Here are 23 Excel Ebooks, linked at itebookhome.com, covering many topics and areas of Microsoft Excel, versions 2000, 2002 (XP), 2003, and 2007. These ebooks will teach you about many of Excel’s key components, features, toolbars, and its user interface. They will give you lots of spreadsheet examples, formulas, techniques, and tips, while also providing step-by-step instructions, useful graphics, and suggestions performing time-saving tasks. You can learn the basics on how to create spreadsheets, add and format data in cells and ranges, preview and print reports, create charts, and utilize formulas and functions. You can also learn many of Excel’s advanced features as described below. (To download Excel ebooks at rapidshare.de, first click on the Free button, then wait a few seconds, and then click on the download link or button.)

The areas and technical topics covered by these Excel ebooks are as follows:

• The redesigned user interface with tabbed toolbar in Excel 2007
• Excel VBA and .NET
• Macros for automating tasks, transposing cells, adding formula details, globally changing values, and more.
• Lists and XML data, using Visual Studio Tools for Office, and using Web Services and Infopath
• Building reporting solutions with Excel – Pivot Table reports and spreadsheet reports,
• Using Excel as a calculating tool for finance – financial statements, budgets, capital budgeting, pro forma statements, cost of capital, etc.
• Using Excel add-ins (written in C and C++) with financial applications
• How to use Excel for computations, circuit modeling, graphing, and data analysis in regards to electronics design
• How to use Excel for statistical tests and modeling, such as bootstrap, decision trees, t-test, and permutations
• Using XML with Excel
• Excel hacks for reducing workbook and worksheet frustration, and adjusting features such as pivot tables, charts, formulas and functions
• What-If data analysis tools using Goal Seek, Data Tables, Scenarios, and Solver
• Integrating Excel and Access
• VSTO – the new Excel Macro programming language

The 23 available Excel Ebooks are as follows:

• Excel 2007 Bible
  
• Financial Analysis with Microsoft Excel
  
• Excel 2007 The Missing Manual
  
• Microsoft Excel for Electronics Engineers
  
• Programming Excel with VBA and .NET
  
• Excel Advanced Report Development
  
• Introduction to Statistics through Resampling Methods and Excel
  
• Guide to Developing Applications Using Excel
  
• Excel 2003 Programming for Developers
  
• Excel VBA Macro Programming
  
• Excel Add-ins in C/C++ – Applications in Finance
  
• Excel Pivot Tables Book
  
• From VBA to VSTO
  
• Excel Programming Course
  
• Excel Tips and Tools
  
• Excel 2003 VBA Programming Reference
  
• Excel What-If Data Analysis Tools: Goal Seek, Data Tables, Scenarios
  
• Excel 2003 Programming with VBA
  
• Excel VBA Beginner Programming
  
• Excel for Starters: The Missing Manual
  
• Integrating Excel and Access
  
• Excel for Chemists
  
• Fixing Problems in Excel 2003, 2002, 2000

Popularity: 26% [?]

Related Posts:

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

27 Free Microsoft Office Training eBooks

11 Microsoft Office eBooks

8 Free Ebooks for Microsoft Word, Excel, Access, Office 2003

20 Office 2007 eBooks

Tags for this post>> Excel | Excel 2003 | Excel 2007