# Intro to Excel: Essential Training & Tutorials

### Course Summary

Learn how to create graphs, tables and charts using Microsoft Excel with this engaging tutorial course. Use our short video lessons to learn the basics of using this program for school, home, or professional use.
Create An Account
To Start This Course Today
Used by over 30 million students worldwide

#### 15 chapters in Intro to Excel: Essential Training & Tutorials

Week {{::cp.getGoalWeekForTopic(0, 15)}}
Ch 1. Creating Worksheets & Workbooks in Excel {{cp.topicAssetIdToProgress[14421].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Creating Workbooks in Excel: Blank Workbooks and Templates
Score: {{cp.lessonAssetIdToProgress[14422].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[14422].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - How to Import and Open Files Directly in Excel
Score: {{cp.lessonAssetIdToProgress[14423].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[14423].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Add, Copy, and Move Worksheets Within Excel Workbooks
Score: {{cp.lessonAssetIdToProgress[14424].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[14424].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - What is a Workbook in Excel? - Characteristics and Options
Score: {{cp.lessonAssetIdToProgress[14425].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[14425].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(1, 15)}}
Ch 2. Formatting Worksheets & Workbooks in Excel {{cp.topicAssetIdToProgress[24999].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - How to Modify the Worksheet Tab in Excel
Score: {{cp.lessonAssetIdToProgress[25000].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25000].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Modifying Page Setup Properties in Excel
Score: {{cp.lessonAssetIdToProgress[25001].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25001].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Insert & Delete Columns & Rows in Excel
Score: {{cp.lessonAssetIdToProgress[25002].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25002].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Workbook Themes: Applying & Changing Themes in Excel
Score: {{cp.lessonAssetIdToProgress[25003].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25003].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Adjusting Column Width & Row Height in Excel
Score: {{cp.lessonAssetIdToProgress[25004].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25004].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - How to Insert Watermarks in Your Excel Worksheet
Score: {{cp.lessonAssetIdToProgress[25005].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25005].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - How to Insert Headers & Footers in Excel
Score: {{cp.lessonAssetIdToProgress[25006].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25006].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Using Data Validation in Excel
Score: {{cp.lessonAssetIdToProgress[25007].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25007].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(3, 15)}}
Ch 4. Configure to Print & Save in Excel {{cp.topicAssetIdToProgress[30375].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Setting a Print Area in Excel
Score: {{cp.lessonAssetIdToProgress[30376].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30376].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Saving an Excel Workbook: File Formats & Options
Score: {{cp.lessonAssetIdToProgress[30377].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30377].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Print Individual Worksheets in Excel
Score: {{cp.lessonAssetIdToProgress[30378].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30378].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - How to Set Print Scaling in Excel
Score: {{cp.lessonAssetIdToProgress[30379].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30379].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Ensuring Your Excel Workbook is Backwards Compatible
Score: {{cp.lessonAssetIdToProgress[30381].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30381].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Printing in Excel: How to Configure Workbooks to Print
Score: {{cp.lessonAssetIdToProgress[30382].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30382].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - How to Modify Print Settings in Excel
Score: {{cp.lessonAssetIdToProgress[30383].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30383].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - How to Save Excel Workbook Files in Different Formats
Score: {{cp.lessonAssetIdToProgress[30384].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30384].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - How to Share Your Excel Workbook
Score: {{cp.lessonAssetIdToProgress[30385].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[30385].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(4, 15)}}
Ch 5. 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(5, 15)}}
Ch 6. Insert Data in Cells and Ranges in Excel {{cp.topicAssetIdToProgress[31595].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - How to Append Multiple Worksheets
Score: {{cp.lessonAssetIdToProgress[31596].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[31596].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - How to Find and Replace Data in Excel
Score: {{cp.lessonAssetIdToProgress[31597].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[31597].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Copy and Paste Data in Excel
Score: {{cp.lessonAssetIdToProgress[31598].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[31598].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Using the AutoFill Tool in Excel
Score: {{cp.lessonAssetIdToProgress[31599].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[31599].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Cells in Excel: How to Insert and Delete Cells
Score: {{cp.lessonAssetIdToProgress[31601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[31601].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Using the AND function in Excel
Score: {{cp.lessonAssetIdToProgress[146722].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[146722].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(7, 15)}}
Ch 8. 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(10, 15)}}
Ch 11. Use Cell Ranges & References for Formulas & Functions in Excel {{cp.topicAssetIdToProgress[36599].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
Lesson 2 - Cell References in Excel: Relative, Absolute & Mixed
Score: {{cp.lessonAssetIdToProgress[36601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36601].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Defining Order of Operations in Excel
Score: {{cp.lessonAssetIdToProgress[36602].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36602].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Referencing Cell Ranges and Other Worksheets in Formulas
Score: {{cp.lessonAssetIdToProgress[36604].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36604].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(11, 15)}}
Ch 12. Summarize Data with Functions in Excel {{cp.topicAssetIdToProgress[36605].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Using the SUM Function in Excel
Score: {{cp.lessonAssetIdToProgress[36606].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36606].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Using the MIN and MAX Functions in Excel
Score: {{cp.lessonAssetIdToProgress[36607].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36607].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Using the COUNT Function in Excel
Score: {{cp.lessonAssetIdToProgress[36608].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36608].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Using the AVERAGE Function in Excel
Score: {{cp.lessonAssetIdToProgress[36609].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36609].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(13, 15)}}
Ch 14. Format & Modify Text with Functions in Excel {{cp.topicAssetIdToProgress[36614].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Using the RIGHT, LEFT and MID Functions in Excel
Score: {{cp.lessonAssetIdToProgress[36615].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36615].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Using the TRIM & CLEAN Functions to Fix Data in Excel
Score: {{cp.lessonAssetIdToProgress[36616].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36616].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Using the UPPER and LOWER Functions in Excel
Score: {{cp.lessonAssetIdToProgress[36617].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36617].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - How to Use the CONCATENATE Function in Excel
Score: {{cp.lessonAssetIdToProgress[36618].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36618].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(14, 15)}}
Ch 15. Create a Chart in Excel {{cp.topicAssetIdToProgress[36619].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Excel Charts & Graphs: Summarizing Data Visually
Score: {{cp.lessonAssetIdToProgress[36620].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36620].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - How to Change a Chart Type in Excel
Score: {{cp.lessonAssetIdToProgress[36621].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36621].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Switch Between Rows & Columns in an Excel Graph's Source Data
Score: {{cp.lessonAssetIdToProgress[36623].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[36623].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Quick Analysis in Excel
Score: {{cp.lessonAssetIdToProgress[38447].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[38447].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
Intro to Excel: Essential Training & Tutorials
Not Taken
More practice by chapter
Ch. 3
Customizing Options & Views in Excel
Not Taken
Ch. 4
Not Taken
Ch. 5
Not Taken
Ch. 7
Not Taken
Ch. 8
Not Taken
Ch. 9
Create a Table in Excel
Not Taken
Ch. 10
Modify a Table in Excel
Not Taken
Ch. 12
Not Taken
Ch. 13
Not Taken
Ch. 15
Not Taken
See practice tests for:

Support