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

# Fast Track to Microsoft Excel Beginner + Advanced Training

### Course Summary

MASTER EXCEL in HOURs instead of weeks. Beginner And Advanced Excel Training - Microsoft Excel 2007 / 2010

• +

### Course Syllabus

• Beginner Excel Training
• Introduction To Excel
• The Ribbon
• Formula Bar
• The Information Bar
• Entering Data
• Data And Autofill
• Formatting
• Formatting Cells
• Introduction To Formulas
• Range Reference And Functions
• More Formulas
• Formatting For Currency
• Conditional Formatting
• Absolute References
• Borders
• Filling Cells
• Styles
• More Functions
• Illustrations
• Introduction To Charts
• Printing
• Closing Statements
• Introduction
• The ROUND Function
• Using ROUND
• TEXT
• Using TEXT
• The LEN Function
• The REPLACE Function
• Using REPLACE And LEN
• The IF Function
• Using IF
• More On IF
• Using LEFT, RIGHT & MID
• The CONCATENATE Function
• Using UPPER, LOWER & PROPER
• The TRIM Function
• Using VALUE
• Working With Multiple Sheets
• Drop Down
• Real World Scenario
• Using COUNTIF & COUNTA
• COUNT Together
• Relative & Absolute
• Mulitiplying Text
• The PMT Function
• Introduction To Macros
• More On Macros
• Editing Macros
• Macro Notes
• Using VLOOKUP
• Creating a VLOOKUP Invoice
• VLOOKUP & IF
• SUBTOTAL
• Using HLOOKUP
• Introduction To Pivot Tables
• Pivot Table Options
• Pivot Charts
• Goal Seek

Course Fee:
USD 49

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: