Mastering Excel 2007

Learn Microsoft Excel 2007

Put the 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 nor spreadsheet is necessary

Why our amazing elearning technology 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)
• Side-by-side learning and doing - best for using the Excel 2007 and tutorial at the same time.

Level: Basic to Intermediate

Course Outline:

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

Content: CD-ROM Online Access

System Requirements:

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

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