Microsoft Office Excel 2007 Intermediate

After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel. You will learn important features that will save you time and make you much more efficient with the program.

Course Outline

After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel.  You will learn important features that will save you time and make you much more efficient with the program.

 

Advanced File Tasks 
Using My Computer within Excel  
Using the My Places Toolbar   
Navigating with My Computer 
Performing Basic Tasks with My Computer      
Changing Views           
Step-By-Step  
Skill Sharpener
Saving your Files  
File Formats    
File Properties 
AutoRecover   
Upgrading a Workbook           
Step-By-Step 
Skill Sharpener
Using Templates    
Opening a Template     
Downloading a Template         
Using a Template        
Creating a Template     
Step-By-Step  
Skill Sharpener
Case Study  
Review Questions      

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          
Step-By-Step  
Skill Sharpener
Exploring Excel Functions  
What are Functions?    
Finding the Right Function        
Some Useful and Simple Functions       
Step-By-Step  
Skill Sharpener
Using Functions in Excel    
Inserting Functions      
Using Functions and AutoFill to Perform Difficult Calculations   
Using the IF Function   
Working with Nested Functions          
Step-By-Step  
Skill Sharpener
Working with Names and Ranges  
What Are Range Names?        
Defining and Using Range Names         
Selecting Nonadjacent Ranges 
Using AutoCalculate    
Step-By-Step  
Skill Sharpener
Working with Array Formulas       
What are Array Formulas?       
Using Basic Array Formulas     
Using Functions with Array Formulas   
Using the IF function in Array Formulas
Step-By-Step  
Skill Sharpener
Case Study  
Review Questions      

Managing Tables       
Working with Tables         
What is a Table?          
Creating Tables           
Modifying Tables         
What is the Total Row?           
Step-By-Step  
Skill Sharpener
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       
Step-By-Step  
Skill Sharpener
Working with Tables and Filters    
Sorting Data in a Table
What is an AutoFilter? 
Custom AutoFilters      
Using an Advanced Filter         
Copying Filtered Records        
Step-By-Step  
Skill Sharpener
Using Excel as a Database 
Filtering with Wildcard Characters       
Validating Your Data   
What are Database Functions? 
Step-By-Step  
Skill Sharpener
Case Study  
Review Questions     

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           
Step-By-Step  
Skill Sharpener
Working with Text Boxes  
Adding a Text Box      
Selecting a Text Box    
Manipulating a Text Box          
Formatting a Text Box 
Step-By-Step 
Skill Sharpener
WordArt   
Adding WordArt to your Spreadsheet  
Changing the Font Color          
Changing the Outline Color      
Adding Effects 
Step-By-Step  
Skill Sharpener
ClipArt     
Finding ClipArt
Inserting ClipArt          
Manipulating ClipArt    
Inserting a Photographic Image
Step-By-Step  
Skill Sharpener
Using Objects       
Creating New Embedded Objects       
Embedding Existing Files          
Editing Embedded Objects    
Embedding Parts of Files        
Step-By-Step  
Skill Sharpener
Case Study  
Review Questions      

Finalizing Your Workbook     
Protecting your Workbook
Protecting your Workbook      
Protecting your Worksheets     
Unlocking Cells          
Protecting your Excel Files       
Step-By-Step  
Skill Sharpener
Finishing Your Workbook 
Using the Document Inspector 
Using the Compatibility Checker          
Marking a Workbook as Final 
Step-By-Step  
Skill Sharpener
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    
Step-By-Step  
Skill Sharpener
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     
Step-By-Step  
Skill Sharpener
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    
Step-By-Step  
Skill Sharpener
Case Study  
Review Questions    
Index

Additional Details

Pre-Requisites

Excel 2007 Level 1 (Introduction)

Certificates offered

Includes: Course manual , Certificate of completion, Lunch

Cancellation Policy

Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to info@itplanit.com.

Map & Reviews

Itplanit Services Corp.
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

A very interesting course. Claude Gerin, our instructor, was excellent in making this a very interesting and learning experience. THANKS!

Reviewed by Oleg T. 2012