|
Learning outcomes
Delegates will be able to use some of the more advanced functions within
Excel and be able to work with multiple workbooks and worksheets as well
as, competently, use the program for database analysis and graphical presentation
of data.
Who should attend?
Delegates should first attend the Microsoft Excel Introduction or have
gained a similar level of expertise.
Training style
Informal and participative using a combination of trainer input, discussion
and practical exercises. This approach ensures the training meets the
needs of both the group and individual participants.
|
Course contents
More Functions and Features
Conditional tests and logical operators
Using IF and nested IF statements
Naming cell ranges
Attaching comments to cells
Viewing, printing, deleting, copying comments
Auditing
Consolidation
Conditional formatting
Using Multiple Spreadsheets
Inserting, deleting, moving, renaming sheets
Changing the tab colour of sheets
Linking workbooks and worksheets
Format multiple spreadsheets at once
Comparing workbooks side by side
Creating 3D formulas (across sheets)
Protecting workbooks and worksheets
Sorting and Filtering Lists
Sorting rows and columns
Sorting and formulas
Creating and using custom sort orders
Using AutoFilter and removing filters
Custom AutoFilter
Advanced Filters
Using List Functionality
Designating data as a list and using this interface
to manage and analyse your data
Using Format a Table
Removing duplicates
|
Automatic Subtotals
Converting a list to a range
Applying and removing subtotals
Counting
Multi-Level Subtotals
Creating Outlines
Using Auto Outline
Collapsing and expanding outlines
Removing outlines
Creating Charts
Using ChartWizard to create charts
Moving and resizing charts
Using the Chart toolbar
Changing the chart type, adding titles
Combination charts
Adding and deleting floating text
Adding labels to data points
Formatting the data series and plot area
Customising 3-D charts, rotating 3-D charts
Exploding slices of pie charts
Drawing
Drawing using the Illustrations tab
Drawing lines and shapes
Changing colours and patterns
Changing line and arrow styles
Selecting, moving and resizing objects
Including text in a drawing
Grouping and ungrouping objects
Creating diagrams
Using Smart Art
|
