Training Course:Excel 2003School/Trainer:Avaal Technology Solutions Inc. Brampton, Ontario, Canada
Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Course Description:
'' Excel - Chapter 1:
Excel Databases and Data Form Setting a Single Record with Formulas Adding Records to a Database Finding Records Excel - Chapter 2:
Data Validation Establishing Data Entry Criteria Using Formulas and Lists to Restrict Data Using Data Validation on Existing Data Data Validation Exclusions Excel - Chapter 3:
Data Sort Sorting from a Menu Sorting from the Toolbar Multiple-Key Sorting Sorting Columns Excel - Chapter 4:
Data Subtotals Single Level Subtotals Multiple Level Subtotals Excel - Chapter 5:
Data Filter Criteria Multiple Column Creating Custom Filter Copying Formatting and Sorting Data Using "SUBTOTAL" Function to Count Results Advanced Filter Excel - Chapter 6:
Data Functions "SUMIF", "COUNTIF" Array Formulas Database Functions Excel - Chapter 7:
The IF Function and VLOOKUP "IF" Functions and Relational Operators Using Text in "IF" Functions Logical Operators ("AND" and "OR") with "IF" Functions Nested "IF" Functions Getting Table Data with "VLOOKUP" Function Excel - Chapter 8:
Dates and Time Using Dates as Values Entering a Series of Dates Date/Time Techniques Excel - Chapter 9:
Understanding Pivot tables and charting Creating a Dynamic Chart using Pivot Charts ...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.avaal.com/
Phone:1-877-995-1313
School Address/Venue(s):
2 Automatic Road Unit 110, Brampton Ontario, L6S 6K8 Canada
Jobs & Resumes: Brampton Houses & Roommates: Brampton
Search other schools for Excel 2003 training resources.
Other training courses offered by Avaal Technology Solutions Inc.:
A+ Certification
A+ Hardware Certification
A+ Software Certification
PC Literacy
Dreamweaver
Asp
Trucking Dispatch Specialist
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback. |
|
|