Home All Courses Project Management Advanced MS Excel 2010

Advanced MS Excel 2010

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.

Why this 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.
10% Off
5999
5399

Edureka For Business

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

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.

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:

  1. Understand Excel Abilities and its Functions.
  2. Explain Data Security, Formatting and Analyzing concepts.
  3. Understand the specialized functions like DSUM, DMAX etc.
  4. Explain the advanced options of Pivot Table.
  5. Summarize data by using Sparklines.
  6. Record and play a macro.
  7. Edit a macro using VBA Editor.
  8. Explain how to manage scenarios.
  9. 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.

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.

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.
user
link
user
link
user
link
user
link
user
link