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
• Working Files All - Download These First
• 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
• Hyperlinks
• Hyperlinks
• Data Validation
• Data Validation
• Random Numbers
• Random Numbers
• Custom View
• Custom View
• Protecting - Worksheet and Workbook
• Protecting - Worksheet and Workbook
• Advanced Charts
• 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

Active

### Workload:

1 - 4 hours / week

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

Related Posts:

## Microsoft Excel

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software