Price: SGD 342
- Duration: 1 Day
Course details
This in-depth one-day course introduces Microsoft Excel users to the advanced features in creating and analyzing databases. Participants will learn how to sort and manage data in lists; filter and query data; apply lookup and database functions. Participants will also learn how to analyze and evaluate the information in databases by creating pivot table and pivot charts.
COURSE OUTLINE
- Module 1. Working with Databases
- Module 2. Using AutoFilter
- Module 3. Working with Advanced Filters
- Module 4. Lookup Formulas
- Module 5. Exporting and Importing Data
- Module 6. Creating/Revising PivotTables
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
- Microsoft Excel : Top 50 Formulas Course LineSGD 32
SGD 655Duration: Upto 1 Hour - Mastering Excel 2019 – Intermediate Course CentralSGD 31
SGD 191Duration: Upto 5 Hours
