Copyright

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:

    How to Merge Cells in Excel
    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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.

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? 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
See practice tests for:
Support