MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Excel - Advanced Excel Course

### Course Summary

This Advanced Excel Training (MS Excel 2010) covers concepts like Pivot Tables, Dynamic Graphs, Advanced Excel Formulas

• +

### Course Syllabus

• Introduction to the Course
• Introduction to the Course MS Excel 2010 Advanced
• Key Difference MS Excel 2007 vs 2010
• Office Button and Paste Function
• Office Button and Paste Function
• Sparklines, Custom Ribbons and Screenshots
• Sparklines, Custom Ribbons and Screenshots
• Conditional Formatting and Equation Editor
• Conditional Formatting and Equation Editor
• Useful Excel Functions
• Paste Special
• Paste Special
• Logical functions - IF AND OR
• Logical functions - IF AND OR
• Logical functions - IF AND OR
• Arithmetic functions MAX MIN ABS etc
• Arithmetic functions MAX MIN ABS etc
• Arithmetic functions MAX MIN ABS etc
• COUNT COUNTIF COUNTA COUNTBLANK
• COUNT COUNTIF COUNTA COUNTBLANK
• COUNT COUNTIF COUNTA COUNTBLANK
• Cell Information - ISERROR ISBLANK etc
• Cell Information - ISERROR ISBLANK etc
• Data Functions
• CHOOSE Function
• CHOOSE Function
• CHOOSE Function
• VLOOKUP Function
• VLOOKUP Function
• VLOOKUP Function
• HLOOKUP Function
• HLOOKUP Function
• HLOOKUP Function
• MATCH & INDEX
• MATCH & INDEX
• MATCH & INDEX
• Database functions - DSUM DAVERAGE DCOUNT
• Database functions - DSUM DAVERAGE DCOUNT
• Database functions - DSUM DAVERAGE DCOUNT
• OFFSET Function- Understanding basics
• OFFSET Function - Dynamic nature
• FORECAST Function
• FORECAST Function
• WhatIf Analysis
• One Dimensional Data Tables
• One Dimensional Data Tables
• One Dimensional Data Tables
• Two dimensional Data Tables
• Two dimensional Data Tables
• Solver
• Solver
• Goal Seek
• Goal Seek
• Goal Seek
• Arrays
• Array Function - Introduction
• Array Function - Row and Columns
• Array Function - Row and Columns
• Array Function - TRANSPOSE
• Array Function - TRANSPOSE
• Array Function - FREQUENCY
• Array Function - FREQUENCY
• Functions for working with Text
• PROPER UPPER LOWER LEFT RIGHT MID
• PROPER UPPER LOWER LEFT RIGHT MID
• FIND CLEAN REPT CONCATENATE
• FIND CLEAN REPT CONCATENATE
• Pivot Tables
• Pivot Tables
• Pivot Tables
• Pivot Table Filter - Slicer
• Pivot Table Filter - Slicer
• Pivot Charts
• Pivot Charts
• Naming Dynamic Ranges
• Naming a Cell and a Range
• Naming a Cell and a Range
• Naming Dynamic Ranges
• Auditing and Trouble Shooting formulas
• Auditing Toolbar
• Auditing Toolbar
• Watch Window
• Watch Window
• Form Controls
• Group Boxes and Options Button
• Group Boxes and Options Button
• Check Boxes
• Check Boxes
• List Boxes and Combo Boxes
• List Boxes and Combo Boxes
• Scroll Bar and Spinners
• Scroll Bar and Spinners
• Important Excel Tools
• Text to Columns
• Text to Columns
• Grouping Tabs
• Grouping Tabs
• SUBTOTAL Function
• SUBTOTAL Function
• Data Validation
• Data Validation
• Random Numbers
• Random Numbers
• Custom View
• Custom View
• Protecting - Worksheet and Workbook
• Protecting - Worksheet and Workbook
• Excel 2010 Sparklines
• Excel 2010 Sparklines
• Range Charts
• Range Charts Type 1
• Range Charts Type 1
• Range Charts Type 1- Continued
• Range Charts Type 1- Continued
• Range Charts - Area
• Range Charts Area Type 2
• Range Charts Area Type 2
• Range Charts Area Type 2- Continued
• Range Charts Area Type 2- Continued
• Funding Graph
• Funding Graph
• Funding Graph
• Two Axis Graphs
• Two Axis Graphs
• Two Axis Graphs
• Scenario Graphs
• Scenario Graphs
• Scenario Graphs Continued
• Scenario Graphs Continued
• Average Line
• Average Line
• Bar to Pie Chart
• Bar to Pie Chart
• Combo Charts
• Combo Charts
• Creating Histograms
• Creating Histograms
• Invert Negatives
• Invert Negatives
• Scrolling Chart
• Scrolling Chart
• Scrolling Chart Continued
• Scrolling Chart Continued
• CONCLUSION
• Conclusion

Course Fee:
USD 99

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: