Excel

This comprehensive course covers the fundamental features of Excel as well many functions in Excel. 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 courses like Excel Intermediate and Excel Advanced and Excel Dashboard reporting. Each student receives an Excel manual and an electronic attendance certificate on completion of the Excel Essentials Course. We almost run on demand as we try to accommodate the client’s work schedule when possible.

We train any version of Microsoft and Office 365

Contact Arnold + 27 083 778 4903 or email [email protected] 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
Sheet printout options
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
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

This course will prepare the delegate for more advanced Excel Courses. The delegate receives a manual and an electronic attendance certificate on completion of the relevant Excel Basic 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 [email protected] 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, a minimum of three delegates attending simultaneously. Prices on request.

View our Excel Video tips on Youtube  

These are great Excel Tips resources

ExcelTips Daily Nuggets

Chandoo

Ablebits

We provide training throughout Southern Africa and have offices in all the major cities.

Johannesburg, Pretoria, Sandton, Midrand, Centurion, Roodepoort, Edenvale, Durban, Umhlanga, Cape Town. "Other Areas on Request"

You May Also Like

MS Excel

Excel

MS Excel software package has different levels which cover many courses.
MS Excel

Excel Guru

Excel Guru software package has different levels which cover many courses.
MS Excel

MS Office

MS Office software package has different levels which cover many courses.
MS Excel

Soft Skills

Soft Skills software package has different levels which cover many courses.
Skip to content