## edu CBA, Udemy

This Advanced Excel Training (MS Excel 2010) covers concepts like Pivot Tables, Dynamic Graphs, Advanced Excel Formulas

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.

Website: - edu CBA

Course Page – excel training 2010 advanced

You may also find awesome resources at our Excel blog

• What are the requirements?
• Basic Excel Knowledge
• What am I going to get from this course?
• Over 79 lectures and 6.5 hours of content!
• The objective of this online program is to make you awesome in Advanced Excel 2010.
• What is the target audience?
• Students and Professionals

##### SECTION 1: Introduction to the Course
• Introduction to the Course MS Excel 2010 Advanced
• ##### SECTION 2: Key Difference MS Excel 2007 vs 2010
• Office Button and Paste Function
• Office Button and Paste Function
• Sparklines, Custom Ribbons and Screenshots
• Sparklines, Custom Ribbons and Screenshots
• Conditional Formatting and Equation Editor
• Conditional Formatting and Equation Editor
• ##### SECTION 3: Useful Excel Functions
• Paste Special
• Paste Special
• Logical functions - IF AND OR
• Logical functions - IF AND OR
• Logical functions - IF AND OR
• Arithmetic functions MAX MIN ABS etc
• Arithmetic functions MAX MIN ABS etc
• Arithmetic functions MAX MIN ABS etc
• COUNT COUNTIF COUNTA COUNTBLANK
• COUNT COUNTIF COUNTA COUNTBLANK
• COUNT COUNTIF COUNTA COUNTBLANK
• Cell Information - ISERROR ISBLANK etc
• Cell Information - ISERROR ISBLANK etc
• ##### SECTION 4: Data Functions
• CHOOSE Function
• CHOOSE Function
• CHOOSE Function
• VLOOKUP Function
• VLOOKUP Function
• VLOOKUP Function
• HLOOKUP Function
• HLOOKUP Function
• HLOOKUP Function
• MATCH & INDEX
• MATCH & INDEX
• MATCH & INDEX
• Database functions - DSUM DAVERAGE DCOUNT
• Database functions - DSUM DAVERAGE DCOUNT
• Database functions - DSUM DAVERAGE DCOUNT
• OFFSET Function - Part 1
• OFFSET Function - Part 2
• FORECAST Function
• FORECAST Function
• ##### SECTION 5: WhatIf Analysis
• One Dimensional Data Tables
• One Dimensional Data Tables
• One Dimensional Data Tables
• Two dimensional Data Tables
• Two dimensional Data Tables
• Solver
• Solver
• Goal Seek
• Goal Seek
• Goal Seek
• ##### SECTION 6: Arrays
• Array Function - Introduction
• Array Function - Row and Columns
• Array Function - Row and Columns
• Array Function - TRANSPOSE
• Array Function - TRANSPOSE
• Array Function - FREQUENCY
• Array Function - FREQUENCY
• ##### SECTION 7: Functions for working with Text
• PROPER UPPER LOWER LEFT RIGHT MID
• PROPER UPPER LOWER LEFT RIGHT MID
• FIND CLEAN REPT CONCATENATE
• FIND CLEAN REPT CONCATENATE
• ##### SECTION 8: Pivot Tables
• Pivot Tables
• Pivot Tables
• Pivot Table Filter - Slicer
• Pivot Table Filter - Slicer
• Pivot Charts
• Pivot Charts
• Naming a Cell and a Range
• Naming a Cell and a Range
• Naming Dynamic Ranges
• Naming Dynamic Ranges
• ##### SECTION 9: Auditing and Trouble Shooting formulas
• Auditing Toolbar
• Auditing Toolbar
• Watch Window
• Watch Window
• ##### SECTION 10: Form Controls
• Group Boxes and Options Button
• Group Boxes and Options Button
• Check Boxes
• Check Boxes
• List Boxes and Combo Boxes
• List Boxes and Combo Boxes
• Scroll Bar and Spinners
• Scroll Bar and Spinners
• ##### SECTION 11: Important Excel Tools
• Text to Columns
• Text to Columns
• Grouping Tabs
• Grouping Tabs
• SUBTOTAL Function
• SUBTOTAL Function
• Data Validation
• Data Validation
• Random Numbers
• Random Numbers
• Custom View
• Custom View
• Protecting - Worksheet and Workbook
• Protecting - Worksheet and Workbook
• ##### SECTION 12: Advanced Charts
• Excel 2010 Sparklines
• Excel 2010 Sparklines
• Range Charts
• Range Charts - Type 1 Part a
• Range Charts - Type 1 Part a
• Range Charts - Type 1 Part b
• Range Charts - Type 1 Part b
• Range Charts - Area
• Range Charts - Area - Type 2 Part a
• Range Charts - Area - Type 2 Part a
• Range Charts - Area - Type 2 Part b
• Range Charts - Area - Type 2 Part b
• Funding Graph
• Funding Graph
• Funding Graph
• Two Axis Graphs
• Two Axis Graphs
• Two Axis Graphs
• Scenario Graphs
• Scenario Graphs Part 1
• Scenario Graphs Part 2
• Scenario Graphs Part 2
• Average Line
• Average Line
• Bar to Pie Chart
• Bar to Pie Chart
• Combo Charts
• Combo Charts
• Creating Histograms
• Creating Histograms
• Invert Negatives
• Invert Negatives
• Scrolling Chart Part 1
• Scrolling Chart Part 1
• Scrolling Chart Part 2
• Scrolling Chart Part 2
• Conclusion
•

会期:
• 自由时间安排
介绍:
• 免费:
• 收费:
• 证书:
• MOOC:
• 视频讲座:
• 音频讲座:
• Email-课程:
• 语言: 英语

### 反馈

目前这个课程还没有反馈。您想要留第一个反馈吗？

请注册, 为了写反馈

还有这个题目的:
Online Courses - Anytime, Anywhere
This course will teach you Excel 2010 from the absolute basics through to the...
Excel VBA Tutorial - Excel VBA Training Online
This Excel Visual Basic course gives you a non coding approach to VBA and Macros...
Getting Started With Microsoft Office 2010 Tutorial
This Microsoft Office 2010 tutorial will quickly get you up to speed. Taught...
Microsoft Excel Training - Beginner to Advanced Level
Learn from Ramzan Rajani (Microsoft Excel Specialist & Microsoft Certified Trainer...
Learn Microsoft Excel 2013
Fast moving, easy to follow Microsoft Excel 2013 tutorial from the e-learning...
还有Udemy:
Thousands of online courses for only \$15
Most courses are dropped to \$15 flat price!
Ruby on Rails Tutorial: Learn From Scratch
This post is part of our “Getting Started” series of free text tutorials on...
\$10 Sitewide Deal
\$10 Fixed Price across the site!
1 Hour HTML
Learn how to code in HTML in 1 hour. This class is set up for complete beginners...
1 hour jQuery
Have you ever wanted to learn to code. This course will show you the basics...