Intermediate Excel Training: Help & Tutorials

Course Summary

This Intermediate Excel Training: Help & Tutorials course is the simplest way to master intermediate Excel concepts before moving on to more advanced topics. Short lessons easily teach you what you need to know so you can catch up in class, study for a test or increase your workplace technical 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

5 chapters in Intermediate Excel Training: Help & Tutorials

Week {{::cp.getGoalWeekForTopic(0, 5)}}
Ch 1. Format Cells & Ranges in Excel {{cp.topicAssetIdToProgress[26814].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - How to Merge Cells in Excel Score: {{cp.lessonAssetIdToProgress[26815].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26815].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - How to Modify Cell Alignment & Indentation in Excel Score: {{cp.lessonAssetIdToProgress[26816].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26816].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Fonts and Font Styles in Excel Score: {{cp.lessonAssetIdToProgress[26817].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26817].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - How to Use the Format Painter in Excel Score: {{cp.lessonAssetIdToProgress[26818].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26818].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Wrapping Text in Excel: How to Wrap Text within Cells Score: {{cp.lessonAssetIdToProgress[26819].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26819].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - The Number Format in Excel: Options & Properties Score: {{cp.lessonAssetIdToProgress[26820].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26820].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - How to Highlight Cells in Excel Score: {{cp.lessonAssetIdToProgress[26821].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26821].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Cell Styles in Excel: Applying & Modifying Styles Score: {{cp.lessonAssetIdToProgress[26822].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26822].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - How to Change Text to WordArt in Excel Score: {{cp.lessonAssetIdToProgress[26823].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26823].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(1, 5)}}
Course Progress Best Score
Lesson 1 - Conditional Formatting in Excel: Applying & Modifying Formatting Score: {{cp.lessonAssetIdToProgress[32515].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32515].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Sparklines in Excel: How to Insert & Modify a Sparkline Score: {{cp.lessonAssetIdToProgress[32516].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32516].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Transpose Columns & Rows in Excel Score: {{cp.lessonAssetIdToProgress[32517].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32517].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Creating & Modifying Named Ranges in Excel Score: {{cp.lessonAssetIdToProgress[32518].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32518].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Outlines in Excel: How to Create an Outline Score: {{cp.lessonAssetIdToProgress[32519].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32519].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Outlines in Excel: How to Collapse Groups of Data in an Outline Score: {{cp.lessonAssetIdToProgress[32520].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32520].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - How to Insert a Subtotal in an Excel Worksheet Score: {{cp.lessonAssetIdToProgress[32521].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32521].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(4, 5)}}

Earning College Credit

Did you know… We have over 160 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.