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
Try it risk-free for 30 days
Create an account
Try it risk-free for 30 days

2 chapters in Advanced Excel Training: Help & Tutorials

Course Practice Test

Check your knowledge of this course with a 50-question practice test.
  • Comprehensive test covering all topics
  • Detailed video explanations for wrong answers
Week {{::cp.getGoalWeekForTopic(1, 2)}}
Ch 2. Excel Formulas & Functions {{cp.topicAssetIdToProgress[52737].percentComplete}}% complete
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Score: {{cp.lessonAssetIdToProgress[36618].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36618].bestScoreQuestions}}  Take Quiz Optional

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 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 Tests in this course
Check your knowledge of this course with a 50-question practice test. Once you take the test, you will receive a detailed exam report complete with your personal statistics and even specific lessons to focus on! Take the practice test now
Your detailed study guide will include:
  • Answers and detailed explanations to each question
  • Video lessons to explain complicated concepts
Course Practice Test
More practice by chapter
Ch. 1
Working with Excel Charts & Graphs
Not Taken
See practice tests for: