Advanced Excel Training - Excel Training Online

edu CBA, Udemy

This Online course on Microsoft Excel will make you awesome in Excel Features, Functions and Charts.

This is a well-researched and strategically designed Excel Training Program: Gain Excel Proficiency, perform mathematical calculations, functions, formulas and Master Excel Best Practices. This step-by-step lesson guide enables students/professionals to enhance their Excel skills through video tutorials, exercise, templates and gaining hands-on experience on various techniques.

Take this Excel Online Training and be awesome in Excel.

Website: - edu CBA

Course Page – excel training 2010 basic

Be a part of the learning community onFacebook orTwitter

You may also find awesome resources at our Excel blog


  • What are the requirements?
    • The Course starts from the Basics and Take you to the advanced level. An expert in Excel will find this course to be extremely useful. Similarly, the course is self sufficient for a starter as it will take care of all his foundation. So, anyone interested in learning excel, go for it. There is no prior requirements for opting for this course.
  • What am I going to get from this course?
    • Over 96 lectures and 5.5 hours of content!
    • Effective organize and store important financial data in a clean, easy-to-read format so the user can find information quickly
    • Calculation of Mathematical Formulas & Advanced Functions
    • Sorting of Data and data debugging is very easy using excel
    • Powerful customizations that can save 100 of hours
    • Graphs & Charts can be easily depicted using Excel
    • Perform Sensitivity Analysis & Scenario Analysis
    • Last but not the Least, To Make you Awesome in Excel
  • What is the target audience?
    • Students and Professionals
    • Financial Analysts, Bankers, Investment Bankers, Research Analyst, Professionals from the domains of Equity Research, Investment Banking, Private Equity, Credit Research
    • Any Excel Enthusiast, Undergraduate, Graduate and Post Graduate Students
    • Anyone using Excel in His/Her Day to day activity
    • Professors, Lecturers, Readers from Colleges and Universities

SECTION 1: Excel - Overview
  • Excel - Overview
  • SECTION 2: Getting Started
  • Excel Overview Notes
  • Formatting a Spreadsheet
  • Use Paste Special Effectively
  • Check Boxes
  • Comments
  • Comments
  • Group Boxes And Options Button
  • Grouping Tabs
  • List Boxes And Combo Boxes
  • Print Setup Options
  • Auditing Features
  • Arrays Notes
  • Scroll Bar And Spinners
  • Subtotals
  • Text To Colum
  • Getting Started
  • SECTION 3: Date & Time
  • Date Functions Notes
  • Day Date Datedif Networkdays PART 1
  • DAYS FUNCTIONS PART 2
  • Date & Time
  • SECTION 4: Text & Data
  • String Functions Notes
  • Text And String
  • Text & Data
  • SECTION 5: Filter, Sort & Conditional Formating
  • Data Filters Notes
  • Auto Filter
  • Sorting Notes
  • Conditional Formatting
  • Filter Sort & Conditional Format
  • SECTION 6: Formatting Data
  • Formating Notes
  • Formatting Data
  • SECTION 7: Cell Information
  • Cell Information
  • Cell Information
  • SECTION 8: Validating Data
  • Validating Data
  • Validating Data
  • SECTION 9: Pivot Table
  • Pivot Tables
  • Pivot Table
  • Pivot Table
  • SECTION 10: Logical
  • Logical Functions Notes
  • And OR IF
  • Logical
  • SECTION 11: Mathematics & Statistics
  • Aggregation Function Notes
  • Arithmetic Function Notes
  • ABS LARGE MAX MIN SMALL
  • Count Countif Count A Countblank
  • Forecast Function
  • Mathematics & Statistics
  • SECTION 12: Database Function
  • Database Functions Notes
  • Detabase Function Part 1,2
  • Database Function
  • SECTION 13: Lookup & Reference
  • Choose Function Notes
  • CHOOSE Function
  • HLOOKUP Notes
  • HLOOKUP
  • Hyperlinks
  • Match Notes
  • MATCH And INDEX
  • OFFSET Function Part 1,2
  • OFFSET Function Part 3,4
  • Vlookup Notes
  • VLOOKUP Function
  • Lookup & Reference
  • SECTION 14: Basic Charting for Business analysts
  • Adding An Average
  • Combo Charts
  • Bar To Pie Charts
  • Histogram
  • Delta Charts
  • Invert Negative In Chart
  • Dynamic Chart Labels
  • Scrolling Chart
  • Thermometer Chart
  • Basic Charting For Business Analysts
  • Quiz 1
  • Quiz 2
  • SECTION 15: Advance Charting for Business analysts
  • Funding Graphs Notes
  • Funding Graph
  • Range Charts Notes
  • Area Range Charts Notes
  • Range Chart Part 1,2
  • Range Chart Part 3
  • Range Charts Version 2 Part 1,2
  • Range Charts Version 2 Part 3
  • Scenario Graphs Notes
  • Setting Up Scenario Graph Part 1
  • Setting Up Scenario Graph Part 2
  • Two Axis Graph Notes
  • Two Axis Graph Part 1,2
  • Advance Charting For Business Analysts
  • SECTION 16: What if Analysis
  • Goal Seek
  • Data Tables Notes
  • One Dimensional Data Tables
  • Two Dimensional Data Tables
  • Solver
  • Watch Window
  • What If Analysis
  • Quiz 3
  • Quiz 4
  • SECTION 17: Security & Privacy
  • Protecting Worksheet
  • Security & Privacy
  • SECTION 18: Concluding Lecture
  • Concluding Lecture
  • Dates:
    • Free schedule
    Course properties:
    • Free:
    • Paid:
    • Certificate:
    • MOOC:
    • Video:
    • Audio:
    • Email-course:
    • Language: English Gb

    Reviews

    No reviews yet. Want to be the first?

    Register to leave a review

    Show?id=n3eliycplgk&bids=695438
    Included in selections:
    NVIDIA
    More on this topic:
    149554_ceb0_2 Learn Financial Modeling from Scratch - Udemy
    Confidently & quickly create your own financial models. Quickly check even...
    58333_95d5_12 Equity Research - A Comprehensive Program by edu CBA
    The way an Equity Analyst / Investment Banker does! Includes Excel, Accounting...
    112670_2bd1_8 Investment Banking Training Online - Investment Banking Course
    This Investment Banking course covers all about Investment Bank, Investment...
    9385_55cb_14 Microsoft Excel 2010: Advanced Training
    Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel...
    30145_10d9_14 Business Mathematics for Enterprises by edu CBA
    A Well Designed Program for Professionals to Learn Mathematics Used by Enterprises...
    More from '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