Excel Level 3
Short course
In Washington and Newcastle Upon Tyne
Description
-
Type
Short course
-
Location
-
Duration
1 Day
This course will enable delegates to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data.
Facilities
Location
Start date
Start date
Start date
About this course
To ensure your success, we recommend that you have completed the Excel Level 2 course or have the equivalent skills. A basic understanding of mathematics is also required.
Reviews
Course programme
This course will enable delegates to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data.
Prerequisites
- To ensure your success, we recommend that you have completed the Excel Level 2 course or have the equivalent skills. A basic understanding of mathematics is also required.
Objectives
- Delegates will be able to :
- Change the view of a spreadsheet to show a different layout without using any formatting tools, then change the data on the sheet to display different data values.
- Create a PivotTable to manipulate and extract data, then create a chart to display the results.
- Create a spreadsheet that will display multiple groups of records that can be updated from a single source.
- Use the Goal Seek and Solver facilities to enable results to be predicted in a spreadsheet where data may be missing or unavailable.
- Create a formula that will only add up or count records that match specific criteria.
- Record a Macro that will automate a repetitive task and then assign it to a new button on a new toolbar.
- Excel Pivot Tables
- Scheduled public course at one of our training venues
- Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
- Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- 1 delegate per computer
- 12 Months telephone and email support
- Comprehensive colour course manual and exercises
- Use of a Modern Training suite with 19 inch flat screen monitors
- Lunch (When at our training venue)
- Refreshments (When at our training venue)
- Relaxed refreshment area at our training room
Lesson 1 : Outlining
- Using the outline symbol
- Removing the outline from a worksheet
- Creating an outline automatically and manually
- Displaying a different view
- Deleting a custom view
- Creating a custom view
- Deleting a Scenario
- Editing a Scenario
- Viewing a scenario
- Setting up a scenario
- Modifying the settings for a pivot table field
- Delete a pivot table
- Refreshing a pivot table
- Removing a field from a pivot table
- Edit a pivot table at a later date
- Creating a pivot table from an Excel list
- Creating a PivotChart
- Filtering the fields once your pivot table is created
- Formatting your pivot table
- Adding summary rows and columns and/or hiding certain field values
- Setting a security option for your macros
- Removing a button from a toolbar
- Assigning a macro to a toolbar button
- Creating your own toolbar
- Editing a button on a worksheet
- Assigning a macro to a button on a worksheet
- Deleting a macro
- Running a macro
- Using relative references when recording a macro
- Recording a macro
- Creating a HLOOKUP
- Tips using VLOOKUP
- Creating a VLOOKUP
- Removing all tracer arrows
- Tracing dependents
- Tracing precedents
- Description of tracer arrows
- Entering a workbooks name, path and worksheet name into a cell
- Now()
- Round: To round a number to so many decimal places
- The COUNTBLANK function
- The COUNTIF function
- The SUMIF function
- The IF function
- Copying styles from another workbook
- Redefining a style using a formatted cell as an example
- Applying a style using the menu
- Deleting a style
- Creating a style using the format cell dialogue box
- Creating a style by example using the style command
- Solver
- Goal Seek
Excel Level 3