Advanced Excel Training: Help & Tutorials

Course Summary

Master some of the more complicated Excel topics by completing this Advanced Excel Training tutorial course. Our self-paced video and text lessons can help you catch up in class or boost your professional skills.
Create An Account
To Start This Course Today
Used by over 30 million students worldwide
Create An Account
Try it free for 5 days

2 chapters in Advanced Excel Training: Help & Tutorials

Week {{::cp.getGoalWeekForTopic(0, 2)}}
Ch 1. Working with Excel Charts & Graphs {{cp.topicAssetIdToProgress[52714].percentComplete}}% complete
Week {{::cp.getGoalWeekForTopic(1, 2)}}
Course Progress Best Score
Lesson 1 - How to Use Formulas & Functions in Excel Score: {{cp.lessonAssetIdToProgress[36600].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36600].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Using the SUM Function in Excel Score: {{cp.lessonAssetIdToProgress[36606].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36606].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Using the AVERAGE Function in Excel Score: {{cp.lessonAssetIdToProgress[36609].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36609].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Copying Formulas with the Excel Fill Handle Score: {{cp.lessonAssetIdToProgress[52738].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[52738].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Cell References in Excel: Relative, Absolute & Mixed Score: {{cp.lessonAssetIdToProgress[36601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36601].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Using the MIN and MAX Functions in Excel Score: {{cp.lessonAssetIdToProgress[36607].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36607].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - Using the COUNT Function in Excel Score: {{cp.lessonAssetIdToProgress[36608].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36608].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Using the IF Function in Excel Score: {{cp.lessonAssetIdToProgress[52739].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[52739].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - How to Use the COUNTIF Function in Excel Score: {{cp.lessonAssetIdToProgress[36613].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36613].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - How to Use the AVERAGEIF Function in Excel Score: {{cp.lessonAssetIdToProgress[36612].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36612].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - How to Use the SUMIF Function in Excel Score: {{cp.lessonAssetIdToProgress[36611].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36611].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - Using the TRIM & CLEAN Functions to Fix Data in Excel Score: {{cp.lessonAssetIdToProgress[36616].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36616].bestScoreQuestions}}  Take Quiz Optional
Lesson 13 - Using the UPPER and LOWER Functions in Excel Score: {{cp.lessonAssetIdToProgress[36617].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36617].bestScoreQuestions}}  Take Quiz Optional
Lesson 14 - How to Use the CONCATENATE Function in Excel Score: {{cp.lessonAssetIdToProgress[36618].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36618].bestScoreQuestions}}  Take Quiz Optional

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Practice Final Exam
Advanced Excel Training: Help & Tutorials
This course currently has no final exam ready
Practice Chapter Exams
Ch. 1:  Working with Excel Charts & Graphs
Chapter too short for exam