Advanced Excel Training - Excel Training Online

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