loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Learn Microsoft Excel Step by Step, Level 3

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Saurav

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Learn Microsoft Excel Step by Step, Level 3

Learn Microsoft Excel Step by Step, Level 3

Online Instructor led Course

Platform: 560102

1,500

No Reviews Yet
0 Interested

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
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Saurav Kumar Sinha picture

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
Seats Left-

Students Interested 0

Course Id: 18380