Syste
m (Hardware/Software)
Requirements
Operating
Software | Windows XP or
Higher
| Processor | Minim
um P4 or Higher
| RAM | 1 GB or
Higher
| Browser | Any
| Recommended Internet
Speed | Minimum 1MBPS
| Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionThis amazing Excel course provides you with in depth knowledge of excel and makes you Zero to hero.
This is a comprehensive course on Microsoft Excel 2010. This Excel training program on Microsoft Excel 2010 starts with the basics and on through the advanced features. With over 100 excel video lectures, approximately 11 hours of Videos, 150+ worksheets, quizzes, Subtitles etc. edu CBA helps both the beginner and advanced user visualize what they are learning with step-by-step instruction from a Microsoft Excel Professional. Watch as the instructor performs progressive operations in each video starting with the Basics of Worksheets. Then moving onto Formatting, Formulas, Illustrations and Charts, Printing, HLOOKUP, VLOOKUP, Array, Solver, database, forecast, goal seek and many more advanced functions. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Take this course to learn all about Microsoft Excel 2010 and be awesome in Excel 2010.
Microsoft Excel is used in almost all fields like finance, statistics, marketing, engineering, human resources especially for the businesses which deal with large amounts of data (numbers, statistics). What we learn in academics is very theoretical aspects of business, but in practical life we want application based learning. Our Excel course is designed in such manner that it will give you practical approach and any person from any background can go ahead with it. Through this course and the practice material you will gain proficiency in Excel. Thus having detailed knowledge of Excel will be beneficial to you, whether you are a student, fresher or an employee.
Note: Microsoft Excel 2010: A Comprehensive Program Advanced (this course) consists of both Microsoft Excel 2010 Beginner and Microsoft Excel 2010 Advanced. If you have taken this course, No need to take Beginner and Advanced Courses separately.
Instructor: Mr. Dheeraj V. (CFA, FRM, IIML, IITD)
Dheeraj, A financial wizard, His relentless pursuit of knowledge and financial acumen has made him one of the most sought after individual in the training circles. He was associated with J.P Morgan Chase Equity Research Group as an analyst and later moved to CLSA India (Asia's #1 Broking Firm) in the field of Equity Research and Investment Banking domain.
This Excel course provides in depth knowledge about following:
Key Difference MS Excel 2007 vs 2010 - This video discuss about Office Button, Paste Function, Sparkline Custom Ribbons, Screenshots and more.
Useful Excel Functions - This Module includes Paste Special, Logical functions IF AND OR, Arithmetic functions like MAX MIN ABS, COUNT functions and many more.
Data Excel Functions - This module includes CHOOSE Function, VLOOKUP Function, OFFSET Function and many more functions.
WhatIf Analysis - This Module includes oneand two Dimensional Data Tables, solver, goal seek function.
Arrays - Learn how to use array and transpose function.
Excel Functions for working with Text - This module includes simple functions like use of PROPER UPPER LOWER LEFT RIGHT MID etc.
Pivot Tables - Learn about pivot table in more details; also learn about Pivot Table Filter Slicer, Pivot Charts.
Names and Dynamic Range - Learn how to name a particular range.
Excel Charts & Graphs
Course Curriculum
Section1:INTRODUCTION
Lecture1:Introduction
Section2:EXCEL 2010: GETTING STARTED
Lecture2:All Working Files Basic Excel - Download These First
Lecture3:All Working Files Advanced Excel - Download These First
Lecture4:Getting Started - Ribbons & Quick Access Toolbar
Quiz1:Getting Started - Ribbons & Quick Access Toolbar
Lecture5:Getting Started - Surfing Excel & HELP Function
Quiz2:Getting Started - Surfing Excel & HELP Function
Section3:CASE STUDY
Lecture6:XYZ Company Basic Excel Case Study
Lecture7:Excel Case Study
Quiz3:Excel Case Study
Lecture8:Data Entry in Excel
Quiz4:Data Entry in Excel
Lecture9:Populating the Case Study in Excel
Quiz5:Populating the Case Study in Excel
Section4:CALCULATIONS
Lecture10:Calculations - Addition Subtract Multiply Division
Quiz6:Calculations - Addition Subtract Multiply Division
Section5:FORMULAS
Lecture11:Formulas - SUM MAX MIN AVERAGE
Quiz7:Formulas - SUM MAX MIN AVERAGE
Section6:FORMATTING
Lecture12:Formatting - Number Formats
Quiz8:Formatting - Number Formats
Lecture13:Formatting - Table Formats
Quiz9:Formatting - Table Formats
Section7:UPDATING A CALCULATION
Lecture14:Updating a Calculation
Quiz10:Updating a Calculation
Section8:PERCENTAGES & ABSOLUTE REFERENCES
Lecture15:Percentages and Absolute References
Quiz11:Percentages and Absolute References
Section9:CONDITIONAL FORMATTING
Lecture16:Conditional Formatting
Quiz12:Conditional Formatting
Section10:IF FUNCTION
Lecture17:IF Function
Quiz13:IF Function
Section11:COUNTIF AND SUMIF
Lecture18:COUNTIF Function
Quiz14:COUNTIF Function
Lecture19:SUMIF Function
Quiz15:SUMIF Function
Section12:CHARTS AND GRAPHS
Lecture20:Creating Charts and Graphs
Quiz16:Creating Charts and Graphs
Lecture21:Create Pie Charts
Quiz17:Create Pie Charts
Section13:SORTS AND FILTERS
Lecture22:Sorts
Quiz18:Sorts
Lecture23:Filter
Quiz19:Filter
Section14:FREEZE AND SPLIT
Lecture24:Freeze and Split
Section15:PRESENTATION
Lecture25:Presentation - Table Formats
Quiz20:Presentation - Table Formats
Lecture26:Presentation - Indents and Formatting Charts
Quiz21:Presentation - Indents and Formatting Charts
Section16:PRINT
Lecture27:Printing the Worksheet
Quiz22:Printing the Worksheet
Lecture28:Printing - Headers and Titles
Quiz23:Printing - Headers and Titles
Section17:SHORTCUTS
Lecture29:Shortcuts - Formatting and Navigation
Quiz24:Shortcuts - Formatting and Navigation
Lecture30:Shortcuts - Selection, Data and Formula
Quiz25:Shortcuts - Selection, Data and Formula
Section18:COMMON ERRORS
Lecture31:Common Errors
Quiz26:Common Errors
Section19:KEY DIFFERENCE MS EXCEL 2007 VS 2010
Lecture32:Difference between 2007 and 2010 version - part 1
Quiz27:Difference between 2007 and 2010 version - part 1
Lecture33:Difference between 2007 and 2010 version - part 2
Quiz28:Difference between 2007 and 2010 version - part 2
Lecture34:Difference between 2007 and 2010 version - part 3
Quiz29:Difference between 2007 and 2010 version - part 3
Section20:USEFUL EXCEL FUNCTIONS
Lecture35:Paste Special
Quiz30:Paste Special
Lecture36:Logical functions IF AND OR
Lecture37:Logical functions IF AND OR
Lecture38:Logical Functions Quiz - without solutions
Lecture39:Logical Functions Quiz - with solutions
Quiz31:Logical functions IF AND OR
Lecture40:Arithmetic functions MAX MIN ABS etc
Lecture41:Arithmetic functions MAX MIN ABS etc
Quiz32:Arithmetic functions MAX MIN ABS etc
Lecture42:COUNT COUNTIF COUNTA COUNTBLANK
Lecture43:COUNT COUNTIF COUNTA COUNTBLANK
Quiz33:COUNT COUNTIF COUNTA COUNTBLANK
Lecture44:Cell Information ISERROR ISBLANK etc
Quiz34:Cell Information ISERROR ISBLANK etc
Section21:DATA FUNCTIONS
Lecture45:CHOOSE Function
Lecture46:CHOOSE Function
Quiz35:CHOOSE Function
Lecture47:VLOOKUP Function
Lecture48:VLOOKUP Function
Quiz36:VLOOKUP Function
Lecture49:HLOOKUP Function
Lecture50:HLOOKUP Function
Quiz37:HLOOKUP Function
Lecture51:MATCH INDEX
Lecture52:MATCH INDEX
Quiz38:MATCH INDEX
Lecture53:Database functions DSUM DAVERAGE DCOUNT
Lecture54:Database functions DSUM DAVERAGE DCOUNT
Quiz39:Database functions DSUM DAVERAGE DCOUNT
Lecture55:OFFSET Function Part 1
Lecture56:OFFSET Function Part 2
Lecture57:FORECAST Function
Quiz40:FORECAST Function
Section22:WHATIF ANALYSIS
Lecture58:One Dimensional Data Tables
Lecture59:One Dimensional Data Tables
Quiz41:One Dimensional Data Tables
Lecture60:Two dimensional Data Tables
Quiz42:Two dimensional Data Tables
Lecture61:Solver
Quiz43:Solver
Lecture62:Goal Seek
Lecture63:Goal Seek
Quiz44:Goal Seek
Section23:ARRAYS
Lecture64:Array Function Introduction
Quiz45:Array Function Introduction
Lecture65:Array Function Row and Columns
Quiz46:Array Function Row and Columns
Lecture66:Array Function TRANSPOSE
Quiz47:Array Function TRANSPOSE
Lecture67:Array Function FREQUENCY
Quiz48:Array Function FREQUENCY
Section24:FUNCTIONS FOR WORKING WITH TEXT
Lecture68:PROPER UPPER LOWER LEFT RIGHT MID
Quiz49:PROPER UPPER LOWER LEFT RIGHT MID
Lecture69:FIND CLEAN REPT CONCATENATE
Quiz50:FIND CLEAN REPT CONCATENATE
Section25:PIVOT TABLES IN DEPTH
Lecture70:Pivot Tables
Quiz51:Pivot Tables
Lecture71:Pivot Table Filter Slicer
Quiz52:Pivot Table Filter Slicer
Lecture72:Pivot Charts
Quiz53:Pivot Charts
Lecture73:Naming Dynamic Ranges
Quiz54:Naming Dynamic Ranges
Lecture74:Naming a Cell and a Range
Quiz55:Naming a Cell and a Range
Section26:AUDITING AND TROUBLE SHOOTING FORMULAS
Lecture75:Auditing Toolbar
Quiz56:Auditing Toolbar
Lecture76:Watch Window
Quiz57:Watch Window
Section27:FORM CONTROLS
Lecture77:Group Boxes and Options Button
Quiz58:Group Boxes and Options Button
Lecture78:Check Boxes
Quiz59:Check Boxes
Lecture79:List Boxes and Combo Boxes
Quiz60:List Boxes and Combo Boxes
Lecture80:Scroll Bar and Spinners
Quiz61:Scroll Bar and Spinners
Section28:IMPORTANT EXCEL TOOLS
Lecture81:Text to Columns
Quiz62:Text to Columns
Lecture82:Grouping Tabs
Quiz63:Grouping Tabs
Lecture83:SUBTOTAL Function
Quiz64:SUBTOTAL Function
Lecture84:Hyperlinks
Quiz65:Hyperlinks
Lecture85:Data Validation
Quiz66:Data Validation
Lecture86:Random Numbers
Quiz67:Random Numbers
Lecture87:Custom View
Quiz68:Custom View
Lecture88:Protecting Worksheet and Workbook
Quiz69:Protecting Worksheet and Workbook
Section29:ADVANCED CHARTS
Lecture89:Excel 2010 Sparklines
Quiz70:Excel 2010 Sparklines
Lecture90:Range Charts
Lecture91:Range Charts Type 1 Part a
Quiz71:Range Charts Type 1 Part a
Lecture92:Range Charts Type 1 Part b
Quiz72:Range Charts Type 1 Part b
Lecture93:Range Charts Area
Lecture94:Range Charts Area Type 2 Part a
Quiz73:Range Charts Area Type 2 Part a
Lecture95:Range Charts Area Type 2 Part b
Quiz74:Range Charts Area Type 2 Part b
Lecture96:Funding Graph
Lecture97:Funding Graph
Quiz75:Funding Graph
Lecture98:Two Axis Graphs
Lecture99:Two Axis Graphs
Quiz76:Two Axis Graphs
Lecture100:Scenario Graphs
Lecture101:Scenario Graphs Part 1
Lecture102:Scenario Graphs Part 2
Quiz77:Scenario Graphs Part 2
Lecture103:Average Line
Quiz78:Average Line
Lecture104:Bar to Pie chart
Quiz79:Bar to Pie chart
Lecture105:Combo Charts
Quiz80:Combo Charts
Lecture106:Creating Histogram
Quiz81:Creating Histogram
Lecture107:Invert Negatives
Quiz82:Invert Negatives
Lecture108:Scrolling Chart part 1
Quiz83:Scrolling Chart part 1
Lecture109:Scrolling Chart part 2
Quiz84:Scrolling Chart part 2
Section30:CONCLUSION
Lecture110:Conclusion
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace