EMail Print


MS Excel lntermediate
20.07.2017 - 20.07.2017


MICROSOFT EXCEL 2007 (Intermediate LEVEL 2)
US 116940: Use a GUI (Graphical User Interface) based spread sheet application to solve a given problem

Overview objectives
This course is designed to help a delegate who already have a thorough knowledge of basic Excel Features and would like to use the program effectively in the workplace/office.

Course re-requisite
Windows Excel level 1

Who should attend?
Any delegate wanting to obtain more skills in using a spread sheet effectively.

Starting Excel
Starting Excel, The Menu Ribbon, To Always keep Menu Ribbon Minimized, To Minimize Menu Ribbon for a Short Time
Changing the View
Full Screen, Zoom Function
Problem Solving by Using Spread sheets
Designing a Spread sheet
Renaming a Worksheet, Different Ways of Inserting a Worksheet, Moving Worksheets, Inserting Data, Changing the Width of a Column
Manipulate Data between Worksheets
Copying Data from One Worksheet to Another, Copying a Column of Data to/from another Worksheet, Deleting a Worksheet
Using Formulas in Excel
Adding up a Range of Cells, Changing Data in a Spread sheet to Test Possible Outcomes, Calculating Percentages
Relative and Absolute Cell References
Creating a Constant (Absolute) in a Formula
Calculating Averages
Calculating Averages using the Formula Function
Rounding numbers to specified number of digits
Natural Order in which Excel Calculates Operators in a Formula
Operator Precedence, Changing the Natural Order of Operation in a Formula
Troubleshooting Formulas
Creating a Simple Chart
Changing the design of a chart, Changing the layout of the chart
Creating a New Spread sheet
Using the Fill Command to Create a Series of Numbers
Creating more Formulas
Calculating Value of Stock on Hand, Calculating Averages, Determining the Highest Cost/kg, Calculating the Lowest Cost/kg, Calculating the Number of Products, Calculating Value Added Tax
Formatting Methods
Manual Formatting, Styles, Templates, Changing Orientation of Text, Changing the Height of a Row, Text Wrapping a Cell, Changing Vertical Alignment of Text in a Cell, Centering Text across a Number of Cells, Applying a similar Border to Separate Cell Ranges, Removing a Border, Formatting Shading in Different Cell Ranges, Removing/Modifying Shading, Copying Formatting Between Cells
Sorting of Information
Highest to Lowest, etc.
Creating Sub-Totals
Creating Sub-Totals for Different Groups
Using Outline Symbols
Creating Headers and Footers
Creating Headers/Footers, Modifying Headers/Footers
Preparing the Spread sheet for Printing
Using the Spell Check Function
Changing the Page Setup
Changing the document Orientation, Setting the Scale of the page, Setting the Paper Size, Changing the Spread sheet Alignment on a Page, Printing Gridlines, Printing the Document
Evaluate a Spread sheet
Readability, Appropriate Formatting, Accuracy, Overall Objective, Data Integrity
Creating What-If Scenarios
The Process of Changing Values in one or more Cells and how the Changes would affect a Formula, Creating Different Scenarios
Setting a Print Range or Print Area
Clearing a Print Area, etc.
Viewing Options
Freeze Panes, Unfreeze Panes, Split Cells, Removing the Split
Inserting a Symbol on a Spread sheet
Changing Data Formats in Cells
Formatting Cells to Display Different Currency Symbols
Working with Templates
Saving the Customized Template, Using a Customized Invoice Template, Creating your Own Template to Provide a Solution to a Given Problem
Testing and Validating Formulae
Different ways to test formulas, Saving the Document in Template Format, Creating a Document from a Template, Saving a Document Created from a Template.

Venue:  Graham & Rhona Beck Skills Centre

RSVP: Enquiries and Bookings at 023 626 1833