Course Catalog > Microsoft Office 2007 > Advanced Excel 2007
Advanced Microsoft Excel 2007
Our Microsoft Excel 2007 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.
In this Advanced Excel 2007 course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2007, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
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 already use Excel 2007 and need to gain the skills necessary to:
- Increase productivity and improve efficiency by streamlining your workflow
- Collaborate with others using workbooks
- Audit worksheets
- Analyze data
- Work with multiple workbooks
- Import and export data
- Use Excel with the web
- Structure workbooks with XML
- Increase productivity and improve efficiency by streamlining your workflow
- This course is designed for people preparing for certification as a Microsoft Certified Application specalist (MCAS), formerly know as the Microsoft Office Specialist (MOS).
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Introduction to Microsoft Excel 2007 $249.00 List Price $299.00 Special Discounted Student price for 3 or more from the same Company $199.00
For More Information About Introduction to Microsoft Excel 2007 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Advanced Microsoft Office Excel 2007
Lesson 1: Streamlining Workflow
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
- Update a Workbook's Properties
- Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Protect Files- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
- Administer Digital Signatures
- Restrict Document Access
Lesson 3: Auditing Worksheets
- Trace Cells
- Troubleshoot Errors in Formulas
- Troubleshoot Invalid Data and Formulas
- Watch and Evaluate Formulas
Create a Data List Outline
Lesson 4: Analyzing Data
- Create a Trendline
- Create Scenarios
- Perform What-If Analysis
- Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Lesson 6: Importing and Exporting Data
- Export Excel Data
- Import a Delimited Text File
Lesson 7: Using Excel with the Web
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Lesson 8: Structuring Workbooks with XML
- Develop XML Maps
- Import and Export XML Data
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Certified Application Specialist (MCAS) - Excel | ||
For More Information About Introduction to Microsoft Excel 2007 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800