Course details
This course provides the participant to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The participant shall be able to operate effectively at more than intermediate level of competence and be able to sort, query and link data.. The participant shall be able to use functions such as those associated with logical, statistical or mathematical operations. Furthermore, the participant will be able to use available analysis and audit tools and to run and record simple macros.
COURSE OUTLINE
- Module 1. Using Auditing Tools and Range Names
- Module 2. Exporting and Importing Data
- Module 3. Using Advanced Functions
- Module 4. Creating/Revising PivotTables
- Module 5. Using Scenarios
- Module 6. Tracking and Merging Workbooks
- Module 7. Recording Macros
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.
Are you from ITBM ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Free Excel 2019 Beginners eduCBASGD 29Duration: Upto 4 Hours
- MS Office 365 Core Apps Skill-UpSGD 29
SGD 302Duration: Upto 1 Hour
