Published on HiTech Institute (http://www.htinstitute.com)

Home > Advanced Skills in Microsoft Excel 2010 (E-Learning)

Advanced Skills in Microsoft Excel 2010 (E-Learning)

Vendor: 
Microsoft [1]
Subject: 
Microsoft Office [2]
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Jun 29, 2010
Language:English
Audiences:Information Worker
Level:Advanced
Technology:Microsoft Office 2010 suites
Type:Course
Delivery method:Self-pace Course

Course Contents: 

This online course is designed to help you customize and manage the Excel 2010 interface as well as know how to manage, manipulate, and format data.

Topics covered in this course include:

Setting Excel 2010 Options
Manipulating Worksheet Data
Creating and Editing Named Ranges
Working with Solver and PowerPivot Add-Ins
Working with External Data
Creating and Editing Web Queries
Creating Sparklines and Trendlines
Analyzing PivotTable Data
Creating and Editing Macros
Running a Macro
Workbook Protection Levels

Prerequisites: 

:
Learners must have the basic skills of using Excel 2003. These include basic tasks such as opening a workbook, formatting text, and saving a workbook. It is recommended that the learners complete the course 4697 that introduces the Fluent Interface (ribbon).

Business Analysis (BA)

Business Analysis (IIBA) Courses
About IIBA
CBAP Certification
CCBA Certification
Business Analysis Certification Benefits
Business Analysis Training at HiTech Institute

-->

Source URL: http://www.htinstitute.com/courses/advanced-skills-in-microsoft-excel-2010-e-learning

Links:
[1] http://www.htinstitute.com/vendors/microsoft
[2] http://www.htinstitute.com/htnteam/microsoft-office