Course details
The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. The trainee will be able to accomplish standard mathematical and logical operations using basic formulas and functions. The trainee will be able to demonstrate competence in using some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.
This course prepares the participants for the Microsoft Office Specialist exams.
COURSE OUTLINE
- Module 1. Using Basic Workbook Skills
- Module 2. Using Formulas and Functions
- Module 3. Using Range Names
- Module 4. Using Advanced Functions
- Module 5. Using Conditional and Custom
- Module 6. Using Page Setup
- Module 7. Using Large Worksheets
- Module 8. Managing Files
- Module 9. Using Worksheet Protection
- Module 10. Creating Charts
- Module 11. Formatting Charts
- Module 12. Using Shapes and SmartArt
- Module 13. Working with Comments
- Module 14. Using Paste Special
- Module 15. Working with Tables
- Module 16. Using AutoFilter
- Module 17. Sharing Workbook
Course Location
About ITBM
Instructional & Courseware Design
- Customized CD Learning, e-Learning and Courseware for companies. Find out more now.
Office Workflow Automation
- When running your day-to-day business, you realise that things can be made easier for you if the system is computerised. But how do you get started? More information here.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel 2010 – Intermediate Global EdulinkSGD 84Duration: Upto 6 Hours
- SGD 28Duration: Upto 5 Hours
