Participants also learn the basics of creating and editing Excel charts. Learn to sort information in a list, and enhance worksheets and charts using the drawing tools to add graphic objects. Learn to quickly locate information in a list that meets specified conditions using the advanced filter features. Upon successful completion of this course, students are able to create charts that graphically represent worksheet data, modify charts, and apply formatting to customize charts. In this one-day advanced class, students learn how to customize toolbars and the work area, create styles and templates, create nested and decision making functions, analyze worksheet data by creating pivot tables, compare and contrast workbook files and file links.
Students also learn advanced formula construction , and how to outline and consolidate worksheets.
Worksheet data analysis, protecting worksheet data, and recording and modifying macros by using the Visual Basic Editor are also covered.