We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

MS Excel Intermediate

ENDED
Training by  Sankin
Inquire Now
On-Site / Training

Details

Unit Standard: 116940
Course Schedule
1. Customizing Excel
2. Working with the View Tab
3. Freezing Panes
4. Changing Excel Defaults
5. Working with multiple Sheets
6. Adjusting ranges between sheets
7. The SUM function – using BODMAS
8. Understanding formula errors
9. Absolute referencing
10. The ROUND function
11. Statistical Functions (Count, Average, Max, Min)
12. Working with Templates
13. Advanced Formatting Options (number, date, currency, percentage)
14. Advanced Border Application
15. Evaluating Spreadsheets

Unit Standard: 258879
Course Schedule
1. Outlining Data
2. Hiding Workbooks, Sheets, Columns, Rows and Cells
3. Splitting your workbook
4. Conditional Formatting
5. Working with Comments

Unit Standard: 258878
Course Schedule
1. Tracking Changes
2. Creating a summary index
3. Controls and access to information
4. Using passwords to protect access
5. Applying named ranges
6. Formating cells to show text and numbers
7. Importing Text Files
8. Charting Information
9. Using a macro and pop ups
10. Data validation

Outline

  • Customizing Excel
  • Working with the View Tab
  • Freezing Panes
  • Changing Excel Defaults
  • Working with multiple Sheets
  • Adjusting ranges between sheets
  • The SUM function – using BODMAS
  • Understanding formula errors
  • Absolute referencing
  • The ROUND function
  • Statistical Functions (Count, Average, Max, Min)
  • Working with Templates
  • Advanced Formatting Options (number, date, currency, percentage)
  • Advanced Border Application
  • Evaluating Spreadsheets
  • Outlining Data
  • Hiding Workbooks, Sheets, Columns, Rows and Cells
  • Splitting your workbook
  • Conditional Formatting
  • Working with Comments

Speaker/s

Theresa Cronje
Nonzuzo Hlatswayo

Special Offer

NGO and NPO 40% discount on all courses booked
Companies offering training to unemployed learners include a 35% discount
Group bookings offered discounted rates
Reviews
Be the first to write a review about this course.
Write a Review

Sankin Computer Training offers MICT Accredited end using computer training on the Microsoft Office Suite (all levels) to individuals and corporate clients countrywide.

 

Established in 2003, Sankin Computer Training was born from an Internet Café, where the founder of the business recognised a need for education in the private and public sector. Having a background of computer training for Quest Personnel, our private company, Sankin Computer Training soon took root and has grown from strength to strength.

 

Sankin Computer Training is designed to offer short, intensive, personalized courses that effectively present new concepts and techniques through interactive training methods. Small focused groups allow for individual attention and the practical application of theory.

 

We Offer:

Personal training venue in Glenwood, Durban for up to 8 delegates in a boardroom styled air-conditioned office with secure parking on site.

Training at your premises – we are equipped with 15 laptops and ready to travel, saving your company logistical arrangements and costs. We have enjoyed training all over South Africa this way, in both major cities and in outlying areas.

Flexible calendar – we prize ourselves on arranging our training times and dates according to your company and delegate’s requirements. ...

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.