Microsoft Excel Certification: Practice & Study Guide

• Course type: Self-paced
• Available Lessons: 28
• Average Lesson Length: 8 min
• New lessons are still being added
• Watch a preview:

chapter 1 / lesson 1

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

4 chapters in Microsoft Excel Certification: Practice & Study Guide

Week {{::cp.getGoalWeekForTopic(0, 4)}}
Ch 1. Introduction to Excel {{cp.topicAssetIdToProgress[52828].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Common Uses for Excel Spreadsheets
Score: {{cp.lessonAssetIdToProgress[52829].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[52829].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - How to Customize the Quick Access Toolbar in Excel
Score: {{cp.lessonAssetIdToProgress[25010].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[25010].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - What is a Workbook in Excel? - Characteristics and Options
Score: {{cp.lessonAssetIdToProgress[14425].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[14425].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Using the Formula Bar in Excel
Score: {{cp.lessonAssetIdToProgress[52831].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[52831].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Navigating in Excel
Score: {{cp.lessonAssetIdToProgress[52833].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[52833].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(1, 4)}}
Ch 2. Data Entry in Excel {{cp.topicAssetIdToProgress[52835].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 - Using the AutoFill Tool in Excel
Score: {{cp.lessonAssetIdToProgress[31599].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[31599].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - How to Use Undo & Redo in Excel
Score: {{cp.lessonAssetIdToProgress[52838].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[52838].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - How to Find and Replace Data in Excel
Score: {{cp.lessonAssetIdToProgress[31597].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[31597].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(2, 4)}}
Ch 3. Worksheets & Workbooks in Excel {{cp.topicAssetIdToProgress[52839].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 - 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)}}
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

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
Microsoft Excel Certification: Practice & Study Guide
Not Taken
More practice by chapter
Ch. 1
Not Taken
Ch. 2
Not Taken
Ch. 3
Not Taken
Ch. 4
Not Taken
See practice tests for:

Support