Microsoft Excel Online Resources 2010

For those who have older versions of Excel (versions up to 2003) then your tutorials are here: Excel 2000 to 2003 (Or use the links on the left.)
	> Section One - Make a Start with Excel
		1 A first look at Excel 2007/2010 2 Excel Rows and Columns 3 Enter text and numbers in a Cell 4 How to Edit text in a Cell 5 How to Centre text and numbers 6 Font Formatting in Excel 2007/2010	7 How to change the colour of a Cell 8 How to Save your work in Excel 9 Currency Symbols in Excel 2007/2010 10 How to Merge Cells 11 Review Number One
	> Section Two - A more complex spreadsheet
		1 Introduction to Section Two 2 How to use AutoFill in Excel 2007/2010 3 Entering Simple Addition Formula 4 The SUM Function in Excel 5 The SUM Function Continued 6 Copy and Paste	7 How to use Paste Special 8 How to Multiply in Excel 2007/2010 9 Finishing your spreadsheet for this section 10 How to Add a Comment to a Cell 11 Review Number Two
	> Section Three - Excel 2007/2010 Charts
		1 How to Sort Data in Excel 2 Create an Excel Chart 3 Move and Resize your Chart 4 Chart Styles and Layouts 5 Chart Titles and Series Titles 6 Chart Layout Panel in Excel 2007/2010	7 The Format Chart Panel 8 Create a Pie Chart in Excel 9 Add Labels to a Pie Chart 10 Format Pie Chart Segments 11 Create a 2D Line Chart in Excel 12 Format your Axis Titles
	> Section Four - Formulas in Excel 2007/2010
		1 The SUM Function 2 How to Multiply in Excel 3 Subtract and Divide	4 Combining the Arithmetic Operators 5 A Budget Spreadsheet
	> Section Five - Functions in Excel 2007/2010
		1 The Average Function 2 The Date Function 3 Time Functions in Excel	4 A TimeTable Project 5 Financial Functions 6 The Student Averages Project
	> Section Six - Conditional Logic in Excel
		1 The IF Function 2 Conditional Formatting in Excel 2007/2010	3 CountIF 4 SumIF
	> Section Seven - Processing Data in Excel
		1 Data Tables in Excel 2007/2010 2 A Second Data Table 3 Excel Scenarios 4 Goal Seek 5 Absolute Cell References 6 Named Ranges in Excel 2007/2010	7 Create a Custom Name in Excel 8 Excel Pivot Tables 9 Pivot Tables, Part Two 10 The LOOKUP Function 11 The VLOOKUP Function in Excel
	> Section Eight - Advanced Excel 2007/2010
		1 How to Create an Excel Template 2 Data Forms in Excel 2007/2010 3 Drop Down Lists in Excel 4 Add your own Error Messages 5 Excel and Web Integration	6 Hyperlinks in Excel 7 Object Linking and Embedding 8 Reference other Worksheets 9 Insert Drawing Objects
All Course Material ©Copyright of Home and Learn

Beginners Computing
Word 2007 to 2010
Word 2000 to 2003
> Excel 2007 to 2010 <
Microsoft Excel to 2003
Web Design
Cascading Style Sheets
Javascript
Visual Basic .NET
Beginners PHP
C# .NET
Java for Beginners

http://www.homeandlearn.co.uk/excel2007/Excel2007.html







=============================================

IT is recommended that you have EXCEL running at the same time. You can try what you are reading. On an PC you can toggle back and forth between the Tutorial and Excel using the ALT-TAB. If you are using this on a Mac, switch back and forth with the finder. Using either machine, if you can tile the windows just a little you can switch back and forth by clicking on the window of the program you want to become active.

• Welcome
• What is a spreadsheet
• Why on a computer?
• Basics of a spreadsheet
  • columns
  • rows
  • cells

Types of Data

• Labels
• Constants
• Formulas
  • Basics
  • change in formulas
  • Basic Math
  • Selecting cells

Specific Formulas (or FUNCTIONS)

• SUM
• AVERAGE
• MAX
• MIN
• COUNT
• COUNTA
• IF
• PMT
• SIN COS TAN etc.
• Function Wizard

copying formulas

• fill down
• absolute positioning
• fill right

Formatting

• formatting text
• formatting numbers
• column width

inserting a column

inserting a row

charts or graphing

get ready

---

---

TAKE THE QUIZ

http://people.usd.edu/~bwjames/tut/excel/

Microsoft Excel 2007 Tutorial — Free & Online

By Denise Etheridge

You can use this free online tutorial to learn Microsoft Excel 2007. Click here to start the tutorial. If you are using an older version of Excel, click here for our Excel 2003/2002 tutorial or click here for our Excel 97 tutorial.

Lesson 1: Entering Text and Numbers
Microsoft Excel is an electronic spreadsheet that runs on a personal computer. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This lesson will introduce you to the Excel window. You use the window to interact with Excel.

• The Microsoft Excel Window
• The Microsoft Office Button
• The Quick Access Toolbar
• The Title Bar
• The Ribbon
• Worksheets
• The Formula Bar
• The Status Bar
• Move Around a Worksheet
• Go To Cells Quickly
• Select Cells
• Enter Data
• Edit a Cell
• Wrap Text
• Delete a Cell Entry
• Save a File
• Close Excel

Click here to start Lesson 1
Lesson 2: Entering Excel Formulas and Formatting Data
Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data.

