Learn Microsoft Excel 2007
Put the Excel 2007 to work for you in a few hours!
Click here to see a demo (it will take a few minutes to download the actual lesson)
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:
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
