Educba

Advanced Excel Course

Advanced Excel Training covers concepts like Pivot Tables, Dynamic Graphs, Advanced Excel Formulas

Self paced

tutorials

ENROLL NOW

Overview
Schedule

About this Course

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 goes deeper into the features and functions of the powerful Excel spreadsheet. The course is perfect for those who already have a good knowledge of Microsoft Excel 2010 basics.

Why should you take this course?

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

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 with beautifully in details.

The objective of this online program is to make you awesome in Advanced Excel 2010.

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

Course Content :

Section 1: Introduction to the Course

Lecture 1: Introduction to the Course MS Excel 2010 Advanced

Section 2: Key Difference MS Excel 2007 vs 2010

Lecture 2: Working Files All - Download These First

Lecture 3: Office Button and Paste Function

Lecture 4: Sparklines, Custom Ribbons and Screenshots

Lecture 5: Conditional Formatting and Equation Editor

Section 3: Useful Excel Functions

Lecture 6: Paste Special

Lecture 7: Logical functions - IF AND OR

Lecture 8: Logical functions - IF AND OR

Lecture 9: Arithmetic functions MAX MIN ABS etc

Lecture 10: Arithmetic functions MAX MIN ABS etc

Lecture 11: COUNT COUNTIF COUNTA COUNTBLANK

Lecture 12: COUNT COUNTIF COUNTA COUNTBLANK

Lecture 13: Cell Information - ISERROR ISBLANK etc

Section 4: Data Functions

Lecture 14: CHOOSE Function

Lecture 15: CHOOSE Function

Lecture 16: VLOOKUP Function

Lecture 17: VLOOKUP Function

Lecture 18: HLOOKUP Function

Lecture 19: HLOOKUP Function

Lecture 20: MATCH & INDEX

Lecture 21: MATCH & INDEX

Lecture 22: Database functions - DSUM DAVERAGE DCOUNT

Lecture 23: Database functions - DSUM DAVERAGE DCOUNT

Lecture 24: OFFSET Function - Part 1

Lecture 25: OFFSET Function - Part 2

Lecture 26: FORECAST Function

Section 5: WhatIf Analysis

Lecture 27: One Dimensional Data Tables

Lecture 28: One Dimensional Data Tables

Lecture 29: Two Dimensional Data Tables

Lecture 30: Solver

Lecture 31: Goal Seek

Lecture 32: Goal Seek

Section 6: Arrays

Lecture 33: Array Function - Introduction

Lecture 34: Array Function - Row and Columns

Lecture 35: Array Function - TRANSPOSE

Lecture 36: Array Function - FREQUENCY

Section 7: Functions for Working with Text

Lecture 37: PROPER UPPER LOWER LEFT RIGHT MID

Lecture 38: FIND CLEAN REPT CONCATENATE

Section 8: Pivot Tables

Lecture 39: Pivot Tables

Lecture 40: Pivot Table Filter - Slicer

Lecture 41: Pivot Charts

Lecture 42: Naming a Cell and a Range

Lecture 43: Naming Dynamic Ranges

Section 9:Auditing and Troubleshooting formulas

Lecture 44: Auditing Toolbar

Lecture 45: Watch Window

Section 10: Form Controls

Lecture 46: Group Boxes and Options Button

Lecture 47: Check Boxes

Lecture 48: List Boxes and Combo Boxes

Lecture 49: Scroll Bar and Spinners

Section 11: Important Excel Tools

Lecture 50: Text to Columns

Lecture 51: Grouping Tabs

Lecture 52: SUBTOTAL Function

Lecture 53: Hyperlinks

Lecture 54: Data Validation

Lecture 55: Random Numbers

Lecture 56: Custom View

Lecture 57: Protecting - Worksheet and Workbook

Section 12: Advanced Charts

Lecture 58: Excel 2010 Sparklines

Lecture 59: Range Charts

Lecture 60: Range Charts - Type 1 Part A

Lecture 61: Range Charts - Type 1 Part B

Lecture 62: Range Charts - Area

Lecture 63: Range Charts - Area - Type 2 Part A

Lecture 64: Range Charts - Area - Type 2 Part B

Lecture 65: Funding Graph

Lecture 66: Funding Graph

Lecture 67: Two Axis Graphs

Lecture 68: Two Axis Graphs

Lecture 69: Scenario Graphs

Lecture 70: Scenario Graphs Part 1

Lecture 71: Scenario Graphs Part 2

Lecture 72: Average Line

Lecture 73: Bar to Pie Chart

Lecture 74: Combo Charts

Lecture 75: Creating Histograms

Lecture 76: Invert Negatives

Lecture 77: Scrolling Chart Part 1

Lecture 78: Scrolling Chart Part 2

Section 13: CONCLUSION

Lecture 79: Conclusion

Language of instruction: English

Highlights

6+ hours of high quality content
Learn advanced formula, pivot tables, dynamic graphs and more
79+ HD Video Tutorials

About the instructor

Educba

Mumbai , India

eduCBA is a globally recognized training firm, providing a blend of instructor-led and online financial training programs in Excel, Advanced Excel, VBAs, Macros, Equity Research, Wealth Management, Technical Analysis Investment Banking, Private Equity, Fundamental Analysis, Investment Research, Credit Research etc and preparatory courses like CFA Level I & II and FRM Level I & II, Campus Placement Trainings etc.

eduCBA Online Training Learning Management System provides access to high-end Excel videos, valuation tutorials, online tests, downloadable templates and models that are prepared by Research Analysts & Investment Bankers.

4 FOLLOWERS

Schedule & Syllabus

Please wait while we are fetching data...