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 advanced online course on Microsoft Excel 2010 is not for beginners. This awesome course is ideal for those seeking to enhance their Excel 2010 knowledge, it even goes deeper into the features and functions of the powerful excel spreadsheet. The course is perfect for those already having a good knowledge of Microsoft Excel 2010 basics. In this online course, you will learn advanced features. You will learn about performing lookups with HLOOKUP and VLOOKUP. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the author. The course starts with an explanation to show the differences between excel 2007 and excel 2010. It begins with useful functions like Paste Special, Logical, countif goes on to explain advanced features like HLOOKUP, VLOOKUP, Match, Offset, Forecast etc. What-if-analysis in one dimension, two dimension table, solver, Goal seek have been done beautifully taking examples. Pivot Tables in details, range, excel tools, advanced charts have been dealt beautifully in details. The objective of this online program is to make you awesome in Advanced Excel 2010.
This course is best viewed on HD 720p. The same option is given in Udemy Video Screen Bottom Right.
Note: Microsoft Excel 2010 Advanced (this course) is also a part of Excel - Excel Course (Basic and Advanced). If you are looking for both Beginner and Advanced Excel 2010, Please go for Comprehensive program.
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.
Course Curriculum
Section1:Introduction to the Course
Lecture1:Introduction to the Course MS Excel 2010 Advanced
Section2:Key Difference MS Excel 2007 vs 2010
Lecture2:Working Files All - Download These First
Lecture3:Office Button and Paste Function
Quiz1:Office Button and Paste Function
Lecture4:Sparklines, Custom Ribbons and Screenshots
Quiz2:Sparklines, Custom Ribbons and Screenshots
Lecture5:Conditional Formatting and Equation Editor
Quiz3:Conditional Formatting and Equation Editor
Section3:Useful Excel Functions
Lecture6:Paste Special
Quiz4:Paste Special
Lecture7:Logical functions - IF AND OR
Lecture8:Logical functions - IF AND OR
Quiz5:Logical functions - IF AND OR
Lecture9:Arithmetic functions MAX MIN ABS etc
Lecture10:Arithmetic functions MAX MIN ABS etc
Quiz6:Arithmetic functions MAX MIN ABS etc
Lecture11:COUNT COUNTIF COUNTA COUNTBLANK
Lecture12:COUNT COUNTIF COUNTA COUNTBLANK
Quiz7:COUNT COUNTIF COUNTA COUNTBLANK
Lecture13:Cell Information - ISERROR ISBLANK etc
Quiz8:Cell Information - ISERROR ISBLANK etc
Section4:Data Functions
Lecture14:CHOOSE Function
Lecture15:CHOOSE Function
Quiz9:CHOOSE Function
Lecture16:VLOOKUP Function
Lecture17:VLOOKUP Function
Quiz10:VLOOKUP Function
Lecture18:HLOOKUP Function
Lecture19:HLOOKUP Function
Quiz11:HLOOKUP Function
Lecture20:MATCH & INDEX
Lecture21:MATCH & INDEX
Quiz12:MATCH & INDEX
Lecture22:Database functions - DSUM DAVERAGE DCOUNT
Lecture23:Database functions - DSUM DAVERAGE DCOUNT
Quiz13:Database functions - DSUM DAVERAGE DCOUNT
Lecture24:OFFSET Function - Part 1
Lecture25:OFFSET Function - Part 2
Lecture26:FORECAST Function
Quiz14:FORECAST Function
Section5:WhatIf Analysis
Lecture27:One Dimensional Data Tables
Lecture28:One Dimensional Data Tables
Quiz15:One Dimensional Data Tables
Lecture29:Two dimensional Data Tables
Quiz16:Two dimensional Data Tables
Lecture30:Solver
Quiz17:Solver
Lecture31:Goal Seek
Lecture32:Goal Seek
Quiz18:Goal Seek
Section6:Arrays
Lecture33:Array Function - Introduction
Lecture34:Array Function - Row and Columns
Quiz19:Array Function - Row and Columns
Lecture35:Array Function - TRANSPOSE
Quiz20:Array Function - TRANSPOSE
Lecture36:Array Function - FREQUENCY
Quiz21:Array Function - FREQUENCY
Section7:Functions for working with Text
Lecture37:PROPER UPPER LOWER LEFT RIGHT MID
Quiz22:PROPER UPPER LOWER LEFT RIGHT MID
Lecture38:FIND CLEAN REPT CONCATENATE
Quiz23:FIND CLEAN REPT CONCATENATE
Section8:Pivot Tables
Lecture39:Pivot Tables
Quiz24:Pivot Tables
Lecture40:Pivot Table Filter - Slicer
Quiz25:Pivot Table Filter - Slicer
Lecture41:Pivot Charts
Quiz26:Pivot Charts
Lecture42:Naming a Cell and a Range
Quiz27:Naming a Cell and a Range
Lecture43:Naming Dynamic Ranges
Quiz28:Naming Dynamic Ranges
Section9:Auditing and Trouble Shooting formulas
Lecture44:Auditing Toolbar
Quiz29:Auditing Toolbar
Lecture45:Watch Window
Quiz30:Watch Window
Section10:Form Controls
Lecture46:Group Boxes and Options Button
Quiz31:Group Boxes and Options Button
Lecture47:Check Boxes
Quiz32:Check Boxes
Lecture48:List Boxes and Combo Boxes
Quiz33:List Boxes and Combo Boxes
Lecture49:Scroll Bar and Spinners
Quiz34:Scroll Bar and Spinners
Section11:Important Excel Tools
Lecture50:Text to Columns
Quiz35:Text to Columns
Lecture51:Grouping Tabs
Quiz36:Grouping Tabs
Lecture52:SUBTOTAL Function
Quiz37:SUBTOTAL Function
Lecture53:Hyperlinks
Quiz38:Hyperlinks
Lecture54:Data Validation
Quiz39:Data Validation
Lecture55:Random Numbers
Quiz40:Random Numbers
Lecture56:Custom View
Quiz41:Custom View
Lecture57:Protecting - Worksheet and Workbook
Quiz42:Protecting - Worksheet and Workbook
Section12:Advanced Charts
Lecture58:Excel 2010 Sparklines
Quiz43:Excel 2010 Sparklines
Lecture59:Range Charts
Lecture60:Range Charts - Type 1 Part a
Quiz44:Range Charts - Type 1 Part a
Lecture61:Range Charts - Type 1 Part b
Quiz45:Range Charts - Type 1 Part b
Lecture62:Range Charts - Area
Lecture63:Range Charts - Area - Type 2 Part a
Quiz46:Range Charts - Area - Type 2 Part a
Lecture64:Range Charts - Area - Type 2 Part b
Quiz47:Range Charts - Area - Type 2 Part b
Lecture65:Funding Graph
Lecture66:Funding Graph
Quiz48:Funding Graph
Lecture67:Two Axis Graphs
Lecture68:Two Axis Graphs
Quiz49:Two Axis Graphs
Lecture69:Scenario Graphs
Lecture70:Scenario Graphs Part 1
Lecture71:Scenario Graphs Part 2
Quiz50:Scenario Graphs Part 2
Lecture72:Average Line
Quiz51:Average Line
Lecture73:Bar to Pie Chart
Quiz52:Bar to Pie Chart
Lecture74:Combo Charts
Quiz53:Combo Charts
Lecture75:Creating Histograms
Quiz54:Creating Histograms
Lecture76:Invert Negatives
Quiz55:Invert Negatives
Lecture77:Scrolling Chart Part 1
Quiz56:Scrolling Chart Part 1
Lecture78:Scrolling Chart Part 2
Quiz57:Scrolling Chart Part 2
Section13:CONCLUSION
Lecture79: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