Excel 2007 Intermediate

Request more details:

submit request
Description:
In Microsoft Office Excel 2007: Foundation, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, functions, formulae, arrays, tables, WordArt and also using Excel with Word, Access and other packages.

View other Excel Courses available
Prerequisites:
To ensure the successful completion of the Intermediate course, the completion of the Foundation course or equivalent knowledge is recommended.
Advanced File Tasks :
Using the My Places Toolbar
Navigating with My Computer
Performing Basic Tasks with My Computer
Changing Views
Saving your Files :
File Formats
File Properties
AutoRecover
Upgrading a Workbook
Using Templates :
Opening a Template
Downloading a Template
Using a Template
Creating a Template
Working with Functions and Formulas :
Using Formulas in Excel
Understanding Relative and Absolute Cell References
Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Buttons
Fixing Formula Errors
Displaying and Printing Formulas
Exploring Excel Functions :
What are Functions?
Finding the Right Function
Some Useful and Simple Functions
Using Functions in Excel :
Inserting Functions
Using Functions and AutoFill to Perform Difficult Calculations
Using the IF Function
Working with Nested Functions
Working with Names and Ranges :
What Are Range Names?
Defining and Using Range Names
Selecting Nonadjacent Ranges
Using AutoCalculate
Working with Array Formulas :
What are Array Formulas?
Using Basic Array Formulas
Using Functions with Array Formulas
Using the IF function in Array Formulas
Managing Tables :
What is a Table?
Creating Tables
Modifying Tables
What is the Total Row?
Working with Records and Fields :
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Quickly Adding Records to a Data Table
Deleting Records or Fields
Working with Tables and Filters :
Sorting Data in a Table
What is an AutoFilter?
Custom AutoFilters
Using an Advanced Filter
Copying Filtered Records
Using Excel as a Database :
Filtering with Wildcard Characters
Validating Your Data
What are Database Functions?
Enhancing your Workbook :
Customizing your Workbook
Inserting a Symbol or Special Character
Adding and Editing Shapes
Creating and Altering Diagrams
Changing the Diagram Type
Incorporating Text
Adding a Signature Line
Working with Text Boxes :
Adding a Text Box
Selecting a Text Box
Manipulating a Text Box
Formatting a Text Box
WordArt :
Adding WordArt to your Spreadsheet
Changing the Font Color
Changing the Outline Color
Adding Effects
ClipArt :
Finding ClipArt
Inserting ClipArt
Manipulating ClipArt
Inserting a Photographic Image
Using Objects :
Embedding Existing Files
Editing Embedded Objects
Embedding Parts of Files
Finalizing Your Workbook :
Protecting your Workbook
Protecting your Workbook
Protecting your Worksheets
Unlocking Cells
Protecting your Excel Files
Finishing Your Workbook :
Using the Document Inspector
Using the Compatibility Checker
Marking a Workbook as Final
Using Excel in Word :
Inserting Excel Data in Word
Linking Excel Data in a Word Document
Modifying Excel Data after Insertion
Insert an Excel Chart into a Word Document
Using Excel and Access :
Linking an Excel Workbook to an Access Database
Importing Table, PivotTable, and PivotChart Data from Access
Transforming an Excel Workbook into an Access Database
Using Excel With other Programs and Files :
Using Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text File
Importing Data from External Data Sources
Publishing a Workbook as a PDF File
Faxing a Workbook