• Set the Enter Key Direction
• Perform Mathematical Calculations
• AutoSum
• Perform Automatic Calculations
• Align Cell Entries
• Perform Advanced Mathematical Calculations
• Copy, Cut, Paste, and Cell Addressing
• Insert and Delete Columns and Rows
• Create Borders
• Merge and Center
• Add Background Color
• Change the Font, Font Size, and Font Color
• Move to a New Worksheet
• Bold, Italicize, and Underline
• Work with Long Text
• Change a Column's Width
• Format Numbers

Click here to start Lesson 2
Lesson 3: Creating Excel Functions, Filling Cells, and Printing
By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. You can also use Microsoft Excel to fill cells automatically with a series.For example, you can have Excel automatically fill your worksheet with days of the week, months of the year, years, or other types of series.
A header is text that appears at the top of every page of your printed worksheet. A footer is text that appears at the bottom of every page of your printed worksheet. You can use a header or footer to display among other things titles, page numbers, or logos. Once you have completed your Excel worksheet, you may want to print it. This lesson teaches you how to use functions, how to create a series, how to create headers and footers, and how to print.

• Using Reference Operators
• Understanding Functions
• Fill Cells Automatically
• Create Headers and Footers
• Set Print Options
• Print

Click here to start Lesson 3
Lesson 4: Creating Charts
In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data, your chart will automatically Update. This lesson teaches you how to create a chart in Excel.

• Create a Chart
• Apply a Chart Layout
• Add Labels
• Switch Data
• Change the Style of a Chart
• Change the Size and Position of a Chart
• Move A Chart to a Chart Sheet
• Change the Chart Type

Click here to start Lesson 4

http://www.baycongroup.com/excel2007/04_excel.htm

Content

• What’s New In Excel 2010
• PivotTables
• Freeze Panes
• Cell References
• Absolute Cell References
• Sparklines
• Summing
• Tables
• Merge And Center
• Shortcuts
• COUNT
• Offset
• Save As PDF
• Microsoft Excel Training
• Number Formatting
• DATEDIF
• Quick Access Toolbar
• Drop Down Lists
• Make A 2011 Calendar In Excel
• Excel Resources
• Count The Number Of Cells With Text
• Remove Duplicates
• VLOOKUP
• Backstage View
• Developer Tab
• Excel Macro
• Excel Text
• Formulas
• Functions
• Excel Smart Tags
• Excel Viewer
• Hyperlinks
• Conditional Formatting
• Scatter Charts
• Column Charts
• Area Charts
• Bar Charts
• Pie Charts
• Line Charts

http://www.excel-2010.com/whats-new-in-excel-2010/


There are a great many Microsoft Excel resources on the internet, and some are of a really high quality. Some even cater to Excel 2010 – the most recent version of Excel. To help you get to grips with this ubiquitous spreadsheet program, we’ve listed some of the better Excel resources here.

• Excel Tutorials by Lynda.com – very high quality video tutorials for all levels at lynda.com
• Mr Excel – the Excel monolith! The number one destination if you need help with Excel
• OzGrid – a fantastic resource for Excel tutorials and tips. One of the better ones out there
• The Financial Modeler – a focus on financial models, with sometimes complicated tutorials. Older versions of Excel covered.
• Excel Digest – numerous well written Excel tutorials.
• XL Dennis – frequently updated Excel tutorial site that also provides tutorials on Microsoft .NET technology too
• Easy XL – this is actually a product that adds over 50 time saving data analysis and manipulation features to Excel. From the MrExcel people and worth a mention.
• Excel Is Fun – a whole bunch (over 1,000) of free video Excel tutorials on Youtube
• Microsoft Excel Blog – Excel tutorials and how-tos straight from the horse’s mouth
• Spreadsheet Page – a plethora of Excel tips by John Walkenbach
• Mead In Kent – a selection of Excel tutorials, some a little more advanced
• Excel Tutorials – the tutorials here seem a little dated, but the principles are still useful
• Baycon Group – a variety of Excel tutorials for beginners and upwards
• Excel 2007 Tutotials – a selection of easy to follow Excel 2007 tutorials. An older version of Excel is used, but they are still useful.
• Graphing with Excel – help with visualizing data in Excel
• M I Stupid – a small selection of video tutorials on Excel

http://www.msoffice-tutorial-training.com/excel-2010-tutorials.html

Free Excel 2010 Tutorials and Links Index

Getting Started

• Getting Started with Microsoft Excel 2010!
  
• The First Step...Knowing The Excel 2010 Screen Elements
  
• What You Can Do with The Excel 2010 Ribbon?
  
• Customizing Excel 2010 Ribbon by Adding New Tab, Group and Command to It
  
• Adding and Removing Commands From The Quick Access Toolbar
  
• Guide to Customize the Quick Access Toolbar in Excel 2010

Excel 2010 Essentials

• What are the Excel 2010 Three Different Views?
  
• Discover How to Use the Excel 2010 Smart Tags Feature Correctly!
  
• Applying Gallery Effects to The Spreadsheet Objects in Excel 2010

Formulas and Functions

• Discover the 5 Types of Formula and Some Tips in Creating Formulas
  
• Why Mastering Your Excel 2010 Functions Are So Critical?
  
• Knowing the different types of Function Argument used in Microsoft Excel
  
• Excel 2007/2010 Relative Cell Reference Real-live Example Demonstration
  
• Excel Absolute Cell Reference (Example Demonstration - Part 1)
  
• Excel Absolute Cell Reference (Example Demonstration - Part 2)