Copyright

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
Try it risk-free for 30 days. Cancel anytime
Create An Account
Try it risk-free for 30 days

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

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
Intro to Excel: Essential Training & Tutorials
Not Taken
More practice by chapter
See practice tests for:
Support