Microsoft Excel Level 2

Microsoft Excel Level 2 teaches students how to apply basic skill sets along with some intermediate to advanced functions to manage and audit numerical reports.

Students will learn to create and manipulate charts, work with different types of graphics, look at various methods of analyzing, organizing, linking and sharing workbooks, learn to use advanced formatting features.

What You’ll Learn

• Use name ranges
• Use intermediate formulas in a worksheet
• Use conditional formatting
• Work with and arrange worksheet panes and windows
• Create and work with charts
• Add and work with graphic images (shapes and pictures)
• Practice methods of organizing data
• Work with tables
• Analyze data
• Search worksheets for values
• Make workbooks more accessible
• Use hyperlinks in a worksheet
• Import and export data between other applications