Microsoft Excel Essential 2013

Excel

This comprehensive course covers the fundamental features of Excel 2013 as well many functions in Excel 2013. This is an intense one day course, 09h00 to 15h30, which will provide you or your staff the knowledge of putting together comprehensive spreadsheets and understanding formulas. Prices from R 895 ex vat for large groups of 10+ ONSITE. T&C's apply

This course will prepare you or your staff for more advanced Excel 2013 courses. Each student receives an Excel 2013 manual and an electronic attendance certificate on completion of the Excel Essentials 2013 Course. We almost run on demand as we try to accommodate the client's work schedule when possible.



Contact Arnold + 27 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?

What This Course Covers
  • 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 2013 Courses. The delegate receives a 2013 manual and an electronic attendance certificate on completion of the relevant Excel Essentials 2013 Course.

We almost run on demand as we try to accommodate the client’s work schedule when possible. Contact Arnold + 27 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. Offsite includes teas, light lunch, and an electronic attendance certificate. Group discounts apply. ONSITE, YOUR VENUE, minimum of three delegates attending simultaneously. Prices on request.

ENQUIRY FORM

 

Contact Arnold + 27 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