# Intermediate Excel Training: Help & Tutorials

• Course type: Self-paced
• Available Lessons: 24
• Average Lesson Length: 8 min
• New lessons are still being added
• Watch a preview:

chapter 1 / lesson 1
How to Merge Cells in Excel

### 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 10 million students worldwide
5 Chapters in Intermediate Excel Training: Help & Tutorials

#### 5 chapters in Intermediate Excel Training: Help & Tutorials

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
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

### 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.

### Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com 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
Intermediate Excel Training: Help & Tutorials
This course currently has no final exam ready
Practice Chapter Exams
Ch. 5:  Shared Workbooks in Excel
Chapter too short for exam

Support