Advanced Excel Training - Learn Advanced Excel 2010

edu CBA, Udemy

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

This 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.

Website: - edu CBA

Course Page – excel training 2010 advanced

Be a part of the learning community onFacebook orTwitter

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
  • Working Files All - Download These First
  • 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
  • Hyperlinks
  • Hyperlinks
  • 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
  • SECTION 13: CONCLUSION
  • Conclusion
  • 会期:
    • 自由时间安排
    介绍:
    • 免费:
    • 收费:
    • 证书:
    • MOOC:
    • 视频讲座:
    • 音频讲座:
    • Email-课程:
    • 语言: 英语 Gb

    反馈

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

    请注册, 为了写反馈

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

    © 2013-2019