Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


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


Prerequisites & Certificates
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.
This course was very, very interesting due to the instructor. He was simple, gave good examples and made a few jokes. Also, being only 5 participants was a bonus for us as we were able to share our experiences in a timely manner.
Reviewed by 2016
I think there is too much material to cover in one session. It's a lot of information to absorb all at once.
Reviewed by 2013
The only thing I would add...if you know you don't have many participants, hands on practice would be great. I would like to have had more time applying what i learned in a diagram. Once I got back to my office...i didn't know how to move a shape and associated text together. I also would like to know where I can see all the shapes offered by visio instead of searching for the shape and not knowing what to call it?
Reviewed by 2013
The instructor was excellent. I was pleasantly surprised by how interesting she made a potentially dry subject appear. Non-stop, great snacks provided all day from ham/egg bagels for breakfast, muffins, Valentines chocolate, chips, popcorn, gumball machine, coffee, juices etc etc. Perfect location for me as it was 2 blocks from my office.
Reviewed by 2013
I had no problem with the instructor's technigues, methods or delivery of the course material. He made what was otherwise fairly dry material as interesting as he possible and augmented it with practical examples that the class could relate to. The training facility and staff were also comendable, however what can't be overlooked is the IT infrastructure. During the exam the problems with latency were so bad that it affected my ability to concentrate on the material. Prior to the exam I completed 2 practice exams on paper in 35 & 37 minutes respectively. Doing the exam online it took over 1.5 hrs because it would take between 30 & 60 sec to refresh the page and show the next question. At times when I attempted to go back and review quesgtions I had marked I found my original answer wasn't recorded & I'd have to answer the question a second time. By the end of 70 min I was so digruntled I couldn't wait to finish regardless of the end result. It may not seem fair to evaluate the favility in this manner, but as a student the outcome is the ultimate measurement of a training favility.
Reviewed by 2013
A very interesting course. Claude Gerin, our instructor, was excellent in making this a very interesting and learning experience. THANKS!
Reviewed by 2012
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 747 times.