Advanced Microsoft Excel 2010
Advanced Microsoft Excel 2010
Our Microsoft Excel 2010 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 2010 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.
Download Course Outline and Information
- Course Objectives
- Course Details
- Course Outline
- CTCLC Discounts
- Exam Information
After completing this course, students will be able to:
- enhance productivity and efficiency by streamlining the workflow.
- collaborate with other workbook users.
- audit worksheets.
- analyze data.
- work with multiple workbooks.
- import and export data.
- integrate Excel data with the web.
- structure workbooks with XML.
Intended Audience
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.
Course Duration
- 1 Day, Instructor-led classroom training (8:30am to 4:30pm)
Module 1: Streamlining Workflow
- Update Workbook Properties
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
Module 2: Collaborating with Other Users
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
- Administer Digital Signatures
- Restrict Document Access
Module 3: Auditing Worksheets
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Module 4: Analyzing Data
- Create a Trendline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
- Perform a Statistical Analysis with the Analysis ToolPak
Module 5: Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Module 6: Importing and Exporting Data
- Export Excel Data
- Import a Delimited Text File
Module 7: Integrating Excel Data with the Web
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Module 8: Structuring Workbooks with XML
- Develop XML Maps
- Import and Export XML Data
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.
CTCLC Special Discounts
| EXCEL10-L3 | Introduction to Microsoft Excel 2010 | $299.00 |
| Call (219) 764-3800 for Current Specials | ||
CTCLC Microsoft Excel 2010 Certification Path
| Required Exam(s) | Recommended Training |
|---|---|
| Microsoft Certified Application Specialist (MCAS) - Excel |
Introduction to Microsoft Excel 2010 |
| Intermediate Microsoft Excel 2010 | |
| Advancede Microsoft Excel 2010 |
For more Information on Microsoft Office Courses or to Register
Email: Sales@ctclc.com
Phone: (219) 764-3800
