Microsoft Excel Certification: Practice & Study Guide

Course Summary

From basic operations to advanced formatting and hyperlinks, this course teaches you the ins and outs of Microsoft Excel 2013. Our experienced instructors present topics using screenshots and graphics to help you become proficient in Excel.
Create An Account
To Start This Course Today
Used by over 30 million students worldwide
Create An Account
Try it free for 5 days

4 chapters in Microsoft Excel Certification: Practice & Study Guide

Week {{::cp.getGoalWeekForTopic(2, 4)}}
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 - Wrapping Text in Excel: How to Wrap Text within Cells Score: {{cp.lessonAssetIdToProgress[26819].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26819].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - How to Modify Cell Alignment & Indentation in Excel Score: {{cp.lessonAssetIdToProgress[26816].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[26816].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Workbook Themes: Applying & Changing Themes in Excel Score: {{cp.lessonAssetIdToProgress[25003].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25003].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - Adjusting Column Width & Row Height in Excel Score: {{cp.lessonAssetIdToProgress[25004].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25004].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - How to Insert Watermarks in Your Excel Worksheet Score: {{cp.lessonAssetIdToProgress[25005].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25005].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - How to Insert Headers & Footers in Excel Score: {{cp.lessonAssetIdToProgress[25006].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25006].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Using Data Validation in Excel Score: {{cp.lessonAssetIdToProgress[25007].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25007].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(3, 4)}}
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

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

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