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 in Excel 2013

### Course Summary

All videos less than 5 minutes! You will learn from the ground up to become a confident user of Microsoft Excel 2013.

• +

### Course Syllabus

• Basic parts of an Excel spreadsheet
• Simple Arithmetic Using Excel
• Basic Formatting
• Some tricks to save you time.
• Moving Data & Inserting Extra Columns and Rows
• Multiple Sheets in the one spreadsheet
• Absolute Referencing
• What is Absolute Referencing?
• Are you feeling old? We calculate your age in days, hours, minutes and seconds.
• Common Formulas in Excel 2013
• Sum()
• Average()
• Max() & Min()
• If()
• Rank()
• Lookup()
• CountIf()
• AverageIf() & SumIf()
• Other Formulas Galore
• Basic Formula Quiz
• Challenge Activity for Practising Using Formulas
• Explanation of Challenge
• Challenge Activity to Test Your New Skills
• Sample Responses for Task 1 & 2
• Sample Responses for Task 3
• Sample Responses for Task 4 & 5
• Conditional Formatting
• Conditional Formatting
• Creating a Basic Chart
• Probability in Excel
• Rand() & Randbetween()
• Using Probabilty in Excel

Course Fee:
USD 29

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: