Course Catalog > Microsoft Office 2003 > Intermediate Microsoft Excel 2003
Intermediate Microsoft Excel 2003
Intermediate Microsoft Excel 2003 (1 Day)
Our Microsoft Excel 2003 training will show you features you need to be a an effecient Excel user. Microsoft Excel is the standard spreadsheet application for both the business world and personal use. Whether you are new to Excel or an advanced user, Current Technologies courses for Excel will cover what you need to know to become an Excel power user.
This Intermediate Microsoft Excel course covers the skills needed to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Come Experience the Current Technologies Computer Learning Center Way of Training. We take great care of all of our students.
The CTCLC Difference
Current Technologies Computer Learning Center uses our own certified instructors that will help guide you to a sucessful completion of your Microsoft Office training and certification. Our Instructors are simply the best instructors you will find. Let our great instructors help you get started in understanding and using your Microsoft Office applications. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
Intended Audience
People who desire to gain the skills necessary to:
- Create templates
- Sort and filter data
- Import and export data
- Analyze data
- Work with Excel on the Web
- Employees who need to use excel in their job
- This course is designed for people preparing for certification as a Microsoft Office Specalist (MOS).
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Intermediate Microsoft Excel 2003 $249.00 List Price $299.00 Special Discounted Student price for 3 or more from the same Company $199.00
For More Information About Intermediate Microsoft Excel 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Intermediate Microsoft Excel 2003
Lesson 1: Creating and Applying Templates
- Create a Workbook from a Template
- Create a Custom Template
- Working with Comments
- Create a Hyperlink
- Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
- Create a Chart
Format Chart Items- Change the Chart Type
- Create a Diagram
Lesson 3: Working with Graphic Objects
- Insert Graphics
- Create AutoShapes
- Format Graphic Objects
- Change the Order of Graphic Objects
- Group Graphic Objects
- Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Create and Apply a Name for a Range of Cells- Calculate Across Worksheets
- Calculate with Date and Time Functions
- Calculate with Financial Functions
- Calculate with Statistical Functions
- Calculate with Lookup and Reference Functions
- Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
- Sort Data Lists
- Filter Data Lists
- Create and Apply Advanced Filters
- Calculate with Database Functions
- Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
- Export Excel Data
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Office Specialist (MOS) - Excel | ||
For More Information About Intermediate Microsoft Excel 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800