Learn Excel 2007 Training Tutorial

Learn to put Excel 2007 to work for you in a few hours!

• Get to know the interface and features of Excel 2007
• Learn to use Excel 2007 so that you can create a spreadsheet with formula, graph, chart, and much more.
• Lessons include text, voice, and mouse activities to accommodate the three basic learning styles: reading, hearing, and doing.
• The best step-by-step tutorial using the latest eLearning technology 
• No prior knowledge of using Excel or a spreadsheet is necessary

Advantages of amazing elearning technology that allows you to learn Excel 2007 in a few hours.

• Each step comes with voice, text, hightlighted box, and mouse activity
• Crystal clear audio delivered by professional narrator
• Texts are written and edited by professional editor.
• Mouse motion to draw your attention
• Highlighted box to show you exactly where to click
• Easy navigation to each topic
• Playback controller to move a slide forward, backward and stop
• Full-size screen display for maximum viewing (1024 x 768)

 Level:  Basic to Intermediate

  Lesson 1:  Getting Acquainted with Excel 2007

• The interface of Excel 2007
• How to customize the quick access toolbar
• The status bar
• How to use help
• New features of Excel 2007

Lesson 2: Basic Operation

• Create a new worksheet  
• Perform basic operations upon cells  
• Add comments  
• Sort your data  
• Use and manipulate multiple worksheets  
• Split windows and freeze panes  
• Protect your worksheet  
• Use Print Review
• Save a worksheet

Lesson 3:  Worksheet Format

• Change fonts and font styles
• Change number format settings
• Adjust row height and column width
• Hide/unhide columns and cells
• Change borders and shading
• Use formatting 

Lesson 4:  Formula and Functions

• Use formulas
• Use array formulas
• Insert functions
• Use AutoSum  

Lesson 5:  Editing Graphics

• Insert pictures
• Edit pictures
• Use SmartArt
• Insert shapes  

Lesson 6:  Chart Design

• Insert Charts
• Resize a chart
• Move a chart
• Format the text settings
• Choose appropriate chart types
• Re-choose source data
• Change layouts and patterns
• Use auto-update
• Edit the title
• Hide data labels
• Show vertical axis and gridlines
• Set background color
• Format data series
• Insert WordArt
• Display source data in the chart

Lesson 7:  Managing Data Lists and Worksheet  

• Create a data list
• Filter data
• Sort data
• Show subtotal
• Create PivotTable

Lesson 8:  Excel Macro and Application  

• Show the developer tab.
• Record Macros
• Edit Macros
• Use Macro Security

Lesson 9:  Sharing and Networking  

•  Share your workbook
• Tack changes
• Protect shared workbooks
• Create hyperlinks  

System Requirements:

• Windows 9x/ME/NT/2000/XP/VISTA
• Pentium 133 Mhz or higher 
• 32MB RAM  
• 10MB free disk space  
• 24x CD-ROM

Brand New in shrinkwrapped plastic case