Copyright

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:

    Common Uses for Excel Spreadsheets
    chapter 1 / lesson 1
    Common Uses for Excel Spreadsheets

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(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
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
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
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
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
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
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
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
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
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
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 - 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 5 - 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 6 - 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 7 - 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 8 - 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 9 - 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 10 - 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, 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
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

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
Microsoft Excel Certification: Practice & Study Guide
Not Taken
More practice by chapter
See practice tests for:
Support