Wednesday, July 4, 2012

EXCEL FREE TRAINING AND MICROSOFT OFFICE



http://www.free-training-tutorial.com/


Basic Excel Functions: Sum, Average, Count, Countif
(Excel Online Training)

SUM - Calculating the sum of numbers
AVERAGE - Calculating the average of numbers
MAX, MIN - Highest and lowest numbers
COUNT - Counting the cells that contain numbers
COUNTIF - Counting cells that match some specific criteria






COUNTA - Counting cells that contain any value
COUNTBLANK - Counting the empty cells
More Excel videos are in the full course here

Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Excel Charts (Graphs)
Worksheets Quick Functions Excel Sort
Edit Cells The IF Statement Excel Filter
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Sumif Function Pivot Table
The Fill Handle Excel Formulas Create a Drop Down List
Excel Keyboard Shortcuts First Aid



MS Office Training
Excel Training
Microsoft Word Training
PowerPoint Training
Excel 2007 Books
Office 2010 Books
Free Training Courses
A Full Excel Course


Typing Training
Typing Games For Kids
Typing Tutorial
Typing Test

-->



Skip Navigation Links Home > All Topics >
Microsoft Office
 >
Office 2010
 >
Excel 2010

Excel 2010

Excel 2010 is a spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows you to store, manipulate and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of Sparklines and Slicers.
Get our new GCF Excel 2010 Tutorial App for Android and iPhones.
Lessons Interactives Extras Videos

  • How to Navigate an Excel Workbook
    Get to know the layout of an Excel Workbook and explore its various tools and features.
    Play

  • Backstage View
    Explore the new Backstage view in Excel 2010 which includes features for saving, printing and more.
    Play

  • Formatting Numbers in Excel
    Review the various ways Excel formats numbers and displays values in a cell.
    Play

  • Print Pane
    Explore the various features of the Print pane in Excel 2010's Backstage view.
    Play

  • Explore the Function Library
    Learn how to search and find functions in Excel's Function Library.
    Play

  • Chart Types in Excel 2010
    Review examples of the types of charts that are available in Excel 2010.
    Play

  • Parts of a Chart
    Identify the different parts of a chart in order to improve your understanding of them.
    Play


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)