# 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 30 million students worldwide

#### 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)}}
Ch 2. Order & Group Cells & Ranges in Excel {{cp.topicAssetIdToProgress[32514].percentComplete}}% complete
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(3, 5)}}
Ch 4. Working with Excel Tables {{cp.topicAssetIdToProgress[52761].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - How to Create a Table in an Excel Worksheet
Score: {{cp.lessonAssetIdToProgress[32523].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32523].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - How to Add & Remove Columns & Rows in an Excel Table
Score: {{cp.lessonAssetIdToProgress[32525].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32525].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Apply a Style to an Excel Table
Score: {{cp.lessonAssetIdToProgress[32528].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32528].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - How to Band Rows & Columns in an Excel Table
Score: {{cp.lessonAssetIdToProgress[32529].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[32529].bestScoreQuestions}}  Take Quiz Optional

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

### 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 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!
Your detailed study guide will include:
• Answers and detailed explanations to each question
• Video lessons to explain complicated concepts
Course Practice Test
Intermediate Excel Training: Help & Tutorials
Not Taken
More practice by chapter
Ch. 1
Not Taken
Ch. 2
Not Taken
Ch. 3
Not Taken
Ch. 4
Not Taken
Ch. 5
Shared Workbooks in Excel
Not Taken
See practice tests for:

Support