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 - Basic Excel Course

### Course Summary

This MS excel training tutorial teaches you basics of MS Excel 2010 using practical excel case studies

• +

### Course Syllabus

• Excel for Beginners - Overview
• Excel 2010 Beginner - Overview
• Excel 2010: Getting Started
• Getting Started - Surfing Excel & HELP Function
• Getting Started Quiz
• Case Study
• Excel Case Study
• Excel Case Study Quiz
• Data Entry in Excel
• Data Entry Quiz
• Populating the Case Study in Excel
• Populating the Case Study in Excel Quiz
• Calculations
• Calculations - Addition Subtract Multiply Division
• Calculations Quiz
• Formulas
• Formulas - SUM MAX MIN AVERAGE
• Formulas Quiz
• Formatting
• Formatting - Number Formats
• Formatting - Number Formatting Quiz
• Formatting - Table Formats
• Formatting - Table Format Quiz
• Updating a Calculation
• Updating a Calculation
• Updating a Calculation Quiz
• Percentages & Absolute References
• Percentages & Absolute References
• Percentage and Absolute References Quiz
• Conditional Formatting
• Conditional Formatting
• Conditional Formatting Quiz
• IF Function
• IF function
• IF Function Quiz
• COUNTIF and SUMIF
• COUNTIF Function
• COUNT IF Quiz
• SUMIF Function
• SUMIF Function Quiz
• Charts and Graphs
• Creating Charts and Graphs
• Charts and Graphs Quiz I
• Create Pie Charts
• Charts and Graphs Quiz II
• Sorts and Filters
• Sorts
• SORT Quiz
• Filters
• Filter Quiz
• Pivot Tables
• Pivot Tables
• Pivot Table Quiz
• Freeze and Split
• Freeze and Split
• Freeze and Split Quiz
• Presentation
• Presentation - Table Formats
• Presentation Quiz I
• Presentation - Indents and Formatting Charts
• Presentation Quiz II
• Print
• Printing the Worksheet
• Printing the Worksheet Quiz
• Printing - Headers and Titles
• Print Quiz
• Shortcuts
• Shortcuts - Formatting and Navigation
• Shortcut Part I Quiz
• Shortcuts - Selection, Data and Formula
• Shortcut Part II Quiz
• Common Errors
• Common Errors
• Common Error Quiz
• Concluding Lecture
• Concluding Lecture

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: