Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Microsoft Office 2003
Office 2007
Office 2010
Windows Vista
Windows 7
Visio 2003 & 2007
OneNote 2003 & 2007
Project 2007
SharePoint 3.0 User
Access 2007
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007
Office For Mac 2008
Acrobat 8 Pro
ADO .NET 2.0
Crystal Reports XI
Flash 8

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 

Order NCSA OnDemand today and get access to over 7500 quality instuctor led videos and training courses covering today's most popular software programs and programming languages including:

          many more!

PlanComparison

Customers Include:

  • Texas Education Foundation
  • Job Corps
  • Piggly Wiggly
  • Texas A&M Corpus Christi
  • Airsplat
  • Asian College of Technology
  • INOVA Federal Credit Union
  • Capital Area Career Center
  • Las Positas College
  • Many More!


Course Highlights

  • Quickly find old features within the new results-oriented user interface and Ribbon.
  • Learn to write advanced formulas and use functions such as IF, HLOOKUP and DSUM.
  • Collaborate with team members using Excel’s comments, security and data validation options.
  • Save time with Excel’s table and list management features, including AutoFilter and Automatic Subtotals.
  • Create and use interactive PivotTables to summarize and retrieve sets of data on the fly.

About This Course

This Microsoft Office Excel 2007 Essentials Training Course contains three levels of instruction to walk you through performing many time-saving tasks in Excel, beginning with an introduction to the new results-oriented interface. The course topics appeal to all Excel users – beginner through advanced. You will learn everything from creating professional-looking charts to sharing data with enhanced security and managing your spreadsheets more effectively.

In this course, you’ll learn from a combination of quick tips and detailed instruction on using Excel for team collaboration and creating templates to work smarter, not harder. You will learn how to create professional-looking spreadsheets through modifying the worksheet layout and formatting.

And, of course, you will learn about harnessing the power of Excel formulas with an entire section devoted to the anatomy of formula. To really understand formulas, there are additional lessons on advanced functions (such as Nested IF Statements, HLOOKUP, VLOOKUP and DSUM) and data consolidation using three dimensional formulas, position and category.

There are over 100 lessons in this Excel course – all designed to increase your productivity.

Microsoft Excel 2007: Beginner


1.0 Getting Started
1.1 Launching Excel 2007
1.2 Touring the Excel Window
1.3 Using the Office Menu
1.4 Using the Quick Access Toolbar
1.5 Save vs. Save As
1.6 File and Folder Management
1.7 Opening and Closing Files
1.8 Getting Help
2.0 Entering Data
2.1 Navigation and Selection Techniques
2.2 Data Entry Techniques
2.3 AutoFill
2.4 AutoComplete
2.5 Undo and Redo
2.6 Exiting Excel
3.0 Changing Worksheet Layout
3.1 Inserting Rows, Columns and Cells
3.2 Deleting Rows, Columns and Cells
3.3 Adjusting Column Widths and Row Heights
3.4 Hiding Columns and Rows
3.5 Moving and Copying Data
3.6 Create, Modify and Delete Named Ranges
3.7 Go To, Find and Replace
4.0 Entering Formulas
4.1 Anatomy of a Formula
4.2 Using the Formula Tab
4.3 AutoSum
4.4 Basic Functions
4.5 Copying Formulas
5.0 Formatting
5.1 Using the Home Tab
5.2 Using the Quick Format Mini Toolbar
5.3 Number Formats
5.4 Format as a Table
5.5 Merging and Splitting Cells
5.6 Applying Worksheet Backgrounds
6.0 Using Themes and Styles
6.1 Applying Themes
6.2 Creating Custom Themes
6.3 Applying Styles
6.4 Creating Custom Styles
7.0 Printing
7.1 Using the Page Layout Tab
7.2 Changing Margins and Page Orientation
7.3 Exploring Worksheet Views
7.4 Adding Headers and Footers
7.5 Adding Print Titles and a Print Area
7.6 Viewing and Setting Page Breaks
7.7 Printing
8.0 Charts
8.1 Using the Insert Tab
8.2 Creating a Chart
8.3 Using the Chart Contextual Tabs
8.4 Creating a Chart Sheet
8.5 Adding and Removing Chart Data
8.6 Format and Resize Charts


Microsoft Excel 2007: Intermediate


1.0 Managing Workbooks
1.1 Creating New Workbooks from a Template
1.2 Rename and Move Workbook Tabs
1.3 Insert and Delete Worksheets
1.4 Copy and Paste Worksheets
1.5 Using the View Tab
1.6 Splitting Your Worksheet View
1.7 Freezing and Unfreezing Your View
2.0 Tables and Data Management
2.1 Table Guidelines
2.2 Using the Data Tab
2.3 Sorting
2.4 Grouping and Outlining Data
2.5 AutoFilter
2.6 Advanced Filter Using Single Criteria
2.7 Advanced Filter Using Multiple Criteria
2.8 Automatic Subtotals
3.0 Using Cell References
3.1 Using Relative Cell References
3.2 Using Absolute Cell References
3.3 Using Mixed Cell References
4.0 Auditing
4.1 About Auditing
4.2 Tracing Precedents
4.3 Tracing Dependents
4.4 Tracing Errors
5.0 Creating Web Pages from Workbooks
5.1 Publishing a Web Page
5.2 Viewing Your Published Web Page
6.0 Using Excel with Other Applications
6.1 Importing Data to Excel
6.2 Exporting Data from Excel
6.3 About XML
7.0 Customizing Excel
7.1 Customizing the Quick Access Toolbar
7.2 Modifying Excel Options
8.0 Using Scenarios and Watching Cells
8.1 Creating and Displaying Scenarios
8.2 Editing and Removing Scenarios
8.3 Summarizing Scenarios
8.4 Using the Watch Window
9.0 PivotTables and PivotCharts
9.1 About PivotTables and PivotCharts
9.2 Creating a PivotTable
9.3 Modifying a PivotTable
9.4 Creating a PivotChart
9.5 Modifying a PivotChart


Microsoft Excel 2007: Advanced


1.0 Collaborating
1.2 Inserting and Deleting Comments
1.3 Viewing and Printing Comments
1.4 Protecting Workbooks, Worksheets and Cells
1.5 Enabling Workbook Security
1.6 Sharing Workbooks
2.0 Advanced Formulas and Functions
2.1 IF Functions
2.2 Nested IF Functions
2.3 Using the VLOOKUP Function
2.4 Using the HLOOKUP Function
2.5 Using the DSUM Function
3.0 Data Consolidation
3.1 About Data Consolidation
3.2 Three Dimensional Formulas
3.3 Data Consolidation by Position
3.4 Data Consolidation by Category
4.0 SmartArt
4.1 About SmartArt
4.2 Creating a List
4.3 Creating a Hierarchy
4.4 Creating a Pyramid
4.5 Editing SmartArt
5.0 Track Revisions
5.1 Tracking Changes
5.2 Accepting and Rejecting Changes
6.0 Data Validation and Conditional Formatting
6.1 Working with Data Validation Rules
6.2 Set Conditional Formatting
6.3 Use Expressions in Conditional Formatting
7.0 Creating Templates
7.1 Using Excel Pre-Defined Templates
7.2 Creating and Modifying a Template
8.0 Macros
8.1 Create a Macro
8.2 Run a Macro
8.3 Edit a Macro

 



Web-based Training Courses, including 7,500+ Videos & Articles, covering:

Microsoft Office
2010 | 2007
Microsoft Windows
7 | Vista
Visio
2003 / 2007
OneNote
2003 / 2007
Project
2003 | 2007
Sharepoint
3.0
Access
2010 | 2007
Excel
2010 | 2007
Outlook
2010 | 2007
PowerPoint
2010 | 2007
Word
2010 | 2007
Office for Mac
2008
Excel for Mac
2008
Entourage for Mac
2008
PowerPoint for Mac
2008
Word for Mac
2008

Acrobat 8 Professional ADO.NET 2.0 ASP.NET 2.0 for Visual Basic 2005
C# 2005 Crystal Reports XI Exchange Server 2003
Flash 8 ActionScripting Flash 8 for Designer FrontPage 2003
Mind Manager 7 Pro + Project 2007 Mind Manager 7 Pro Fundamentals Office 2007 - What's New
Photoshop CS2 PHP Programming QuickBooks Pro 2006
SharePoint End User: Administrator SharePoint End User: Contributor SharePoint End User: Reader
Small Business Server 2003 SQL Server 2005 Visual Basic 2005
Windows Server 2003


Typing Speed Test
Test your typing speed with our certified typing speed test today.



  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

© 2002-2011 National Computer Science Academy, All Rights Reserved.