We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Microsoft Excel 2010 Level 3

ENDED
Training by  New Era Technology
Inquire Now
On-Site / Training
Ended last Jun 17, 2015
CAD  245.00

Details

Microsoft Excel 2010 Level 3 - Course Information
   
Name: Microsoft Excel 2010 Level 3
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245

Description: In this 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.

Prerequisites: Excel 2010 Level 1 and 2.

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application 

Outline: 

Lesson 1: Streamlining Workflow
• Update Workbook Properties 
• Create a Macro 
• Edit a Macro 
• Apply Conditional Formatting 
• Add Data Validation Criteria 

Lesson 2: Collaborating with Other Users
• Protect Files 
• Share a Workbook 
• Set Revision Tracking 
• Review Tracked Revisions 
• Merge Workbooks 
• Restrict Document Access 

Lesson 3: Auditing Worksheets
• Trace Cells 
• Troubleshoot Invalid Data and Formula Errors 
• Watch and Evaluate Formulas 
• Create a Data List Outline 

Lesson 4: Analyzing Data
• Create a Trendline 
• Create Sparklines 
• Create Scenarios 
• Perform a What-If Analysis 
• Perform a 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: Integrating Excel Data with the Web
• Publish a Worksheet to the Web 
• Import Data from the Web 
• Create a Web Query
Reviews
Be the first to write a review about this course.
Write a Review

New Era Technology was established in 1996 as a business improvement training provider local to Calgary. We invest heavily in providing a top notch learning environment, great tools and above all instructors who are keenly interested in understanding your personal and organizational requirements so that your training has maximum benefit.

As a Microsoft® Gold Certified Partner, we have a close working relationship with Microsoft® and have acquired the highest level of competence and expertise in Microsoft® technologies. With over 5,000 students trained yearly and successful business done with over 1,000 companies, we are Calgary’s premier training solutions provider.


What Makes Us Different


Highly innovative and high quality instructors:We are constantly improving our training processes as we strive to provide a quality learning environment. For example, our full-time instructors only teach 3 out of 5 business days per week, which allows them more time to enhance their knowledge and course-breadth to suite your training needs.


Customizable training solutions as a core competency:We offer versatile training solutions that are customizable to your organization’s training needs and budget. Whether you would prefer any number of distance learning options, or “in-person” training - at your facilities or ours in downtown Calgary - we have the resources to help your organization succeed. ...
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.