"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Excel Intermediate Level 2

Course Overview

· Using multiple worksheets, workbooks and workspaces · Working with advanced functions · Use advanced formatting techniques · Using charts to display data · Using Excel as a Database Target student This course takes users to a high level of knowledge using multiple worksheets, charting, advanced functions and advanced formatting.

Course Delivery:JCS training NN3 6QB and associate locations nationwide
Related Courses
Excel 2007/2010 Advanced

Duration: 1 Day
 
Course Objectives
·         Using multiple worksheets, workbooks and workspaces
·         Working with advanced functions
·         Use advanced formatting techniques
·         Using charts to display data
·         Using Excel as a Database
Target student
This course takes users to a high level of knowledge using multiple worksheets, charting, advanced functions and advanced formatting.
Prerequisites
Delegates should have an understanding of any of the Windows operating system and a good understanding of Microsoft Excel or alternatively students should have attended MS Excel level 1 training or have equivalent knowledge.
Using Multiple Worksheets and Workbooks
Using Multiple Worksheets
Inserting New Worksheets
Renaming Worksheets
Deleting Worksheets
Creating Multiple Views
Freezing Panes
Viewing and Arranging Multiple Worksheet Windows
Navigating in Multiple Workbooks
Selecting and Viewing Multiple Workbooks
Creating and Opening a Workspace
Managing Multiple Worksheets and Workbooks
Selecting Multiple Worksheets
Moving and Copying Data between Worksheets
Linking Data Between Worksheets
Creating a 3-D Formula
Advanced Functions
Creating and Using Functions ie If, Vlookup, countif
Using Built-in Functions
Working with Arguments: Using Dates and Times
Using Dates in Calculations
Using Nested Functions
Named Ranges
Creating and Using Named Ranges
Automatically Naming Ranges
Navigating with Named Ranges
Using Range Names in Formulas
Pasting a List of Named Ranges
Deleting and Editing Range Names
Creating Named Constants
Working with Lists
Creating a List
Maintaining a List
Sorting a List
Filtering a List
Using Subtotals in a List
 
 
Advanced Formatting
Using Comments in a Worksheet
Reviewing, Showing, and Hiding Comments
Deleting a Comment
Working with Styles
Applying a Style
Modifying Existing Styles
Using Format Painter
Creating Custom Number Formats
Applying an AutoFormat (Table Format)
Conditional Formats
Clear conditional formats
Charting
Using Charts
Creating a Chart
Changing Chart Type, Style and Chart Sub-Type
Changes to the Chart Source Data
Add data to an existing chart
Change the data in an existing chart
Remove data from a chart
Managing Chart Objects
Moving and Resizing Chart Objects
Deleting Chart Objects
Adding Data Series and Objects to a Chart
Changing the Chart Type
Formatting Chart Objects
Printing Charts
Adding Graphic Elements
Creating Graphic Objects
Editing a Graphic Object
Creating and Editing 3-D Objects
Using Other Drawing Tool