# "Learn Microsoft Excel Step by Step, Level 3" is no longer available

No Reviews Yet

Course type: Online Instructor led Course

Platform: 560102

Course ID: 18380

Course type: Online Instructor led Course

Platform: 560102

No Reviews Yet

## Date and Time

Not decided yet.

Saurav Kumar Sinha

President - Manthan Trust

Passion: Investment in early stage companies, sales and marketing across India, financial planning for startups, making business plans and mentoring startups

Specialties: Entrepreneurship training, helping startups, funding for startups, business networking, sales and marketing
No reviews currently

One day instructor-led course provides students with the skills to analyze alternative data sets, create dynamic worksheets by using PivotTables, create charts and graphics, automate repetitive tasks, work with other Microsoft Office programs, and collaborate on workbooks.

## Topics Covered

Module 1: Analyze Alternative Data Sets
This module explains how to use alternative data sets to analyze the results of changes to your data.
Lessons
Defining an Alternative Data Set
Defining Multiple Alternative Data Sets
Varying Your Data to Get a Desired Result by Using Goal Seek
Finding Optimal Solutions by Using Solver
Analyzing Data by Using Descriptive Statistics
Lab : Defining an Alternative Data Set
Create a scenario
Lab : Defining Multiple Alternative Data Sets
Create and view multiple scenarios; summarize scenario results in a separate worksheet
Lab : Varying Your Data to Get a Desired Result by Using Goal Seek
Use Goal Seek to determine a solution
Lab : Finding Optimal Solutions by Using Solver
Use Solver to determine a solution
Lab : Analyzing Data by Using Descriptive Statistics
Use the Analysis ToolPak to generate statistics
After completing this module, students will be able to:
Define alternative data sets.
Determine the necessary inputs to make a calculation produce a particular result.
Module 2: Create Dynamic Worksheets by Using PivotTables
This module explains how to use PivotTables to create worksheets that can be sorted, filtered, and rearranged dynamically to emphasize different aspects of the data.
Lessons
Analyzing Data Dynamically by Using PivotTables
Filtering, Showing, and Hiding PivotTable Data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from External Data
Lab : Analyzing Data Dynamically by Using PivotTables
Create, edit, and pivot a PivotTable
Lab : Filtering, Showing, and Hiding PivotTable Data
Filter a PivotTable by using multiple methods; show and hide details in a PivotTable
Lab : Editing PivotTables
Rename and reconfigure a PivotTable; create a formula that references PivotTable data
Lab : Formatting PivotTables
Apply a number format, PivotTable style, banded rows, and conditional formatting; create a custom PivotTable style
Lab : Creating PivotTables from External Data
Create a PivotTable based on data you import from a text file
After completing this module, students will be able to:
Create and edit PivotTables from an existing worksheet.
Focus PivotTable data using filters and Slicers.
Format PivotTables.
Create a PivotTable with data from a text file.
Module 3: Create Charts and Graphics
This module explains how to show trends in data by creating charts to summarize a worksheet's data visually, and to use sparklines to summarize the data in a single cell. It also discusses changing the appearance of charts by changing formatting; creating a PivotChart dynamic view of data; adding shapes and mathematical equations; and creating diagrams.
Lessons
Creating Charts
Customizing the Appearance of Charts

## Who should attend

This course is intended for intermediate Excel users who want to learn advanced-level Excel 2010 skills.

## Pre-requisites

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.

## What you need to bring

Online. With good internet connection

## Key Takeaways

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.
Edit PivotTables.
Format PivotTables.
Create PivotTables from external data.
Create charts.
Customize the appearance of charts.
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.
Share workbooks.
Track and manage colleaguesâ€™ changes.
Protect workbooks and worksheets.
Authenticate workbooks.
Save workbooks for the Web.

## Reviews

No reviews currently

## Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more