Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Learn Microsoft Excel Step by Step, Level 3

No Reviews Yet

Course type: Online Instructor led Course

Platform: 560102

Course ID: 18380

Course type: Online Instructor led Course

Platform: 560102

Students Interested 0 (Seats Left 0)

₹ 1,500

No Reviews Yet

Date and Time

Not decided yet.

Saurav Kumar Sinha picture
Saurav Kumar Sinha

President - Manthan Trust

About Saurav Kumar Sinha

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

About the Course

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
Finding Trends in Your Data

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.
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.
Create hyperlinks.
Paste charts into other documents.
Share workbooks.
Manage comments.
Track and manage colleagues’ changes.
Protect workbooks and worksheets.
Authenticate workbooks.
Save workbooks for the Web.

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

₹ 1,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 1,500 Enquire