

Advanced Excel Course
Advanced Excel Training covers concepts like Pivot Tables, Dynamic Graphs, Advanced Excel Formulas
Self paced
tutorials
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
- 6+ hours of high quality content
- Learn advanced formula, pivot tables, dynamic graphs and more
- 79+ HD Video Tutorials
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.
Schedule & Syllabus
