Pictures, forms, SmartArt, WordArt, and screenshots are all examples of graphic techniques that can be used to improve the visual effect of documents that are typically dominated by numbers and text. The course demonstrates how to use forms, text boxes, and pictures to create and edit them. We’ll show you how to apply a SmartArt graphic to your spreadsheets as well as how to add watermarks. We’ll also look at how workbook themes will help you display your data more effectively.
This course will assist learners in preparing for Microsoft Certification Exam 77-420: Excel 2013, which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013. To build a customized environment, you can configure options and views in Excel 2013.
Hide and unhide rows and columns, allow Show options, and adjust the zoom level to customize how data is shown. You can change the view of your workbook from Normal to Page Layout, Page Break Preview, or Tradition. Arrange Both, Freeze Panes, Split, and View Side by Side are only a few of the window-arranging options covered in this course. It will also teach you how to customize the Ribbon and Quick Access Toolbar and change the settings for making new workbooks.