Online Instructor led Course
This course is intended for intermediate Excel users who want to learn advanced-level Excel 2010 skills.
Before attending this course, students must have:
Basic computer knowledge, such as keyboard and mouse skills.
Basic file-management skills. The student should know how to navigate to folders and files on a computer running Windows 7.
Online. With good internet connection
Define an alternative data set.
Define multiple alternative data sets.
Vary your data to get a desired result by using Goal Seek.
Find optimal solutions by using Solver.
Analyze data by using descriptive statistics.
Analyze data dynamically by using PivotTables.
Filter, show, and hide PivotTable data.
Create PivotTables from external data.
Customize the appearance of charts.
Find trends in your data.
Summarize your data by using sparklines.
Create dynamic charts by using PivotCharts.
Create diagrams by using SmartArt.
Create shapes and mathematical equations.
Enable and examine macros.
Create and modify macros.
Run macros when a button is clicked.
Run macros when a workbook is opened.
Include Office documents in workbooks.
Store workbooks as parts of other Office documents.
Paste charts into other documents.
Track and manage colleagues’ changes.
Protect workbooks and worksheets.
Save workbooks for the Web.
Not decided yet
President - Manthan Trust
Students Interested 0