Microsoft Excel Essential 2007

Excel

This comprehensive course covers the fundamental features of Excel 2007, which has been superseded by versions, 2010 and 2013, as well exposing the delegate to some of the functions in Excel 2007. This is an intense one day course, 09h00 to 15h30, which will provide the delegate with sufficient Excel 2007 skills to create basic spread sheets and formulae.

This course will prepare the delegate for more advanced Excel 2007 courses. The delegate receives an Excel 2007 manual and an electronic attendance certificate on completion of the Excel Essentials 2007 Course. Prices from R 895 ex vat, T&C's apply.

We almost run on demand as we try to accommodate the client's work schedule when possible. Contact Arnold 083 778 4903 or email This email address is being protected from spambots. You need JavaScript enabled to view it. for dates in your area?

ENQUIRY FORM

 

 

Topic-Level Outline
  • Introduction to spreadsheets
  • Starting excel in win 8
  • The excel screen
  • Navigating within a worksheet
  • Workbook views
  • Working with help
  • Working with excel
  • Working with the office clipboard
  • Entering information into excel
  • Creating a new workbook
  • Entering information
  • Auto complete & auto fill
  • Pick from drop-down list Auto fill options
  • Save as new name/workbook
  • Editing and deleting data
  • Working with blocks
  • Adjusting column width
  • Adjusting row height
  • Formulas and functions
  • The sum function
  • The auto sum feature
  • Working with common functions
  • Changing fonts & point size
  • Cell borders and colors
  • Customizing cell formats
  • Aligning cell data
  • Indenting text
  • Rotating text
  • Wrapping text within a cell
  • Formatting numbers
  • Inserting and deleting a row/column
  • Using cell styles
  • Using the format painter
  • Creating a chart
  • chart objects
  • Accessing other functions
  • Working with insert (built-in) functions
  • Formulas and mathematical rules
  • Creating a custom formula
  • Spell checking the worksheet
  • Saving your workbook
  • Previewing a workbook before printing
  • Modifying the page setup
  • Changing margins
  • Changing the print area
  • Setting/removing page breaks
  • Applying a graphics background
  • Defining print titles
  • Scaling the document
  • Sheet options
  • Accessing the page setup dialog box
  • Customizing headers/footers
  • Sheet printout options
  • Printing your worksheet
  • Closing a document
  • Formatting cells
  • Applying attributes
  • Applying design
  • Moving the chart
  • Selecting chart objects
  • Sizing the chart
  • Editing the chart
  • Printing the chart
  • Applying text attributes to chart objects
  • Changing the font of chart objects
  • Changing font size
  • Changing the font color
  • Applying numeric formats to
  • Glossary of short cut keys
 

Download the table of contents (TOC)

DOWNLOAD TOCENQUIRY FORM

 

This courses will prepare the delegate for more advanced Excel 2007 Courses. The delegate receives a Excel 2007 manual and an electronic attendance certificate on completion of the relevant Excel Essential 2007 course.

We almost run on demand as we try to accommodate the client’s work schedule when possible. Contact Arnold 083 778 4903 or email This email address is being protected from spambots. You need JavaScript enabled to view it. for dates in your area?

ON and OFFSITE training are offered. See our Specials for Gauteng & KZN, other areas call Arnold 083 7784903. YOUR VENUE, prices from R 895 ex vat.Includes travel, manuals and an electronic attendance certificate. Minimum of three delegates attending simultaneously. OUR VENUE, prices from R 995 ex vat. Includes teas, light lunch, and an electronic attendance certificate. Minimum of three delegates attending simultaneously.

ENQUIRY FORM

 

Contact Arnold 083 778 4903 or email This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Subscribe to our free tips newsletter

About college africa group

We, at College Africa Group offer training courses
which meet your needs and fit within your budget.

As a MICT Seta National Accredited Microsoft
Computer Training provider, College Africa Group
is the preferred choice for all computer related
training needs.

Contact Info

Mobile: Arnold Muscat + 27 (0)83 778 4903

Call Centre: +27 (0)11 881 5998

Email: sales@collegeafricagroup.com

Head Office:

Physical Address :2nd Floor, West Tower Maude

Street Nelson Mandela Square Sandton

South Africa 2196