You understand the basics of Microsoft Excel but need to use more complex elements to make your job easier. This course has a focus on managing, manupulating and analysing data using a range of simple and complex techniques. It also explores the use of more complex formulas in a business environment and includes techniques to simplify what could be complicated. We also investigate visual techniques that can be used to monitor information by users and managers. The course builds on shortcuts and techniques learnt during the introduction course.

• To apply visual elements and advanced formulas to a worksheet to display data in various formats
• To manage, manipulate and analyse data using a range of techniques.

• Use Conditional Formatting to manage data
• Create and apply templates
• Sort, Filter, Subtotal and use Pivot tables to analyse data
• Manage complex formulas using Range Names
• Calculate with advanced formulas including IF's and Vlookup
• Create and modify charts
• Work with graphic objects
• Use a range of useful shortcuts

Creating and Applying Templates - Create a Workbook from a Template - Create a Custom Template - Working with Comments - Create a Hyperlink - Use Web-based Research Tools

 

Creating and Modifying Charts - Create a Chart - Format Chart Items - Change the Chart Type - Create a Diagram

 

Working with Graphic Objects - Insert Graphics - Create AutoShapes - Format Graphic Objects - Change the Order -  Graphic Objects - Group Graphic Objects - Move, Copy, and Resize Graphic Objects

 

Calculating with Advanced Formulas - Create and Apply a Name for a Range of Cells - Calculate Across Worksheets - Calculate with Date and Time Functions - Calculate with Financial Functions - Calculate with Statistical Functions - Calculate with Lookup and Reference Functions - Calculate with Logical Functions

 

Sorting and Filtering Data - Sort Data Lists - Filter Data Lists - Create and Apply Advanced Filters - Calculate with Database Functions - Add Subtotals to a Worksheet

 

Using Excel with the Web - Export Excel Data - Publish a Worksheet to the Web - Import Data from the Web - Create a Web Query