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
  • 会期:
    • 自由时间安排
    介绍:
    • 免费:
    • 收费:
    • 证书:
    • MOOC:
    • 视频讲座:
    • 音频讲座:
    • Email-课程:
    • 语言: 英语 Gb

    反馈

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

    请注册, 为了写反馈

    Show?id=n3eliycplgk&bids=695438
    已经在列表:
    NVIDIA
    还有这个题目的:
    23148_f4b4_15 Excel for Beginners - Excel 2010 Training
    This MS excel training tutorial teaches you basics of MS Excel 2010 using practical...
    112670_2bd1_8 Investment Banking Training Online - Investment Banking Course
    This Investment Banking course covers all about Investment Bank, Investment...
    116252_9f5f_6 Mastering Microsoft Excel 2013 for Lawyers Training Tutorial
    This Excel tutorial is designed specifically for those who practice law.
    57011_6df4_7 Advanced Excel Training - Learn Advanced Excel 2010
    This Advanced Excel Training (MS Excel 2010) covers concepts like Pivot Tables...
    9385_55cb_14 Microsoft Excel 2010: Advanced Training
    Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel...
    还有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