Contact Us

1844 230 6365 (Toll Free)

+91 90660 20866

Advanced MS Excel 2010

Reviews

3166 learners

Add to wishlist

This is a self-paced online course designed to develop your Advance Excel skills and practically implement your learning on MS Excel to make you an MS Excel Expert.

Watch the re-run of previous class

About The Course

Edureka's Advanced MS Excel Course 2010 course covers all the Excel functions to perform financial, mathematical or statistical calculations such as, DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros. You will also get to implement an Excel project towards the end of the course.

Course Objectives

After the completion of Advanced MS Excel 2010 course at Edureka, you will be able to:

Understand Excel Abilities and its Functions.
Explain Data Security, Formatting and Analyzing concepts.
Understand the specialized functions like DSUM, DMAX etc.
Explain the advanced options of Pivot Table.
Summarize data by using Sparklines.
Record and play a macro.
Edit a macro using VBA Editor.
Explain how to manage scenarios.
Describe the restrictions and manipulating techniques.

Prerequisites

This Advanced MS Excel course is designed to anyone who wants to become a pro in Excel 2010. Also this course enables you to turn data into information with powerful tools to analyze, communicate, and share results. It can help you work better in teams, help to protect and control access to your work.

Skills: Excel Basics.
Software: Windows 7 / 8 – 32 / 64-Bit, Microsoft Office 2010
Hardware: 500 MHz processor, 256 MB Ram, 3 GB HDD.
Internet: 1.0 Mbps Broadband Connection.

Project Work

The purpose of this project is to store the daily work status of the employees. This project involves external hyperlinks, dynamic charts, pivot table, filtering and specialized functions such as date. Also it deals with absolute & relative cell references, restrictions, drop down list and so on.

The output of this project provides a crystal clear pictorial representation of individual employee work reports, monthly reports, project wise reports, and yearly reports. These reports are helpful for employee assessment, project effort calculation, and future project estimations and so on.

Why learn Advance Excel Course 2010?

Excel is one of the most used software applications of all time. This course is designed for the users those who want to perform accurate and rapid calculations with results ranging from simple calculation to complex financial analyses. Advanced MS Excel Course helps you to structure and present your data impressively.

1. Excel Abilities and its Functions

Learning Objectives - In this module, you will learn what are the new features added in Excel 2010. How to customize quick access toolbar and ribbon. Differences between relative and mixed cell references, to perform complex calculations.

Topics - Overview of Microsoft Excel 2010, Improved ribbon, Microsoft Office Backstage view, Excel Mobile 2010 for Windows 7 Phone, Sparklines – An Introduction, Slicers – An Introduction, Customize the Quick Access Toolbar, Customizing common options in Excel Setting, Absolute, Relative and Mixed Cell References, Work with Comments, Using Hyperlinks, Introduction to Excel Functions, Adding a Function to a Formula, Writing conditional expressions (using IF), Building an AutoSum Formula, Adding a Range Name to a Formula.

2. Data Security, Formatting and Analyzing

Learning Objectives - In this module, you will learn to protect and unprotected workbook, Inserting the existing file and new file as an object, share a workbook with others and filtering a table.

Topics - Protecting and un-protecting worksheets and cells, Hiding Formulas, Track Workbook Changes, Share a workbook with other users, Inserting, Formatting and Deleting Object, Changing the font and font size, Applying effects to fonts, Changing font color, Working with text within a cell, Wrapping text within a cell, Applying auto format to a range, Applying a number format, Applying a style to a range, Sorting a Table, Filtering a Table, Filtering a Range, Filtering data for selected view (AutoFilter), Using advanced filter options, Sort by colorSorting in a Pivot Table, Filtering in a Pivot Table, Filtering Using the Report Filter Area.

3. Data Reports

Learning Objectives - In this module, you will learn aggregate functions, reference functions and specialized functions. This module also deals with Pivot Tables and Pivot Charts.

Topics - Using aggregate Functions like Dsum, Dcount, Dmax, Sumif, Countif, Averageif, Sumifs, Countifs, Averageifs, ISERROR, ISBLANK, Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX), Summarizing Data with subtotals, Pivot Tables, Using advanced options of Pivot tables, Types of Pivot Report, Consolidating data from multiple sheets and files using Pivot tables, Import and export data in Excel.

4. Graphical Representations of Data

Learning Objectives - In this module, you will learn Data Visualizing and Automating Excel.

Topics - Examining Chart Elements, Understanding Chart Types, Create a Chart, Format Charts, Create a Chart Template – Combination chart, Summarizing Data by Using Sparklines, Creating Dynamic Charts by Using Pivot Charts, Changing the Chart Layout and Style, Introduction to Macros, Recording and Playing a Macro, Editing Using VBA, Mapping a Simple Document.

5. Specialized Functions

Learning Objectives - In this module, you will learn scenario based analysis of data with ‘what if’ analysis & specialized functions.

Topics - Date and time functions, Time Function, Text functions, Proper Function, Concatenate Financial Functions Pmt, Fv, Named Ranges, Creating a Data Table, Introduction to Scenarios, Managing Scenarios, Using Goal Seek, Solver, Saving Solver Models, Configuring Solver.

6. Working with Other Microsoft Office Programs

Learning Objectives - In this module, you will learn restrictions in Worksheet, manipulating External Data, and working with other Microsoft Office Programs.

Topics - Specifying a valid range of values for a cell, Input Message, Custom Error Alert, Specifying custom validations based on formula, Getting External Data in Excel, Refreshing data, Add own error messages, Object Linking and Embedding, Insert Drawing Object, Data Forms, Drop Down List, Including Office Documents in Workbooks, Pasting Charts into Other Documents, Preparing Worksheets for Printing, New Methods For Headers And Footers In 2010, Insert Specific Elements In A Header Or Footer, Add A Predefined Header Or Footer, Custom Header Or Footer For A Chart.

How soon after Signing up would I get access to the Learning Content?

As soon as you enrol into the course, your LMS (The Learning Management System) access will be functional. You will immediately get access to our course content in the form of a complete set of Videos, PPTs, PDFs, Assignments. You can start learning right away.

For how long will I have access to the course materials?

All the videos and other materials like PPTs, Quiz and Assignments, etc are hosted in our Learning Management System (LMS) and you will have a lifetime access to that.

Are there any pre-requisites for this course?

There are no pre-requisites for this course. But basic understanding of Microsoft Excel will be helpful.

What if I have more queries?

Just give us a CALL at +91 88808 62004 OR email at sales@edureka.co. US Toll free number is 1800 275 9730.

What are the payment options?

You can pay by Credit Card, Debit Card or Net Banking from all the leading banks. For INR payment, you can use CCAvenue Payment Gateway. For USD payment, you can pay by Paypal. We also have EMI options available.

Suman Raja

IT Analyst at Tata Consultancy Services Greater Philadelphia Area Information Technology and Services

Follow on Linkedin

Definitely there is no doubt in saying that all the instructors at Edureka are industry experienced and the support staff provides a quick response to the tickets you log whether it be Day or Night. I

Read Less

Alexey Starykh

R&D Engineer at IFAS of RWTH. Developer.Aachen University,Germany

Follow on Linkedin

Looks like they want us to think of nothing but learning. I really appreciate this approach. Thank you Edureka Team! I had a nice and fruitful time.

Madhusudan Rao S

Senior software consultant at PCS Technical Services, Bengaluru Area, India

Follow on Linkedin

I had attended a couple of demo session with other training institutes before joining Edureka. I can safely say Edureka is one of the best training company. They have good trainers with excellent comm

Read Less

Michael Harkins

Solution Engineer-Open Source Analytics at IBM, former Systems Architect at Hortonworks

Follow on Linkedin

The courses are top rate. The best part is live instruction, with playback. You get all the presentations and labs. Great instructions. But my favorite feature is viewing a previous class. They provid

Read Less

Sidhartha Mitra

IBM MDM COE Head @ CTS, Kolkata Area, India

Follow on Linkedin

Edureka has been an unique and fulfilling experience. The course contents are up-to-date and the instructors are industry trained and extremely hard working. The support is always willing to help you

Read Less

Contact Us

1844 230 6365 (Toll Free)

+91 90660 20866

Online Self learning USD Change

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You'll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.

Get 15% Off ( Hurry! Limited slots only )

ENROLL NOW

Course Features

Duration: 16 Hrs

You will undergo self-paced online training where you will get an in-depth knowledge of various concepts of Advance MS Excel 2010.

Assignments: 25 Hrs

Each module will contain practical assignments, which can be completed before going to next module.

Lifetime Access

You will get lifetime access to all the videos, discussion forum and other learning contents inside the Learning Management System.

Edureka for Organizations

Your organization's partner for all professional trainings

Learn More

Follow on

Definitely there is no doubt in saying that all the instructors at Edureka are industry experienced and the support staff pro..

Suman Raja (IT Analyst at Tata Consultancy Services Greater Philadelphia Area Informati...)

Follow on

Looks like they want us to think of nothing but learning. I really appreciate this approach. Thank you Edureka Team! I had a ..

Alexey Starykh (R&D Engineer at IFAS of RWTH. Developer.Aachen University,Germany...)

Follow on

I had attended a couple of demo session with other training institutes before joining Edureka. I can safely say Edureka is on..

Madhusudan Rao S (Senior software consultant at PCS Technical Services, Bengaluru Area, India...)

Follow on

The courses are top rate. The best part is live instruction, with playback. You get all the presentations and labs. Great ins..

Michael Harkins (Solution Engineer-Open Source Analytics at IBM, former Systems Architect at...)

Follow on

Edureka has been an unique and fulfilling experience. The course contents are up-to-date and the instructors are industry tra..

Contact Us

Advanced MS Excel 2010

This is a self-paced online course designed to develop your Advance Excel skills and practically implement your learning on MS Excel to make you an MS Excel Expert.

About The Course

Course Objectives

Prerequisites

Project Work

Why learn Advance Excel Course 2010?

1. Excel Abilities and its Functions

2. Data Security, Formatting and Analyzing

3. Data Reports

4. Graphical Representations of Data

5. Specialized Functions

6. Working with Other Microsoft Office Programs

How soon after Signing up would I get access to the Learning Content?

For how long will I have access to the course materials?

Are there any pre-requisites for this course?

What if I have more queries?

What are the payment options?

Suman Raja

Alexey Starykh

Madhusudan Rao S

Michael Harkins

Sidhartha Mitra

Contact Us

Course Features

Duration: 16 Hrs

Assignments: 25 Hrs

Lifetime Access

Edureka for Organizations

Suman Raja (IT Analyst at Tata Consultancy Services Greater Philadelphia Area Informati...)

Alexey Starykh (R&D Engineer at IFAS of RWTH. Developer.Aachen University,Germany...)

Madhusudan Rao S (Senior software consultant at PCS Technical Services, Bengaluru Area, India...)

Michael Harkins (Solution Engineer-Open Source Analytics at IBM, former Systems Architect at...)

Sidhartha Mitra (IBM MDM COE Head @ CTS, Kolkata Area, India ...)

Edureka

Work with us

Follow us on

Learn on the GO!

Contact Us

Advanced MS Excel 2010

This is a self-paced online course designed to develop your Advance Excel skills and practically implement your learning on MS Excel to make you an MS Excel Expert.

About The Course

Course Objectives

Prerequisites

Project Work

Why learn Advance Excel Course 2010?

1. Excel Abilities and its Functions

2. Data Security, Formatting and Analyzing

3. Data Reports

4. Graphical Representations of Data

5. Specialized Functions

6. Working with Other Microsoft Office Programs

How soon after Signing up would I get access to the Learning Content?

For how long will I have access to the course materials?

Are there any pre-requisites for this course?

What if I have more queries?

What are the payment options?

Suman Raja

Alexey Starykh

Madhusudan Rao S

Michael Harkins

Sidhartha Mitra

Contact Us

Country

Currency

Course Features

Duration: 16 Hrs

Assignments: 25 Hrs

Lifetime Access

Edureka for Organizations

Suman Raja (IT Analyst at Tata Consultancy Services Greater Philadelphia Area Informati...)

Alexey Starykh (R&D Engineer at IFAS of RWTH. Developer.Aachen University,Germany...)

Madhusudan Rao S (Senior software consultant at PCS Technical Services, Bengaluru Area, India...)

Michael Harkins (Solution Engineer-Open Source Analytics at IBM, former Systems Architect at...)

Sidhartha Mitra (IBM MDM COE Head @ CTS, Kolkata Area, India ...)