Creating & Analyzing Database (Microsoft Excel 2013 ) Course

Creating and Analyzing Database (Microsoft Excel 2010/2013/2016)

 Customize Training

  • Overview
  • Course Outline
  • Target Audience
  • Fees & Funding

What Will Be Taught For This Business Analysis in Excel Course?

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.

Module 1. Working with Databases
  • What is an Excel Database
  • Creating a Database (Excel Table)
  • Modifying a Database (Add a New Record / Add a New Field)
  • Sorting Records by Multiple Fields
  • Using Data Validation
  • Validating Data using a List
  • Creating a Custom Error Message
  • Removing Data Validation
  • Creating Subtotals in a List
  • Removing Subtotals from a List
  • Practice
Module 2. Using AutoFilter
  • Enabling AutoFilter
  • Using AutoFilter to Filter a List
  • Clearing AutoFilter Criteria
  • Display Top Ten Records
  • Creating a Custom AutoFilter
  • Create a Custom Filter using Wildcards
  • Disabling AutoFilter
  • Practice
Module 3. Working with Advanced Filters
  • Creating a Criteria Range
  • Using a Criteria Range
  • Showing All Records
  • Using an Advanced And Condition
  • Using an Advanced Or Condition
  • Copying Filtered Records
  • Using Database Functions
  • Practice
Module 4. Lookup Formulas
  • Using VLookup
  • Using HLookup
  • Practice
Module 5. Exporting and Importing Data
  • Exporting Data to as Text File
  • Importing Data from Text Files
  • Refresh Data
  • Changing External Data Range Properties
  • Removing the Query Definition
  • Importing Data from Other Applications
  • Importing Dynamic Data from the Web
  • Copying a Table from a Web Page
  • Practice
Module 6. PivotTables
  • Get Answers with PivotTables
  • Create the PivotTable
  • Create the Layout
  • Rearrange the Layout
  • Filter your Data
  • Changing the Summary Function
  • Creating a Page Field Report
  • Formatting a PivotTable Report
  • Creating a PivotChart Report
  • Practice

Who Should Attend This Business Analysis in Excel Training?

Ideal upgrading course for Information professionals who possess advanced working knowledge in Microsoft Office Excel and want to unlock other high-level features in creating and analysing databases.

Pre-requisite

Have attended / a working knowledge of Excel advanced course is recommended.

  w/o GST w GST
Course Fee $350 $374.50

This course is applicable for Skills Development Fund (SDF).

 

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attained minimum 75% attendance in order to qualify for Funding.
  • Trainee undertakes to reimburse ST Electronics (e-Services) FULL course fees should he/she be ineligible for course fee grant. ST Electronics (e-Services) is not liable for any other funding not approved by WSG.
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.

 

 

 

Please select the course date to enrol

  Duration: 1 day
  Time: 9am to 5.30pm