Advanced MS Excel 2010 Online Training | MS Excel Certification Course | Edureka
  1. Home
  2. BI and Visualization
  3. Advanced MS Excel 2010

Advanced MS Excel 2010

usflag usflag

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 demo class

Why should you take Advanced MS Excel 2010 course ?

Online self - paced learning

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.
15% Off
6999
5949
EMI Option availableGive us a call at +91 98702 76459

Get 10% Off ( Hurry! Limited slots only )

Edureka For Business

Train your employees with exclusive batches and offers and track your employee's progress with our weekly progress report.

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.

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.

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.

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.

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.

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.
. Call a Course Advisor for discussing Curriculum Details . 1844 230 6365

Course Duration

You will undergo self-paced learning where you will get an in-depth knowledge of various concepts that will be covered in the course.

Real-life Case Studies

Towards the end of the training, you will be working on a project where you will implement the techniques learnt to visualize and analyze data.

Assignments

Each class has practical assignments which shall be finished before the next class and helps you to apply the concepts taught during the class.

Lifetime Access

You get lifetime access to Learning Management System (LMS) where presentations, quizzes, installation guide & class recordings are there.

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

edureka certifies you as a Data Visualization Expert based on the project reviewed by our expert panel.

Forum

We have a community forum for all our customers that further facilitates learning through peer interaction and knowledge sharing.

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.

How do I avail EMI option as a method of payment?

You no longer need a credit history or a credit card to purchase this course. Using ZestMoney, we allow you to complete your payment with a EMI plan that best suits you. It's a simple 3 step procedure:
  • Fill your profile: Complete your profile with Aadhaar, PAN and employment details.
  • Verify your account: Get your account verified using netbanking, ekyc or uploading documents
  • Activate your loan: Setup automatic repayment using NACH to activate your loan
user
link
user
link
user
link
user
link
user
user
link

Advanced MS Excel 2010

usflag usflag