- [Voiceover] Using headers and footers in your workbooks…give the reader more information about the document,…such as the date it was created, who the author is,…and when it was last updated.…In this video we will explore two ways…to insert headers and footers into your worksheets.…And you'll probably encounter this as a challenge…on the Excel 2013 MOS Exam.…I have the 0208 exercise file open,…so let's go ahead and get started.…Here we have a very long document…with lots of records in it.…

It's a really good idea when you have a long document…such as this, to include the page number…somewhere in the document,…either in the header or the footer.…The first method that I'm going to show you…is to go to the Page Layout ribbon,…and we're going to click on the Page Setup More button.…Now those More buttons can be accessed…by clicking the arrow in the lower…right-hand corner of the group.…I'll go ahead and click on the More button,…and this brings me into my Page Setup window.…One of the tabs I have available to me is Header Footer.…

Resume Transcript Auto-Scroll

Author

Released

4/4/2016

Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist. Study to pass the MOS Excel 2013 certification exam. This course, created by Microsoft Certified Trainer Jennifer McBee, helps test takers prepare for exam 77-420, which covers the five main skills on the MOS Excel 2013 exam: creating worksheets and workbooks, cells and ranges, formulas and functions, and charts and other objects.

Disclaimer: Microsoft does not produce, provide, or endorse this video training course.

The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam.