Learn everything about Analytics

Setting Up a Database in Excel 2010 – Lynda

Lynda
0-6 Month Online
Executives Contact Institute
Online Business Intelligence
Online Self Paced 979

[su_tabs]
[su_tab title = “Description”]

The course explains the limits of Excel as a data management tool and spells out the design considerations for creating a database. It also demonstrates using tables to simplify database creation as well as the Form and Data Validation tools to manage data.

[/su_tab]
[su_tab title = “Program Structure”]

Topics:

  • Understanding database design concepts
  • Using the Text to Columns feature
  • Creating fields
  • Using tables
  • Adding total fields
  • Formatting tables with the Design tab
  • Using the Form tool to build and view data
  • Using data validation to restrict data entries

Fees: – INR 15, 00 (assuming $ = INR 60)

Duration:

43 minutes 27 Seconds

[/su_tab]

[su_tab title =”Tools”]

  • Excel

[/su_tab]
[su_tab title = “Contact”]

Name :
Email :
Contact Number :
Message :
Code :


[/su_tab]
[/su_tabs]

This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved