Details
Outline
- Data Validation
- Sorting Data
- Subtotals
- Adding Security Settings – password protection
- Date and Time Functions
- Mathematical Functions (Sumif, Rounddown, Roundup, Even, Odd)
- Statistical Functions (Countif, Counta, Trend, Large, Small)
- Financial Functions (FV, NPV, PMT, IPMT, Nper, PV, Rate)
- Nested Subtotals
- Text Functions (Upper, Lower, Proper, Concatenate)
- Lookup and Reference Functions (Lookup, VLookup, HLookup)
- Logical Functions (If, And, Or, Not, True, False, Nested If)
- Using mixed references
- Named Ranges
- Goal Seek
- Scenarios
- Formula Auditing
- Tracing Errors
- Importing Text Files
- Exporting Text Files
- Converting numbers
- Data Consolidation
- Linking Spreadsheets
- Filtering Information
- Using Forms
- Macros
- Comparing Spreadsheets
- Pivot Tables
- Pivot Charts
Speaker/s
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
Schedules
| No. of Days: | 1 |
| Total Hours: | 6 |
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. ...
