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 2016 Bundle Diploma Alpha AcademySGD 34
SGD 655Duration: Upto 2 Days - Computing Level 3 Advanced Diploma Course LineSGD 32
SGD 655Duration: Upto 11 Hours
