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
• Spreadsheets And Cells
• 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
• Advanced Excel Training
• 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

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